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, 11 months 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...

select * from sys.dm_server_services lists both the db account and the agent account. the db account(SQL) is what is used for backups.

mapped drives are on a PER USER basis, and...

you can poke around, but there is an open source zip code database here: you can easily find others.

https://public.opendatasoft.com/explore/dataset/us-zip-code-latitude-and-longitude/table/

https://gist.github.com/erichurst/7882666

that has a latitude and longitude  for the center of each zip...

i am pasting a full example below, with what is undoubtedly your issue with object ownership chaining.

for SQL server, if you grant execute permissions to a procedure, underlying objects permissions...

typically that error is invalid parameters, i think, and might be related to the @query paremeter

since you didn't provide any details or sample code, lets start at the top:

does sp_send_dbmail...

Create an SSIS package that processes the file;

whether the procedure calls CLR to process the file, or you load the file contents into a SQL table via that SSIS package...

agreed, but I cannot tell you how many people I've met who consider CSV to be excel, since it's often the default  application for CSV.

add in the fact that he's...

the data would have to feature text qualifiers(typically dbl quotes) in order to do that; doe sit?

for example a csv that looks like this:

"col1","col2","col3"
"data1","data2","data 3
that features
multiple lines"

if...

briefly, the way I have been doing it is as follows:

the VM will have access to a virtual folder form the host that you share, ie Z:\Shared, so you put...