some more information, i see in the system event view errors referring to mount points being invalid: the network admin is not aware of any mount points being used, if...

here's a coded example.

create table #MyExample(Id int identity(1,1) not null primary key,StartTime datetime, OriginalValue varchar(30) )

INSERT INTO #MyExample(StartTime,OriginalValue)

SELECT '1899-12-30 07:45:00.000','1899-12-30 07:45:00.000'

SELECT DATEADD(minute,240,StartTime) As NewTime FROM #MyExample

UPDATE...

i get the sense you might be new to both powershell and SMTP;

think it through...you cannot use a feature without using the service behind it, so you must use...

SMTP is the only way to send mail.

you don't have to use YOUR smtp server, you can send via a gmail account, yahoo, but it is not possible to send...

scrubbing data is really nothing more than an update statement, but you have to come up with a pattern for your updates.

in my case, I've got a suite of tables...

preview mode creates a cache file, and does not always call the server to get the data; if you look, you should see a rdl.data file, i believe.

delete that file,...

i looked at sp_applock, and it would not give you any granularity at the object level.

I'm not sure if the OP is just second guessing SQL locking, and is...

I believe that only Standard and Enterprise have paths for in-place upgrades;

all other versions, like express, require an uninstall and re-install, i think.

so you'll want to either do a side-by-side...

answering my own question, by converting ms_ticks to seconds, i think i see what i was after:

--ServerRestartTimeServiceRestartTimeServiceUpTimeInDays

2015-08-22 21:46:51.9802016-03-29 08:34:07.89087

-- select

DATEADD(second, -1 * ( ms_ticks / 1000),getdate()) as ServerRestartTime,

...

you are looking for a data driven subscription, which is an enterprise feature; are you using SQL enterprise or standard?

the subscription can use a table or view to feed the...

i believe the GUI will DEFAULT to use Local Users to the server, and you explicitly need to select domain. annoying, for sure.

so if i search for mydomain\lowell, it...

here's a snippet i use for auditing...

reading it again, since you want to hav eby month, the date logic needs to be int he group by also:

Select

br.Branchno,

DATEADD(mm, DATEDIFF(mm,0,vw.viewdate), 0) As MonthViewed,

...

here's my best guess.

Select

br.Branchno,

DATEADD(mm, DATEDIFF(mm,0,vw.viewdate), 0) As MonthViewed,

Count(*) As TotalViews

FROM Branch

INNER JOIN Registration rg ON br.Branchno = rg.Branchno

INNER JOIN Client cl ON rg.Clientno...

Welsh Corgi (6/21/2016)

---

The following list the Extended Properties for each column in a table:

SELECT * FROM ::fn_listExtendedProperty

(DEFAULT,'schema', 'dbo', 'table', 'Event', 'column',DEFAULT)

How do you list the...