Viewing 15 posts - 13,261 through 13,275 (of 22,224 total)
Anna_SQL (2/14/2011)
I downloaded an enterprise version of sql 2008 and I will install it on a testing machine.
This machine will be...
"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
February 14, 2011 at 1:42 pm
For a) you want to take a look at the default trace. That's how you can tell who made structural changes to the system.
As far as b) goes, if the...
"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
February 14, 2011 at 1:40 pm
Brandie Tarvin (2/14/2011)
Grant Fritchey (2/14/2011)
Roy Ernest (2/14/2011)
GilaMonster (2/14/2011)
Craig Farrell (2/14/2011)
GilaMonster (2/14/2011)
Another promising looking contract cancelled due to lack of @#$$#@$%$ budget!
I'm almost at the point of walking away and...
"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
February 14, 2011 at 12:48 pm
mw112009 (2/14/2011)
After about 2 hours the result was the same. When I logged in I did not see SSMS running.Why did it shut down on it's own ?
That, I don't...
"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
February 14, 2011 at 12:27 pm
Crud. I mean restore. Sorry.
"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
February 14, 2011 at 12:06 pm
Grant Fritchey (2/14/2011)
mw112009 (2/14/2011)
Question: Can...
"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
February 14, 2011 at 12:06 pm
Roy Ernest (2/14/2011)
GilaMonster (2/14/2011)
Craig Farrell (2/14/2011)
GilaMonster (2/14/2011)
Another promising looking contract cancelled due to lack of @#$$#@$%$ budget!
I'm almost at the point of walking away and going to work in...
"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
February 14, 2011 at 12:06 pm
Raghavender (2/14/2011)
if you think this will encourage the fake guys, np,...
"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
February 14, 2011 at 12:04 pm
Check the schedule on the job. It is probably disabled as well. Instead of disabling the job, if you disable/renable the schedule on the job I think you'l run into...
"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
February 14, 2011 at 11:10 am
mw112009 (2/14/2011)
Question: Can we run...
"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
February 14, 2011 at 10:32 am
SanDroid (2/14/2011)
Grant Fritchey (2/14/2011)
paul.knibbs (2/14/2011)
"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
February 14, 2011 at 10:31 am
GSquared (2/14/2011)
GSquared (2/14/2011)
Tom.Thomson (2/11/2011)
Grant Fritchey (2/11/2011)
Lordy, that's still going on?
Yes, and now as a result of nadabadan's reply to Brandie our favourite Saint is feeding the troll. Will this wear...
"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
February 14, 2011 at 9:22 am
mw112009 (2/14/2011)
Grant Fritchey (2/14/2011)
mw112009 (2/14/2011)
When I started the "RESTORE.." I used the query window in SSMS.
Then 4 hours later when I logged back into the server...
"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
February 14, 2011 at 9:20 am
mw112009 (2/14/2011)
When I started the "RESTORE.." I used the query window in SSMS.
Then 4 hours later when I logged back into the server I did not...
"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
February 14, 2011 at 7:57 am
sjimmo (2/14/2011)
restore database NGProd
from disk = N'D:\Backups\NGProd.bak' with file = 1,
move 'NextGen_System_Data' to 'D:\Databases\NGProd\NGProd_System_data.mdf',
move 'NextGen_Core_Data_1' to 'D:\Databases\NGProd\NGProd_Core_Data_1.ndf',
move 'NextGen_Index_1' to 'D:\Databases\NGProd\NGProd_Index_1.ndf',
move 'NextGen_Log' to 'D:\Databases\NGProd\NGProd_Log.ldf',
recovery,
stats = 10;
As an FYI -...
"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
February 14, 2011 at 7:09 am
Viewing 15 posts - 13,261 through 13,275 (of 22,224 total)