hi,

yes it helps a lot !

thank you very much. I ll try this tomorrow at work

Thank you very much for all your answers.

That's what i need.I am going to work with indexed views. Except that i finally decided to add certain computed columns directly...

Another problem linked to this one..

The query works fine now, even if i don't like not being able to write "jprod as....query treatement here"

What if i need to define the...

Indeed!

It works this way:

select

...

I t works using ''''

SET @effacer = 'master.dbo.xp_cmdshell ''DEL '+ @chemin + @filename +''''

but i don't understand why (tried everything)

Hi Lowell

I insisted a bit and they gave me rights to be able to perform settings change.

I did exactly what u said :

my login/password in "open a session as"

and...

I can't change this!

access denied

error 0x80070005

That's probably coze i have limitations on my own PC..I am gonna check this and try to set the "open session" with my domain...

IDTheOutput

1nt service\mssql$sqlexpress

2NULL

3NULL

Indeed! That's what i have. I had checked actually when i first red your post (in services, right-click on the instance name..). The point is that for the moment...

Hi Lowel,

Have the same problem "access denied" when trying to exec "xp_cmd". Except that i am on windows seven. The company isntalled sql express on my machine to start constructing...

Hi Lowel,

I have the same problem.."Access denied". Except that I am on windows seven. My PC is on the local network and the company installed sql server express on it...

It does work.

I did create a copy of the table with varchar columns instead of float and i insert the data in this table. An "instead of" trigger insert then...

Hi guys,

Part number is a varchar column. Float columns are measurements.

The solution i think is what u said Sergyie. I m going to insert first temp table with varchar...

Hi Sergiy,

Indeed, i tried to run today and it s not working.

USE [test1]

GO

BULK INSERT [dbo].[TABLETEST1]

FROM 'C:\Users\HPENOT\Documents\data_xls\ligneEOLT2etoile.txt'

WITH

(

...

That is exactly what i was looking for. thanks a lot Lowell!

PS : Sorry for the error in my post, I actually did an INSTEAD OF trigger.

special thanks to "dwain" and"Want a cool sig".

To jason : no, i don't have a technical mentor...it s certainly gonna be hard! i ll spend some time on sqlserver central...