sp_change_users_login doesn't create logins; it maps existing users to existing logins.  If the login doesn't exist on the QA server, you'll need to create it then map the database user...

A couple of notes about importing DTS packages in SSMS:

You have to have saved the packages as structured storage files first and you'll need to download and install the...

Please post your SELECT statement.

Thanks,

Greg

Or you could create 7 monthly schedules for the job, each specifying a different day.  For example:

schedule 1 - day 1 of every month

schedule 2 - day 2 of every...

I forgot to ask if there is already data in the table that violates the check constraint.  If there is, you'll either need to clean it up before adding the...

Hmm.  AUTO_FIX only works if the user name and login name are identical.  If they're not, you'll have to use the UPDATE_ONE argument and specify the user and login that...

John,

The place to run T-SQL code is in Query Analyzer, which can be started from Enterprise Manager or from the SQL Server Program group.

You can set ID as the primary...

alter table testdate with check

add constraint datecheck check (col1 > col2)

Greg

What goes wrong when you run sp_change_users_login? 

Greg

James,

If you work 12 hour days, how long do your DBAs work?!? 

Greg

I became a DBA after being a developer for 11 years, though I worked on

a mainframe OLTP system rather than SQL Server.  Frankly, I don't know

any DBAs who weren't...

Simon,

You can script out SQL Server logins with their passwords.  I've used sp_help_revelogin, as described in this article http://support.microsoft.com/kb/246133/en-us, many times.  Next time, eh?

Greg

I think that info is stored in master.  You can see it in the system table spt_server_info. 

As for fixing it, one thing that comes to mind is to backup...

Only the person who requested this information can tell you what output is expected.  While someone on this forum can probably help you with syntax, you should post what you've...

You don't specify if you want to set up built-in SQL Server log shipping (available in Enterprise Edition) or if you're setting up a home grown version.

If you're going the...