OK, if it's all on one computer, you shouldn't need to map any drives.

What do you get if you run this?
SELECT servicename, service_account FROM sys.dm_server_services

When you do it via a command prompt, it runs as you.  When you do it through xp_cmdshell, it runs as the SQL Server service account.  You need to ensure...

Yes, you can do it like that.  I wouldn't recommend creating a permanent server object, though, if, as it seems, this is a one-off task.

John

Edvard

There is indeed!  In SSMS, right-click on DB1 in Object Explorer, then choose Tasks and Export Data, and let the wizard guide you through the steps.

John

You can get to the Package Configuration Organizer through the Properties window.  Click on the design surface of your package and press F4.  Then click on the ellipsis button next...

Is reinitialising the subscription an option for you?  It might be easier than fiddling about trying to identify primary and foreign key constraints.

John

Not really enough information here to answer your question, but you might want to compare how long each individual section takes when run separately against when run in one go....

Now you just have to sit and wait.  If that job history wasn't there before, it won't be now, just because you've changed the number of rows to retain.  If...

Tick Remove agent history and set to to Older than: 1 Month(s).  Then either untick Limit size of job history log, or make sure than the numbers of rows per...

1. If you put OPTION (RECOMPILE) in your sp_executesql command, the statement will be compiled but the plan won't be stored in cache.
2. You only have one statement in each...

Not sure I understand.  Does this help?  You'd have to add a where clause looking for your query text in the "text" column.

John

Is it because of your attempt to concatenate the $PSScriptRoot variable with the rest of the file path?  Perhaps you need to enclose the file path part in quotes, and maybe...

Ant

Try this.  It can probably be simplified and/or prettified, but it's a start.  And it seems to return the correct results. The Apportion and Nominal columns don't appear...