Viewing 15 posts - 481 through 495 (of 1,179 total)
Check the following link for Microsoft support:
http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=sql
Assess the risk of continuing with old SQL Server version and communicate to the client/owner.
However it's better to check all this in test environment...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 5:35 am
Check the system table sysjobactivity and find out if you can get what you want based on start & Stop execution date?
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 5:25 am
Not always but yes most of the time.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 5:16 am
check following link might help...
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 5:14 am
Check this out:
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 3:44 am
As per the data provided everything looks OK; as only 36 MB unallocated space is reflecting out of 45 GB.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 3:31 am
Refer following link:
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 3:24 am
visit following link to troubleshoot step by step:
http://technet.microsoft.com/en-us/library/ms187540(v=sql.105).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 12, 2014 at 11:04 pm
In this process no reverse gear i.e. once you failover to 2008 R2 you can't again use 2005.
Hence, advisable to take take full backup and if required log backup in...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 12, 2014 at 11:00 pm
Easy one, thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 12, 2014 at 10:37 pm
You need outgoing mail server (SMTP) for Database mail.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 12, 2014 at 3:29 am
What is the size of the database? Check the availability of downtime howmany hrs? Based on this you can check other options too like attach/detach, logshipping.
Yes, it is possible. Refer...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 12, 2014 at 3:22 am
check following link:
http://www.techtalkz.com/windows-server-2003/39348-server-2003-restart-log.html
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 12, 2014 at 3:04 am
Good Question. Getting +2 questions continuous in a row 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 11, 2014 at 11:13 pm
SQLRNNR (3/11/2014)
Koen Verbeeck (3/11/2014)
free_mascot (3/11/2014)
Koen Verbeeck (3/11/2014)
Although the IDENTITY property doesn't always transfer:
When an existing identity column is selected into a new table, the new column inherits the IDENTITY...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 11, 2014 at 10:56 pm
Viewing 15 posts - 481 through 495 (of 1,179 total)