Is this a local install of SQL Server?

You are passing along a local credential if you have computername/username and not a domain credential. Check the registration properties from SSMS and...

May the Force be with you...always

[highlight]Test[/highlight]

I added a highlight there. I'm not sure that it covers colors.

It's something that we have talked about. I'll raise the issue. It definitely is something I'd like.

Incompetech is the site of Kevin Macleod. The credit is given to him and his site for the music used in the podcasts.

There are scripts on this site to assign permissions for all stored procedures to an account or role.

Moved to SQL 2000.

You should never do this. You should create a role and assign permissions to the role, then assign users to the role.

I'm always wary of these products. I don't mind them grabbing the disk backup files, but I don't know I'd trust them if I had a disaster.

you can set a unique index, but that only prevents it, it doesn't help the users.

I'd turn identity on, and not worry about gaps in the sequence.

That's an interesting issue.

If someone gets rights through a group, who should own the object? Off the top of my head lean towards the group, which in many ways...

What do you mean by "exact difference"? Everything that has changed?

Even if I had the document, you'd have to carefully research it yourself. If you have a cluster I recommend...

rebuild indexes.

In a sandbox, I don't think there's a big problem, but I might suggest setting up a desktop instead to handle this and RDP to that. If something happens on...

Boy, that OUTPUT clause is nice. This is much cleaner than anything I've written in the past.

I'd disagree, Jeff. If I need a web service that provides mapping, should I hire someone to use Virtual Earth to do this? Should I use VE? That's outsourcing. We...