Hi Chad Miller

Thanks for providing the script. i would like to know whether this script work for 2005/2008 or do you have different script ?

Basically i am trying to find...

hi

dbcreator have only permission to create new database on the instance, if you want alter the database to add the file, u need db_owner of alter database permission on...

Hi

if sql server agent is not able to connect sql server database engine, we will get this error

Kindly check what service account sql server agent service is running , whether...

Hi SQL DBA

I am also working from sql 2000 version... i have around 5+ years experience in SQL Server DBA and around 2+ years exp in DB2 DBA.

According my experience,...

hi

Kindly find the sample code...hope this will help u...is there any better way of performing the delete operation, kindly let us know

Declare @count int

set @count =0

while @count<=2000

begin

delete from tablename...

Hi

Please provide more information about your server as well as sql server memory configuration

1 )What is memory configuration in boot.ini file (swtich used related to memory usage like /PAE...