I don't like @@Version. I always run:

SELECT ServerProperty('Edition'),

ServerProperty("ProductLevel'),

ServerProperty('ProductVersion')

-SQLBill

The size of database really depends on what edition of SQL Server you are using. Some editions only allow 2 GB for the database. I currently have 207 GB using...

Also, you might want to check your MDAC level. Microsoft has a tool called Component Checker that will tell you what version you have. The latest is MDAC 2.8 something.

Lastly,...

Sounds like a EM specific problem. I would try closing and reopening Enterprise Manager. If that doesn't work, try reinstalling Enterprise Manager.

-SQLBill

Take note that Microsoft has said that they may not always support the use of =* and *=.

-SQLBill

You can't take anyone out of the Public role. Almost every query, at one time or another, makes use of the Master or TempDB tables. System stored procedures are stored...

They can see Master and TEMPDB because they are a member of the Public group which has access to those databases. Check the logins and you should see that...

Quote: We had a fight and argued that friendship should not be used in hiring. Now my friend did not even talk to me anymore !

Did your 'friend' have...

Also, in a previous response I had asked if the SQL Server edition and SP level were the same on all the systems. I didn't see a response. Are they...

One possibility that I can think of...on this one system are you running database maintenance, such as reindexing or index defragging? Each will cause the log file to increase by...

Are they linked servers?

Is there a trigger that moves data from one to the other?

Do you have transactional replication set up?

-SQLBill

If you need to copy logins and passwords to another SQL Server (or just make a backup of them), Microsoft has a great script for it.

http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

-SQLBill

The problem is that when you don't include a time, SQL Server uses the default of 00:00:00.000. So, what is BETWEEN '5/1/2006 00:00:00.000' AND '5/1/2006 00:00:00.000'?

Something else to consider: is...

You still have ten connections to the database. It doesn't matter if all connections use the same username or all different names - it's still ten connections. Your SQL...

Just curious.....what service pack do you have installed? For SQL Server 2000, it should be SP3a or SP4.

-SQLBill