Viewing 15 posts - 16 through 30 (of 42 total)
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...
October 14, 2002 at 9:18 am
This could get you started. It does not script databases/roles, but you could easily alter it.
Be great!
Michael
October 11, 2002 at 1:04 pm
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...
October 10, 2002 at 2:12 pm
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...
October 10, 2002 at 2:09 pm
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...
October 10, 2002 at 1:51 pm
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...
October 9, 2002 at 8:49 am
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...
October 7, 2002 at 9:24 am
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...
October 3, 2002 at 11:49 am
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...
October 3, 2002 at 7:49 am
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...
September 24, 2002 at 2:01 pm
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
...
September 24, 2002 at 1:38 pm
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...
September 19, 2002 at 2:57 pm
Viewing 15 posts - 16 through 30 (of 42 total)