Viewing 15 posts - 16,831 through 16,845 (of 19,560 total)
Chad Crawford (3/4/2010)
BTW - I thought of a few more assumptions that should have been included:
--Assume you are in the database containing tblUsers
--Assume you have been granted rights 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
March 4, 2010 at 11:04 pm
Henrico Bekker (3/4/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
March 4, 2010 at 11:01 pm
Kingstons response is more accurate for your desired results.
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
March 4, 2010 at 10:39 pm
Not all databases need to be in Full recovery model.
If you currently need to, or may need to in the future, be able to recover your database to a point...
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
March 4, 2010 at 10:33 pm
Please attach a screenshot of the connection properties for the connection you are using to perform the insert statement.
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
March 4, 2010 at 10:12 pm
Thanks Saurabh, I learned something about sparse columns today.
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
March 4, 2010 at 10:10 pm
Idera Diagnostic Manager
Quest Spotlight
Confio
Those are options to purchase. Or you can develop some inhouse stuff to monitor performance counters, jobs, database files, backups, etc.
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
March 4, 2010 at 9:54 pm
When I use your last set of code, I get successful (expected/desired) test results.
Msg 229, Level 14, State 5, Line 1
The INSERT permission was denied on the object 'paramore1', 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
March 4, 2010 at 9:50 pm
masterpiecebeta2 (3/4/2010)
hey pal the user is= masterpiece
That doesn't answer my question though. You created that user for testing. Did you login with that user prior to creating that...
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
March 4, 2010 at 9:42 pm
How did that one perform in comparison to your other scripts on your system?
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
March 4, 2010 at 8:48 pm
Did you run the deny prior to or after running the insert?
The order of your statements shows insert and then deny.
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
March 4, 2010 at 8:47 pm
Which user were you logged in with when creating the table?
Which user were you logged in with when running the insert statement?
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
March 4, 2010 at 8:45 pm
Excellent QOD idea
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
March 4, 2010 at 8:36 pm
If you are referring to Users then check out this link
http://msdn.microsoft.com/en-us/library/ms190387.aspx
if you are looking for a way to compare database structure (schema) between two different servers, then check out RedGate...
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
March 4, 2010 at 6:20 pm
GilaMonster (3/4/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
March 4, 2010 at 6:07 pm
Viewing 15 posts - 16,831 through 16,845 (of 19,560 total)