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...

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...

Sorry,unless you have some auditing in place, before it happened, it is not possible.

you can get basically the last executed information for current connections from the DMV's, or using sp_whoisactive,...

i think the right thing to do is is go straight to sys.dm_db_index_usage_stats, which keeps track of how many times an index was used for seeks/scans/ lookup/updates.

the data is only...

i poked around the metadata with this query, and looked at views that seemed interesting:

SELECT * FROM sys.all_objects WHERE type='V' AND name LIKE '%avail%' OR name LIKE...

16 Gig is fine. for three servers, i would say you need 3-4 gig per server, i've done 1 core / 2 gig per server, but they are painfully slow,...

I know if you install IIS or some other web server, you can redirect the default name of the server to the right folder;

so if someone goes to

for me, that OR statement is something i think i would switch to two separate queries, for each of the two sets.

ON a.ra_number = b.ra_number

and (a.ei = b.ei or...

db_datareader gives permissions to all SELECT-able objects, which would include tables and views.

I think you wanted just specific views, so you have to turn to dynamic sql:

offhand, it would look...