FYI, if you have multiple AG's does NOT check properly.

We do a similar process, but we just check using the system function. setting our database to one is the AG...

SURE!

Using it for ASPstate database, now keep in mind the web dev's need to make a few changes to utilize ASPstate in memory. here is a link to the...

I think its great that Microsft does the early (not always perfect) for us early adopters. We have SQL 2014 in production utilizing Column store index, filetables, and In-memory. And...

Lewis, did you ever achieve a resolution for this? I have bumped into the same issue, and only work around is to move files to alternate location or BCP.

And just to mention the Microsoft supplied function for SQL version 2012, 2014 the EOMONTH.

http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(EOMONTH_TSQL);k(SQL12.SWB.TSQLRESULTS.F1);k(SQL12.SWB.TSQLQUERY.F1);k(MISCELLANEOUSFILESPROJECT);k(DevLang-TSQL)&rd=true

Congratulations Jeff !!!

Thank you all for your comments, and to those that voted for myself and all the finalists. As you can see in the posts I have had a few inquiries...

JUST FYI,  If you want to monitoring a service state inside SQL this can be done by another undocumented xp. Here is the T-SQL to show the surrent state for...

SELECT SERVERPROPERTY('NumLicenses')

if your using the IP address ( xxx.xxx.xxx.xxx ) simply quote the IP address. This can be done by [xxx.xxx.xxx.xxx]   or  quotename('xxx.xxx.xxx.xxx').  Hope this helps.

Dan

Why not use Excel, you can retrieve external data into excel ( ie Get external data / Query) and then chart/graph all you want.  when needed you can manually or...

I have moved MSDB and model database at the same time on more than a dozen servers recently.  The first time I ran into the same issued by following the...

Found the ODBCCONF very helpful.  but can not find the parameter for SQL DSN to create it as a trusted connection ? 

Based on information I have seen on Microsoft's site,  PKM = Publishing and Knowledge Management.

an example being:

Publishing and Knowledge Management Collaboration Data Objects (PKMCDO)

Dan

Try this to keep it inside SQL. I use this as a schedule job on my servers to execute against all databases /tables on the server. I execute IndexDefrag...