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)