Duplicate data or objects?

I'm no expert on this topic, but reading from the books online, I can't see anything about the recovery model..

Check this topic in the books online : CREATE DATABASE

Maybe that'll...

Now you're forcing me to post......

GO

Create proc dbo.MyProc @menu_lvl2_id as int, @menu_lvl2_item as varchar(50)

AS

SET NOCOUNT ON

UPDATE on_line_tutorial_menu_level2

SET menu_lvl2_item = @menu_lvl2_item

WHERE menu_lvl2_id = @menu_lvl2_id

SET NOCOUNT OFF

GO

EXEC dbo.MyProc 2, 'test'

Select * from...

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 .