sys.objects is a view which is filtered on the database_principals permissions.

rows of data may exist for an admin which will not be visible to that user; simple enough to prove:

create...

well, as you probably read over at books online about sp_settriggerorder (Transact-SQL), you can set the first trigger, and the last trigger.

there is no way, with four triggers, to know...

databases all by themselves are independant of service packs.

only system databases(master,model,msdb)...

another way to do it:

use xp_cmdshell to get a list of all files in a directory, or all files including subdirectorys;

sticking that data into a table, you can join the...

ok got it.

the files may have been deleted.

You could do it via xp_cmdShell, or with a nice CLR that Elliot Whitlow has posted out there:

http://nclsqlclrfile.codeplex.com/

then you can use a simple...

I think the pointers may be to files stored elsewhere, not to data in the database.

[/quote]

must be a long day; i'm still not reading the requirement right yet.....

ricardo.cuevas (4/3/2012)

---

Greetings. Long time lurker first time poster. BTW I love this site. Very professional and educational. I'm looking to find orphan records on a single...

Is there an easier way to determine "good" vs "garbage"?

would it be a solution to find values not in the dictionary, or values that do not pass a spell check...

if you want to script out the trace just in case you need to put it back again, I've posted a very nice TSQl for it you can find here:

sp_ScriptAnyTrace.txt

do a quick SELECT * FROM sys.traces

if you have C2 auditing on, id=1 is the c2 trace, and id=2 is the default DDL trace;

otherwise id=1 is the default DDL trace.

everything...

pammu (4/3/2012)

---

Thanks for your quick reply.

mentioned rights given to the user and after executed the send mail query i am getting the below mentioned error. May be it needs some...

to make it 1:1, you simply add a unique constraint on the child table's column that is referencing the Parent;

so it's not a "type" of foreign key you are looking...

your user "TEST" needs to also be a user in the msdb database.

that user needs to be in the DatabaseMailUserRole which exists in that database.

something like this is the...

I absolutely did not mean to imply that you did not have any experience, and I definitely did not mean to offend you.

If you read my post that way, I'm...

I think digging at the setup for db_mail is fine; we've got to get Welsh from...