You don't actually say on which server you created the publication?  By the way, the specifications you posted are for SSMS, not for the SQL Server database engine itself.

If I understand your requirement, you want all rows that have a Wait or Wrap Category that are followed by a row with a Logout category.  Is that right?  Does...

I think you're looking for the LAG and LEAD functions.  Read about and experiment with them, and please post back if there's anything you don't understand.

John

Have you tried running SQL Server under a named Windows account (either domain or local) instead?

John

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...