Interesting reaction from this OP.

This is the first time I have anyone saying that. SSMS is just a GUI. It does not do any work. You use it to set up the Job. After...

I am not sure why you want to do this. You can just take back ups. On SSMS, you can use the maintenance plan to set up Back up of...

You could always install SQL Server development edition. You can set up VM ware on your laptop to play around with log shipping, replication etc.

Only thing that comes to my mind is that there is some kid on deny rights on these two particular DB. It could be a login trigger on these two...

The snapshot does a truncate command. When a table is in replication Truncate is not allowed. Since Server B is also replicating, all the tables in Server B has restrictions....

Keep in mind that one of the main reason why you want to use Global temp table is because you want it available for different sessions. That means when it...

Since this is the set up you are stuck with, I would say put the log in RAID 10 and data in RAID 5. Basically because you have more writes...

This is from Symantec if I am not mistaken and they are changing their Schema name to something else.

The only thing that comes to mind is BCP.

DBCC Opentran will show the open transactions and using the SPID you can use

DBCC Inputbuffer (SPID Number)

Or you can use

select s.spid , [Text] as Code from sys.sysprocesses as a

cross...

The SQL Server Express was installed when you did the installation of Visual studio if I am not mistaken. There are some tools/products that come with SQL Server Express.

Just...

Did you or anyone else have the perf mon on when you restarted the SQL Server? I have seen this issue before, that is why I am asking.

From what I saw, the execution plan is totally different between the production and development. The dev is doing a CL seek where as the prod is doing a non...

With power shell you could do it. But you will have to connect to each Db separately I guess.