At least for me, i only want a last login if it's changed since yesterday. i don't need 50 updates to update to the latest second

By adding a WHERE statement...

whenever i do a SQL consolidation, i actually stop the SQL Service on the old machine afterwards, and see who complains that they cannot connect anymore, so I can then...

this knowledge base from MS says that support for bcp.exe to use UTF-8 was added to SQL2014 in service pack 2, so if you are in SQL2012, i think you'll...

does the issue go away if you run it in administrator mode instead? Right click...run as administrator?

I've seen that same error before in places where permissions were locked down pretty...

When it is blank white circles, it is specifically telling you that you do not have permissions to start and stop the service (where the MSSQL or the SQL Agent)

if...

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.