You can't drop the identity property using ALTER TABLE. You'll either have to drop and recreate the table or use the "Design" option in SSMS to remove the identity...

Looks like a pretty good list.

A note on step 3: if you backup and restore the databases to the new instance, the users and object permissions will be...

I think the answer depends on how "in sync" the databases need to be. If the data in the SQL 2005 database needs to moved to the SQL 2000...

Thanks for that Steve. I based by comments on BrendA's statement that it's a test environment, but you reminded me that developers shouldn't have free reign to change jobs...

Change dbo to a login other than the developers and make the developers members of db_ddladmin. This role will allow them to create objects. Instruct them to qualify...

The Windows group for developers sounds like a good idea and Vidhya's suggestion of using the SQLAgent roles in msdb is a good choice for allowing non-sysadmins to maintain jobs....

Okay, here's how we've done it. You have to migrate one package at a time.

1. Save DTS packages as files.

2. In SQL 2005 Business Intelligence Development Studio, create a...

SELECT, DELETE, INSERT, UPDATE may be granted to individuals but ALTER TABLE and TRUNCATE TABLE are only available for members of the db_owner, db_ddladmin, and sysadmin roles and the...

Yes, you can do it by adding a login for Harry to SQL Server and adding a user for Harry in ExampleDB, then making the user a member of the...

All I can think of is the query isn't selecting any rows. Do you see data when you click the "Preview" button on the wizard screen called "Select Source...

It's a great opportunity to meet other SQL Server professionals and get information about all aspects of SQL Server.

http://www.sqlservercentral.com/articles/SQLServerCentral.com/62979/

Look at the properties of the text file destination connection in the DTS package. If it has "First row has column names" checked, it will output a header...

Are these files created by DTS packages or do you want to import the files into SQL Server? Could you post a sample of the data?

BOL has good information, see "Migrating packages". I also like these articles:

http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1216481,00.html

http://technet.microsoft.com/en-us/library/ms143226.aspx

Also, Brian Knight has developed a tool that migrates DTS packages to SSIS packages. I've looked...

I haven't had any problem importing data to an existing table. Do you get any error messages?