Thank you so much.

Product A and B have nothing in common except democraphic tables. A developer suggests put Product B in a seperated database so that he can use...

Thanks for the replies.

Here is the basic table relationships.

Account

AccountGUID (PK)

SalesrepGUID (FK)

AddressGUID (FK)

PhoneGUID (FK)

ProductA

ProductGUID (PK)

AccountGUID(FK)

Address

AddressGUID(PK)

Phone

PhoneGUID(PK)

Salesrep

SalesrepGUID (PK)

User

UserGUID (PK)

UserAccount (1 user to many accounts relation)

UserAccountGUID (PK)

UserGUID (FK)

AccountGUID (FK)

Since all existing...

Thanks, The table is back.

The process status =runable, open transactions = 1, command=execute,blocking=0

I still cannot kill it. Any comments?

Thanks

Yes, you are right. spid 80 is gone. But spid 20 blocking is 0 status is running. It has a rollback transaction. I tried to stopped the job, it said...

Thanks, ianscarlett.

You are right. The account I tried was a remote PC access network via VPN and it does not have access to the network direcotry. It works if I...

Thanks, Thomas,

I found the related article using xp_fileexist.

Thanks, Andy.

How often do I need to run dbcc checkident?

Thanks, Jay:

It works after I used inner join instead of left outer join. I am wondering about other queries that have to use left outer join.

It happens on some complicated queries joined from several tables. These tables are updated frequently. It ran ok for several months with execution time 1s. But now it takes over...

It works after I rebooted server.

Thanks

I have trouble to connect to the SQL Server with windows authentication settings from ASP or VB.

It works if I use SQL Server authentication as: dsn = "Provider=SQLOLEDB; Server=xxxxx; Database=xxxxx;...