I admit, I strayed, though I think it's more of a moral issue than political. At least that's what I intended.

I think the US has issues, but I hear as...

Don't think so, but sent a note to some people at MS.

I don't know, but I sent an email to someone that works there. Hopefully I'll get a response soon.

I haven't. Are you not including any columns in the ADO insert?

I hope they can't make changes to exclude people. As much as I think you have a personal responsibility, some things aren't your fault and as a society and group...

That calls for a part 2, Bert!

😀

Follow the above advice and Re-test everything! Especially beforehand on the 64-bit server if you can. Check alerts, mail, other things that might be set up on the SQL 2000...

David,

Thanks for the update and I'm sure someone else will appreciate it in the future.

Enjoy the day now that the crisis is solved! 😉

How did you try to change it? SSMS or T-SQL?

I might try an ALTER DATABASE command and see. Alternatively, can you stop replication and try to shrink the log file,...

Brian Knight has written two well received books about SSIS. He's a business partner of mine, but also a SQL Server MVP and lots of people have liked the books.

Search...

http://support.microsoft.com/kb/274750

First, post these in the DTS forum.

Second, if you need to drop the FK, you can drop it with an Execute SQL task set up to run before you drop...

Is this still happening? Any resolution?

Could it be scheduled twice?

Sorry for the delay here. Are you looking to backup the primary or secondary?

Set up a Profiler trace (or better yet, server side trace). You can search in Books Online under Profiler (http://msdn2.microsoft.com/en-us/library/ms173757.aspx)

You might want to just monitor the batches and look for...