If however you know that it is PRATTS you need to remove from every instance and does not change then this will also work, but Arvind's is most likely what...

When you have ideas always send them to MS even if they seem like they may happen anyway. Unfortunately, to the best of my knowledge there is nothing with sp_'s...

That a dll was not registered in the OS, can be an issue but most times is not. Check funtionality of EM and QA when done as those are the...

Thank for the update, now I don't have to test those. Overall it appears is a 2K problem, do not know yet about SP3.

You cannot dynamically subtitute the name in the fasion your are trying. However you could build a string from the create table statment and concatinate the variables value in. Then...

How is you connectio to the Oracle server defined in the Job? Have you tried executing the Job manually qithout doing QA first? Could be you connection has problems with...

To the best of my knowledge and looking at the publications you would have to setup seperate publications for the articles you need independent of the rest. If anyone has...

Without going into this all again, take a look at the following threads.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4330&FORUM_ID=9&CAT_ID=1&Topic_Title=Oracle%20Vs%20SQL%20Server&Forum_Title=General

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=1635&FORUM_ID=61&CAT_ID=5&Topic_Title=SQL%20Server%20VS.%20Oracle&Forum_Title=Anything%20that%20is%20NOT%20about%20SQL!

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=7346&FORUM_ID=61&CAT_ID=5&Topic_Title=Truth%20about%20Oracle%20and%20MSSQL...Help%20needed&Forum_Title=Anything%20that%20is%20NOT%20about%20SQL!

Personally, I prefer and am biased toward SQL, the ease of installation, use and management are the big...

MDAC should not have this kind of impact, the server should be keeping an execution plan and when either interface runs the same query you should get the same results....

Generally a sleeping process is doing nothing. Client side thou they could have the data pulled and working with it and until they apply thru the client interface a need...

Although I probably would not use often if I had, it looks to be quite an interesting product and I would love to see how it works under the hood....

Yes, a foreign key is placed to enforce referential integrity. When a record is inserted the server will read the records in the Primary Key of the referenced table to...

I am confused when you state INSERT INTO blah, blah. Are you trying to insert into 2 tables, or can you be a bit more descriptive on this?

Major PRO, unlike compiled code this are easy to access and change without recompiling and sending to end users, which in turn makes bug fixing faster.

Major CON, more work is...

Truncate is immediate and non-recoverable as is not logged. Even as part of a transaction you cannot get the truncated rows back. You could instead use DELETE but you have...