At the database level, we make developers members of db_ddladmin, db_datawriter, and db_datareader.

db_ddladmin allows object creation, db_datawriter allows insert, update, & delete in all user tables, db_datareader allows select from...

Make sure you have all the source columns mapped to destination columns.

Isn't it the sysdiagrams table? I've never done this, but if you try copying the table to another instance, make sure you have a backup of the destination database...

I'd use an SSIS package that imports data from all twenty Access tables and schedule it in a monthly SQL Agent job. You can use the Import/Export Wizard in...

To clarify, are you using Transfer SQL Server Objects task or a Transform Data task? If it's the former, I suggest using the Transform Data task if you're just...

Tara,

You didn't mention what kinds of changes you're making to the database. Are you updating objects such as stored procedures, views, tables or updating data in tables? Either...

I think you misread the question, Krishna. The OP wants to stop a table from being truncated (accidentally, I presume).

The only way I know for sure to prevent...

More replies in the original thread: http://www.sqlservercentral.com/Forums/Topic697546-146-1.aspx

Adam's right, that's the way to copy packages using T-SQL. If packages have multiple versions, I'd probably check the createdate column to get the latest version.

I'm not aware of a way to automatically connect to servers when SSMS is opened. You can save servers in the Registered Servers window, but you still have to...

Use DTSBackup2000. It's free, it copies all the packages in an instance, and it's very reliable. I've used it many times. Find the download here:http://www.sqldts.com/242.aspx

BTW, there is...

So, the procedure is created by an application? Does the application connect to SQL Server using the user's login or with it's own application login?

Jack Corbett (4/15/2009)

---

Greg Charles (4/14/2009)

---

Yes. Something to keep in mind about db_ddladmin is that, while it allows members to create objects, the objects are owned by whomever created them not...

Yes. Something to keep in mind about db_ddladmin is that, while it allows members to create objects, the objects are owned by whomever created them not by DBO. ...

You're running DBCC INPUTBUFFER to see the text of the last statement executed by process ID 213 and putting the results into a temporary table. The SELECT statement shows...