You cant script out an encrypted sp. you need to speak to the third party vendor and ask them for the scripts.

there are some third party scripts available that...

you use the "with encryption" command when you create the object

deepthi818 (5/3/2010)

---

Can we execute a join on two tables with different collation settings? Why or why not?

"Cannot resolve collation conflict for equal to operation." -Does this error always occur or...

T_SqueaKquel (4/28/2010)

---

Its a unidirectional replication with immediate update. We didn't such errors before, so I can tell that it will not replicate until it commits on publisher. My guess is...

what type of transactional replication are you using? is it queued or immediate updating. If its immediate then i believe it will try and commit the transaction at...

Hi,

I know its been a few months since you had this issue but how did you go about finding that the problem was due to a trigger? I...

Toby White (4/22/2010)

---

I think what you want is information from the system tables that are on your publishing or subscribing database depending on your replication architecture. Mine are on my...

Thanks Toby. I did see that table, however there doesnt seem to be a lot to join...

It depends on how often you want the data refreshed, if the table is being written to in both locations and what kind of link you have between the two...

carringtonmukwasi (4/4/2010)

---

Hi

I have a table containing details of customers. When updating this table, I want to maintain the original details, I don't want to overwrite the original data. Can I...

i always just use left(getdate(),11). so i would just use

select * from datestable

where mydate between left(getdate() -1,11) and left(getdate(),11)

warning of 2 means the latency has been exceeded. if the value is 0 sql doesnt...

There is also a quick script you can use which will also email you if the job is set to having a warning which it will be if the latency...

replication monitor makes it slightly easier than that still. Highlight a publication, go to the warnings tab and click configure alerts. That takes you to the same screen...

have a look what sql jobs run every 5 minutes and see if any of them are failing. its likely going to be a legacy service you have forgotten...