here's my first pass, does this do what you are asking?

SELECT distinct jobnbr,tasknbr

FROM (

--do not have a JPRE or JPOS route,

SELECT * FROM #JobRoutes WHERE jobnbr NOT IN(SELECT jobnbr FROM...

it's not that intuitive, but you have to remember that...

yes there is Jim!

i had worked diligently on this same issue, and put together a pretty good version code base that creates a script by reading the metadata, to create...

This is what i slapped together to get started: i figured strip out anything Alpha might work, and preserve numbers, spaces and math symbols? but one of your examples had...

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...