Hi, I've checked this and in this case optimizer gets wrong join type once again. I'll stay with that hint

Regards,

Rafal

Hi, parameters are ok.

But finally I've found why it took so much time. The problem was with wrong choose join type by query optimizer (nested loop instead of hash join),...

I've tried with recompile option but result is the same :S

How it is possible that it is so huge difference between executing some code in sp and the same code...

Hi it was only example, my query exactly looks like this:

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS OFF

GO

ALTER     PROCEDURE GetRawAUniverse

 @AttributeID int,

 @AttributeDateID int,

 @DateID int,

 @CountryID int

AS

CREATE TABLE  #ACountry ( AssetID int PRIMARY...

Hmm, you have right, I'll change this in my table.

Thanks,

Rafal

But I really don't see the problem with that end date ? I can query against NULL values, but I think that in this case is better using '6/6/2079'. Maybe I'm wrong,...

I've red that we should avoid using nulls in tables. What the difference if I update date '6/6/2079' instead of null ? And I have improve in executing query using BETWEEN.

Regards,

Rafal

No it isn't as simple as it seems. The last EndDate for client is equal the max value for data type smalldatetime.

But I've resolved this problem, I'll add here...

Hi,

thanks for reply and help. I have a really good reason However this script doesn't work (ie. 100.0000). If doesn't exis any...

Of course. You can remove Builtin/Administrators, but be carefull

The same article:

"

Note: The BUILTIN\Administrators account can be removed from a server only if...

Yes, try to uncheck this option. By default this option is unchecked.

for example http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops3.mspx

"The SQL Server 2000 BUILTIN\Administrators login account maps to the local Administrators group on the local computer where SQL Server 2000 is installed. The local Administrators group...

Can you run cliconfg.exe to check if the "Force protocol encryption" option is checked ??

I've checked this and it works, you can deattach database from sql 2000 and attach on sql 2005.

Check owner of this job and if necessary change to existing user.