Just don't forget to qualify the original object !

sp_changeobjectowner [ @objname = ] 'original_owner.object' , [ @newowner = ] 'owner'

Could you attach the results of dbname..sp_helpdb dbname ? 

What version of Sybase and what EBF level are you at ?

Is the device that you need to remove a data...

Good points Joe, but I think that you are a bit too harsh, possibly bordering on acerbic.

Should I begin to laud you on your straight forward grammar and then close...

Out of curiosity, why didn't you try to 'tune' the queries that pukled the data from Oraqcle originally ? That point aside, I'd liek to optimize Mohammed's suggestions and also...

Installation of triggers to gather data for analysis on multpile servers on a Citrix farm ??? What kind of architecture is that ???

Their architecture is indicative of their design....

Great Steve !

I'll shoot you a message when I get back to work later in the day on the 2nd -- I have a production implementation first thing that day.

Yeah, they're a bunch of 'sick pups' ... gotta love 'em !

SLIM DOWN !!!

Ever since Office 95, the core functionality that I (and probably many                                       others) use on a daily basis has remained the same. There is just too much there....

I encounter this same issue about once every other week. It is a bit annoying. In the past the only timethat I have received it was when updateing IE (and...

A 'keeper' Steve - just forwarded it to the System Engineer group and things are roaring here right now !

Stephen, just wher is "ours" ???

If this is a business case study more information is definitely needed. Just a broad stroke of the pen for starters:

• Do you have a SAN ?
• Do you have multiple servers...

Silly me ... I only did SAN, COW ...

Please do not double post.

Good Day Colin - could you translate the acronym COW please (Iit would be  rather ridiculous to google it) ...