have you used sp_send_dbmail before? i swear i've seen that error when the .net library 3.5 was not installed on the server, but dbmail depends on it:

December 6, 2019 at 8:14 pm

#3705542

i wrote a decent DDL trigger example for someone that had  a similar-ish requirement.

some people needed to be able to create ONLY views.

the solution was  arole,a nd a DDL trigger...

i think the issue is that on your new SQL2017 server, you must enable Filestream at the server level in SQL Configuration manager first.

then filestream would be supported. also, i...

this might be data related.

so far, lets say Word had to render x number or rows of text boxes, and now the data finally exceeds the number of objects word...

your insert statement above  is clearing inserting 820419145086 into the column in the very first line of the table, so your assumption that the column [NOKP_NEW] [nvarchar](255) NULL, will cleanly...

you can either  join the master_profile table  to the insert for the child table, or you can leverage the OUTPUT clause and capture the newly inserted data into a temp...

so looking at the code, it is using Excel Interop to save to a tab delimited file;

can you eliminate the middleman and just read the excel document with SSIS, and...

• This reply was modified 4 years, 11 months ago by  Lowell.

that would only work on a very small environment right? I've got 64 prod servers and nearly 200 total including non-prod, and the number of times in the last year...

DAC guarantees some memory is held in reserve for an admin to be able to connect,  whether you connect via sqlcmd or SSMS.

so if the CPU on the server is...

i think you have to uninstall all services and shared features by checking modify existing,and selecting everything that was previously installed via the SQL installer. i do not believe you...

there are three statements, so you have to evaluate which one is syntactically correct.

two of the statements are not, so if...

datatime has an implicit conversion to varchar, based on your locale. datetime2 does not.

the map below from microsoft has some other examples.

• This reply was modified 5 years ago by  Lowell. Reason: wrong map!

you were originally planning to handle the null, so this is a bit better:

SET @CaptureError= @CaptureError + ' ,Date: ' + coalesce(convert(varchar(10), @Date,101), 'NULL')

i think the definitions of the index need to match the queries hitting the server. the multi column index is not equivalent to indexing three columns individually.

a single index on...

sultikav i guess lets start with the basics:

is the SSRS service up and running, so you can navigate to pages or the management links, and you are just having trouble...