charlesd (3/7/2013)

---

Yes, that is essentially correct. The developers have dbo rights in the development databases, which implicitly gives them all necessary rights on stored procedures i.e., execute, view definition,...

sqlPirate_Fl (3/7/2013)

---

So I've been reading up on Merge and have been experimenting with it lately in my 2012 environment.

I've run a few tests and was curious if aside from the...

Sounds like you want to work with a vendor who can advise you on a hardware purchase based on your anticipated workload, like Dell or CDW. Know your workload though...

It could be a permissions issue. Anything in the Agent Job logs?

For most DML operations it will be ignored since exclusive locks will always...

charlesd (3/7/2013)

---

I think you are missing the point. I do script out object level permissions with the Create\Alter script. However the view definition permission does not exist for...

tony28 (3/7/2013)

---

opc.three (3/7/2013)

---

Yes, you would merge all the tables...

Yes, you would merge all the tables with an...

OK, I see where the disconnect is coming in. I like it when the developers send their own scripts, then there is no mistaking what they wanted to go to...

tony28 (3/7/2013)

---

opc.three (3/7/2013)

---

I am happy you found a way forward but as a side comment I must say that your code raises several red flags. The dynamic cursor is a...

You're welcome. Thanks for the feedback.

You're welcome. Thanks for the feedback.

charlesd (3/7/2013)

---

Unfortunately, a user is still unable to grant explicit view definition permissions to themselves using this method, so there is no apparent solution other than globally granting permissions...

ajnubee (3/5/2013)

---

I'm trying to alter a column in a table that corresponds to UDDT, this column has a primary key and it reference to foriegn key in other tables. What...

From http://stackoverflow.com/questions/11905649/unicode-support-for-invoke-sqlcmd-in-powershell/11911050#11911050

Update 3 The encoding of the file seems to be the key. Looking at [System.IO.File]::ReadAllText, the MSDN doc states it will only detect UTF-8 or UTF-32 encoding. http://msdn.microsoft.com/en-us/library/ms143369(v=vs.90).aspx

If I...