You need to be sure you specify a different databaes name. You want to create a "new" database by restoring the original database's backup as a new database with the...

Can you post some sample DDL and DML? That's a strange one. I'd still suspect that it's a data issue, but it could possibly be some bug.

You'll need some type of delay to run profiler. What you could do is create a stored procedure to start profiler. There are various stored procedures to setup a trace...

I couldn't get objectname to work either. I tend to just record them all and then search later in the textdata column for those sql or sps that I am...

You can also run profiler for specfically that event. I'm not sure that event log will show the hostname. Keep in mind that hostname is a field that is "sent"...

Thomas,

Apologies!, I rebuilt it and it should be there now.

I agree with the above. Paper based systems are a problem in and of themselves. Most of us are getting less used to paper not more. Even email based "forms"...

That is interesting. I would have thought performance would be similar. This is a simple view, not an indexed view? Is there an index on these columns?

Perhaps the query processor...

There are decryption routines on the internet. Search Google and decrypt it and recompile on the new machine.

Derrick is correct. unless you are getting "transaction log full" errors, in which case the NO_LOG option will work.

You are correct there is no default for DELETE, but I think the person was getting at what you said. The default options set for the FK.

Try changing the columns you get, I'd bet you get a different row cont. We fought this issue using Client Access going against a AS/400 and didn't get a resolution...

I would say no. You read by pages, and a page has to contain an entire row, so the order wouldn't matter.  I suppose that the query processor could short...

I agree with Antares. You don't want another Windows machine to be a router since that would be asecurity risk. Another SQL Server that could see both, while inefficient, would...

I assume the logfile is full for one of the databases. You haven't really posted much informaiton. You can try "backup transaction xyz with no_log" and then run a full...