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...

Why do you have the "go"s in there?

Why not:

select * from tbl

if not exists(select * from othertbl)

insert into tbl1(fld1)

values(val1)

else

select 'done'

Sorry to hear that. Maybe you shouldn't have made that previous post :w00t:

old, but it works

http://www.sqlservercentral.com/articles/Administering/pushftp/473/

http://www.sqlservercentral.com/scripts/Miscellaneous/30830/