Like this?

<name>

I've used the [ code ] [ / code ] tags from the shortlist for the code and then the "& l t ;" and the "& g t...

Are you sure you want to do this? What about DDL triggers? Are you 100% sure you know what every trigger does?

Look in sys.triggers, loop through the results and use...

I don't believe that AES is available in XP.

No one is likely to crack them. I'd use one of the shorter and quicker algorithms like RSA for the asymmetric key.

Please also look in the error logs and there should be some clue about why they are suspect.

Not sure, but I'll look around and see.

There are 2 2's in the question example, so those are being compared.

In the representation, as Christian has shown, there could be two places 1/1/2 could be. However if I...

Please read Books Online for what this does.

Use OSQL for SQL Server 2000. Similar parameters, osql /? will help.

Are you using INIT and creating a new file every day? A BAK file can be set to store multiple backups, which is a bad idea. Go to the restore...

I'd definitely think SSIS if this is data movement, as in download or transfer to another server.

If not, get the plan, be sure things are indexed properly, and I might...

What are the failures? Are they logged? Anything in the error/event logs?

You might have some issues with DTC accounts across servers. Are both servers on a domain? If not, there are some things that don't work with DTC without changes.

Why do...

Here's a vote for Bob! Keep posting.

You can test it in QA by running SP_setapprole, but that's not how users use it.

Your users still need to have a login/user on SQL Server, albeit with no rights....

I'd post this as a bug on Connect, ask for some votes (post the URL here) and see if you can get a good answer from MS. Or have someone...