Tag Archives: T-SQL

Workaround for Adding Encrypted Databases by a Database Master Key on High Availability Groups without a password

Have you ever encountered this error when you are trying to add a database on your Always On Availability Groups? “This database is encrypted by database master key, you need to provide valid password when adding it to the availability group.” You get this on the Wizard after warning you that a Password is required… Read More »

Error in Linking new SQL Server x64 versions (2005 and 2008) to old SQL Server x32 versions (2000 and 7.0)

If you encounter this error: OLE DB provider “SQLNCLI10” for linked server “LinkedServerName” returned message “The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.”. Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset “DBSCHEMA_TABLES_INFO” for OLE DB provider “SQLNCLI10” for… Read More »

Auditing events on SQL Server 2008

If you want to audit whats happening on your SQL Server then look no further as SQL Server 2008 have a built in function for that, so you can log all Queries like Select, Insert, Updates and Deletes perfromed on a cetain table easily, before you will be needing third party tools to do this… Read More »