Thank you Todd very very much. it seems the counter Current Connections under Web service object did the trick for me.. You are awesome..Thanks a lot.

Thanks Todd. Sounds like this will do the trick. Where can I exactly find Performance Monitor? Is it under Component Service?

Yeah I understand what you are saying. But as you know some users are so oblivious to those messages that they might just log in still. And therefore I...

are you hinting towards xp_cmdshell??

There is a option called First rows contained the coloumn name in the SISS import export wizard.

The things is that what if both conditions are true. will it perform both the cases? I am not sure about the working of case statements in SQL.

The two update statements are:

UPDATE studTable

SET choice=@Choice1

where StudentID=@studID and Choice="Dance" and Status="S"

UPDATE studTable

SET choice=@Choice2

where StudentID=@studID and Choice="Music" and Status="S"

So basically I would like to achieve the above in just one...

Thanks guys. So waht should the final code look like after your last suggestion about the inner loop.

wow looks like that might work. Thanks for the effort. How do you get the number 175,167 for char and varchar. What if I had 'number' as type. Where do...

Thank you guys for the suggestion. I guess I will have to go the usual way.

BTW, how can I access the script Library. Just curious.

Thanks

well thank you guys for your replies. Actually the statement that you guys suggested:

INSERT INTO login_info(login,password,email)

SELECT LTRIM(RTRIM(login)),LTRIM(RTRIM(login)),LTRIM(RTRIM(email)) from Master

In the above statement, I have to write LTIRM,TRIM for every coloumn...

can you give the exact SQL statement to achieve after removing 'where login=@manualindex' from the above statement.

Thank you all of you guys for your valuable help and time. I was able to get the error messages in my own defined variable by streaming the output of...

Thank you so much. I tried the above script and with some modification I was able to retrieve the error messages in my owned defined variable.

I have couple of questions:

1....

You mean if I use the above script, I won;t be required to use the long script that you have posted earlier. Extremely sorry, if I am bothering too much,...