Well that seems weird...

However, I experimented with a move and a copy and, in both cases, the permissions were as expected, and identical.

I had the...

Thanks Chris, that did it when I changed the ORDER BY to use the date in the ROW_NUMBER()

Much appreciated!

All:

I goofed on the expected results in the OP: here's how they should appear.
The PK (nrev_Id)  can be out of calendar sequence (because users), so that...

It takes a while, longer depending on the number of servers you have. About 10 seconds for my ~20 instances.

Does your server show up in the list when you
sqlcmd -L

And, Presto! Copying Poshtools_Profile.ps1 files to there did the trick.

Thanks Sue!

Edit: The $Home threw me off since it points to somewhere else entirely.

Doesn't appear to be working:

I've copied my profile.ps1 to

$Home\Documents\WindowsPowerShell\Poshtools_profile.ps1

and

$Home\Documents\WindowsPowerShell\profile.ps1

but in neither case is it being loaded when I start Visual Studio.

Also tried

$Home\My Documents\... to no avail.

Figured it out.

$DescCols = @()

$MultiCols = $objTable.Columns | %{$_.Name.Substring(3)} | group | ?{$_.Count -eq 2}

if ($MultiCols)

{

foreach ($Row in $MultiCols)

{

$DescCols += $objTable.Columns | ?{$_.Name -like "*$($Row.Name)"} | select name

}

}

...and note that $_.IsSystemObject -eq $False still returns the Northwind DB???

Bit of a kludge, but I've found a way. In short,

- create a trace to capture User Error Message events

- script out the trace definition

- start the trace

- run sp_refreshsqlmodule...

Here's the code for anyone interested:

clear

$strSrv = "MyServerName"

$objSrv = New-object Microsoft.SqlServer.Management.Smo.Server $strSrv

$objdb = $objSrv.Databases["MyDBName"]

$ObjectsToCheck = $objdb.StoredProcedures | ?{($_.textbody -like '*MyModifiedObject*')}

$ObjectsToCheck += $objdb.UserDefinedFunctions | ?{($_.textbody -like '*MyModifiedObject*')}

$ObjectsToCheck += $objdb.Views | ?{($_.textbody...

I agree the search is simpler in T-SQL; it's the compiling of the affected code before runtime that I want automated.

Maybe I'm using the wrong word here: I want the...

As I mentioned, I was able to generate my list -- albeit with a few false positives.

Thanks all for taking the time to respond.

PS: Am I missing some obvious reason...

Got my list:

selectdistinct OBJECT_NAME(object_id)

fromsys.all_sql_modules

whereCHARINDEX('dbo.v_enqobj_descriptions', definition) > 0

andCHARINDEX('nNodeType_Id', definition) > 0

andCHARINDEX('.nNodeType_Id', definition) = 0

EDIT: Found sproc that does what I want:

sys.sp_refreshsqlmodule

Yes, using Powershell. I don't have access to SQL Search or VS.

Getting the dependencies is easy. It's finding out which ones will throw an error the next time they're executed...