How did you know there is no other application running against your SQL Server?

You may try sp_who2 active or SELECT * FROM master..sysprocesses to check activities on your SQL Server.

You...

From your error message, it does not seem to be a security issue, at least at this moment. The error is VBScript error with losing definition of an object.

Please check...

In my memory, we cannot alter a column to IDENTITY, not for CE.:hehe:

I agree with mobasha's comment. At this moment, I have not got any clean solution since I post this question a week ago.

Also, I would like to show my thanks...

In SQL 2005, you can check sys.syscolumns table.

May the following links help.

http://www-912.ibm.com/s_dir/slkbase.NSF/0/5a3856efecb7f19f8625672b006cee76?OpenDocument

http://peoplesoft.ittoolbox.com/groups/technical-functional/peoplesoft-enterpriseone-l/sql-server-2005-connection-to-the-iseries-1258362

Check the following link. May it help.

http://msdn.microsoft.com/en-us/library/ms175887.aspx

Collation can be set at different levels, such as database-, table-, and column-level. It is all based on your desire.

Thank you for your input.

How about the packages, assemblies, ... in the system databases?

Let me see whether or not I can help the "good boy" :hehe:

SELECT Company, MAX(Employee) FROM yourTable GROUP BY Company

The script is acceptible in SQL 2005, but not in SQL 2000. You need to remove the quotes for default values.

As far as I know, a web server uses an application account to connect to a database server. If you kill its spid, it will connect the database right away....

As far as I know, there is no issue in changing compatibility level on SQL Server side. What you need to do is to check whether or not your application...

How about?

DBCC FREEPROCCACHE

You cannot find original size of a database.