Sankyverma, the request is to get the last record not the max value record for each user.

We have used linked server. We also create separate logins, provide necessary access and execute linked server using the above login.

I was trying something to make this work. I did open Surface Area Configuration to check the remote connections.

When i click the "Remote Connections" i am getting the error message...

Yes. and Both are set to run with "Local System" account. But still the same issue.

Yes. Thanks Paul.

I would like the automated script to run 24/7 and hope it would not block the memory if it going to keep it in cache.

How to program such...

The trace file got created successfully but it showing only "0" bytes. I am assuming the process has access since it has created the trace file in the network share...

Hi,

I developed similar to one below.... but it not writing anything.. please let me know what is wrong in here?

--------------------

/****************************************************/

/* Created by: SQL Server Profiler ...

But.. still i can select debuglocal and set the destination server to my test server and the report will get still deployed. Isn't it?

How debuglocal, debug tied up with...

Forgot to mention in the previous post.

The total records which would get updated would be around 10 million records.

This is the modified update statement based on your feedback...

UPDATE a

SET a.field1 = CASE WHEN b.field1 IS NOT NULL

THEN b.field1

ELSE a.field1

...

Thanks.

Eventhough table1 is very large, table2 would have less number of records around 3000 rows so i hope batch update is not required.

Also i am planning to add "date" condition...

Hi,

I am trying to create notification in server A and want the read the queue data using stored procedure from server B. Can you help me with sample article of...

For sql server deployment you might have to manually edit the manifest before deploying.

You may also try installing the BIDS helper (.net addin) through which you can deploy single package.

...

Do you want to do file based deployment or sql-server?

In the first case I would copy the package directly into the destination folder, login thru SSMS and to intergration services...

Making delay validation to true is just delaying the validation till runtime. This property would be useful when designing/building packages through BIDS.

What happens in a typical scenerio is when a package is...