Single_user access is not the same as restricted_access. As Gail said, restricted_access allows only members of the db_owner sysadmin roles to connect to the database. Single_user allows only...

Fixed database roles are always created when a database is created so you shouldn't have to script them. If you mean you want to script the members of the...

I've never heard of a database spontaneously change recovery models. I'd say that either the database is being restored from a backup made when the recovery model was simple...

There's no "cross reference" for packages and jobs. You can't tell what executes a package by looking at the package itself, so you'll have to look at the jobs....

A task failure indicates an error. 0 rows selected in a Transform Data task isn't an error, so the task would succeed.

As JDixon said, the Data Transformation...

I can think of a couple of ways to approach this. The first way is to look at the creation date and time of the package logs and compare...

Sure. Add the Windows logins to a Windows group, add the group as a login in SQL Server, grant the login access to the databases that need testing, and...

Afraid not. SQL Server only knows the account that is used to connect to the instance. You'd need something in the application that would report the network login...

Is it a user database or a system database? What was the recovery model when the database was created?

Add DB_NAME() to the SELECT list like this:

EXEC sp_MSforeachdb 'USE [?];

SELECT DB_NAME(), * FROM sysusers;'

I'm pretty sure there's no way to figure out who did it this time, but you could run a trace or create a DDL trigger to be alerted to future...

http://support.microsoft.com/lifecycle/?p1=2852

As far as I know, there isn't a way to script out a maintenance plan. They're SSIS packages, so you might be able to copy the package to a...

Adam,

Are you asking if you can copy data between databases as easily with T-SQL in a stored procedure as with a DTS package? If so, I'd say "yes" if...

select o.name, a.name as child, b.name as parent, cc.name as childcol, pc.name as parentcol

from sysobjects o inner join sysforeignkeys f

on f.constid = o.id

inner join sysobjects a on...