pk_GroupMembership is not the name of the constraint. Run SP_HELP GroupMembership and see what is returned for constraint_name.

Is this a DTS package or an SSIS package?

It appears that we've been going down the wrong path as far as the indentity column is concerned. You aren't trying...

Brandie,

Did the user refresh Object Explorer after you made him a member of the SQLAgentReaderRole? I experimented with a non-sysadmin in my office and she was able to expand...

It looks like you're using the Import/Export Wizard rather than a package, right? And you're running it in SQL 2005 Mangement Studio?

The error indicates that the input column named...

Randy,

I'm not sure your original question has been answered. Before you can add a database user for a Windows login, you have to add the login to the SQL...

If you want to disconnect everyone from a database so you can restore it run:

alter database MyDatabase set offline with rollback immediate

When the restore is completed, run:

alter database MyDatabase...

If you create the user in the Model database, it will be created in every new database afterward.

I'm going to suggest a different method for doing this in DTS. Remy's suggestion will work if you put the INSERT statement in an Execute SQL task. I...

Query the sys.fulltext_indexes catalog view.

These are legacy DTS packages, not SSIS packages, right? The only option I know of to search DTS packages is to save them as VB files and edit them....

Sorry, I can't help with that. I'm in the process of deploying our first package with a config file and I was thinking of simply restricting access to the...

I don't think those things are recorded in the transaction log, but you might find something in the default trace log file if it hasn't been too long since the...

Grant,

Out of curiosity, what problems have you had with cross-database ownership chaining?

Thanks

Also search this site for "compare databases" or "database comparison". I know I've seen numerous discussions about this.

We don't use maintenance plans much, but we do run an integrity check job, using DBCC CHECKDB for all user databases, twice a week and an update statistics job once...