That's the only way in 7 or 2000. SQL 6.5 had a table restore.

Strange. No patches or option changes? Have you contacted Litespeed? We're running 3.0 here, so not sure if there's something in the version change.

You need the IBM drivers installed on the server. Client Access was the one we used. From there you would create a linked server and enter the appropriate credentials and...

Another thing to consider is SS2K DTS is redistributable, so the components can be put on any workstation/server and run from there with no license issues. Not the same in...

Jason,

I've upgraded a few and query performance didn't seem dramatially different. The tools were better and backups seemed faster, but I don't have an objective look right now.

One good reason...

Nice handle

Rajesh,

when you execute this in Query Analyzer, use CTRL-K first and get the execution plan. Then you can compare the two methods. I think the OR is less efficient in...

If you could modify for Northwind and post it, I'll take a look.

reboot the workstation?

Does this happen everytime? I might uninstall, reinstall the client tools. And patch tem.

I like Yelena's solution, simple and easy. The adduser/drop user gets complicated, as you'll see in EM if you restore a db. Sometimes things don't synch right.

Phil is right. This is what you get when SQL Server has problems communicating. Hiccups in comm that a file transfer or other type of RPC use tend to blow...

Great questions!!! Awesome!!!!! Very tricky and caused me to run over to my copy of SQL Server 2005 to check it out and build a test package, only to realize...

The code has been announced in numerous newsletters and articles on the site (http://www.sqlservercentral.com/columnists/pressrelease/sscsourcecodeforthepass2005summit.asp, http://www.sqlservercentral.com/columnists/pressrelease/thelastdaytosave.asp, http://www.sqlservercentral.com/newsletter/view_newsletter.asp?dt=5/31/2005, etc). Unless you registered before early June when we started the messaging, there isn't...

If this is to be one call from the client, you'd need to insert into Header, then get the identity value from the row using scope_identity() and use that in...

There's no great "secure" option on the db server. I'd look at a third party product as they have dealt with this before and made lots of mistakes.