Getting "Subquery returned more than 1 value" error on cursors. Changed the following in a couple of places and it runs now. systypes.[name], --(SELECT systypes.[name] FROM systypes WHERE xtype = syscolumns.xtype), Mny thanks to whomever wrote the script. Saved me a bunch of effort."This script will document tables (including constraints and triggers, row counts, sizes […]
2005-10-19 (first published: 2005-10-07)
578 reads
By Steve Jones
It’s that time of the month again, when the T-SQL Tuesday blog party takes...
By DataOnWheels
My first time at SQL Saturday New York City was an absolute blast! Thank...
Some of our more regulated customers (banks, gambling sites and suchlike) like to know...
Hello, I was wondering if anyone knew how to prevent this issue I am...
Hi there I need help on creating a Linked Server to an MS Access...
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers