I think oraculum meant to say you should assign one of the roles to the user, since, as he says, they...

It depends on what the data is. You shouldn't put any databases out there that contain confidential data. I work for a governement agency and we have a...

Use sp_addsrvrolemember to add the login to the sysadmin server role (I think that's what you're asking).

sp_addsrvrolemember 'dwen', 'sysadmin'

Use the Import/Export Wizard in SQL Server Management Studio. It will create the Excel file before exporting data. See "SQL SErver Import and Export Wizard" in BooksOnLine.

Follow the instructions in this kb article for tranferring logins and passwords between different versions: http://support.microsoft.com/kb/246133.

After transferring the logins and restoring the databases, you may need to resolve...

...or sp_helprolemember?

Hi Adam,

I haven't seen that error message. Is it possible that the SQL Server instance name specified in the config file is misspelled or doesn't exist on the server...

You can't change the package owner. What you should do is change the protection level of the package so it can be run by a login other than the...

There are other options (http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx), but I've found the best way to do this is to create an unscheduled SQL Agent job to run the package and use sp_start_job to...

None of the backups (full, differential, or log) shrink the physical log file. The log backup truncates the inactive part of the logical log to remove the backed up...

I'll second the call for healthy people to donate. I never even thought about donating blood for over 20 years, then decided I wanted to do something to help...

I haven't had the need to do this and I don't see an obvious way to script a profile. It looks like you could select from msdb.dbo.sysmail_profile and msdb.dbo.account...

I'm not sure using differential backups is the best way to keep your client database up to date. It sounds like you want to restore a full backup then...

Restoring from a backup is probably the most common way to recover a dropped table. Because object level restore isn't available, you would restore and recover the database with...

If sa isn't available, my second choice would be the SQL Agent service account. If you want a less privileged login to be the job owner, you'll need to...