If the column is indexed the like operator seems to work faster , however execution plans are the same , basically a index scan

are you sure its not an another type of blank space , like tab for example

you could try running bcp from command prompt , or even create a ssis package which will give you better control flow.

I would recommend these because it looks like...

Having been there I would say there is no such thing as a silly question. While I try not to give the full answer if i feel the person hasn't...

exact error messages will be useful , meanwhile , u cud try installing each of them separately.

Else under the installer directory u will find indivigual installer for each component

Servers\Setup

SqlRun_RS.msi...

http://msdn.microsoft.com/en-us/library/aa561924%28v=bts.20%29.aspx

the above link shows how to troubleshoot issues with distributed transaction coordinator

and would have a solution for the trigger based approach. But like Lowel said the job is a more...

Have you ever come across an informational message

"Cannot add rows to sysdepends for the current stored procedure because it

depends on the missing object 'XXXXXX. The stored procedure

will still be...

I am thinking the trigger should look something like

CREATE TRIGGER employee_insupd

ON employee

FOR INSERT

as

BEGIN

BEGIN TRY

Insert into server2.database.schema.table

select * from inserted

END TRY

BEGIN CATCH

Insert into server1.database.schema.table

select * from...

I am not sure if sysdepends is a fool proof way of identifying dependencies.

I remember i could create procedures to select from non existent tables and then add the...

have you checked if there are any blocing processes on any of these objects.

the below link is a good place to start

http://msdn.microsoft.com/en-us/library/ms144256.aspx

Different disk means what , LUNS or just a paritioned drive.

Is this the index for a partitioned table.

Intellsense is not fool proof , i had a issue recently where i created a table data type and was not able to refer it within a proc as it...

check the autogrowth setting for the log file in the db , make sure the db backups are compressed , enable database compression to reduce the size of the database.

Having used SVN , VSS , TFS and Redgate Source control , I would go with TFS or Redgate Source control since these are more coupled with SQL and also...