what about using bcp to dump out each table to a text file and then either zipping/tarring/raring all the files up into one file to be archived for your time...

There's an old windows admin tool called hyena that you can use to help generate scripts and .bat/.cmd files to do this type of thing.

I'd suggest a WMI script to...

Have a look at the following and see if it helps you.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=148608

-Luke.

It's a toss up, either drive to Pittsburgh and see some old friends, or stay at home and brew a batch of Wie Heavy for this winter and enjoy some...

I personally have worked with PostgreSQL and quite enjoyed it. There were a few growing pains at first, but eventually it just became a rock solid platform for us...

I'd be surprised if the folks from Red Gate couldn't come up with a way to integrate the simple Talk SQL Prettifier http://www.simple-talk.com/prettifier However it would be great to...

Yeah I'd thought about that, but that application already handles that logic, before it sets up the values it sends over to the stored procedure. I know I should...

Yeah I've already trimmed it down below 3 secs which is more than acceptable, but I'm just looking to see if I can do better than that. Also, it's...

Yeah the code I'm working on has been in production 5 years or so... And it's not like it was upgraded from SQL 7 hence the @@ identity. ...

Thanks for confirming my suspicions. I was mostly just curious that it didn't appear as a step in the new execution plan as I assumed it would have, because...

That was just sample data. It's another varchar value that gets stored. I just didn't feel like typing out the whole thing. Thank you though.

I guess that's what I'm trying to get at... There will only ever be 1 of 2 values passed into this stored procedure because of validation that is happening in...

Then that would seem to be your problem. In your connection string, you are sending a user name and password instead of the integrated windows authentication information.

Have a look...

How will you know what dates you are tyring to calculate?  will they be passed in from your application? 

Is this something that is the result of a process that...

Another avenue to get another SQL 7.0 CD would be if you could find an old set of MSDN CD's or if you're currently licensed with an MSDN subscription you...