The db_owner role is probably a good choice, but be aware that a user in this role can drop the database. You definitely don't want to allow the user...

You don't need to drop the primary key constraint, but you...

The column definition is causing the error. Assuming the column is already in the table, remove (PAYEE_ID INT NOT NULL) and you won't get the syntax error. Also...

You can get pretty much the same information from the sysjobhistory table, which is in both SQL 2000 and SQL 2005. Look at run_date, run_time, and run_duration.

If you're interested...

You can find that in the sysforeignkeys system table. Here's a query that will list foreign key info for the tables in a database:

select t.name as 'Table', c.name as...

Is your local database that includes the new table in SQL 2005 or SQL 2000? Since you posted in the Integration Services forum, I could assume that it's in...

If it's the package that's failing, enable package logging by opening the package in DTS Designer, open package properties and go to the Logging tab. You can log to...

Here's how I'd do it:

create table x (A varchar(20))

insert into x

select substring(system_user,charindex('\',system_user) + 1,20)

select * from x

You can decide if it seems easier.

ray 78019 (12/10/2009)

---

Hi Greg,

If I understand correctly, if I open the DTS in SQL Server Management Studio (2005) and save it under a different name, it'll still be saved as...

If you launch Replication Monitor in SSMS on any SQL Server instance, you can see the instances that are replication publishers. When you click on a publication, you can...

Bru Medishetty (12/8/2009)

---

ray 78019 (12/8/2009)

---

I have SQL Server 2005 and I need to create DTS packages (not SSIS packages). I installed the DTS add-on but the DTS node only allows...

Faiyaaz (12/1/2009)

---

Good day

Our server crashed and I managed to recover everything, there is just on thing missing, one of our senior developers could edit/update DTS Packages but defintely was not...

We want to limit the number of holes in the firewall so we've decided against linked servers and restricted data movement to pushing data into the DMZ servers with SSIS...

Here's an article that summarizes the permissions needed to backup and restore: http://www.sqlbackuprestore.com/backupandrestorerights.htm. Unfortunately, there isn't a very restrictive role for restoring a backup. Hopefully, this isn't a...

ajith.ranjan (11/18/2009)

---

When I try to restore msdb database of SQL server 2008 using a backup copy of SQL 2000 msdb database I can getting following error.

Msg 3154, Level 16, State...