It sure sounds like the backup is from a later version. Are you sure that both instances are SQL 2005? Maybe you should run RESTORE HEADERONLY with the...

The syntax is a little different from SQL Server, but it looks like it's creating a database named dblinks then creating tables called tbl_admin, tbl_catagories, and tbl_links.

The tbl_links table has...

Specifically, you'll need a server scoped DDL trigger for DROP_DATABASE. Btw, I think the reason you got an error while trying to create a DML trigger on sys.databases is...

See this thread for links to decryption tools: http://www.sqlservercentral.com/Forums/Topic396563-119-1.aspx.

See "Create Procedure" in BooksOnLine for syntax to create an encrypted stored procedure.

Yes, that's the tool. Just use SQL Server as both the source and destination. BooksOnLine has more information and there are lots and articles on this site with...

You can list jobs by joining msdb.dbo.sysjobs and msdb.dbo.sysjobschedules. Something like:

select name, next_run_date

from sysjobschedules s join sysjobs j on s.job_id = j.job_id

order by next_run_date

Since all your jobs run...

Good advice from gyanendra.khadka & mahesh.vsp. The Migration Wizard works pretty well for simple packages. The advice to learn about SSIS before migrating from DTS is a good...

I'd use DTS. The Import/Export Wizard would work fine for this.

Is WEBM a SQL Server login? Did you re-sync the database users with logins on USSERVER2 after restoring the database? Try running sp_change_users_login 'report' in the database and...

The important bit in the Microsoft's advice is this:

Note You can only use the DTS Designer to rename a step for a DTS package. You cannot use the DTS Designer...

I always use dtsrunui to generate the encrypted DTSRUN string. If you select just the package name rather than selecting a specific version, the package will always use the...

Apparently, wmError is owned by the schema WEBM in the USSERVER2 database. You say the owners are the same in both databases. Do you connect to BOTH servers...

And, while you'd like to think that you'll only need a log reader once, it's pretty cheap insurance. If you need it this time, you'll probably need it again.

If you haven't mapped a login to a user in a database and granted it access to the database, the login can't even open the database. Even when there...

No. In fact, you may find that you can't truncate a table that's being referenced by foreign keys.