It might not be possible to get the DAC port from the error log if the error logs are cycled frequently. In that case you could restart the SQL Server...

I don't know if anyone is still looking at this old thread - I've got a huge backlog of SQLServerCentral emails to work through - but I just wanted to...

Thanks for the quick reply Lowell, but xp_logininfo will only return information for Windows Groups that have been added as a login to SQL Server. What I am talking about...

I agree with a lot of what you state in your article, but would also add the following:

- Decide whether the upgrade will be in-place or side-by-side

- If...

It's a nice idea, but would involve getting access to HR data which, in my experience, HR departments tend to be rather twitchy about!

Regards

Lempster

I agree with your point Steve about management or 'the business' just wanting to get things done at the expense of security. Some months ago I undertook what I thought...

I must admit that I got a bit lost by the description in your first paragraph, but the example that you gave made it clear and confirmed to me that...

Brilliant and funny article Paul. I wonder if Daniel Vettori really does wear wasabi lip balm?! 😛

Thanks for the reply Grant. You are right, this is development led and the issue will be trying to bring everyone else on board. I'll have a read of your...

Jason, thanks for the article. Just one point: after forcing the optimizer to use a Nested Loop you state,

By trying to force the optimizer to use a Nested Loops...

If you expand the Local Subscriptions node under the Replication node on your Server A, do you see anything?

Try executing sp_removedbreplication on Server A.

If your Connection Manager properties are set by a variable, an expression, a configuration file or a Data Source, the upgrade process will not be able to upgrade it (despite...

An excellent, simple, step-by-step post illustrating how to create user-defined custom time dimensions. Thanks and well done 🙂

Lempster

Something else you may need to do when moving system databases to a different server is to restore the Service Master Key, the password for which should be kept in...

The webinar recording does not seem to be available - the link opens Windows Media Player, but reports that the server is not available.