I think you will find quite a few similarities within the TSQL constructs. Remember MS "created" their RDBMS with a little help from the folks at Sybase. My...

This could get you started. It does not script databases/roles, but you could easily alter it.

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=486&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1

Be great!

Michael

You will need to write triggers on all of the tables you want to track.

Not pretty, but it can be done. I did it a few years ago on...

You are in luck - as long as your company has deep pockets - SQLCast, http://www.castsoftware.com/.

It does other things, but a side benefit is that it will give...

An alternative to a trigger would be a job that checked the CRDATE field of sysobjects and notified you. Very flexible and customizable.

Let me know if you want particulars.

Be...

You can add filtering as needed.

SELECT sf.groupid AS GroupID, substring(sf.groupname,1,30) AS FilegroupName,

so.id AS ObjectID, substring(so.name,1,30) AS ObjectName,

CASE si.indid

WHEN 0 THEN 'TABLE'

WHEN 1 THEN 'CLINDX'

WHEN 255 THEN 'TEXT/IMAGE'

ELSE 'NCLINDX'

END AS...

A blanket approach, just change the type to reflect the object(s) you want to grant:

SELECT "GRANT SELECT ON "+name+" TO <role/user>"

FROM sysobjects

WHERE type IN ("U","V")

ORDER BY NAME

SELECT "GRANT EXEC ON...

Sorry I meant @dbuse not @dbname.

Be great!

Michael

Huhm!?!?

SELECT db_name() works, returns MASTER, only if I do not inlcude @dbname = '<database>'. If I include that, it fails.

I also tried send the SELECT statement with...

Yes, same error.

Be great!

Michael

Yes

No - 5.5

Be great!

Michael

SQL2000 w/SP2.

For testing purposes. The email's subject is SQL:bo, the body says SELECT @@servername. In ISQL - EXEC sp_processmail @subject = 'SQL:bo', @dbuse = 'bo'. This returns...

My apologies for jumping the gun. The SQL-DMO script will only script table permissions. Add these pieces to the DIM area for procedures/views:

Dim oPROCDDL ''As SQLDMO.TableSchema

Dim oVIEWDDL...

If you just need the object permissions, try one of these 2 options, both of which can be executed on the source.

1. This is a SQL-DMO script

...

Create a job (ActiveX Script), paste this code, change the appropriate information and you are set. It is a SQL-DMO piece that we use.

Dim conServer

Dim fso

Dim iFile

Dim oJB

Dim strJob

Dim...