it should live in the following location

C:\Program Files\Microsoft SQL Server\90\DTS\Binn

it should look like the file attached. Once you have changed this file you will need to restart the “SQL Server...

Achtang (4/2/2009)

---

That was good work even I was rolling my sleves up to do the same in sometime as I am at work cant imagine corrupting anything?

Thanks for that,...

Achtang (4/2/2009)

---

and also how do you apply hotfixes? I mean do you have to install it the same way as a SQL Server service pack? I mean do you have...

sorry matey, as the old saying goes "all pirates should find their own treasure", i cant be seen to be helping someone who condones piracy

it did work.

i restored master onto another instance called the db "Newone" and it created the files

newone.mdf

newone_1.ldf

i then detached the db after restoring it and copied the disk files to...

Achtang (4/2/2009)

---

you can restore the backup master database onto another server using a different name and then move the files to the server that is not starting?? Is that posible...

a hotfix addresses a single issue. A service pack is a roll up of many independant hotfixes, etc

if master is truly hosed you will need to rebuild first using the cd

read Gails link below

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

Achtang (4/2/2009)

---

Woww..you are here again :).

so lets say I have a Server...

upgrading is not affected by service pack, they are installed after...

for sql2005 post installation you should ideally...

your welcome, give the virtual server idea a crack it'll make an ideal testbed for you and you wont get fired for wrecking it 😉

surely you would restore a backup of the master database from that server that wasn't corrupt

Achtang (4/2/2009)

---

Hi,

Ia m new to SQL server, its been 6 months or so. Trying to get some knowledge. Hope you guys understand and help me out to the questions I...