Thanks everyone for the valuable answers.

To cut things short. The product we have is running on windows 2003 with sql 2005. We need to exit 2003 by year end. That...

Thanks.. Without u encrypting them can the upgrade work? The reason it needs to be 2008 and. Not higher is because that's the last version it supports and we don't...

hi happycat..

thanks for the reply.. yeah it works perfectly as what i mentioned in the first post without a parameter..

however currently i can't afford to without.. it will return more...

ok. Thanks for the reply.. i was thinking of using an UDF like a shortcut.. at the end i took the stored procedure approach, more line of codes.

Hopefully in future...

Anyone? pls pls... very urgent

hey hey.. it works. Thanks man!!

it works!!! thanks..

this query doesn't work if i pass in the parameters(example a sp name).. any ideas? it just return no recordsets..

but if i were to run just EXEC master..sp_sproc_columns spname

it will...

hi GCN, thanks for ur help, but this is not what i wanted, i want the recordset not the columns only

ok thanks. Btw, how do i go abt doing the set based approach?

if it's not too much i would like ur help again, the openrowset or openquery doesn't work properly on this system sp

sp_sproc_columns, it keeps giving me error

Syntax error converting the...

Hi Allen,

I am running SQL2000 EE, and windows 2000 advance version. I have max 2 GIG physical RAID5. I need to rephrase my question as i have figured...

Any ideas, if i cna get a hand on any pre-exisiting script that does the change users login.

Thanks

Finally got it working!! Thanks all!! especially Jeremy. I found out the problem.

When i was running on query analyzer, my setting on the connection is set_concat_null_yields_null is off, And so...

Hi Jeremy, Got it already. It works however i have a few issues.

Here's what is happening.

I have a job that execute a stored procedure. In this SP, i am constructing...