Congratulations on half a million!!!!!

I stumbled on this site while looking for the answer to a very esoteric problem and found not only that answer but the answer to a...

My experience has been that having triggers interact with objects outside the DBMS is a bad idea. More typically, I've seen this type of event-driven processing accomplished by having...

Take the quotes off:

FirstName = @FirstName,

LastName

= @LastName,

JobLevel

=

If you're selecting all the rows from a table, you'll read all the data pages.  No index would help with that.  If you were reading a subset of the columns...

What are you trying to accomplish with this?

You can't really address the databases and tables residing inside the database management system as though they were other computing objects, like files, unless...

In the spirit of belief in my fellow man and the idea that any help given is never wasted, I'd still like to see the script run by the OP...

Back in the dim and distant past, isql used to have a -w option to specify the size of the output file. It shows up as an option on the MS site:

bcp...

Has this ever worked?  According to the boys in Redmond:

http://office.microsoft.com/en-us/excel/HP052009261033.aspx?pid=CH010006341033

Important  When you insert cells, rows, or columns, keep in mind that the maximum size of a worksheet is 65,536 rows...

I believe the short answer is 'NO'.

If you need to get at the data, you could download the SQL Server 2005 Express version (free), restore the DB there, and then...

Do the execution plans for the queries look well-optimized?  Are you sure they're using the indexes?

I don't know what the restrictions are on the developer edition, but I'm guessing that...

In one of my previous lives we had a similar problem.  We'd start with 2 databases both containing the same data from the source.  The users only had rights to...

Is the archive bit indexed?  Otherwise, you need to do a table scan just to find the records to delete.  I don't think the rowlock provides any benefit and you...

What's the total number of rows in the table?  Why rowlock?  Is 'archive' indexed?  How many other operations are going on on this table while the delete is running and...

Remove the concept of 'sorted table' from your thinking.  Inserting data into a table in a particular order does not guarantee the data will come back in the same order.

The...

If it can be yesterday's data, replication and dts copies are probably not the most efficient, or easiest to manage, alternatives.  Why not just take the backup from the primary...