This is what I looked at:

SELECT CURRENT_TIMESTAMP- SYSDATETIME() 'CURRENT_TIMESTAMP- SYSDATETIME()',

SYSDATETIME() 'SYSDATETIME()',

SYSDATETIMEOFFSET() 'SYSDATETIME()',

SYSUTCDATETIME() 'SYSUTCDATETIME()',

CURRENT_TIMESTAMP 'CURRENT_TIMESTAMP',

GETDATE() 'GETDATE()',

GETUTCDATE() 'GETUTCDATE()'

CURRENT_TIMESTAMP- SYSDATETIME() was either

1899-12-31 23:59:59.997

or

1900-01-01 00:00:00.000

vivasjimmy (11/19/2015)

---

Hello falk

I have a batch file running sqlcmd and use Windows schedule task to trigger it every 30 minutes.

My issue is that for an unknown reason the...

It would be nice if someone posted both the Powershell and the bat script in the same article.

This .bat approach is very helpful

Thanks!

What did you finally wind up with?

Did anyone consider creating a topic for the original topic and renaming this Water Cooler?

Luis Cazares (11/18/2015)

---

Why should we consider using hashtags? Is there any benefit on that? The forum software won't recognize them, I'm not sure if search engines would care, and what...

I'm setting up Dokuwiki on a stick to get a handle on this.

Often I'll take a photo of handwritten notes, or scan them on the multi-function printer.

I'm a fan of...

We're usually reference Books Online by name and most times include a link to the page they need....

have we ever considered using a hashtag...

Water water everywhere and nor a drop to drink

Lynn,

Asking someone to approach a situation differently doesn't mean that they are doing something wrong, or they aren't one of the best people on the site.

Lynn,

That is correct. I've had my email address changed, and I use to one log in from work that was changed at that time and I also use one for...

Lynn,

This thread or this site?

I've been using SQL Server Central for at least 5 years.

Gilamonster,

I think you have been trying too hard to teach someone without altering your approach if your response is that someone has asked a bad (as in ineffective) question 20...

Lynn,

I was responding mostly to this remark:

GilaMonster wrote:

Second? Well past 20th in the two cases that triggered that post.