Browse by Tags

How to handle PRAGMA AUTONOMOUS TRANSACTION mode within SQL Server?

Published 28 August 8 3:1 AM | SSQA.net

The question on the subject was asked by one of the Data Integration project developers, which is initiated to migrate a database from Oracle to SQL Server. The process of transactions should be handled from Application and when it comes to the data migration...

Filed under: sql server, oracle, transactions, ssma, dtc, data-migration, autonomous, mode

Property IsLocked is not available for Login '[x]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

Published 22 August 7 8:56 AM | SSQA.net

One of my colleague has been getting following error when trying to open few logins properties to change their default databases using SSMS. TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. --...

Filed under: sql server, security, ssms, error, login, property, ssma