No harm that I have ever encoutered.

Unfortunately the only other book I have seen is "Sql Server 2000 Replication Handbook

by David Winters" published by "Butterworth-Heinemann (Trd); ISBN: 1555582303; 1st edition (October 1, 2000)"

Also, check out...

Duplicate thread see also, http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8070&FORUM_ID=23&CAT_ID=2&Topic_Title=Formal+Design+Methodologies&Forum_Title=General

quote:

---

It is SQL2k and the recovery mode is set to Simple.

Thanks...

---

I stand corrected, I just...

I know, especially if the product has any merrit. I have in the passed asked vendors if they could see if any of their users would be willing to talk...

Sorry I was referring to your question of does it have to be in the same path as before, I only added that you could move them afterwards if yo...

quote:

---

It would be great if you could categorise stored procedures into folders. So that in EM you have Stored Procedures Then a...

I believe Brain is right. If you look back I mark the sp as a system object by running

sp_MS_marksystemobject

against it.

It is not a documented procedure but what it does...

Unfortunately, that is not allowed in TSQL at this point, don't foresee it happening in the future either. As you said EXEC or even sp_executsql could be used. I personally...

If I understand you right then take a look at this thread and the code I posted.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4238&FORUM_ID=22&CAT_ID=2&Topic_Title=Restore%20database%20with%20new%20name%20using%20SQLDMO&Forum_Title=DMO

At least for the part of restoring to the same server but a different...

That would be my understanding and I what happened when I tested but you did an INSERT so I would assume 10.

What version of SQL are you running? If 2K...

Did you make sure to choose the option for not all subscribers would be SQL? I haven't tried this yet but will be able to test next week when I...

Yes, has always worked for me.

The reason to move, is so the install cannot inadvertently overwrite it, once that happens it is gone. It is a safety thing I...

I agree as it buffers current security against unforseen issues.

I use CONVERT myself, I have seen other soultions which do everything in memory, but in comparision the CONVERT is more percise without need to double check. However, using it...