In addition, boxes behave differently no matter how well you test with similar everything. Little power fluctuations or unknown process running can mean a locked file hendering the upgrade or...

Sorry, I do not have an example I can think of off hand to show a difference. That is why I stated 'may be' and not will be. My opinion...

o you have a FK constraint in place? If so you may need to drop it until you clean up then add back.

"Don't roll your eyes at me. I will...

It is xp_eventlog.

To view the application log do xp_eventlog 'Application'.

These works in 7 but not 2000. xp_eventlog is there but have not found the parameters yet.

Edited by - antares686 on...

May even be the transaction log needing to grow and while doing so you are getting waits. Make sure file growth is large enough to keep delays to a minimum.

"Don't...

If the problem is itermittent then may be a piece of code causing it. Try running profiler when the server is not in this condition until you catch when it...

I am not sure exactly what may be happening but there are several things that can do this. I am betting however the old schedule may have been set to...

I haven't done this type of connection but the principal is like so. If the replication is interupted in mid point all changes will be rolled back. Only on successful...

What is the name of the example and I can see if I can translate to VB?

"Don't roll your eyes at me. I will tape them in place." (Teacher on...

How are you running as both OSQL and ISQL qork fine for me. They just have a horrible effect on the wrap of the data making it harder to read...

If you are needing to replace 2 single quotes then just run the replace you already use and it will double to 4 which is the correct thing to do....

Doesn't really matter, if tying to other data in DB1 it is best to use a view. However when using aview you are still connecting to DB2 you just...

Not sure how your trigger looks but I suspect you have an issue with how to hadle multiple updated rows.

Should depending on other things and considering if you are inserting...

Hey Steve, in your discussion you mention the need to wait because of the dialog that appears when shutting down a service. Many people don't realize however that a service...

I agree with the number guy. Just submit to an SP as a VARCHAR comma delimited. Then you can use CHARINDEX to seperate and insert using a WHILE loop to...