Viewing 15 posts - 13,741 through 13,755 (of 22,227 total)
gmamata7 (12/29/2010)
Perhaps you want to explain what you are trying to do in the database from a logical perspective, rather than saying you want a login to own a schema....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 30, 2010 at 6:03 am
Jack Corbett (12/29/2010)
You can get the query text yourself...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 30, 2010 at 5:58 am
Craig Farrell (12/29/2010)
http://balapalani.blogspot.com/2010_12_01_archive.html
It's roughly a copy/paste...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 30, 2010 at 5:36 am
What's the deal. You guys can't keep your girl friend satisfied? She sent me four messages last night. She's begging for attention. Come on on gentlemen. Do your duty.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 30, 2010 at 5:35 am
There is no completely reliable method for retrieving this information. Almost any method you use can be spoofed because a given table is only accessed once a month/quarter/year and if...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2010 at 1:43 pm
GRANT CREATE TABLE ON SCHEMA::MySchema TO MyUser
You'd need to do that for PROCEDURE, VIEW, etc.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2010 at 1:39 pm
Koen (da-zero) (12/29/2010)
Grant Fritchey (12/29/2010)
Yes a full backup every night means that you should be able to recover up to the last full backup. And, yes, you're right, without...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2010 at 12:22 pm
ankur_libra (12/29/2010)
Hi Grant,Thanks for the response and Sorry for posting my question here.:crying:
With regards,
Ankur
No big deal. Like I said, for future reference.
It can just lead to confusion when people...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2010 at 9:17 am
Jack Corbett (12/29/2010)
Hello My New Friend.
Good Day and How are you today.
Please...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2010 at 9:02 am
ankur_libra (12/29/2010)
The similar case is with one of our clients which are using the Symantec Backup Exec 12.5. They have also purchased SQL Agent license from MS. Now...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2010 at 9:00 am
Since SQL Server is turned off, yes, those backup files are useful. They can be used to reattach a database in the event of a disaster. Now, you won't have...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2010 at 8:16 am
check sys.dm_exec_sessions to be sure you're seeing all connections. sys.dm_exec_requests only shows active connections.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2010 at 8:14 am
GilaMonster (12/29/2010)
I am really struggling for inspiration for a 24hop abstract. Would a session title 'Bad plan! Sit!' intrigue people, or kill them with laughter?
Ha! You'd get a few, for...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2010 at 7:50 am
Brandie Tarvin (12/29/2010)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2010 at 7:50 am
Apologies. I think that might have sounded more argumentative than I meant for it to.
I agree. There are a number of ways to skin this particular cat. None of them...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2010 at 7:46 am
Viewing 15 posts - 13,741 through 13,755 (of 22,227 total)