Mike Good (7/10/2014)

---

Confirmed. I was wrong to assume error would get thrown, sorry about that.

I think problem specifically comes from attempt to read definition column from sys.default_constraints. No...

mister.magoo (7/9/2014)

---

I haven't tested this myself, but I wonder if you have seen this post about the same issue?

http://serverfault.com/questions/258088/minimum-access-rights-for-generating-schema-creation-scripts

Unfortunately the Generate Scripts Wizard looks at sys.sql_expression_dependencies to find out what...

Ed Wagner (11/8/2013)

---

We use SQL Sentry for our monitoring and investigation. It's a great product and I'd recommend it to anyone.

I haven't used any Oracle monitoring tools myself, and...

This occurred for us due to Windows Updates. A specific .NET update caused our replication and SharePoint systems to break. Uninstalling the update fixed it immediately.

The update that caused this...

How was the upgrade performed, side by side or in-place?

I am guessing that you scripted out all the logins and ran the scripts on the upgraded server. Scripting SQL...

GilaMonster (11/8/2012)

---

Don't do it that way. When you want to take the last backup, run backup database with norecovery (or backup log with norecovery), that'll switch DB into restoring, allow...

Very informative articles. Thank you for sharing!

There is a minor error that threw me for a bit of a loop. In listing 2.3, you mention the code to load the...

IDENTITY_INSERT will let you explicitly insert values into an identity column, and then behave like a normal identity column once you turn IDENTITY_INSERT off.

http://msdn.microsoft.com/en-us/library/ms188059%28v=SQL.90%29.aspx

Great, glad I could help.

Does this help?

http://support.microsoft.com/kb/321185

10.0.xx is 2008, while 10.50.xxx is R2.

Edit for stupid URL tags..

Perhaps something like this?

http://msdn.microsoft.com/en-us/library/ms151705.aspx