could you post the query that you are using currently. Also try appending -- where 1=2 to your query. i think this should help you.

Paras Shah

Evision Technologies

Mumbai, India

dateadd, datediff could help you for add / sub datetime fields and also datepart could be useful for you for date manipulations

Paras Shah

Evision Technologies

Mumbai, India

How is this possible? I have got hang of software that are able to decrypt encrypted stored procedures. But I want to decrypt the value in the field(column). Please let...

then .. what is the best way we can encrypt the data while storing it and also retrive it while getting it to the frontend.

Has anyone made a stored procedure...

You need to start SQL Server Agent for this.

Paras Shah

Evision Technologies

Mumbai, India

this is the script that i had browsed thru in the past..

CREATE PROCEDURE SendMail_sp (@FROM NVARCHAR(255), @TO NVARCHAR(255), @SUBJECT NVARCHAR(255), @BODY NVARCHAR(4000)) AS

DECLARE @Object int

DECLARE @Hresult int

DECLARE @ErrorSource varchar (255)

DECLARE...

Andy, is there anyway that we can start SQL Server Agent by stored procedures, if is not started. this is because i am facing a problem on my shared web...

You need to start SQL Server Agent and then SQLMail. I think then you would be able to use xp_sendmail perfectly.

Also if you are using NT Web Server, you have...

MIke / Andy, could any of you please elaborate on your problems and also elaborate more on the difference between bi-directional and 2-way replication.

Thankx

Paras Shah

Evision Technologies

Mumbai, India

Thankx Sean, I shall try this out and shall keep you informed on the developments in this regard.

Paras Shah

Evision Technologies

Mumbai, India

[font=verdana]I have databases in 3 cities and 1 database on the internet.

Internet

|

|---------|-----------|

A.........B...........C

My data is...

I am using replication so that I have common data on all my offices. The data on the web server is in a way kept somewhat for staging but...