Viewing 15 posts - 106 through 120 (of 130 total)
1. goto sql server configuration manager
2.goto "sql server 2005 services" then rightclick on sql service goto properties
3.in that go in advanced tab there u will find Startup parameter option in...
November 6, 2009 at 11:53 pm
just fire
"sp_readerrorlog" command in query analyzer , u will get the ans.
October 26, 2009 at 12:36 am
You can perform a side by side upgrade as follows,
1.Take full backup of all the databases in SQL 7 or SQL 2000 for precautionary purpose
2.Script all the logins using...
October 21, 2009 at 3:37 am
You can perform a side by side upgrade as follows,
1.Take full backup of all the databases in SQL 7 or SQL 2000 for precautionary purpose
2.Script all the logins using...
October 21, 2009 at 3:27 am
what is the error Text while connecting thru windows auth.?
October 14, 2009 at 1:22 am
first u will have to install workstation component(SQL 2005) or client component (SQL 2000) which is included in SQL server setup CD.
then only u will be able to connect to...
October 13, 2009 at 11:06 pm
hey guys this will help u
find the attachment
October 11, 2009 at 11:21 pm
Thanx for the reply guys
but i want the format of daily monitoring sheet.
whatever we do in the morning it should be documented
i want sample of that document.
i use...
September 3, 2009 at 11:09 pm
i m having sql2000 & sql2005 both servers
now i want to make daily monitoring sheet which should be automated.
i want a sample sheets if u have it.so that i can...
September 2, 2009 at 3:20 am
hi Megistal
can u tell me those features?
August 18, 2009 at 10:39 pm
i m having total 8 CPUs
i feel MAXDOP should be 4 (as per MS suggestion)
what u feel ?
August 10, 2009 at 4:42 am
but this is not applicable for xp_cmdshell
August 10, 2009 at 4:36 am
currently i m using MAXDOP 0 (Default)
August 10, 2009 at 4:24 am
Viewing 15 posts - 106 through 120 (of 130 total)