I hope this doesn't come across as rude, but I work for a very large...

Column is already indexed and no other blocking processes

Sorry you're having troubles with this...I did say it would be fun I think 😛 The difference with this scenario and the way I've deployed it before in...

Thanks...

And I should have added the biggest caveat of all...make sure you test the living daylights out of this because there will be a myriad of factors that will have...

Ok, so we're nearly there but with some caveats, which I'll list first.

1. In order to deploy an updatable subscription the tables need to have a uniqueidentifier column....

You can query the sysjobactivity table in msdb to get various information regarding execution dates and times. The trouble with a job that doesn't run is that you won't...

deon 25081 (9/11/2012)

---

Hi Clare

Thank you for your reply.

I have not had many replies in various forums, so would appreciate if you could you explain a bit more about transactional replication...

mahesh.dasoni (9/11/2012)

---

We have faced a scenario in which jobs are scheduled to run on daily basis,but one day what happened that the job didnt run and we didnt get any...

I have run transactional replication in the past where I have customised the replication stored procedures in order to preserve data at the subscriber. I've never done much with...

Are you...

RBarryYoung (9/10/2012)

---

opc.three (9/10/2012)

---

RBarryYoung (9/10/2012)

---

...

public does have VIEW ANY DATABASE by default and my test instances do not undergo any changes to those permissions. REVOKE simply clears an explicit setting on...

GonnaCatchIT (9/7/2012)

---

Hi All,

Our default language setting for a DB is set to US-english , but our client insists now that it was British and needs it to change it.

Now I...

Developer Edition 9.0.4266

Apologies :blush: my bad. Thanks for posting up the SQL versions, because it just made me go back and check and I'd run up my code against a 2005...