Please review my above description of scenario again from top, I only put an example of a table not a actual table having PK , constraints etc, i just want...

CREATE TABLE tbl

(

APC DATETIME ,

ACS DATETIME ,

AET DATETIME...

Dear LutzM

Actually purpose of this trigger is to deal with dates, for more detail; this tables contains different dates such as date_added, date_modified,date_created etc, e.g. date_created is empty and if...

I am focusing on following error.

Operating system error 3: "3(path not found)".

As I am having experience of above error and suggest you that you should change time zone then try.

Reinstall Visual Studio and .Net framework then try.

You should enable Execution Plan before executing query, the Execution Plan will let you know if any table required any additional index and also provide you exact query execution time....

yes look like good

This may can help you, i used ascii code unqiue value instead of soundex code, for sql 2000 need minor changes in code.

DECLARE @position int,

@string char(15),

@val2 varchar(MAX)=''

SET @position =...

You did not consider comments added by me.

--> you can also add desired values to @table variable instead of setting value of veriable.

You dont need to add vairable, use veriable...

declare @param1 nvarchar(10)

set @param1 = '2,4,6'

--> you can also add desired values to @table variable instead of setting value of veriable.

declare @current_datetime datetime

set @current_datetime = getdate()

declare @get_min smallint

select @get_min =...

very simple, when i execute select statement it should return all items with identification of child's master item or master's child. Actually my goal is to findout that if the...

HI

Probably the problem which you are facing occurred just becuase of antivirus program, e.g McAfee Enterprise has strong security checks and also block events which hits outside of applictions.

Follow follwing...

One of following solution can resolve your problem.

1. Add port 25 to firewall port exceptions.

2. Verify mail account authentication specially SSL.

3. Check antivirus program or disable it, restart SQL Services.

4....