Operating System Error 5 while Attaching/Creating Database
Actual value was -1. (Microsoft.SqlServer.GridControl) Error when attaching database.
When attaching a database in SQL Server 2008, a user might get the following error. TITLE: Microsoft SQL Server Management Studio —————————— Cannot show requested
Performace Tuning Stored Procedures
I been performance tuning an OLTP system which is built with Visual Basic Front end, Microsoft Components middle tier and SQL Server back-end for DBMS.
Unable to Delete Records in using API Cursors
I am not very familer with the internals of API Cursors; so this was an annoying problem to solve. I was working with web guy,
SQL 2000 Reporting Server Issue with Print Control
Just finished configuring SQL 2000 Reporting Server in Dev/Test/Production environment with issues with printing. But when users tried to print they got the following error:
SQL Server Integration Services Issue (Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum))
TITLE: Microsoft SQL Server Management Studio —————————— Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 —————————— ADDITIONAL INFORMATION: The SQL server