Thanks, I had caught that one but forgot to mention it.  It is one of the reasons I haven't applied SP4 yet.

An additional question for you THANG,

Did this bug also affect using Suser_sname() without a sid to get the name of the server login?

I am considering applying SP4, but I use...

Yes, I have had that problem.  In fact Enterprise Manager will occasionally timeout and fail.  I have to guess that it is contention and locking preventing the select.

I'll bet that...

I believe I once tried using DTS to do this and the results were terrible.  Microsoft totally messed up the datatypes.

I have not tried the Migration Assistant.

One suggestion, if you...

Well I can't quote the books, but I just ran a test in SQL Server 2000 and I created a login t with both a password of t and an...

RESTORE DATABASE <Database> with recovery

This will do it.

First of all, make sure that you identify the City table as the parent key table if you are using enterprise manager, or alter the Title table to reference city...

Thanks for responding.

Actually it is a file transfer product.  We tested it and while it can trigger a full backup remotely, the functionality apppears to be full backups only, there...

Couldn't you use the IF UPDATE (ColumnName) to determine if a column was updated?

I have never had a problem with that, but I haven't used it excessively.

SELECT     db1.dbo.tblSalesOrderTrans.salesOrderId,

db2.dbo.tblProductMaster.productName

FROM  db1.dbo.tblSalesOrderTrans INNER JOIN                       db2.dbo.tblProductMaster

ON db1.dbo.tblSalesOrderTrans.productId = db2.dbo.tblProductMaster.productId

Do you think it won't create any performance overhead ?

As long as they are on the same server.  You should...

In my company we ended up having to split one massive database into multiple customer databases and here is some experience.

Querying different databases on the same server, no performance hit. ...

I also remembered something I did yesterday that might indicate what we haven't considered.

I executed the query

SELECT 1

and it took 2 minutes 10 seconds to run.

Ed,

I agree it is a pain in the but as I deal with it daily.

The one thing you might be able to do, is shrink the data and log files...

The time thing is wierd.  Try running the clustered index twice in a row.  See if time drops off. Do this clearing things, and not clearing things.

In Query Analyzer on...

That's cool.  I was really using the classic order problem as an example.  That isn't what we do, I was using it to explore the general question will a unique...