This blog post has been moved to my team blog site >> http://blogs.msdn.com/sqlserverfaq/archive/2009/09/24/bcp-command-fails-with-error-user-name-not-provided-when-both-sql-server-2000-and-sql-server-2005-tools-are-installed-on-machine.aspx Enjoy!
Read More...
The following post describes how you can configure your SQL Server to archive more than six Errorlog files using SSMS (2008, 2005) or Enterprise Manager GUI. While I was aware of MS KB # 196909 , that describes a way of increasing the number of SQL Server
Read More...
Hello All, This month have been filled with interesting and thought provoking issues. Here's a new one In a recent scenario, I tried dropping a “secondary” data-file in SQL 2005. Got below error TITLE: Microsoft SQL Server Management Studio ------------------------------
Read More...
Hi Friends, Here's something interesting about Management Studio 2005 (SSMS) When you launch SQL Server Management Studio 2005 on the server, it takes a couple of minutes (more than 5 mins in some case) before it starts up and another few minutes to connect.
Read More...
Hello Friends, March has been a busy month, and it is not over yet. Taking some time off to blog; small finding “worth sharing”. When managing SQL Server there are so many different locations to look for MSSQL files, like SQL Server Error Logs. While
Read More...
