Does the package return any messages? Do you have pacakge logging enabled? If so, what messages are in the log?

The problem could be permissions. Does the nonsysadmin...

This will get you started. The query works as-is in SQL 2000. In SQL 2005, sysprotects, sysobjects and sysusers are views in the sys schema rather than tables.

select...

This article http://www.dbazine.com/sql/sql-articles/cook10 tells how to script SQL 2000 maintenace plans by scripting the jobs that run them. I haven't tried it so I can't vouch for the method...

The rest of the space is probably being used by the database's transaction log.

Run DBCC SQLPERF (LOGSPACE) to see the space used by all the logs in the...

ibnzakariyyahh,

I think what respondents are telling you is that it's fairly easy to use SSIS to do what you want but it would be difficult to walk you through creating...

I've used two methods to move databases:

1. Detach the databases, move files, and attach the databases

2. Backup and restore the databases

With either of these methods you'll have to recreate...

The runtime component and DTS Designer are used in SSMS, but if you have the option of keeping a SQL 2000 instance with Enterprise Manager, you may find it's easier...

Basically, an identity column is used when an automatically incremented value is required. If used in a table where rows are regularly deleted, gaps in the sequential numbers will...

Please don't post the same question in multiple forums. You've gotten a reply in this forum: http://www.sqlservercentral.com/Forums/Topic626999-6-1.aspx

You probably should read about the privileges of the various fixed server roles and fixed database roles in BOL. You can't create custom server roles, but you can create...

You can run it using sp_cmdexec and dtexec or you can put it in an unscheduled job and just run the job when you want.

See this article from BOL: http://msdn.microsoft.com/en-us/library/ms141708(SQL.90).aspx...

It depends on your definition of "dba tasks". The DBAs in my organization are members of the sysadmin server role and we don't farm out administrative duties to non-DBAs.

If...

In Management Studio, connect to Integration Services, expand stored packages, expand MSDB, right-click the package and select "Run Package". You can also create a SQL Agent job and run...

In SQL 2000, only dbo (not just member of db_owner) and members of sysadmin can execute sp_adduser. Try using sp_grantdbaccess instead.

When using log...