Viewing 15 posts - 1 through 15 (of 80 total)
Thanks! That did the trick.
October 22, 2009 at 8:14 am
I thought about that. That doesn't appear to be the case. And if this developer logs into a different workstation, they can connect to the db server just...
July 17, 2009 at 10:22 am
We've resolved the issue. The DB Server needed .Net 3.5.
July 16, 2009 at 1:06 pm
RBarryYoung (6/15/2009)
If you are running your exe from a mapped drive letter, try accessing it with a URN instead.
I'm running it from a UNC path... \\mymasterserver\folder\mine.exe. I tried setting...
June 16, 2009 at 12:43 pm
I'm running sql 2005 Standard sp3 on windows server 2003 sp2.
June 15, 2009 at 1:16 pm
I am seeing the error in the job history.
June 15, 2009 at 11:57 am
I am a big fan of nolock and have used it very successfully (and prudently) over the years. I must admit that this whole thread has made me reconsider...
April 22, 2009 at 2:59 pm
Well... I rebooted the server and integrity checks passed after failing 2 nights in a row.
One thing I didn't mention was that we had a bad SAN drive 2 days...
April 6, 2009 at 8:39 am
Thanks for the input Gail. Checksums are enabled and have been for quite a while. It is possible that the databases were originally SQL 2000 but I'm not...
April 3, 2009 at 2:53 pm
Something must have changed within the last year because, to my surprise and delight, the following now works:
SELECT * FROM MyLinkedServer.MyDB.dbo.Table1 WITH (NOLOCK)
This works from 2005 to 2000 and from...
August 26, 2008 at 11:22 am
Wow, I can't believe I didn't notice the timestamp on the CHECKDB. You've answered my question clearly. Thank you. And thanks for the article link.
July 23, 2008 at 10:27 pm
Simon Villiers (6/5/2006)
By "orphaned temp tables" I mean temp tables in tempdb that no longer have any connecting processes/sessions/etc. I know they are dropped when the connection terminates, and when...
May 30, 2008 at 1:30 pm
I think some clarification is needed here.
I set up a sql login called Test with no permissions (other than the default inherited through public). In SSMS I...
May 20, 2008 at 10:14 am
As far as I know, the sql server user that you describe should not be able to restart the server.
I am assuming that you tested this and found that the...
May 16, 2008 at 3:44 pm
Nice article. I would just like to point out that for those of us that have numerous servers, automation of the checklist is critical. If you're dealing with...
April 14, 2008 at 7:32 am
Viewing 15 posts - 1 through 15 (of 80 total)