It couldn't hurt to submit it to Microsoft.  They're always saying they want feedback.

In the meantime, maybe you could lock users down with more granular permissions than making them members...

Terrell,

If the packages were moved to SQL 2005 successfully, you can see them in SQL Server Management Studio by expanding Management, Legacy, Data Transformation Services.

Greg

Brandie,

I've recently been researching this myself and I've decided that BOL is misleading when it lists create role, alter role, and drop role as events that can be used with...

What that blog entry says is that you can't actually recover to a point-in-time from a full backup only.  The purpose of using STOPAT with RECOVER DATABASE is to see if...

Ben,

Log Explorer, in my opinion,  is worth the money in these cases but you can get a rudimentary look into the T-log with DBCC LOG.

Syntax:

DBCC log ({dbid|dbname}, [, type={-1|0|1|2|3|4}])

Your first attempt probably didn't work because the backup was for a database with a different name than the one you want to overwrite.  "WITH REPLACE" only works for overwriting...

You mean the inserts?  They were committed before I made the backup.  I wasn't able to restore to a point in time from the full backup.

Greg

Karl,

sp_SearchText is a homegrown stored procedure that Ben uses to search for strings in stored procedures.  It basically the same thing that Aaron's code does.  Here's another way to do...

Gunter,

Are the users members of a group that has higher level permissions or is Public a member of a database role with higer level permissions?  You wouldn't see the permissions for the individuals...

Hi,

I tried that and could not restore successfully.  I inserted at 9:58 and again at 10:02.  I did a full backup at 10:03 and when I tried to restore to...

Cross post.  See my reply in the DTS forum: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=372394

Greg

W R,

Look at the package log for better error descriptions.  If you haven't enabled logging in the package, open the package in DTS Designer, select 'Package Properties', the Logging tab,...

So, do they need db_datawriter when using the client-server app because it doesn't use stored procedures for everything it does?  If so, maybe you could use a SQL Server login...

William,

That's weird.  Like everyone else in this thread, except you, the Import/Export Wizard that I see in SSMS has no option for copying objects.  I only see options for copying...

Jeff,

Sorry if my answer wasn't clear.  I wasn't trying to imply that restoring a differential backup prevents point-in-time recovery, only that log backups are also needed.

Deepak,

Point-in-time recovery in SQL 2005...