The named instance will not become a default instance automatically, nor can it be renamed. The way to make the SQL 2005 instance the default instance would be to...

I think your method of exporting or copying a table before modifying it is the quickest and easiest method. It's what I do if I'm making table schema or...

Does the message say UID doesn't exist or you don't have permission? Anything run in a job is executed as the login that runs SQL Agent. If that's...

You don't need to restore all the differential backups, just the last one before the time of the crash, because each one contains all the changes since the last full...

karen.rogers (7/17/2008)

---

The sp_change_users_login is used to correct users when there is no login. In this case I have a login but no user. Is there a similar procedure...

Sure. You can use DENY ALL on each table although you'll get the same result if you don't explicitly grant table permissions to a user. For example, you...

Those are called ophaned users because they're not connected to any logins. You can use sp_change_users_login to report on ophaned users and connect them with the proper logins.

set nocount on

select 'exec sp_grantdbaccess ' + 'create user ' + a.name + ' for login ' + b.name

from

...

Once you've created a user in the database mapped to the login, GRANT EXECUTE on each stored procedure that you want the user to run.

In SSMS, you can open the...

I just noticed that the title of your original post says you're doing log shipping. I recommend you stop the log backups until you can find more space on...

As far as I can tell, there isn't a way to differentiate between a real orphaned user and one purposely created without a login.

Here's an interesting blog about the usefulness...

You have to restore the full backup with norecovery before restoring the log backup anyway. You can specify a new physical location for the database files by using "WITH...

In Enterprise Mangager -> Management -> SQL Server Agent -> Jobs: right-click on the job and select "view job history...". Check the "Show step details" box on the Job...

SQL Agent database role members can only change or delete jobs they own.

1. A log file is the physical location that holds the transaction log data.

2. A full backup will backup enough of the transaction log to allow recovery of the database...