Viewing 15 posts - 8,701 through 8,715 (of 19,560 total)
If not, then try this
SELECT dp.grantee_principal_id,p.name AS UName
,dp.permission_name,c.name
,OBJECT_NAME(o.object_id) AS TabName
FROM sys.database_permissions dp
INNER JOIN Sys.objects O
ON dp.major_id = o.object_id
INNER JOIN sys.columns C
ON c.object_id = O.object_id
AND c.column_id = dp.minor_id
INNER JOIN sys.database_principals P
ON...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 4:48 pm
See if this helps.
http://jasonbrimhall.info/2010/03/19/security-audit/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 4:33 pm
When you are viewing the data, how are you viewing it (e.g. what is that you are doing to see the ?'s)?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 4:25 pm
Ninja's_RGR'us (9/15/2011)
SQLRNNR (9/15/2011)
Steve Jones - SSC Editor (9/15/2011)
I'm going out of town for a few days....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 4:23 pm
Steve Jones - SSC Editor (9/15/2011)
I'm going out of town for a few days. I'm hoping...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 4:15 pm
Thanks for putting this article together.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 12:38 pm
WayneS (9/15/2011)
SQLRNNR (9/15/2011)
Just saying that we only need 98 more posts for 30,000how many?
Ummm - 96
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 10:43 am
You can try the upgrade of the browser - looks like it may be a memory leak in IE if FF is returning reasonably quickly.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 10:42 am
I would just use a table then.
Also, since the fields vary depending on parameter - you should consider either hiding fields depending on parameter value or using multiple reports to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 10:41 am
Just saying that we only need 98 more posts for 30,000
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 10:24 am
crookj (9/15/2011)
Ray K (9/15/2011)
Stuart Davies (9/15/2011)
SQLRNNR (9/14/2011)
Revenant (9/14/2011)
SQLRNNR (9/14/2011)
crookj (9/14/2011)
Ray K (9/14/2011)
Daniel Bowlin (9/14/2011)
Pressurecooker
Rice Steamer
Jasmine
Thai
Lemon Grass
Blue Grass
Tall grass (I need to mow my lawn!)
The Lawnmower Man 😉
The Stand
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 10:23 am
Well, that depends on your requirements. Do you just want to display the information? Or do you want to have expandable groupings?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 10:22 am
Stuart Davies (9/15/2011)
bitbucket-25253 (9/15/2011)
Stuart Davies (9/15/2011)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 9:47 am
More important than the table design is that when there is free food/drink people will come 😀
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 9:41 am
Thanks for the question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2011 at 9:36 am
Viewing 15 posts - 8,701 through 8,715 (of 19,560 total)