Viewing 15 posts - 61 through 75 (of 360 total)
capnhector (11/7/2012)
select top 10 b.database_name, b.backup_start_date, b.backup_finish_date
from msdb.dbo.backupset b
with a join...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 7, 2012 at 2:55 pm
Thanks for the script
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 7, 2012 at 11:52 am
Is the job enabled? Does the job use any linked servers? Please post the results of view history of this job.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 10, 2012 at 8:18 am
Per your example the order does not matter. What is the size of the index and the table? What is the number of reads over writes for that index? Before...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 10, 2012 at 8:14 am
Cool...Thanks so much lowell...I was working on it parallely and came up with almost a same script..please find mine below:..Thanks a bunch again
DECLARE @TableName VARCHAR(255)
DECLARE @PKColumnName VARCHAR(255)
DECLARE @sql NVARCHAR(4000)
DECLARE TableCursor...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 4, 2012 at 3:17 pm
Thanks for your help Lowell. I have too many tables and I want to put it in a cursor. But I am stuck at the inner join condition. Here is...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 4, 2012 at 1:57 pm
Sapen (9/26/2012)
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 27, 2012 at 12:41 pm
I verified my local policy settings and found out that "Enable computer and user accounts to be trusted for delegation" has none added to this policy. I just added...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 26, 2012 at 1:33 pm
Experts I need your valuable inputs. Thanks Again.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 26, 2012 at 12:35 pm
Zeal-DBA (9/26/2012)
how do we check if it is enabled or not?
go to control panel--> windows updates-->check if you have enabled it
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 26, 2012 at 11:57 am
Ensure that you have no automatic updates scheduled on your servers.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 26, 2012 at 9:55 am
The Linked server is between sql servers.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 18, 2012 at 9:57 am
I will also be adding few maintenance jobs on this database that will actually purge data from this database on a daily basis and we are using Entity framework scripts...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 4, 2012 at 5:20 am
Thanks For the reply Gail. I will test it before I move it to production.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 3, 2012 at 1:25 pm
Thanks for the reply Gail. . Due to non existent data in our test environments, we dont have a valid environment to use this SP. Hence I will have to...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 3, 2012 at 11:30 am
Viewing 15 posts - 61 through 75 (of 360 total)