Viewing 15 posts - 13,501 through 13,515 (of 19,560 total)
select object_name(i.object_id) as TableName,i.name
from sys.indexes i
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
June 21, 2010 at 9:36 pm
What you did was the first part. You created a login (in the instance) for the user. In order for that user to do anything in a 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
June 21, 2010 at 9:26 pm
hxkresl (6/21/2010)
"Grant db_datareader to the specific databases that the user is permitted to see. "
When I run this:
use AdventureWorksDW
go
exec...
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
June 21, 2010 at 7:57 pm
Trey Staker (6/21/2010)
dbowlin (6/21/2010)
Like they say....it's not the heat, it's the humidity.
So true, I also spent 2 weeks in Huston in August in 90 degree weather and it felt much...
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
June 21, 2010 at 7:38 pm
Are you able to send to any other recipient from the server? Try sending yourself an email from the sql server and see if that works.
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
June 21, 2010 at 7:35 pm
jcrawf02 (6/21/2010)
enjoy!...
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
June 21, 2010 at 2:33 pm
Grant db_datareader to the specific databases that the user is permitted to see. Better would be to grant select to a ROLE for the specific tables that the user...
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
June 21, 2010 at 1:55 pm
Rebuild
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
June 21, 2010 at 9:25 am
crookj (6/21/2010)
WOTD - ScorchingToo hot this week! In the high 80's to the low 100's.
Joe
Sounds like a break in the weather for us in the desert.
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
June 21, 2010 at 9:23 am
Thanks Ron. I learned something more from this question.
Thanks Hugo for explaining it like 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
June 21, 2010 at 9:02 am
Jan Van der Eecken (6/21/2010)
@jason, check that score again! It was 7:0, not 4:0
I know. See the rest of my comment. Simply stating that at 4:0 it would...
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
June 21, 2010 at 8:19 am
Nice question - thanks.
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
June 21, 2010 at 8:17 am
Jan Van der Eecken (6/21/2010)
Did anyone watch Portugal - North Korea just now? Wow, what a result, 7:0. Now you US'ers stop complaining about low-scoring games.
Absolutely stunning result. 4:0...
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
June 21, 2010 at 8:10 am
Does this login exist in AD or is it just a user that exists on your local machine?
Can you browse to the user name through the add login dialog and...
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
June 21, 2010 at 8:08 am
You're welcome.
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
June 21, 2010 at 7:54 am
Viewing 15 posts - 13,501 through 13,515 (of 19,560 total)