Okay threadiatics, if you have choice between putting data for multiple applications in 1 database because there is some common data or application specific databases?

Wow, I go offline for a day and there are like 60 posts to catch up on.

Glad you are almost there Lynn, have a great vacation.

OP's who have urgent...

I wonder if either signing the procedure or using a synonym would help. I doubt it and I can't try it until Thursday at the earliest as I will...

Okay, I did a little bit of testing and I can't seem to get it to work without specifically mapping the local login to the remote login as part of...

You see the login name column, but not the NTUserName when you use SQL Authentication.

Is logged a datetime or smalldatetime datatype?

What are the execution plans?

That's an interesting issue. I'd run profiler against the linked server and see what credentials are being passed.

Can you post your linked server setup?

I don't have system...

Just keep in mind that Between is inclusive and that sometimes causes problems with datetime columns in SQL Server since SQL Server stored everything as Date AND time so 1/1/2009...

As mentioned in the article provided, many times better or more appropriate indexing can clear up deadlock issues.

But why confuse things by referencing the deleted table when there is never going to be any data in it? Seems like an unnecessary complication.

Most dedicated DBA's like to roll their own maintenance routines instead of using maintenance plans. One issue with Reindex/reorg using maintenance plans is that every index is touched regardless...

Glad I could help. I' recommend against using the datareader role. That means that hey can query any table withing the database, even ones that may be created...

Really can't answer the question without more information. Have you checked for blocking issues/deadlocks when the procedure hangs?

Nope. Can you provide some code?

Are you getting the select by doing a PRINT @sqlstatement in the procedure?

You might want to try running profiler when you run...

Well, the login will need logon rights and then the logon will need to be mapped to a user in the desired database(s) and they will need select rights on...