Betty,

You can use DTS to move the data.  If the tables have the same schema and you're only moving new data, I recommend using the Import/Export Wizard and choosing...

You have to change the connections after moving the package unless you've used UDLs or a .ini file.

See this thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=308151#bm308999

Regarding cranky developers: You didn't make the permission changes without backing from your management, did you?  When I've been in this situation, it's been in response to a clearly documented...

You'll want to grant EXECUTE permission to the DTS and Job stored procedures in msdb.  The ones I can think of off the top of my head are

sp_add_dtspackage

sp_drop_dtspackage

sp_enum_dtspackages

sp_start_job

In DTS, if you're using the Import/Export Wizard, the default behavior is to append to an existing destination table.  You can see this on the Column Mappings tab.

If you've created...

Too bad GRANT VIEW DEFINITION isn't available in SQL2000.  If you only want people to be able to see stored procedure code, grant READ permission on sysobjects and don't grant...

Unfortunately, ALTER TABLE and DROP TABLE are not transferrable which means they can't be granted or revoked from a user or role.

In our development databases, we make developers members of db_ddladmin which...

I'm not aware of a way to move a log file without detaching the database and you can't delete a log file as long as the database is attached.  Have...

By using DTS to transfer packages as described here http://www.sqldts.com/default.aspx?204 and here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=308692 you can change connections while transferring them.

Greg

I agree with vik.  These tools are pretty cheap and I don't imagine anyone whose figured out how to make them work would be anxious to give away the secret.

Greg

Terry,

I assume you're restoring to the same instance where the original database exists.  It looks like you're trying to give new logical names to the database files, which you should...

There's no easy way to do it if the connection information is hard-coded in each package.  If you've used dyanamic properties tasks and UDL or .ini files, you can change...

I think I can help with this one.  When you use the Import/Export wizard and choose to copy objects between SQL Server databases, you can set options for copying (uncheck...

Try DBCC SQLPERF (LOGSPACE)

Greg

I don't know.  What specific error did you get for that?

Greg