Viewing 15 posts - 1 through 15 (of 71 total)
You need to evaluate your server permissions to know who can create triggers at server level.
November 29, 2009 at 5:04 pm
By Definition that is not possible.
sp_addlinkedsrvlogin [ @rmtsrvname = ] 'rmtsrvname'
[ , [ @useself = ] 'TRUE' | 'FALSE' | 'NULL']
...
November 29, 2009 at 4:56 pm
Please try to use this script.
WITH perms_cte as
(
select USER_NAME(p.grantee_principal_id) AS principal_name,
...
November 29, 2009 at 4:47 pm
Please review this article.
http://technet.microsoft.com/en-us/magazine/2008.04.overview.aspx?pr=blog
November 29, 2009 at 4:42 pm
I agree with Elliott W, Triggers are the best options to do it.
November 29, 2009 at 4:40 pm
You can get the list of Active Directory users for every Group create in SQL Server.
Regards
November 29, 2009 at 4:36 pm
Your should consider evaluate the audit options in SQL Server 2008 instead of modify the original security settings.
November 29, 2009 at 4:34 pm
Question 1: If I add another instance for sql2008 that takes 4 cores and 12gb mem and run it on the same node as SQL2000 that should be okay. If...
November 29, 2009 at 4:11 pm
Please read this article.
Database Mirroring Best Practices and Performance Considerations
November 29, 2009 at 4:06 pm
You should copy the backup from Veritas Tool Tape to physical disk before to start the restore process.
November 29, 2009 at 4:03 pm
Which one is the best possible configuration?
The configuration depends or your business rules and service level agreement.
How many IP address will be reuired for the 4 SQL Server Instances?
One IP...
November 29, 2009 at 4:00 pm
I recommend you enable these options, in order to ensure the best way to memory assignment in 64 bit platform.
1. enable AWE.
2. set 'Lock Pages In Memory'.
November 29, 2009 at 3:54 pm
Hi
What exactly is your question?
November 29, 2009 at 3:36 pm
You can use this reference from Microsoft MSDN site.
http://msdn.microsoft.com/en-us/library/ms179530%28SQL.90%29.aspx
Also review this webcast
November 29, 2009 at 3:34 pm
Viewing 15 posts - 1 through 15 (of 71 total)