Right. I'm not doing all your work for you. Have you searched for that error message? What else do you have installed on your server?

John

Sachin

I would concentrate on that line you mentioned in your original post. Have you searched the internet for it? What have you got installed on your T drive?

John

Sachin

That's the errorlog file, isn't it? I need SQLAGENT.OUT.

Thanks

John

Sachin

Please will you post the contents of your latest SQLAGENT.OUT file?

Thanks

John

If it's only the user database that you're going to backup and restore, then you will need to script out logins, jobs, mail profiles and so on, and create them...

You should be able to get all the information you need from the sys.database_permissions system view.

John

The correct string length will be returned. Try the code in the attached file.

John

What you've got should work - just change varchar(@Length) to varchar(1000). Not sure why you need a UDF, though - the built-in function LEFT should do exactly what you...

If you have SQL Server Agent running under a local account then you can't do it. You need to run it under a domain account.

John

Is the destination table on a separate instance? If so, check that the SQL Server Agent account (or a Windows group of which it is a member) is set...

Sounds like it might be an issue with permissions. I take it when you say "scheduled", you mean it runs as a SQL Server Agent job? If so,...

You could try an outer join, or you could look at the EXCEPT operator. As ever, you'll want to to test each one against your own data to see...

You can find view definitions in the sys.sql_modules system view.

John

Sharon

Look at the ROW_NUMBER function.

John

Sanz

Perhaps you are supplying different parameters, or maybe your connection settings are different (things like SET ANSI_NULLS). Different connection providers (ODBC, OLEDB and so on) have different default settings.

John