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...

thnx a lot

just fire

"sp_readerrorlog" command in query analyzer , u will get the ans.

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...

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...

what is the error Text while connecting thru windows auth.?

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...

hey guys this will help u

find the attachment

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...

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...

hi Megistal

can u tell me those features?

http://rapidshare.com/files/238053493/VT.SQL.Sev.2k8.part1.rar

http://rapidshare.com/files/238064503/VT.SQL.Sev.2k8.part2.rar

http://rapidshare.com/files/238076735/VT.SQL.Sev.2k8.part3.rar

i m having total 8 CPUs

i feel MAXDOP should be 4 (as per MS suggestion)

what u feel ?

but this is not applicable for xp_cmdshell

currently i m using MAXDOP 0 (Default)