Viewing 15 posts - 4,036 through 4,050 (of 9,643 total)
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?
October 15, 2009 at 1:21 pm
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...
October 15, 2009 at 5:53 am
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...
October 13, 2009 at 7:58 pm
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...
October 13, 2009 at 2:42 pm
You see the login name column, but not the NTUserName when you use SQL Authentication.
October 12, 2009 at 9:00 pm
Is logged a datetime or smalldatetime datatype?
What are the execution plans?
October 12, 2009 at 8:43 pm
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...
October 12, 2009 at 8:29 pm
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...
October 12, 2009 at 8:26 pm
As mentioned in the article provided, many times better or more appropriate indexing can clear up deadlock issues.
October 12, 2009 at 8:21 pm
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.
October 12, 2009 at 7:31 pm
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...
October 12, 2009 at 12:16 pm
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...
October 12, 2009 at 12:04 pm
Really can't answer the question without more information. Have you checked for blocking issues/deadlocks when the procedure hangs?
October 12, 2009 at 10:07 am
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...
October 12, 2009 at 9:15 am
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...
October 12, 2009 at 9:12 am
Viewing 15 posts - 4,036 through 4,050 (of 9,643 total)