Oooooohhh. Me like TVP! 😀

Thanks opc!

Sure, here you go. I use Windows security, which appears to be the default for sqlcmd, as I'm not setting that switch in the call below.

function ApplyScriptFile ()

{

param ($DstSrv, $DBName,...

SQLCMD has an -o outputfile parameter, to which output and errors can be written.

I actually have a function which:

1) Receives servername, dbname, infile, outfile

2) Writes to outfile the time, server,...

I used to do deployments by .bat file, but PowerShell is SO much simpler -- OK, it's a little complicated at first, but once you get the hang of it,...

Solved by workaround: if unable to open using Bulk Insert, do nothing.

15 minutes is the lowest possible setting, according to my admin guy: we tried for 5, but he sent me a screen shot showing the message box where it says...

Yay, problem solved. My domain admin found a way to grant me rights to run repadmin /replicate without making me domain admin!

P

Ah...but that just moves the problem from remote to local... as in the local SQL Servers won't see those groups until the replication occurs.

I was given the rights to create...

Hey Brian,

So if I understand you, I can create the AD groups on both DCs?

There won't be a problem with out-of-synch SIDs after replication occurs?

Paul

4 x 2000 (archived data)

10 x 2008 R2

You should definitely NOT allow incorrect data to be recorded in the database.

If you have enough info to determine what the proper data should be, then do so, and let...

Thanks Ninja.

Interesting thread. I may yet opt for the sqlfool colour scheme solution as well. Nothing like a visual in-your-face clue.

Bob's solution is definitely working for me, it's not too...

Robert,

That's close enough!

Much appreciated.

P

Wow.

Glad to see I'm not the only one who wishes it wasn't made so easy for us to make a Really. Bad. Mistake.

Hey Microsoft: Can we PLEASE have...

Doesn't do it. On both sprocs, sp_depends returns no results.

if object_id('proc1') is not null

drop proc proc1

go

create proc proc1

as

print 'proc1'

go

if object_id('proc2') is not null

drop proc proc2

go

create proc proc2

as

exec...