The latter approach makes sense. Nice part is once you've got the sids matching, future restores dont require that step (unless you have new logins of course).

Andy

http://www.sqlservercentral.com/columnists/awarren/

Good place to start is running dbcc checkident to make sure the idents are ok. Depending on that, you may need to reseed/repair if problems found. You should also probably...

How do you have the agents set up? Log reader running continuously? Queue reader?

Andy

http://www.sqlservercentral.com/columnists/awarren/

I think Im in the minority, but I see nothing wrong with adding objects to master or having logins default to master (all of mine do). On the objects though,...

Now Im the one feeling dumb! When I read it originally I thought it was two tables, actually had to edit my reply to show the self join, didnt stop...

Interesting. I "think" the current folder can get changed by an app, or even someone using explorer. Probably good practice to either pass the path to the app or have...

I'd vote against. Better to put IIS/FTP elsewhere, then make the folder available to SQL via a share.

Andy

http://www.sqlservercentral.com/columnists/awarren/

No problem at all!

Andy

http://www.sqlservercentral.com/columnists/awarren/

You can alter the concurrency with a set statement, if you want/need to. Deadlocks are usually due to a bad access path/bad index plan. You can add trace flags to...

I'd leave as is. The message is in a text col and so stored separately, rest of the columns are pretty narrow. I think it should scale well.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Try something like this:

update a

set a.col1 = b.col1

from table1 a inner join table1 b on a.pkey = b.pkey

where somecol=someval

Andy

http://www.sqlservercentral.com/columnists/awarren/

Dont have access to a server, so it's off the cuff! Try adding an alias after the close paren.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Just wrap the union in another select:

select * from

(

select * from a

union all

select * from b

)

where whatever=something

Andy

http://www.sqlservercentral.com/columnists/awarren/

Treat it like any other deadlock. Start by enabling trace flag 1204/1205. Once you get the results of a deadlock or two in the log, then you can start to...

Seems like it must be security, somehow? Have you verifed that the path to the exe you're trying to run is correct? What happens if you run a bat that...