strange... what happens if you create a dummy db just now?

It's quite easy to do, but I'm not sure of what you want to do.

Can you post the table definition, some sample data and what you want the select statement...

Please do not cross post, we monitor all the boards.

Finish this thread HERE

"We pretty much ran out of ideas on this tool so to kill time decided to convert it to C#"

hehe... wish I had this luxury

Can we see the insert statement??

Text field or varchar() field???

UPDATE on_line_tutorial_menu_level2

SET menu_lvl2_item = 'Bob''s Hobbies'

WHERE ...

It's not true...

I didn't comment this post today : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=189223

I've built up a documentation tool that does the basic stuff you're doing with your software. The neat thing about it is that I'm able to check both on...

Would work nicely... but the same problem remains : untill we know why he wants to do this, we're simply guessing solutions.

That doesn't answer my questions .

Can you post the code of the sp??

Also you might have to take a look at parameter sniffing, and today's article : Real World Query Plans

Because you didn't know... you assumed.

Now you know .

Run this in query analyser :

Select 'exec sp_changeObjectOwner [' + O.Name + '], [dbo]' as ExecSQL from dbo.SysObjects O where O.XType = 'U' and UID 1 order by...

I said NOT FOR NOVICES.... it took me a fews hours of playing with many different variations to make it work (with the udf problem). It's really not the...

Maybe, but untill he tells us why he wants to do that, it's hard to help him.