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

Naru

No, do not have tables with different structures processed by the same data flow. Please post your code - I'm finding it very difficult to visualise.

John

OK, I found a table with only one index, which is non-clustered. The table has 400000 rows and the fragmenation of the index was 57.9%. I rebuilt the...

Naru

You need to make sure that the collection for each loop only contains the files you want to be processed by the dataflow within that loop. One way to...

Jason, I must confess I don't understand. What's the difference...