Viewing 15 posts - 91 through 105 (of 13,451 total)
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...
December 2, 2019 at 1:44 pm
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...
December 2, 2019 at 1:40 pm
there are three statements, so you have to evaluate which one is syntactically correct.
two of the statements are not, so if...
November 25, 2019 at 9:09 pm
datatime has an implicit conversion to varchar, based on your locale. datetime2 does not.
the map below from microsoft has some other examples.

November 25, 2019 at 7:53 pm
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')
November 25, 2019 at 7:31 pm
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...
November 22, 2019 at 5:04 pm
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...
November 21, 2019 at 1:54 pm
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...
November 20, 2019 at 9:40 pm
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...
November 20, 2019 at 9:22 pm
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...
November 20, 2019 at 5:35 pm
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...
November 19, 2019 at 12:30 pm
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...
November 18, 2019 at 10:18 pm
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...
November 15, 2019 at 10:08 pm
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...
November 15, 2019 at 8:53 pm
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...
November 15, 2019 at 3:02 pm
Viewing 15 posts - 91 through 105 (of 13,451 total)