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 http://MyserverName, the...

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

so there's two things here you have to check.

the D:\ drive here must be on the SQL server.

@file_attachment = 'D:\Test\results.txt',

if the drive is not on the server,...

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

on most of my servers, the log files are on a completely different drive; it is more common on bigger installations to seperate the data to multiple drives.

so the mdf...

Mike Vessey has the answer there. USERS don't have passwords (except in contained databases, there's always an edge case)

so you have to change the LOGIN that the USER in the...

I have had some scripts like that error int he middle do that, and it was because my \\unc path was out of space. i could do the first few...

you'll need to modify this query with your names:

EXEC sp_dropserver 'OldServerName' 
EXEC sp_addserver 'NewServerName', 'local'

after that, there will be a difference in @@servername until you can stop...