Hi,

Here is a similar question:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=119192&p=1

/rockmoose

Hi,

I have had similar experiences from time to time.

What I usually end up doing is:

1. ALTER TABLE refTable DROP CONSTRAINT refConstr

2. DELETE FOM referencedTable

3. ALTER TABLE refTable WITH NOCHECK ADD CONSTRAINT...

To check bobsterboy's hypothesis, which I think is correct.

( multiple salesperson assigned to 1 custaccno ).

You could try the following sql:

SELECT count(distinct sr.salesperson) as no_of_salesp, act.custaccno

FROM sales_report sr ,activations  act

WHERE...

Thanks for support on the Stored Procedure noel,

I agree completely

/rockmoose

See

DBCC DROPCLEANBUFFERS

DBCC FREEPROCCACHE

/rockmoose

Hi,

I made an internal ranking..

T-SQL, View, or Stored Procedure,

Which is more efficient?

Which is more secure?

Which is more flexible?

                   efficient   secure flexible sumpoints

select           1            1        2         4

view             2            2        3         7

sp                4           ...

In what context ?

One might be inclined to answer "It depends..."

I use all three techniques depending on the requirements at hand.

Ok,

"select OrderId from northwind.dbo.orders

go"

that is the one we don't let...

Oh,

And check the defaults on the database columns.

Maybe they are set to insert the database USER, which is not the same as the LOGIN !

/rockmoose

Actually I think it is strange that the Application X leaves sysdba, and not the NT credentials, which obviously is available.

Where do You see "sysdba" ?

If Application X was using one of...

Yeah,

This is troublesome. We limit the number of roles, use "normal" security and don't do much drilltrough.

For detail data we provide traditional asp reports ( RS will maybe be used...

As an example, I am filtering data by Geography.  What is happening is that the user has access to one Geographical region (UK), but this is the only region...

You are welcome ikorenbl!

Yeah the (select count(*) + 1 from #scores s2 where s1.grp = s2.grp and s1.result < s2.result) is a bit tricky.

One might be tempted to believe that (select count(*)...

No idea Kamala,

I could not duplicate the behavior. Make sure that the first character in the copied data is a TAB. If it is not TAB paste is greyed out...

--I don't know why I did this but I guess i feel a bit lethargic at work right now...

--You can try something like this...

--I don't...

Hi,

You say that your date is stored as an int.

Ok does select convert(datetime,my_int_date) correspond to the actual date,

or is there some more logic involved ? like mkeast suggests.

In this example,...