Thank you for the input Aaron. Can you please give me the sample code for creating the function.

Thanks,

MK

Thankyou for the Info. Ahrens.

Thanks for your reply, I know that we can import the data using DTS package and schedule it as a job to see if there are any updates and import the...

GReat.Thank you very much.

Thankyou for the reply stacenic. I am sorry for putting my question wrong. I want to change the port on the Clustered Servers. I was trying to do what you...

It works, thank you for your help Jonathan.

Thankyou Allen for your Solution.

Actually I want to pass only one parameter to the function which is the current date or what ever date the user gives and the function...

I appriciate your response and thanks for your suggestions but I need to get this done in one days time that's why I have posted it here to get quick...

Thanks for the response.

I am forwarding you a link, right now it is in a web app.I think it will give you a clear understanding. I want to do the...

Because you did not have the insert in the create statement.

Try this

CREATE TRIGGER trg_UpdateFlag_U ON dbo.TableB

FOR INSERT, UPDATE

AS

update TableA

set flag = 0

from TableA

inner join TableB

on TableA.Unique_ID = TableB.Unique_ID

where TableBPrimaryKey_id...

I think this is what you are looking for....

DECLARE @ID INT, @Len INT, @Begin INT, @End INT, @Last INT, @val INT

DECLARE CUR CURSOR FOR SELECT Number, LEN(Name) FROM TempTable

OPEN CUR

FETCH...

I think you have to do it manually.

Hi Peterzeke,

Hope this is what you are looking for.

CREATE TABLE DBO.TEST_NAMES(

NAME_ID INT IDENTITY(1,1),

NAME_DESC VARCHAR(50),

NAME_DESC_REVISED VARCHAR(50))

INSERT DBO.TEST_NAMES(NAME_DESC)

SELECT 'BROWN, JOE'

INSERT DBO.TEST_NAMES(NAME_DESC)

SELECT 'BROWN, JOE F'

INSERT...

Hi Wingman,

Try this

dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name /Mpackage_password

Thanks

I think I can use sp_attach_single_db_file

only when I detach the file using sp_detach_db.