Problem: Unable to enable CDC due to either of following errors even when database owner is SA. Error Description #1 Msg 3930, Level 16, State 1, Procedure ...
Please note that I had authored this article originally for www.sqlservercentral.com that was featured in "Best of SQLServerCentral, Volume 6". SQL Server 2005 has ...
Microsoft introduced SQL Server Data Tools with Visual Studio 2010 and bundled improved version with Visual Studio 2013 which can be used by Database Developer to perform ...
[vc_row][vc_column][vc_column_text]Error can be resolved by either of followings: netsh winsock reset if 1st option does not help then try instruction available at ...
Scenario: Installed SQL Server Enterprise Edition 2008 database engine along with Integration Service on four node clusters running on Windows Server 2008 . I am unable to ...
As we all know that it is very important to write good program but few do not write due to lack of proper guideline or they overlook database programming. Intend of this ...
Database Mail is easy to configure, but I thought of putting steps together to save your little time and ensure no issue when you do this. You may come across two Question ...
Microsoft has added new extensions to PowerShell for working with SQL Server and released it part of SQL Server 2008. Intent of this article is to guide you, how to use ...
We often use SET option in stored procedure without realizing if it can cause performance problem. I was working on Critical Database Performance issue recently arguing on SET ...
Insert operation fails thru Linked Server in SQL Server 2008 if column in table defined as smalldatetime but variable declared in procedure or query is datetime. Scenario: ...