Of course! I was reading the bitmask left-to-right instead of the other way round.

Thanks a lot,

Ben

AJ

I'm aware that Enterprise Manager uses MMC, and I'm fairly familiar with creating custom MMC snap-ins in COM based languages like Delphi.

What I meant was, how would you go about adding...

Thanks guys,

Your responses have been very informative.

Ben

NPeeters,

Thanks for your reply. So they both pertain to the same physical Default object?

What does the DRI stand-for?

Ben

Hi noeld,

I've been asked how to do this for a colleague who basically wants to create an audit trail on an records that have been edited on a given table....

Amit,

That's the idea, yes. Obviously, this info has to be collated from several different sources:

sysobjects, sysfultextcatalogs, sysindexes, sysfilegroups, OBJECTPROPERTY(), etc

I'm fully prepared to sit down and do this myself! No...

Excellent! That certainly helps. Does anyone know what all the possible values sotred in the Type field are. So far I've seen the following values:

3 - Diagram information

4 - Table...

So am I correct in thinking that if I'm dealing with international (non-english) databases that I want to treat everything as unicode?

Ben

Thank you Richard. Do you remember the source of this information so that I may confirm?

Ben

Amit,

Please refer to my post at the top of the page on the same topic at:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=98818&p=2

I'm still compiling exact functional requirements, although in short I would describe this as:

"the...

Well thanks for the help anyway, I appreciate it.

Ben

I'm sure I do have sysadmin priveleges. How do I tell?

I use Windows authentication and my user profile has Admin priveleges system wide.

Tried your suggestions. Get the follwoing error in...

I can view them in the treeview on the left of Enterprise Manager fine, but double click on any of them (TABLES) and get the following message:

"Error 8181: Text for 'syscomments'...

I've tried doing this via Enterprise Manager and alway get errors. Have you managed to do this successfully?

Ben

Steve,

I can't provide an exhaustive list of what missing but take INFORMATION_SCHEMA.TABLES for example. It doesn't return the ID of each table/view returned so, you must uses:

select *, OBJECT_ID(TABLE_NAME) as...