Hi Lynn,

Here is the syntax error

Msg 102, Level 15, State 1, Line 9

Incorrect syntax near '@file1'.

Msg 102, Level 15, State 1, Line 10

Incorrect syntax near '@file2'.

Msg 102, Level 15, State...

I can do that and see if it makes any difference. Thanks.

No, if I change the schedule of one job, other automatically gets changed. Both runs at the same time.

No, I didn't find the fix for this. I reinstalled SQL server 2005 and then applied SP4.

Thanks MysteryJimbo

The max. memory allocated using the memory settings is for SQL buffer pool which includes data cache and procedure cache. There are a number of SQL Server objects that use...

Anybody is having some idea on this?

what is the error message you are getting?

Thanks..

Use the delete query with the where condition as

Where Column1<21 and Column1 not in (20,10,1)

If you have the same table name use the secound option to write a query. In the destination field select the table name where you wanted to inserted.

You can just edit the name of the table in the destination and rename it. By default same name will be there as source.

I am not sure about the tables but if you want to get the details from t-sql. you can run

sp_readerrorlog 0,1,'login'

This reads from the error log and returns the details...

Run this to get number of instances and names in a particular server

Exec xp_regenumvalues N'HKEY_LOCAL_MACHINE',N'SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL'

Thanks Perry. It worked fine now.