Jeff Moden (8/2/2011)

---

Leo.Miller (8/1/2011)

---

I can't see any real benefit of using an iTVF, since as far as I can see, [font="Arial Black"]you can still only pass it a single paramater[/font],...

I'd go for Option 4..

Install Instance2

Script all logins, linked servers, jobs, operators, etc on Instance1

Recreate logins, linked servers, jobs, operators, etc on Instance2

Backup and restore (with no-recovery) databases from Instance1...

I can't see any real benefit of using an iTVF, since as far as I can see, you can still only pass it a single paramater, even though it returns...

I've never tested this with iTVFs, only with scaler functions, primaraly because this is where I've been called in to do performance tuning. The big issue is not normally the...

Welsh Corgi (8/1/2011)

---

Leo.Miller (8/1/2011)

---

Welsh Corgi (7/30/2011)

---

This is not neccesarily a good idea. I've worked in the banking environment most of my DBA career, and we almost never had the same...

It's not so much that it isn't using parallelism, but that for every row returned,...

The mail being sent just means it was put on the queue. Have you checked the db-mail error log? Also have you checked your Exchange server to see if the...

Welsh Corgi (7/30/2011)

---

You should have the same users in your Development Environment as your Production Environment.

That way your Development Environment mimics your Production Environment.

If that is not the case you...

Ignacio A. Salom Rangel (7/28/2011)

---

stephen.lappe (7/28/2011)

---

My organization has just started to transition to 2008 R2 and I have seen this error on a couple of our legacy databases.

I...

I did a quick test, a Standby/Read-Only databse can't have it's database owner changed, so there is definitely something being at least tested against the database.

If you recover the database...

No, unfortunately they aren't. The issue being that the database owner detail is stored in the master.sys.sysdatabases table, and not on the user database. There also isn't any way of...

GSquared (7/25/2011)

---

halifaxdal (7/25/2011)

---

I got this idea from Mark Armer, I agree that in some/or many cases SQL cannot be stopped however I still think his idea is surprised, unexpected and...

There's a good change this is some proces that is using the 'abc\mssqlsrv' account to connect to a database that has not yet been brought on line.

One hint is the...

Have you had a look at what MAP 6.0 can do?

MAP is the Microsoft Application and Plannng toolkit, downloadable free from Microsoft. It does a very good job of reporting...

If this is something you want to use going forward then avoid the sp_dboption and stick to the ALTER DATABASE version.

sp_dboption has been removed in SQL Denali.

Cheers

Leo