PS: Is your picture Robert Hays in Airplane?

Confirmed.

Set-Location SQLSERVER:\SQL\MyServer\Default\Databases\MyDB\StoredProcedures

dir | select name

does not return any system sprocs. I wonder why the repl sprocs would fall into the user category.

Weird...

P

$Srv = New-object Microsoft.SqlServer.Management.SMO.Server "Mufasa"

$Srv.Databases["Abb"].StoredProcedures | where {$_.issystemobject -eq $true} | select name

This returns 1300+ system procs -- including repls, and I don't have replication enabled.

P

This will exclude all non-user objects. I assume they're probably not required anyway.

Get-ChildItem | where {$_.IsSystemObject -eq $false}

Mystery solved. Ugh.

I managed to do what I wanted using Substring and IndexOf.

Thanks!

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