I guess you're talking about the Environment Variable Path.

I'm not sure that is correct as I have another batch file which uses ..\file location and this works fine.

Ah someone replied

Ok this is what Ive got

exec master.dbo.xp_cmdshell 'osql -E -SERVERNAME -d DATABASE -i ..\Procedures\PROCEDURE.prc'

Now how do I shorten the directory location so that I dont have to specifiy...

Surely I cant be the first ever person to want to do this....

I just need to execute a stored procedure which is sitting in a file outside of sql server.

if...

OK guys Ive set the column date as a default value of the current date so that problem is solved.

However in the file I have there are 2 rows of...

Hey

Thanks for replying.

This is going to be a one off thing.

Idealy I would like to do it without using another table. Is this possible?

The text file has 4 values in...

I have the code below.

I need the row count to display in the text file but it doesnt. I can see it in my query result.

How can I get it...

Hi

I have the code below but it is not creating a txt file.

The procedure runs fine with no errors and i execute it in sql server 2005 query analyzer but...