I feel your pain as I have run into this one a few times myself.  I finally decided that it is easier to find the row in question and move...

   Defragging does gain an increase in SQL Server performance but is a pain to accomplish with Windows.  Some other ways to increase performance is to place your indexes in...

Excel has some very cool ways of working with SQL Server.  You could even connect and query utilizing a VBA script that runs when you load the spreadsheet.  That is...

You will definately need to make sure to do the workflow as sometimes SQL Server gets a little out of wack when trying to access a file that is being...

Bert is correct.  The table name can not be a variable in SQL Server.  Building the entire query as a variable and then running with EXEC(@variable) should give you the...

MichaelI'm not sure how to upload ASP code here. The entry box keeps processing it since this is HTML based as well. I could email it to you...

You can not use variables in table names unless you build the entire query as a variable and then use EXEC(@variable) to execute the query.  You could query the sys...

I have not seen any way to kill an update without a rollback sorry.  Anytime you kill and update the rollback is automatically initiated.  In the future you may want...

ASP works great for this.  However, be sure not to put your connection string in your ASP file as then it could easily be hacked.  If you are not using...

Check with your network manager.  The port you are connected to on the switch may be bad.  Also check your patch cable.  My hunch is a bad port on the switch.

Good luck

Marvin

I agree.  BackupExec causes more problems then it is worth.  Try LiteSpeed or SQL Safe from Idera.  Both offer compression which speeds the backup process up tremendously.

Good Luck

Marvin