Something i faced yesterday, though this may have nothing to do with your issue. I had a space in between a string and on checking the space turned out to...

I will wait for the next part.

From BOL:

Restoring a copy-only full backup is the same as restoring any full backup.

is the merged database in sql or oracle?

As Paul said we need more details.

Did you run DBCC UpdateUsage and update statistics? You need to check the execution plans in the old server and the new...

didn't think about this

SELECT LEN(@String)-LEN(REPLACE(@String,'@','')) 🙂

Hi

Normally you design tables keeping data integrity and the level of normalization in mind. So If the data is related to one entity then it goes to one table and...

Thanks Gail, i did a reinstall.

nice article, but is there any method other than linked server to connect to various servers.

GilaMonster (9/7/2009)

---

Chirag (9/6/2009)

---

"Error 3(The system cannot find the path specified.) occurred while opening file 'master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error....

Gail

Thanks for your response.

I got these 3 errors from the windows event log.

"Service Broker is disabled in MSDB or MSDB failed to start. Server level event notifications can not...

This is what i got from the error log...

Well in that case .....are there many applications that connect to the databases. Any chance of checking their source code ? I know this is :crazy:

Silverfox (9/3/2009)

---

simple, mainstream support for sql 2000 has expired, so unless you pay for...

That was a good one. Guess DBCC Cleantable also wouldn't help in this case.