Viewing 15 posts - 1 through 15 (of 72 total)
this is useful , please check http://support.microsoft.com/kb/981273
October 20, 2010 at 5:17 pm
Right click on user DB for which script is required -> Task - > Generate scripts and choose all items needed and then get the script to query window or...
March 2, 2010 at 11:39 pm
Just a note -
SQL server 2000 client tools cannot connect SQL 2005 and 2008 ,
SQL server 2005 client tools cannot connect SQL 2008 but connects 2000
SQL server 2008 client...
March 2, 2010 at 11:31 pm
Database mirroring can also be implemented in this case, check for the feasibility
March 2, 2010 at 11:26 pm
Integrity job - Reorganizes index , optimization - rebuild index , its advisable not to run both jobs at same time , its worth putting as a single maintenace plan...
July 27, 2009 at 12:21 pm
In which OS you r installing SQL server 2005 and check whether any old SQL server related folders exists in disk
July 21, 2009 at 4:06 am
Edit your maintenance plan and go to reporting TAB
Refer History on this server .
below this there is a checkbox if its checked the mentioned table would have been otherwise you...
July 14, 2009 at 1:33 am
check autogrowth settings of db , whether its in % or MB
July 14, 2009 at 12:52 am
Please refer http://msdn.microsoft.com/en-us/library/ms191543.aspx for details.
July 13, 2009 at 11:18 pm
I have applied service pack to many SQL servers without stopping SQL services , all are successful,just FYI
July 13, 2009 at 11:02 pm
have you tried changing it from services.msc or SQL server configuration manager ?
July 12, 2009 at 1:54 am
No its not possible refer this link http://sqllearnings.blogspot.com/2009/03/mirroring-faq.html
July 6, 2009 at 2:31 am
Job owner must be SQL server startup account and confirm whether you are manually running it or scheduling and running .
July 6, 2009 at 2:24 am
please paste error string , if possible complete job failure history
July 6, 2009 at 2:22 am
Viewing 15 posts - 1 through 15 (of 72 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy