Simply stated, there is no equivalent for Oracle's spool command. You can use OSQL with a DOS redirect to a file or BCP or DTS or...

Gregory,

I'm curious... What size (in gig or tera-bytes) is your OLTP and Reporting databases?

Best thing you could do for answers to all of that, and more, is to lookup "System Tables" in Books Online (comes free with SQL Server) and drill down to...

And another great tool bites the dust.

Well, where will it be run from... it'll make a difference.

I haven't tried to find the information in 2k5, but you really need to be careful... although the max number of columns may be 1024 per table, you need to...

I hate cross posting...

Anyway, like I said on the other forum, the correct date format number is NOT 103... it's 104. Check out Books Online under CONVERT.

As someone said above, date format #103 is NOT valid for this style of date. Check Books Online under CONVERT... the style you are looking for is style #...

No... cannot change the limit in SQL Server 2000.

Yes, you can work around it... take a look at "Expanding Hierarchies" in Books Online for details.

Never tried it because I just haven't had to do it. However, with...

Sorry, Terry... I don't know enough about the client known as SSIS to flip a nickel. I'm just assuming (bad thing to do, I guess) that it has some...

Misnomer would be correct... client could/will, indeed, pick it up as a "failure" because some error message as you said. Of course, that should be handled...

Loading the table...

Then, you need to do as I said... check out the "What's New" section of each release on the Microsoft website.

If you really have to copy the whole table, then you do not need deletes and you don't need the transaction. Insert into a new table... when you have...

Yeah... mistakes like that would certainly do it... I thought you were talking about something symptomatic with using WAITFOR even though you'd used it correctly...