just my 2ct

Could you elaborate why your update statement would not qualify to be done using this view ?

If the update works, I presume you'll still find these data through...

- do you all have 56" screens ?

Where 's the time we had automatic wrapping ? I don't like to be scrolling horizontal.

- I also get some...

hanslindgren:

quote:

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

Oki, in your opinion, what is application needs? Are they never relying on queries?

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

Of Course it's ALL about queries ! But it's a tradeoff as to which one(s) will be...

I entirely agree happycat59's comments. Plus the fact each clustering index should be picked, based on application-needs. You don't change clustered ix just because a query runs slow. First stage...

use userdb -- User-db

go

print 'print @@servername + '' / '' + db_name()'

print 'go'

go

declare @username varchar(128)

declare @Musername varchar(128)

declare @IsNtName bit

declare @sql_stmt varchar(500)

--cursor returns with names of each username to be...

http://support.microsoft.com/?id=264123 might have been the problem.

Due to production pressure, I've had to solve it with uninstall reinstall of SQL7 up to SP4 and then reattatch the db and recreate the...

grab "the best of sqlservercentral.com 2002", you'll find more info regarding this.

maybe a search on this site gets you in the right direction.

Check BOL (books online)

or

http://www.sqlservercentral.com/columnists/achigrik/lockinginsqlserver70.asp

Check your cluster log and the sqlserver-log regarding what is going on and where it fails.

with EM you'll have to script all and extra check-select script user-permissions and roles. It's not on by default and is to be found on the same tabpage where you...

<But I thought that the real reason for this thread was that the job got stuck?>

No, that reason is known (user32.dll cannot be initialized ... related to MS KB-article).

After upgrade...

Sets see : 1 instance with 1 db returns in 1 second.

1 instance wit 190db's takes way longer.

Your 1-190-instance has to manage 190 db's (with at least 2 files) and...

the delay is 0 because that's what the users want ! I know that can cause problems, but I'm not alowed to alter this to a more reasonable figure.

The reason...

Now there a litle bell ringing somewhere...

I didn't realize you were using linked tables from access to sqlserver. In that case, access usualy will try to solve the query by...

Sqlserver is an advanced database engine !

Access is one of the ancestors. If you want to optimize it you can try to apply the same guidelines you would use...