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

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