The people connecting to SQL Server using their domain logins will still only have the permissions that you grant them as users in the database.  So, if they're members of...

Thanks, Phill.  I didn't notice the referential constraints between sysdtssteplog, sysdtstasklog and sysdtspackagelog.

Greg

There are instructions at sqldts.com for executing a package from T-SQL, ASP, C#, etc. 

Personally, the only method I've used to allow users to trigger executtion of a package is...

Try giving the user EXECUTE permission for sp_enum_dtspackages, sp_get_dtspackage, and sp_get_dtsversion in msdb in addition to having permissions in XYZ.  I've done this to allow a user to execute a...

John,

Can you give us more detail about what the users need to do in the databases and how the data is accessed?

For instance, in our production databases, there is no...

You're probably better off either restricting the input in the application or replace commas with spaces before inserting or updating in a stored procedure.  As an example of the latter,...

I've used this to delete logs for a specific package:

DELETE

FROM sysdtspackagelog P

WHERE logdate < 

  (SELECT DATEADD(month,-1,MAX(logdate))

    FROM sysdtspackagelog d

   WHERE p.id = d.id)

and name = 'Refresh PR & SS'

You'll want to...

I haven't had the need for this, but I found a bunch of scripts in the script section of this site.  I searched for "sysobjects" since most of them use that...

I believe the database with status 536 has the following characteristics:

offline, Truncate Log on Checkpoint 'on', Torn Page Detection 'on'

and the database with 528 has these:

offline, Torn Page Detection 'on'

This query helps...

No.  Restoring to a point in time requires transaction log backups.  Restoring from a differential backup can only be done to the time the differential backup was made.

Greg

Janet,

If the data used by different teams is in separate databases, you could use fixed database roles.  Make managers members of db_datawriter and db_datareader and make their team members of...

You can use sp_help_revlogin to script all logins, SQL Server and Windows, in an instance.  Download it from MS here: http://support.microsoft.com/kb/246133/en-us

I've used this for many server migrations and never...

Either add a task to each package that will truncate the destination tables before importing the data - in essence reloading the tables every 10 minutes -or add tasks that...

You'll have to use Event Notifications or a constantly running profiler trace.

Greg

David,

You could create a custom "Developer" role in each database that would then be made a member of the db_datawriter, db_datareader, db_ddladmin, maybe db_securityadmin.  Add developer users as members of the...