If the database is only 190mb why do you need 4gb of free space on the server to do the restore?

Are you saying that there is only 190mb of...

I'm not sure I understand the question. Are you asking whether you need 2 ip addresses, one for each instance in the same or different subnets?

Is there a maximum field length for the TEXT or NTEXT types.

I searched the microsoft website and it looks like there are several issues that generate this particular error message. Here is the link to the search. Hope it helps.

http://search.microsoft.com/search/results.aspx?c=3&p=1&qu=Error%3a+3624%2c+Severity%3a+20%25&s=0&st=b&View=en-us

I have had that happen too. SQLMail is way too quirky in my opinion. I haven't played with it yet, but I hope SQL 2005 is more robust in this...

It is configured to use POP3, and sends mail through our Groupwise pop3 gateway.

Have you run a DBCC Checkdb on your user databases to make sure there is no data corruption.

Also, can you give us a little more information on your environment. Such...

When you changed to the new service accounts did you use EM to make the change or did you change the account in the services app within administrative tools? If you didn't...

Another tool to use is the index tuning wizard, if you know which tables are causing the performance issue. This is good to use in conjunction with profiler.

I use Outlook 2000 sp1, which does not have to be open on the desktop in order to send mail. I know its not the latest version, but it works...

Are you running the latest version of sql srever (SP3)?

I know this is kind of redundant, but I backup our system databases everyday. Considering the fact that they are so small, and take so little time there is no...

Have you rebooted the server since you installed Outlook? Whenever I do a new install of Outlook I have to do that before SQL Server will see it.

I am currently using GW to email alerts from SQL Server. I use Outlook 2000 sp1. Here is how I did it. 1) Make sure that SQL Server is running...

Thanks for all your responses. It looks like I only have a couple of choices. One would be to partition the data on separate physical raid sets, and the other...