A little searching turned up this company that has a code conversion tool: http://www.swissql.com/products/sql-translator/sql-converter.html. I haven't used it, so I can't vouch for it's effectivness.

My preference is to create a scheduled SQL Agent job and a DTSRUN command in a job step (CmdExec type), just like you did it in SQL 2000.

The package protection level stays at what you set it to when you edit it. AFAIK, there's no way to change it as it's deployed.

You would use ALTER INDEX ALL to disable and rebuild indexes. See "ALTER INDEX" in BOL.

ALTER INDEX ALL ON table DISABLE

ALTER INDEX ALL ON table REBUILD

I don't think there's...

The table that gets the error (child table) refers to another table (parent table), right? Are you importing data for the parent table before the child table?

You...

Logins on different servers will always have different SIDs so when a database that originated on another server is restored or attached, it's likely that the users in the database...

SQL Server does not provide a way to backup or restore individual tables unless each table is placed in a separate filegroup. Some third-party backup software, such as litespeed...

You can't retrieve the password for a SQL Server login. Your only option is to reset it, as Grumpy DBA suggested.

I agree with Michael, up to a point, about database ownership chaining. The user in liveview must be a user in live, but it doesn't need any permissions in...

"ICT Services" must be the name rather than the TeamId since TeamId is a 16 byte GUID. Assuming that, try this to select the row:

select TeamID from dbo.TeamBase

where Name...

So, do you know the TeamId value for the row you want to delete? If not, can you find it by querying for Name or some other identifying column?

How...

I haven't used EncryptSensitiveWithPassword, but as I understand it, the only difference is when the package is opened without the password, the sensitive information is blank.

You can't see the password...

Not much to go on here. If the table has a primary key, select the row from the table where the primary key equals the value for the team...

1. Restore the differential backup from 10:00 AM and the log backup from 10:15 with STOPAT 10:09.

2. Staggering the diff and log backup schedules would eliminate the confusion about which...

If you're using Cognos BI software, doesn't it have instructions for connecting to a data source?