Sushila,

That doesn't work. It gives me <A href="mailto:'@P2'">'@P2<P3>' instead of 'HELLO<P3>'.

David,

I might have more than one tag in a line. And I have more than 20 tags. So, having embedded...

Thanks Steve and Frank.

VP

Hi,

I guess I haven't explained my problem correctly.

A process was run in my database a month ago. We need to run the same process again. I have been tasked...

Thanks Steve, but isn't Profiler used on things which are running now? The process has been complete for about a month now.

Thanks,

VP

Thanks mromm, that worked 🙂

VP

Andy,

I don't want to select the resultset of sp1 in ASP. I want to do it in the stored procedure websp. Is there any way of doing it?

Thanks,

Vidya

Thanks.

I don't know the Q#. I was told by our resident SQL Guru that this was a bug - SQL Server not releasing the memory after it finishes a...

Hi,

The network map works and seems to be fine.

Thanks for all your help.

Vidya.

This process is done during the batch process. So, I have it as a SQL Task in DTS. I scheduled the DTS package and it executed fine. I hadn't logged...

I map a drive on another machine to delete some files out there. I do this using system commands from a stored procedure.

Does using system account cause problems with this?...

I apologize. It might have been a password problem. I went in and re-entered the password for SQL Server and the agent. After that I could stop and restart.

But, just...

I don't understand.

I have the correct password because I logged in to the machine with the id and password the service is supposed to start with.

I installed the SQL...