There are three options available .

Remote data Access: Low data Load High frequency of Sysnchronisation

Mege Replication: High data Load. Low frequency of Sysnchronisation.

Web services : Where Constant conectivity desired.

For...

Looking at the amount of left outer joins. Its fairly hard to crank up the query's performance from over here. Can you post the db Diagram of the view from...

How about trying out the same query by adding "dbo." to viewname try this out instead of only view name. In your Dynamic SQL Instead of " Create @ViewName...

Both were standard editions and SQL2k5 was installed earlier than sql2k but when I tried connecting to 2k the default connection to 2k was dissallowed as saying server doesnt allow...

I had an experience of connection string issues. On a single machine when I tried to connect to SQL 2K that had 2k5 installed on it The connection was dissallowed,...

The BOL of SQL server CE gives you the method to create the connection string. The only thing happening here is you are not able to give the file to...

If you dont mind can you put the code patch that attempts to switch the connections in the two places.

Regards,

Rajesh

MBA-IT (Software Dev & Mgmt)

SCIT 07-09

The Problem is not with the code its with the security settings of the reconciler dll location that you have on the desktop computer. try to check those setttings that...

Look into replication option or write triggers on the source table

This is just the Logic

Try it out in your query

Select MainTable.PrimaryColumn,..... .... from MainTable

Inner...

Can u put the entire business scenario in here. That led to this requirement. Probably if there is a workaround for the same, a different solution can satisfy it ?

There is a function in T-SQL

NullIf(Expression) try that out. It will make your code shorter.

More on this can be found out at

http://doc.ddart.net/mssql/sql70/nos-nz_2.htm

😉

Regards

Rajesh.

MBA-IT (Software Dev....

Hi Ishaan,

I m also a greenhorn here, but from the way it feels there has to be some relation between vertical partition and key contraints. I came across same problem in...

Hi Ishaan,

I m also a greenhorn here, but from the way it feels there has to be some relation between vertical partition and key contraints. I came across same problem in...