a feature of almost all email programs is to not show images without extra user interaction, or not show from untrusted sources. check your application, and see if you can...

I'm betting you are not handling nulls correctly; you have to isnull every column as you build the string, so that...

ahh, so you are using some custom data types you've created, right?

i had assumed the longest string datatype was "uniqueidentifier", and that's where the 16 came from.

good catch, i'll wiggle...

only a domain account can access server shares, so you'll need to change the service account that SQL is currently running under. NT Service\MSSQLSERVER is not a domain account, so...

there's a nice confidence builder to get started:it's testing for basic proficiency with SQL Server.

MTA 98-364 Database Fundamentals is $115, and there is a track on Virtual Academy for...

I've seen upgraded packages change the delimiter to "_0x0044" or something like that, instead of leaving the original comma;

open the package, and review what the delimiter is in the package...

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,

...