Viewing 15 posts - 18,061 through 18,075 (of 19,560 total)
One last one to try - have you tried connecting as 'SA'?
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
January 18, 2010 at 3:14 pm
MrT-SQL (1/18/2010)
Steve Jones - Editor (1/18/2010)
I tend to agree with #3 as well
Thanks for the reply Steve.
3 it is, just thought it best to check, sometimes you cant see the...
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
January 18, 2010 at 3:01 pm
MrT-SQL (1/18/2010)
As my decision was being influenced by the volume of NULL values, it helped to clear a few...
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
January 18, 2010 at 3:01 pm
NP.
Sidebar - Option 2 poses potential performance problems with it too. I have seen bad implementations of this that killed the database.
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
January 18, 2010 at 2:36 pm
Off the top of my head - no. I would need to Google it. During audits in the past, we have had a publication of Mandatory controls issued...
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
January 18, 2010 at 2:28 pm
Exact same question as another user posted. Interesting Coincidence.
Answer:
Grant CREATE PROC to a role. Put Users in that role.
Grant ALTER SCHEMA on the schema(s) that the Users need 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
January 18, 2010 at 2:15 pm
Grant CREATE PROC to a role. Add Users in that role.
Grant ALTER SCHEMA on the schema(s) that the Users need to modify stored procedures in to the role.
Grant VIEW DEFINITION...
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
January 18, 2010 at 2:14 pm
No additional ideas. Just a comment. I would go with option 3. This one seems to make the most sense.
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
January 18, 2010 at 2:09 pm
This article describes some things you can do.
http://www.mssqltips.com/tip.asp?tip=1416
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
January 18, 2010 at 2:03 pm
Toad is a tool that could work for you. Roy's suggestion is an excellent one.
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
January 18, 2010 at 1:50 pm
As for the command line option...
There is the DAC.
http://msdn.microsoft.com/en-us/library/ms178068(SQL.90).aspx
If you can login with a SQL account though, then you would not need the DAC.
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
January 18, 2010 at 1:46 pm
pbyrum (1/18/2010)
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
January 18, 2010 at 1:44 pm
Steve Jones - Editor (1/18/2010)
😀
:crying:
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
January 18, 2010 at 1:42 pm
Other than Steve's suggestion there is the possibility that somebody removed the "Builtin\Administrators" from this Instances Security.
Are there other instances on this server? Are they properly functioning?
Also, could you...
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
January 18, 2010 at 1:42 pm
pbyrum (1/18/2010)
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
January 18, 2010 at 1:19 pm
Viewing 15 posts - 18,061 through 18,075 (of 19,560 total)