raym:

You've got half a Terabyte of data here.

If you need just a single static copy, then I think that you have to go with building a...

Hmm, I don't think that the quad-cores can help a Cursor, can they? Aren't Cursor's inherently...

Is it possibly still/already running?

Note that the only way to tell this for sure is to look at the "Status" column on the Jobs display. The History's and all...

balbirsinghsodhi (8/29/2008)

---

It's kind of wired error. when I create stored procedure on one of the database I get following error.

String or binary data would be truncated.

but when I create same...

Tested on SQL 2005 sp2 on a laptop.

Result

Update: 129 sec

Cursor: 490 sec

It was very CPU-bound. I think that Gail's desktop is a lot better than my laptop. 🙂

What problems are you having?

Of course you could also write this yourself with the ALTER PROCEDURE DDL trigger.

Actually, the...

You are going to have to give us an example of what you want; Alternatively, see this link on how to get better results from these forums: http://www.sqlservercentral.com/articles/Best+Practices/61537/

It is probably DTS, not you.

Try using BCP instead. It will not work on every type of CSV, but when it does, it is much easier than DTS.

Actually, I think that I have know what this is: If you are using the "EXECUTE AS.." clause in your queue's activation definition, then you should be aware that...

Can you post the Procs?

Glad I could help.

What is the execution context (security principal) of your AS? And does that execution context have the rights to use xp_CmdShell(needs SysAdmin normally) and Database Mail?

I have no experience with Raid 50, but personally I would recommend against it.

Raid 50 is striping multiple Raid 5's together. The claim by the SAN vendors...