I like the new activity monitor.

There's also a button for it on the toolbar, which is handier yet.

Good change, IMO.

~BOT

*high five*

A Man after my own heart. Surrogate keys are the devil! ...

Here's my crack at it:

you need some tables...

user_roles that stores the relationship between users and roles (2 columns userid and siteid)

site_links '' '' '' sites and links

user_sites "" ""...

I don't think there's an easy way.

My only suggestion is to use Windows search for .mdf and .ldf and cross reference it with your output from select physical_name from sys.master_files.

If...

Jonathan Kehayias (1/8/2009)

---

Using this same image and configuration, Buck has discussed this before, that you would be better off going physical for this implementation using 5 instances on the...

I wasn't aware of that issue... bizarre!

You might just have to use serverproperty('servername') instead of @@server

@@server can be out-of-date if you rename a server incorrectly, but your thinking...

Erin (1/8/2009)

---

They do not have any server roles. Database roles include public and a role setup by the application.

Adding db_denydatawriter will not stop them from making updates through the...

Aha! Decimal must be immune to a true round::

Try this one!

DECLARE @Gains AS float

SET @Gains=RAND()

SELECT

@Gains

...

BuckWoody (1/8/2009)

---

Licensing for a VM is the same as a physcial machine. If you have 5 VM's installed, you have to license SQL Server 5 times.

Most often the problems...

besides try / catch blocks, I still use the old school return codes from the stored procedures.

example:

declare @ret int

exec @ret = sp_rename --..... etc

if @ret <> 0

begin

...

There shouldn't be a reason to store the password in the stored procedure.

you might need to dynamically generate SQL and use exec() or sp_executesql, but you should be able to...

investigate the ROUND() function.

~BOT

Not to be a forum hog (oink oink),

but something else to consider with SANs and VM's, is that lots of your hardware performance measurements go flying out the window.

for...

We use VM's in production quite a bit.

It's a great (cheap) solution for those vendor applications that require SA.

Licensing is an issue for those not on enterprise licensing agreements, but...

A SQL Server Central points Bailout!

:blink:

What is this world coming to?

I'll confess that I'll be a benefactor to Steve's 700 billion point bailout package.

Looking forward to the forums stimulus package,...