Viewing 6 posts - 1 through 6 (of 6 total)
My error - I forgot to mention that this is on SQL 2008 R2 server. BOL does not mention the WHERE <predicate_expression> for 2008 R2. I did get...
December 2, 2013 at 11:48 am
Running the query on SQL 2008R2 10.50.2796, nothing is returned. Still trying to determine why.
September 20, 2012 at 6:22 am
I found some of this code online a couple years ago, I don't have the original authors name. I have modified over the years to work for our setup....
May 18, 2010 at 6:22 am
You can use .NET to read each of the DTS packages and create a summary of the package including connections and code using the Microsoft DTS Com objects. We...
May 14, 2010 at 7:47 am
I think I found the answer to what I am doing wrong.
BOL has definition of db_securityadmin: Members of the db_securityadmin fixed database role can modify role membership and...
May 14, 2010 at 6:58 am
Bhuvnesh (5/13/2010)
BP-503183 (5/12/2010)
I create an NT group login TEST_DB_SECADMIN and granted securityadmin permission to it.you need to set db_owner
If I set db_owner then I don't need to...
May 13, 2010 at 6:55 am
Viewing 6 posts - 1 through 6 (of 6 total)