the %PATH% allows you to do things...

In SQL Server, they are the same thing...in ORACLE and maybe other DBMS systems an AFTER trigger is different.

The first ingredient in properly employing triggers is to understand the differences...

ruff if you only have hours and minutes, how are you going to get a datetime? you need a base/starting point...is that jan 1 of this year, for example?

you could...

there's a trick that you can get randomly ordered records by using the NEWID() function...is that what you are after?

select top 10

ColumnList

From SomeTable

order By NEWID()

and this?

in both...

something like this?

--SandBox_2011-05-27_10-51-42.bak

SELECT db_name()

+'_'

+ REPLACE(

...

ColdCoffee (5/27/2011)

---

Lowell, actually, if u look at the new dataset the OP provided, there are dups.. so, a GROUP BY of managerID with COUNT > 1 wont work on dups.....

what i posted works...whether there's more than one manager or not.

change the query to work on YourTable instead of mySampleData... then tell us what you expected that is different fromt...

physical file? no...you have to ask the SQL isntance what databases it currently has ...usually via a query, though...for example

SELECT name from master.dbo.sysdatabases

why don't you want to connect to discover...

you can do it with a subselect of something featuring row_number(), or simply with a GROUP BY:

With MySampleData ([Record#],ManagerID)

AS

(

SELECT 370868,1427894 UNION ALL

SELECT 274658,1428292 UNION ALL

SELECT 274658,1428293 UNION ALL

SELECT 349883,1430095 UNION...

i'm very weak on the reason why i had to do that trustowrthy thing;

can you turn off trustowrthy, change the proc to WITH EXECUTE AS SELF, and...

Tom the way i've done it is like this: you'd just have...

it's right at the end: remove the last AND to see ALL dependancies, ro make it...

not an easy way...

every Login would need a user in each databaser, and each user would need to be added to a role that gives them read access and...

glad I could help!

Thansk for the feedback!

here you go...look at the WHERE statement at the end..specific column name, and must be a view...you can change that to fit your needs if needed:

/*

obj_nmcol_nmdep_obj_nmdep_obj_typedep_col_nm

GMAACCPACTTBLKEYVW_GMBENEFViewNULL

GMAACCPACTTBLKEYVW_CDBGACCOMPViewNULL

*/

DECLARE @ColumnName VARCHAR(100)

SET @ColumnName =...