The formatting didn't come out so great. Anyone who wants a copy of the actual SQL script can drop byhttp://www.learnsqlserver.com/ContactUs.aspx and...
If anyone has time or test databases with CHAR/NCHAR usage, I'm trying to "modernize" a SQL 7.0/2000 script (below) and want some input on it. <br...
I was doing some performance-related data collection for a client today and thought I'd share one thing I wrote - a very cool script. Posted in my...
quote:Originally posted by FrankKalis quote: Both sp_helptext and INFORMATION_SCHEMA.VIEWS show the full amount You're sure? The...
Sorry for the long aaaaaaaaaaaaa post above. I tried deleteing the aaaaaaaaaaaaaaaaaaaa's but it won't let me - some bug in the Rich Text editor, I...
I would agree with Adriaan about using a 3rd party tool or EM but I have an additional suggestion: why don't you just run this in DTS and output to a...
Can you use DTS or SSIS? Those seem to be better suited for this type of activity. Or why don't you just write the code in VB/C# to execute a...
AFAIK you must write a separate statement for each. I haven't dug down into the docs but the comma between the columns is what gives you a syntax...
To follow up to Frank's response:<br /><br />Just launch Profiler and "trace" your SQL Server. This creates a .trc file (or table) and you can use...
Separate names with a comma.
