i don't believe...

I looked at your datafile,a nd because some records will contain multiple CrLf,s you will have to use SSIS or BCP, as suggested above.

on the SQL 2005 server, you will...

http://www.sqlservercentral.com/search/?q=audit

audit has way to many connotations...

audit data changes? backups success/failures? diskspace?usernames and roles? login successes/failures? servers on a network and all their versions?

tell us what you are wanting to...

ok i see what you are trying to do;

in order for this to work, the acount that is running the services will need domain admin priviledges in order to browse...

from what i just read WNetGetUniversalName 2will give you the UNC path to a shared resorce, but not a local resource;

i think you'd have to build that yourself, and could...

not sure how much help this really is;

but i found it in two places

by running "NET USE" in a command window, i get results that i could use with xp_cmdshell:

Status...

for the ziptestserver plan, the QueryPlan DegreeOfParallelism="1", but for the homecexecution plan, it's QueryPlan DegreeOfParallelism="0";

it looks like the rest of the plan is exactly the same though;

Jeff mentioned it...

you cannot resize it to be smaller than it currently is...did you perform a shrink before trying to modify the size? that is the most likely issue.

I think you'll need...

Remi you've got to look at the recent posts; he's pasted about a dozen interview questions to the forums, instead of googling. Even changed his screen name once since this...

It sounds like you want to calculate reminder dates with an interval of three months, for lets say a year into the future?

you'll want to use a Calendar or Tally...

i'd suggest updating statistics right away on the server...that can often slow down execution plans.

another thing to consider is the time it takes to assemble the information and send it...

kingscriber with exists(), it should bail out on the first match it finds; seems like it ends up scanning 14K items until it hits a match, so I'd think that...

I was recently "schooled"(ie chastised..hehe) here on the differences of IF EXISTS.

IF EXISTS (SELECT 1 FROM FilesView WHERE Element IS NOT NULL)

or

IF EXISTS (SELECT * FROM FilesView WHERE Element...

Ed i think it has to do with the version you are installing; I think SQL Express and SQL Express with Advanced Services only let you connect to a SQL...

Ed i don't know if this is much help, but in the past when i wanted to get a table that had a field which contained CrLf, i ended up...