SQL Kiwi (1/16/2012)

---

Gianluca Sartori (1/16/2012)

---

Also, I don't find 2012 SSMS to be slow at all, even in a VM. I must admit that my laptop is a very fast machine...

GilaMonster (1/16/2012)

---

Another option, especially if there's a middle-tier for the application, is for the app to impersonate a different windows login for connections to the DB. That way, the users...

SQLRNNR (1/16/2012)

---

Gianluca Sartori (1/16/2012)

---

Chad Crawford (1/16/2012)

---

I guess I should find it amusing...

... but...

SQL Kiwi (1/16/2012)

---

Gianluca Sartori (1/16/2012)

---

Also, I don't find 2012 SSMS to be slow at all, even in a VM. I must admit that my laptop is a very fast machine...

Chad Crawford (1/16/2012)

---

I guess I should find it amusing...

... but my English doesn't...

Lowell (1/16/2012)

---

but the logon trigger only works if the person doesn't know how to change their connection string to explicitly say an application name:

so the logon trigger is not 100%...

The same as Glenn Berry's:

http://sqlserverperformance.wordpress.com/2011/08/27/new-dell-precision-m4600-mobile-workstation/

Very strange, I don't have issues at all with my VMs. Did you have the same problems with...

If you're just trying to change the instance collation, you could read this post:

http://spaghettidba.com/2011/05/26/changing-server-collation/

Let's see if I understand correctly:

1) You are creating a new database or

2) modifying an existing one

and you don't see the collation you would like to set in...

Thanks, glad you liked it.

SQL Kiwi (1/16/2012)

---

It's quite handy - after a reboot, I can...

Roy Ernest (1/16/2012)

---

Change of topic... I got my second part of my Audit series published here... Yay..!!!!

And I got a A+ review for the year 2011 from my CTO. So...

See this script:

http://www.sqlservercentral.com/scripts/tempdb/72007/

It should help you identifying the culprit.

Sorry, I quite don't get it.

What should the report contain? Rows from the Excel file?

My bad, I didn't read your question carefully.

Now I see that you're dealing with a hung backup...

Well, if possible, a restart will probably fix it.

What does SQLServer log say? Is...