Forgive my wording here...But you got the index seek on IX_Contact_EmailAddress because I assume you created the NCI for "EmailAddress" and ContactID only. To get this data SQL has...

Of course it is possible, for DR site you should have mirrored hardware (the same) - so if you can put 100 DB's on your production site, you should have...

If a DOMAIN account is the db owner and that account is deleted/disabled (for whatever reason), and Agent Job tied to it will fail, and any database owned by it...

Is this a fairly "busy" OLTP situation or is there little activity throughout the day? If the publisher is a busy server I wouldn't recommend using triggers or they...

The original post for the question had SELECT * FROM #TEST WTH(NOLOCK) which was all that was needed to answer the question, in the "blurb" that provided the answer, I...

Did this work? I'm looking at attempting the same thing...

Yes it is possible. But for the most part CPU percentages (Min/Max) is set up as a whole. Eg. If you set a particular resource pool up to...

As a test, on the external hosted Perl server, can you open a telnet session and connect to the internal IP address of the SQL Server?

My apologies I believe I misunderstood you from the start

When I was developing my code I was running it on a computer on the same network as the server...

csalazar-607991 (3/4/2013)

In the past I had problems with BCP because when I try to copy the data to a file some times SQL introduce returns between the data and when...

It was in the first response to your post - OPC.Three gave you a script to run

This is an option on the linked server to the Perl Server?

Is it possible this user has a SQL Agent job running under their credentials?

If you have a query window open in SSMS and leave it open, your session stays on the server until the spid is forcibly closed (killed), the user closes out...

Your command will work, there's just a whole bunch of things to think about: First thing that comes to mind is that the entire process will be logged and...