Yeah the services for network wer disabled got it

Hi sam below is the KB for ur issue

KB Article Number(s): 2133566

Samsql,Grant i had a discussion with MS Team this is fixed in SQL 11 version but not sure about 2008 R2..

They are making an hotfix for...

Your process was involved in unresolved deadlock, therefore, the tables were not dropped and blocked the creating table process in tempdb.

This might be the bug in sqlserver 2005.

create proc...

Thankz gail for the info.

Gail do u mean this..

So, what exactly are the considerations with fillfactor? Higher fillfactor settings should result in less index pages which in turn should result...

Hi Jeff,

My question is if we have a publisher and distributor on the same server how can we migrate it to the new server.

Thnkz Jeff

Gail i read every articles,comments of urz thats wat gives us more exp and add more knowlege ......

Gail i have 3 questions :-

1 wat if there is a clustered index...

Colin please let us know which method u r using Mohammed or saby

Hi jeff i know that is forum is too old but i want to know ur how did u migrated it to the new server

Not much great artical as far as experience is con....

srinivas please go for this blog which might clear ur doubts.....

http://databasemail.blogspot.com

Only one Linkserver need to be created .....

Any suggestion on this will be highly appreciated.......

Hi all,

I have Implemented the Mail system on my sqlserver 2000.

Here as my jobs fails the mail will be send my the 2005 mailing server.

I have not used the...

When an SPID is waiting for an I/O page latch, you may notice that the blocked column briefly reports that the SPID is blocking itself. This behavior is a side...