Well if the group exists already in the db, just add the user to the group in the AD and you're done.

Of course this all assumes windows authentication.

calvo (8/2/2011)

---

Ahh... that explains the disappearing unlimited...

Ninja's_RGR'us (8/2/2011)

---

Steve Jones - SSC Editor (8/2/2011)

---

All these discussions just got me to look at my usage and lower my cell plan.

I had an unlimited voice/unlimited data plan for the...

No idea what you want to do in the process.

The only thing I can tell you is to have 2 connections (1 local, 1 remote).

SSIS is a tool, might be...

Just to show how to filter... and how overly complicated it can be in ForEachDB >>

SET STATISTICS IO, TIME OFF

SET NOCOUNT ON

SET IMPLICIT_TRANSACTIONS ON

GO

USE [master]

GO

IF OBJECT_ID('dbo.spaceused', 'U') IS NULL

BEGIN

CREATE TABLE...

msforeach db is just a loop through the list of dbs. This is only 5 lines of code to type.

You can add another filter on dbname on top of...

I don't understand your problem with that!

Steve Jones - SSC Editor (8/2/2011)

---

All these discussions just got me to look at my usage and lower my cell plan.

I had an unlimited voice/unlimited data plan for the iPhone,...

.... clr cache.

ROW_NUMBER() OVER (PARTITION BY ... ORDER BY)

Do it smart...

Make a windows group. Grant access to the dbs to the group. Then add the users to the group as needed.

Doing that manually or through a...

Well yes, unless you preffer to add the linked server.

Option A would have been SSIS if you don't mind the learning curve.

Multi-users permanent temp tables only work if you use a filter (@@SPID).

Other than that you'll always end up with conflit and bad data.

http://msdn.microsoft.com/en-us/library/ms190312(v=SQL.90).aspx

I just hate that you used the work attached here.

I'd DEFINITELY go the backup / restore path here. Much safer and cannot fail, as in lose the whole db,...