SQL Books Online:

- Search for 'Estimating the Size of a Table' in the Creating and Maintaining Databases section. 

Cheers,

Ken

Mark

Here's a little example that might help with your cursor elimination - at least for the ones that you want to loop through data and process each record individually.

SET NOCOUNT...

I usually go for table variables rather than temp tables where possible.  You can create a primary key but can't create indexes on table variables though so if you need...

First of all, my condolences to you.  Getting stuck with a lame app is no picnic.  I've been there. 

This type of situation forces me to <ug.  management buzzphrase> think outside...

For what it's worth, I have log shipping set up and ran into a similar issue but not with DTS.  Another data extracting tool was developed in-house using SQLDMO and...

I'm curious: does the same DBCC error show up on the source?

Thanks for the flashback, Steve.  I may not pre-date you but I'm close: my team supported Microsoft's corporate servers 'way back in the OS/2 days.  (In case you're reading this, a big HEY...

Maybe I missed the point, but there are a handful of free query tools "out there" that seem to be pretty popular.  I did a quick Google and came up...

I can sympathize with your confusion.  IMHO I believe MS blurred the lines between disaster recovery and re-implementing log shipping "the other way" to your replacement ("original primary") server.

You are...

...possibly an alert in PerfMon...?

Here's an example to get you started.  You can drop this in master if you like, then execute it.  Open a second query window up and pummel pubs (the trace...

Profiler is merely the GUI front-end to a server side trace.  You can write those yourself (see BOL-sp_trace_create or script out a trace from Profiler).  I've written several and if...

...or identify the newest file in the folder (by file timestamp)...?

I'd agree with Julian - check the SQL Service rights.  That's definitely a good place to start.

If you're using a [domain] login rather than a local login, and the domain...

Look up triggers in SQL BOL.  If you choose to add the audit columns, you can use triggers to populate the columns without needing to modify your code to accomodate...