Haven't tried it, but it should work.

You should run all queries that you expect to see if they work correctly. Execute all stored procedures, and grab queries or a load from Profiler on the existing server...

I bet it's the driver. This is through a linked server, correct? There are restrictions and I've seen issues with the drivers to DB2. You might try rebooting. We used...

I've seen queries similar, and people would write them. The fact that it compiles is a bad thing in my mind.

Someone submitted this and I think it's a good tickler...

Nothing.

It was a design that Brian Knight came up with, we liked it, and it's still here.

Great thoughts and information. Any of you want to write some articles with examples of what's worked or hasn't?

I was presenting a puzzle/conundrum/whatever here. It's a problem I've seen since my use of PGP in the early 90's and one problem that so many people have faced. I...

Good luck getting picked as well from this side of the water.

We've tried to budget for 200 people, though we've usually run in the 160-180 range the last couple years....

http://www.sqlservercentral.com/articles/DTS/datamigrationquicklyinsertingnewdata/1419/

Instead of inserts, use sqlcmd with a string to change the passwords. Keep all the server names in a single column.

The DBCC above should correct this and you should be sure that you run a DBCC CHECKDB after it to be sure there are no other issues.

Don't cross post.

Answer here: http://www.sqlservercentral.com/Forums/Topic499299-148-1.aspx

Which error? The unable to open error?

We definitely won't allow responses without logging in, but viewing the thread might make some sense.

Membership is at the top of the front pages. Changes constantly, about 1,000 a day or so.

I guess most people don't use it, but the replies seem to underscore my point. Most people posting haven't given a specific area where it has or hasn't worked. It...