Garrick,

1) If a connection in the package uses Windows Authentication, the connection will be made with the security credentials of the Windows account that runs SQL Server Agent, not the...

Try this:

On the Tools menu, click Options.

On the Environment/General page, select Hide system objects in Object Explorer, and then click OK.

In the SQL Server Management Studio dialog box, click OK...

Since I reread your original post found that you want to export to text files, I have to say that there's only one way modify a package to export multiple...

You'd have to write a query to do that. Something like:

select 'INSERT INTO tablename values (', columnname1, ',' ,

columnname2 ')'

from tablename

Greg

The advice I'd offer depends on how you're creating the packages. Are you creating the packages with the Import/Export wizard or are you starting from scratch with the DTS...

Frank,

As John said yesterday, you must restore a full backup before restoring a differential backup. See "How to: Restore a Full Differential Backup (Transact-SQL) " in BooksOnLine for an...

I don't spend a lot of time playing games. Like Luke L, I spend so much time in front of a monitor during the week that I don't have...

Job execution info is automatically stored in the sysjobhistory table in msdb. Does that meet your needs?

Greg

That's a good point. You should see if another job is starting the disabled job.

Greg

Doh!! And it's sp_addsrvrolemember to add a login to a fixed server role.

Greg

If the job still runs after disabling the schedule, try stopping and restarting the SQL Server Agent service.

Greg

Franco,

If you're writing the differential backups to a single file so the file contains a week's worth of backups, just have the differential that occurs next after the weekly full...

Adding role membership is a separate operation from creating a login. Use sp_srvrolemember to make a login a member of a server role and sp_adduser to add a user...

Have you tried scripting out the stored procedures in SQL 2000 and running the scripts to create them in SQL 2005? It's a few more steps than transferring with...

Syed,

After reading your other thread in this forum, I think I understand what want to do. Do you want to put the RESTORE commands (which are T-SQL) in a...