Personal pet peeve of mine... really don't like people who record with a table. It obstruct the view of people behind you. It's a tablet, not a camera....

distribution database... so you are saying that they can restore a distribution databases under a different name?

wow... that's a new one.

I'll check and report back.

thanks

Wow. This would have been so useful two weeks ago.

I hadbthe very same issue and took me a while to troubleshoot (as in googleing), when kerberos broke.

No idea how...

Hello,

The problem is that your query is using double quotation marks inside the SELECT statement, which breaks BCP.

I would change your SELECT statement that lists the columns to

SELECT @cols =...

If you can't see a service called "SQL server..." something, it means you may not even have SQL installed there anymore... Or you are using express version.

Last shot... You mention...

I''ve done that and I had tons of issues adding the new node, as SQL though it already had that node.

A better, clean way of doing it, would be to...

Unusual name? That raises a red flag.

Go to Start > Run > Services.msc

and post the full name of the service running SQL

Another option... if you are sure you have the...

I had a similar issue.

Check if the domain Service Account belongs to any group that's already on the Login list, and check the default database setting.

In my case, the Group...

I wonder how many will attempt a Turing test with your next representative. Considering my experiences with some customer service, it wouldn't be a bad idea

I'm always having issues with project managers asking for HA technologies and trying to pit mirroring vs clustering. My question is always what do you want to protect against?... ...

The title of article is misleading. I though someone figured out a way to rename the actual instance, which right now it is not possible (in a nice supported way.......

I had the same problem about two months ago, and this article helped me

http://www.sqlservercentral.com/blogs/mssqlfun/2013/01/15/the-server-principal-xxxx-is-not-able-to-access-the-database-msdb-under-the-current-security-context/

Miguel

Hello,

We run DBCC everywhere.... but I guess it's not enough to run it if we don't look at the results.

My group provides outsourcing IT services, and we support over 1,500...

I see your point regarding space. But what about disk I/O ? Shouldn't be better to keep them apart, in separate physical drives?

Miguel

I see your point regarding space. But what about disk I/O ? Shouldn't be better to keep them apart, in separate physical drives?

Miguel