sayfrend (8/22/2008)

---

Thanks homebrew ,

I guessed its because of DTS packages... Its really wierd though, it means when ever you are working on DTS packages you cannot use SSMS query window...

Just changed it to my Gmail account and worked like a champ, definitely an issue on my side, awesome.

I had this issue a couple years ago ... All I remember about a negative spid is that it is an orphaned DTC transaction and it was in fact an...

Apply instacat.sql on your SQL2000 server. This can be found in your SP4 install.

Here is a KB article referencing the issue: http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

Task manager never accurately reports memory usage for SQL.

I haven't done much execution plan analyzing on a linked server call in awhile, so I...

Ok, just went into my account settings and went to change email. Left it the same, hit ok, and it says it sent me an email ... didn't get that...

Have you analyzed both execution plans to see where it is you are slowing down? That would be the first place to start...

vijay_shanthi23400 (8/21/2008)

---

Hi All,

I am Vijay...

I am Going to upgrade SQL 2000 to 2005(inplace upgrade)

Can any one help me regarding ,

Before upgrade do i need to dettach the System and...

Check out the attached ...

It will repair and or remove users as appropriate. Run it in debug to see what work would be done per user. It is pretty self...

Perfect, thank you!

Just talked to my email guys and they say nothing is getting caught in our filters from sqlservercentral.com.

Argh, what the hell!

I still have VS2005 installed and when opening my report solution, I get the message "make sure the application for the project type (.rptproj) is installed". Will this resolve itself...

Aw hell, doesn't look like it's gonna work: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3631425&SiteID=1

Yeah that's a good point, I no longer get the daily email either ...