correct.

Should be :

CREATE VIEW v_selectarticle

AS

SELECT TOP 100 PERCENT article_id, headline FROM ARTICLES

ORDER BY article_id desc

This is a long shot, but maybe you could download a trial copy of erwin(CA) or another dbcompare-tool, reverse engineer your scripted db and compare it to a reverse engineered...

If you no longer want the jobownership-burden to be able to start a job, create an alert which you let start the job. So when you want to start your...

IMO this is not supported for sqlserver.

(unlike DB2)

What you could do is alter the clusterd index of those partitioned-view-parts to 100% fill and rebuild it. Keep in mind to put...

I think I've read this in a server-migration descussion/whitepaper.

There is a update sysjobs script which puts the new servername in the "originatingserver"column.

If I'm correct all it took was just a...

FYI: The replies counter in forums is not correct. It goes from 0 to 2.

Is there a way to Unsubscribe from a topic notification ?

maybe this helps :

select o.name

, c.text

FROM dbo.sysobjects O

inner join dbo.syscomments C

on O.id = C.id

and O.xtype = 'V'

where C.text like '%CREATE VIEW %'

when opening a page I already start scrolling down before it is complete.

When it completes, it scrolls to top.

Can you avoid that?

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.