February 28, 2006 at 9:05 am
Okay, I posted this to Microsoft's forum, but I'm not seeing any answers - maybe you all can help!
I have a *LOT* of compiling to do in SQL2005, so I'm using the SSMS query window. Problem is, I'm not seeing the full error messages due to the limitations - apparently you can only have the first 1,000 error messages reported. I have checked the configuration settings for the query window, but nothing appears to change the 'messages' section, it's all the 'results' section that can be configured.
I need to compile 2000+ procs at a time, and I don't want to have to drop them all everytime I want to run my script. If it already exists, I get an error message saying "proc already exists", and that's fine, but it counts against my 1,000 error messages.
Any help out there?
March 1, 2006 at 9:52 am
For large operations (them 'batch') I'd opt for SQLCMD.
The sqlcmd utility allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt. This utility uses OLE DB to execute Transact-SQL batches.
Important:
SQL Server Management Studio uses .NET SqlClient for execution in regular and SQLCMD mode. When run from the command line, SQLCMD uses the OLE DB provider. Because different default options may apply, it is possible to get different behavior while executing the same query in SQL Server Management Studio SQLCMD Mode, and in the SQLCMD utility.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply