do you want to append href inside the file test.aspx?

declare @var char(10)

select @var=name from Filenames where name like '%.aspx' --sample query

-- now @var holds the value 'test.aspx'

-- this does not...

Sweet..

It was running as local system. Changed it to 'This account' giving my windows username/pw - because i can directly access '\\Central\vss'

(although it didn't work when i used Built-in-account:Network service)

thanks

srcsafe.ini is a (single) VSS configuration file that exists on the VSS server.

Env. variable SSDIR (on local machine) should be set to that directory

(Ex: C:> set SSDIR ="\\Central\vss\")

I didn't create...

Thanks.. Sugesh. I tried that and it works.. but please see the comment:

Thanks.. But

'[]' works for column names, but another statement i run from cmd is :

sqlcmd -S srvr -Q...

Thanks.. But

'[]' works for column names, but another statement i run from cmd is :

sqlcmd -S srvr -Q "exec sp_oamethod @oSrv, 'Databases("pubs").Tables("T_Names").Script(2,"c:ames.sql")"

for which double quotes are a must in the...

Please note.. the column is "first name", not first_name (which does not need double quotes)

Besides.. I'm running this from local cmd prompt.. not on the 'server' (where xp_cmdshell doesn't work)

Is...

Not using VB..

am running the command directly from windows(cmd)

C:\> sqlcmd -S srvr -q "select "first name" from pubs..Names"