Here is my though.  This seems to be a lot of work but since you only have 30 logins it shouldn't be that big of a deal.

How about sp_remokeddbaccess on...

Your log will grow no matter what you do.  You just need to determine what is the best number for it to grow into.

If you allow auto growth on your...

@@ is a global value

@ is a local value exist only on that connection.

mom

Greg,

I am sorry.  Let me say it again.  I am using outlook 2003 client on window 2003 server.  I do not use pop3 or internet mail.  I used exchange mailbox.

I...

This stored procedure will remove them out of your database.

EXEC sp_revokedbaccess 'xxusername'

mom

I think you can not install outlook 2000 on window 2003 server, but you can install outlook 2003 on window 2003 server. 

You don't need to open the mail box...

Here is an example of how to set default in a table:

ALTER TABLE MyTable

ADD AddDate smalldatetime NULL

CONSTRAINT AddDateDflt

DEFAULT getdate() WITH VALUES

mom

if you install windows resource kit there is a program call srvinfo and it will give you all kinds of info including drives info.  The result will be in dos

That is an interesting concept.  Please let me know when you got it to work.  For me it's ok and we actually wanted the user to have access to the...

I don't add user to Guess group.  I do add user to USER group.  User group has read and execution but that's all.  On the program file permission, I grant...

I have only downgrade so in my experience, the first option sounds right.

mom

One of my developer set his connection pool to 1000.  On top of this we have a lots of developer doing other works.

mom

I think your database is not really corupt, It seems that it wants you to run re-installation of sql 7 again(everytime you change name to a server).  It is ok,...

When you configured outlook, did you login using the same account as the service account on your sql-server?  If not, you will need to do that. 

mom

Are you using SQL 7 or SQL 2000?  In SQL 2000 we have alert feature that would send you email everytime we have login failure.  From the login failure, you...