Just to clarify HanShi's posting - NVARCHAR(MAX) is not limited to 4000 characters. The maximum length of VARCHAR(MAX) is 2^31 -1 (2,147,483,647) characters.

Unfortunately, Manoj's code references sysxlogins, which doesn't exist in 2005. Go here instead to get the original MS version: http://support.microsoft.com/kb/918992.

Once you have compiled these procs, execute 'sp_help_revlogin', the resultset is...

Run this script against each DB on the server, it will synch up any orphaned users:

USE [DB Name Here]

GO

DECLARE @UserName nvarchar(255)

DECLARE orphanuser_cur cursor for

SELECT UserName = name

FROM sysusers

WHERE (issqluser =...

Script the proc and the table definition, and post them, please.

From your post, I take it you are talking about a DR setup?

You should look into setting up Log shipping. Of course, that implies T-Log backups. The SSMS interface is...

This is my standard script for adding a linked server:

DECLARE @SQLCmd VARCHAR(1024)

DECLARE @LS_Name SYSNAME

DECLARE @ServerName...

I found the information - I did a complete write-up, and I'm going to submit it as an article.

If you rebuild Indexes (which you should) after shrinking the DB, be aware that this could potentially add a lot of data to the log.

Check out my script on this site - http://www.sqlservercentral.com/scripts/Backup/62095/. And if you run the sp_DatabaseBackup with @Debug=1 setting, it will show you the backup commands it executes.

Talking of VB or C# - I guess 'scope' is an 'overloaded' term ... different meaning depending on circumstance.

(1) The 'must' gives it away, you don't have to use REVERT or another EXECUTE AS statement to change your context back.

(3) If you're an sa, you can impersonate a...

Add a MAXDOP 1 hint to the query to prevent parallelism. There is a potential performance hit, but if the query is failing, the performance hit from the MAXDOP is...

Al,

that script you published, I spent months getting rid of that very script from our production servers. You really need to add a line that categorically states that it must...

Interesting (I got it wrong :crying: ). But what happens to the exe's (etc) that were patched?

From what I can find, you may have fragmented memory blocks. This post in Red Gate's Forums does a pretty good job of explaining it / walking you through the...