i found it: it's from Friday January 07, 1994

about halfway down on tis search:

http://dilbert.com/search_results?terms=Opportunity

Thom I had the same issue with some of the earlier versions of SSMS2016; in my case, my settings(which are stored in %appdata%\Microsoft\SQL Server Management Studio\13.0\SqlStudio.bin)

would reset, lose previous history,...

Lord Slaagh (1/3/2017)

---

Hello,

I am trying to export data from our staging environment to a .txt file on my local machine. I am using CMD Prompt for this. When I execute...

ATTACH is for an db1.MDF/db1.LDF pair of files.

what you need to do is RESTORE the database from a file.

http://www.mytechmantra.com/LearnSQLServer/How-to-Restore-Database-SQL-Server-P1.html

the variable assignments CANNOT be a calculation. it has to be a variable or static string.

below you are appending things together.

@Body = '**** This is an automated email - Please...

browse to http://127.0.0.1/Reports instead!

that is the web page interface that you are expecting.

http://127.0.0.1/ReportServer is the deployment target, so it shows up as a directory listing.

I use the free applciaiton Dexpot(http://dexpot.de/?lang=en) to manage multiple desktops, instead of anything that is built in. i use it in both Win10 at home and Win7 at work.

Using that...

what you are looking for is the logon account being used under services:

(Control Panel >>Administrative Tools>>Services)

here's a screenshot with four different SQL instances, and you can see three different accounts...

not all that dangerous, I think, since it's...

so, are you inventorying servers/instances, or databases? for me, that's two different things/levels of documentation.

or are we on...

you might run into some permissions issues, you might need a domain admin level permission;

i can query servers i...

with powershell, you can check the services that exist on multiple machines, as long as they are on the LAN/you can connect.

You don't want to handcuff yourself into a...

you can do the same thing effectively with a dedicated admin connection from the server,

again only if you are a local admin user on the server, and also only if...

i was wondering if you could do the same as a set based operation, without the loop

does this produce your expected results?

SELECT

SUM(CASE WHEN (ISNULL(otherprocedurecode1,'') <> '' AND ISNULL(otherprocedurecode1date,'') = ''...

if you are a local admin on the server, there is a technique using powershell to impersonate the service account running SQL, and add logins, and then add that login...