How often does the stored procedure run and is it a particularly complex one?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

I'm glad you liked the article. To be honest, though, breaking up the topic makes it easier on me, the author, since my daily schedule is probably similar to most...

One of the things you can do is use xp_cmdshell to rename the file before starting the trace.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

I just did the script and recreated the bug. An excerpt of what I'm seeing:

if exists (select 

        ...

That's a good book.

Another one that's got me reading lately is the Transact-SQL Cookbook by Spetic and Gennick. It presents the material in a little different format than the...

One thing you also might look at doing with the command line version is building a script file. You can pass the script file to the FTP command and it'll...

Triggers operate on the entire result set, and are, by nature multi-row.

Based on your trigger, you may want to look at the CASE statement, which should provide you the functionality...

If you use the code option, it'll drop out after a carriage return. For instance:

  Code Line 1



  Code Line 2

What you'll have to...

You can rebuild the indexes while the system is online, but it can cause performance issues. How much of a performance hit is dependent upon the size of the files...

Steve is right in that the user of individual user accounts should be avoided. I listed it because though I know it's definitely not a best practice, I've seen it...

We were restoring to similar hardware, so we didn't have the driver issues and the like. We did use ArcServe, though. Our DR contract allows us to specify hardware, to...

Can you post the CREATE TABLE statements for both tables and a handful of records?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Using Profiler, you do have the option of starting on a new file once the current trace file reaches a certain size. For instance, if 10 MB files are your...

It might. Where the role can save you time and headaches is if another NT group or even an individual user needed rights, and that user, for whatever reason, can't...

Bill,

This is the procedure we follow in a DR situation. Actually, we take the backup tape and restore it in its entirety. This gets us the OS and all the...