Is there an issue with authentication?

What is the authentication you used to test the script.

Check the authentication of SQL Agent

Try to fine tune the code. Choose proper indexes

Think of enabling row versioning (Pls monitor tempDB growth if you choose to do so)

what does it say if you execute

sp_dboption Database,'trunc. log on chkpt.'

You can verify LSN info using

Restore headeronly from disk='YourBakFiles'

1. Backup your log file

2. DBCC SHRINKDATABASE(Databasename)

Right click the database in Enterprise Manager> all task >Shrink Database

You can also use DBCC command

Its because purchase Id is different. Omit purchase ID in the second view and try

set @sql='INSERT INTO dbo.ImportError

(DataElementID, CenterCode, ValueType, ValueDate, [Value], ImportDate, BatchID, ErrorReason)

SELECT

...

put the whole query to a variable and print it. I think you need to give a space after the where clause

run the procedure manually. Check howmuch time it takes (It may timeout)

Check remote query timeout setting

sp_configure 'remote query timeout'

default is 600 , ie 10 mins

change it to appropriate value

dont forget...

Try additional quotes around the variables - two single quote for escape

EXEC('

INSERT INTO dbo.ImportError

(DataElementID,...

How and when to use them?

Inner join uses a column on first table to match rows in the second table.

eg

Select * from Students,Teachers where Students.TeacherID=Teachers.ID

This is inner join...

Like Gints / Jeff said, only a veteran in both Oracle and MS SQL can give a defenite (and objective) answer based on their hands own experience. Even then people...

Recovery models: Log growth/ Shrinking is resource intensive. In full, bulk logged, log growth apparently should be more. However this may depend on your hardware, and the physical design. You...

Finally it got released on December 15, just one week before I was suppossed to do a risky Patch updation on our production.

:Whistling:

Cheers to the site.

Thanx to all who voted...