Removing it breaks your project? Are you developing directly on the SQL server, if so I'd highly discourage that.

I'd say look in Object Explorer under databases and see if...

Saw this thread from google as well. I have this happen occasionally in SQL 2012 SSMS, not really in earlier Management studios unless one of the myriad of more common...

For clusters with SSIS running, I always specify the server name in the C:\Program Files\Microsoft SQL Server\110\DTS\Binn\MsDtsSrvr.ini.xml file.

I wanted to share a powershell script I whipped up that adds the results directly to a SQL table:

Basically, you'd setup your CMS, add all your servers, and then run...

I was seeing this on one of our servers, I looked at the Services running and ran profiler and came up with the same things like: generic queries where NT...

Ahh got it, throw all this into a .ps1 file, then run it like:

powershell -FILE C:\yourScript.ps1

#Server/DB for your repository

$Server = "yourServerName"

$Database = "yourDBName"

## SQL connection function

# removes the need to...

Hrmm xp_cmdshell, I've seen others using the sp_OA Ole Automation proc's too, both imo potential security risks.

Why should I have to enable either of those on what could be...

Thanks! We reset it just to be safe. Had to search around for someone who knew the password though.