can you get the data with a delimiter that is not used in the data, like a tab delimited or pipe [|] or tilde [~] or something? for get the...

i htink you also need a backup of master just in case;

I thought the CREDENTIAL for any database mail username/pass used for the AUTH command are in master, and i...

ok, BULK insert's about a zillion times easier to use than SSIS.

your original table definition that you posted is missing two columns that appear in your data, country, and selection...

CrLf is CHAR(13) + CHAR(10), i think you have the order reversed, so it's not finding anything.

REPLACE(Col011, CHAR(13) + CHAR(10) , ' ') AS Expr2

Thanks! i got inspired by seeing at least three recent threads with that same theme.

gotcha, so in a disaster recovery scenario like that, where the mdf was damaged/lost, you would not be able to do a tail backup...

all you can do is restore the...

instead of a trigger, i strongly recommend a scheduled job that migrates the data to the linked server.

if the linked server cannot be connected to(due to username/password, networking issues, or...

if you deleted the mdf file, you had to have stopped the server to do it...so when you restarted the server, didn't the database show an error? did you recreate...

here is how i would do it:

1.add a new float column to the table.

2.UPDATE table set newcolumn = convert(float,oldcolumn) where isnumeric(oldcolumn) =1

3. the columns that were non-numeric willb e null.....do...

if the path will be less than 4 folders deep, you could use a trick with PARSENAME:

/*

(No column name)(No column name)(No column name)(No column name)

NULLMY ReportsLotusNotes OkMy English Report

*/

SELECT

PARSENAME(ThePath,4),

PARSENAME(ThePath,3),

PARSENAME(ThePath,2),

PARSENAME(ThePath,1)

FROM

( SELECT...

it's pretty close...

i would think that a replacement role like this would give a user the rights they need to create objects and do any DML stiff, but take away the ability...

i just renamed a foreign key no problem...

sp_rename 'FK__SFPLGRP__SFGROUP__000BC426','FK_SFPLGRP_to_SFGROUP'

the FIRST function is an access function, and doesn't have a true equivilent in SQL server...the best you can do is TOP 1...ORDER BY

for me "read only activity" means SELECT from views or tables; and more specifically, no INSERT/UPDATE/DELETE/EXECUTE rights to anything else in

the database.

maybe i can get you at least started...