I know... But I didn't get connected. Thats the problem I got into. Anyway this is resolved.

Thanks.

John,

Do you need to go according to your Tech. Specs?! or are you designing tech specs.?

If you are in the begining stage, I think better choice would be teh way...

Len,

Its your turn... hmmm... Let me guess... Is it your phone number??

toni,

did it work? Just curious.

Two things...

1. Whatever might be your database size, your database backup size will be proportionate to used space in your database.

2. Your can attach a single file (.mdf), in...

Allen,

Since the begining we have implemented this way. But since the Agent never ran to show the error in the report. Thats the reason I could not see anything.

Any thoughts!!!

...

I got it resolved... Please ignore this post...

I have tried to start SQL Server in single user mode with "SQLservr.exe -m". I could see that the SQL Server is started. But I am not able to connect...

I have changed EventViewer Setting early this morning to be on the safe side.

Thanks Brian.

Preeti,

No It will write into a seperate file in DATA folder. If this file reaches 200MB, it will close this file andd create another file.

Brian,

Application Event Log was full. I have observed that this getting full because of :

"AUDIT-ALL" in SQL Server Properties - Security page. I have just changed it to "AUDIT-Failure".

Also I...

I have installed SMTP Service on the box yesterday. Do I need to configure anything before I use ?

Is your Win98 running on FAT16 or FAT32?

Please check the limitations in the following page:

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/winxppro/reskit/prkc_fil_tdrn.asp

Thanks Dan. I would implement.