i only had 7 csv files, but this seemed to work just fine:

note i'm assuming multiple directories as well for the csv files.

uncomment out the "--exec(sql) if you are ready...

ok a tiny bit of research, and i can openquery csv files with this command on either my 2008R2 or 2012 instances:

SELECT *

FROM OPENROWSET('MSDASQL',

...

Howard do all the files have header data as the first row?

i used to be able to do this with the Jet 32 but engine, creating the table on the...

ALTER TABLE SomeTable ADD CONSTRAINT UQ_Firstname_lastname_Birthdate UNIQUE (Firstname,lastname,Birthdate)

the scriptlet i posted is what i've put in a scheduled job before;

just letting it run once a day deletes anything older than 30 days;

that's what would be my simple...

if you know the traceId(select * from sys.traces) , you can import it into a table, or create a view for it, all from within TSQL, so you probably do...

if you look at your code, you have two other variables that have not been declared as parameters:

@NEW_ACCOUNT_ID

@NEW_MSISDN

you did declare @Val1 and @Val2 already;

to me it looks like you did...

jason if you sp_helptext sysmail_delete_mailitems_sp in the msdb database,

you'll see it's using a catch-all query to delete fromt eht able, and only one table;

after a bunch of error checking, this...

I had to deploy a CLR similar to this issue once; it used a "custom" flavor/implementation of an AES-like encryption that was almost, but not the same as, a true...

a really awsome TSQL based stored procedure already exists for handling database backups is part of the suite here :

http://ola.hallengren.com/

that solution is peer reviewed and award winning, and...

ok for me the fix is easy;

there's a much better, award winning, peer reviewed and rather famous script to help handle things like reindexing.

it's been deployed by more businesses, on...

the microsoft documentation is here:

http://msdn.microsoft.com/en-us/library/ms152536.aspx

from what i remember, two way replication must be between non-express versions(SQL Express cannot be a distributor?), so i think you need to create both...

well, linked servers may not behave the way you expect;

typically here's what happens:

every row in the remote table is copied to a table in tempdb.

the update is performed on...

well, i think the issue's in the procedure you are talking about ...i don't think it's schema aware;

i wouldn't take the error message from the scheduled job literally(that a...

i think the table might be in another schema, but you are assuming it's in the dbo schema, since that's what is your default.

try this instead...what schema does it really...