Thanks for the reply.

However I heard that we can set scope for calculated measures so that the calculated measures will appear for drill through.

How far it is correct?

Thanks.

Gianluca Sartori (5/29/2009)

---

What do you mean "SQL Server Software"? Is it SQLServer Management Studio or what? If this is the software you need, it is bundled with SQLServer (2005 or...

venki (4/28/2009)

---

Hi,

I want to increase the column size in the table tblCostBuildUp.

I am trying to execute this DDL statement but I am getting the errors.

If I do it from...

Hi,

I want to increase the column size in the table tblCostBuildUp.

I am trying to execute this DDL statement but I am getting the errors.

If I do it from SSMS...

Chris Morris (4/22/2009)

---

Interesting - the primary key consists of [CostWorkOrder] plus another two columns, but [CostWorkOrder] is also defined separately as a unique key (the DML for this isn't in...

Chris,

I am sending the script for the table.

USE [WKO]

GO

/****** Object:...

There is a duplicate data for that column where user is trying change it. Yes, it is a key column of composite primary key. and also it is unique non...

venki (4/17/2009)

---

Hi,

I have a Access application which has following code.

Set qry = CurrentDb.QueryDefs("qrySumOfExpenses")

qry.Parameters("param1") = pubLocation

Set rec = qry.OpenRecordset

The above code is...

Gosta Munktell (4/16/2009)

---

Venki

Do you run the query as a query in Access?

In design view you have Query Properties there you can adjust the

ODBC Timeout. Default is 60 s. I run...

William,

Thanks for your help. I will try this example and tell you.

But a quick question is I don't think there is a difference between existing query and your query...

Chris Morris (4/15/2009)

---

What's the name of the primary key column?

How are new values for the PK generated?

The Access application may be attempting to change the value in the PK column...

Flo, Thanks a lot for you help. I will...

Thanks for your information.

I attached the options screen shot. Time out property set to 0 secs so it means infinity. So it would not the problem.

My Access application has...

Please help out. It's very urgent.

I analysed the problem and found that the table I mentioned is not the table in SQL Server 2005. It is a VIEW which is...

Thanks a lot Atul. Thnaks for your help.