I have tryed that, but not able to get any script out.

just getting below error.

Msg 22047, Level 16, State 0, Line 0

Error executing xp_get_script extended stored procedure: Specified resource name...

Thanks dmanju for your help.

I already tried {,}{CR}{LF} this option but it didn't work.

Now I am using Script Task for getting rid of that extra comma. so far its working fine.

Thanks all for your help.

Hi All,

Thanks for your help.

The problem is solved now, their where 2 problems.

One with server Ethernet port, never would have guessed unless saw some lost packets. The other one was...

Hi Stefan,

I tried recreating Index every thing, but no luck.

I think what you said about the system db might be true, but not sure as of now how much that...

How about using "sp_helplogins"

Hi, This link may be help full for you.

http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm

David i agree with you on this, even i have customized my function do deal with this issue.

Thank you all very much for your suggestions.

I had a function in 2000 which use to substring & convert values from varchar column, now this is failing in 2005 because its excepts the "\" char as number but...

Thanks a lot for all your help.

I wanted my final output as datetime.

I have data in one table without time & while writing the query i have the statment says col1> getdate(), which gives different result as getdate comes with time so i...

I want my final output should be date only not varchar.

this is what i am useing now..

select convert(datetime,convert(varchar,getdate(),105),105)

November 20, 2006 at 5:07 am