Thanks joie, I agree about updating SQL versions to 2005. Believe it or not I have customers whos databases are still on version 6.5 and I have a proposal to...

to the reply from igor to my post earlier. I didnt say delete the table. I was talking about removing the referenced data e.g

Table A

TableAID int PRIMARY Key IDENTITY(1,1),

data varchar(100)

Table...

i've got some servers that are currently on SQL 2000 RTM and was wondering how to proceed with updating their patches to the latest versions even though its 2012 the...

you need to find the table that is referencing the data in your rolemaster table and remove it before you remove it. otherwhilst you will have a lot of problems...

I was trying to remember what else I did. Yes my rdp shortcut also used the /netonly command.

Do you know why a local SSMS is so slow when connecting to...

I have been experiencing similar problems:

found the following useful:

http://msdn.microsoft.com/en-us/library/ms176029.aspx

I'm still going through this. but its a long ardeous task. My tempdbs grew from 25gb to 33gb. But just...

Hi Kapil,

How are you trying to do this?, what error is being returned? try the above recommendations and if they do not work post further information. however it sounds like...

Hey Rich, I used to RDP to database on cloud servers. beyond that test/dev servers were kept local so I would only RDP to them when I needed to move...

"doesnt break anything" DBA 😀

Hi,

I was just doing some audits on databases i've inherited. A useful blog that hasnt been mentioned is:

http://sqlserverbuilds.blogspot.com/

I just compared the build versions and made a note of...