There are many possibilities for the slowness. For example, (1) are there more users or applications running against the server ? you should run perfmon to check the activities on that...

Andrew,

You can use xp_sendmail from SQLTask within DTS. xp_sendmail is really convenient if you are using SQLMail. Take a look at BOL. It's really simple to use. If you need...

Andrew,

Thank you so much for the info. I've searched Microsoft's website and all indicates Groupwise is not compatible with SQLMail. It's good to see someone (like you) have enabled SQLMail to...

Thank you so much for the reply.

Athur, after your upgrade, did you have any problem with logins ?

Thanks again,

Jimmy

If you have turned off autogrow for data, when inserts exceeded the restricted size, you will also get the error. This could be your case. You can take a look...

Make sure you have permission to view the databases on this server.

It seems you have two questions. Are you saying that you don't see the database or DTS ?

If you don't see the database, then make sure you have permission for...

Thanks Gabor.

How often this system table is updated ?

Thanks again,

Jimmy

Thanks for trying but this xp only provides total physical memory installed. I'm looking for available physical memory.

I found out the problem. It was because user1 and user2 were still logged on. Any security changes I made to NT will not take effect until user1/user2 log off...

If ADP means Access Project, then go to Microsoft KB and look article id 305388. There is a resolution for this.

Jimmy

One possible problem is describe in article 815114. See link below: http://support.microsoft.com/default.aspx?scid=kb;en-us;815114

Yes. It's better to have multiple data files then a single file because SQL Server creates a backup thread for each file that is being backed up.

If you already have...

During the installation it will ask you where to put the data. That's where you specify the db location.

You can use sp_dropserver and sp_addserver to change the name. But if you have jobs, DTS and stored procedures that reference the old name, then you need to change them...