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
Adding new disk resource to cluster
My current configuration includes two node cluster with active-passive configuration. I had requested the Storage team to add a new LUN to the Cluster so
Error 191: Some part of your SQL statement is nested too deeply.
When inserting string into SQL Server table using the INSERT predicate that uses string concatenation there seems to be an issue with in SQL Server
Why backup testing is important?
How do you do backup testing? In normal cases we backup data from SQL Server (either using SQL Server Agent, or another 3rd party backup
SQL Canada (SQLCAN) 