Check out the syntax for RANK in BOL - it'll do the trick for you here.

Was the service account changed through Services rather than through SQL Server Configuration Manager? If so that's probably the cause of the problem. Search BOL for Service Master...

Hi,

We had exactly the same issue with our migrated DTS packages. The fix described in Method 1 of KB917406 resolved the issue for us.

Good luck,

Cath

No, that happens on the destination server later. First read this: http://support.microsoft.com/kb/918992 about how to script out the logins and passwords on the source server and run...

I don't see why there should be a warning - SQL Server is doing exactly what it was told to do and setting the string to CHAR(10).

Thanks Joie. That's always been what we've done in the past - avoided buying the Agent by excluding database files from the backup and just backing up the .bak...

I got this right, but only because the question was on ROLLBACK and I gambled on the INSERT statement being an mistake/typo. I didn't know that it would run OK...

I'm rusty on smtp servers, but the root of the problem could be the '5.7.1 relaying denied' part of the error. Mail servers can deny relaying between domains to...

Sorry for the misunderstanding Bill. It's a long shot, but could the Report Data window position be in Dockable and Auto Hide? If so I guess it might...

I opted for the NULL answer. My understanding was, and still is, that NULL doesn't mean unknown, but that any potential value is simply not there.

When you're in BIDs, select the Report Data tab next to the Toolbox tab and right click over the relevant dataset. You'll get various options, one of which is...

From the error message I'd say either the server or one/some of the databases have SET ARITHABORT OFF in their properties. Check BOL for the behaviours ARITHABORT affects. ...

Your best resource for this is Books Online (BOL). That's about as step-by-step as it comes.

A bit belated, but this should do it:

First use the Login Options facet to create a condition PwdExpiration with @PasswordExpirationEnabled = False. Then use the Login Options facet to...

The only option I could get to work was 'For a login not in the list ...' and 'connect using these credentials'. I know that's not the best, but...