... but you're using CONTAINSTABLE and the poster is using FREETEXTTABLE. Aren't these two different things, or are you saying that Books Online is wrong and FREETEXTABLE does support variables?

Also, one little know tip for the Quick Launch menu, re-size the toolbar so that only the double arrows are visible, if you click the arrows a popup menu appears and you can...

What account are you running the SQL Services under?

Right-Click the stored proc and choose "Script To New Window as -> Create". Then you can edit the stored procedure and when you run it (F5), and it's re-created in the database.

Context...

Have a look at the Best Practices Analyzer over at Microsoft.

One of my most used command-line switches is -C. This loads a previously saved configuration file. Comes in very handy when you have a couple of people working on a...

"Actually, using a @variable does work "

In the context that the poster is trying to use it, no it doesn't.

Using CONTAINS ( because neither FREETEXTTABLE or CONTAINSTABLE support the use...

Please do not cross-post.

See my response here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=228157

Please do not cross-post.

See my response here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=228157

Take a look at these and choose the method that suits your purpose.

http://support.microsoft.com/default.aspx/kb/186133

http://databasejournal.com/features/mssql/article.php/10894_2244821_1

http://www.sqlteam.com/item.asp?ItemID=1491

http://vyaskn.tripod.com/programming_faq.htm#q17

http://www.aspfaq.com/show.asp?id=2427

ALTER PROCEDURE My_First_Transaction 
          @FirstName varchar (10 ) , 
          @LastName varchar (20 ) 
AS 
BEGIN TRANSACTION 
     INSERT INTO Employees( FirstName, LastName ) VALUES( @FirstName,@LastName ) 
     IF...

Check the syntax in Books Online,

"freetext_string

Is the text to search for in the specified column. Variables cannot be used. "

Peter

Can you edit your original post to remove the formatting. Just highlight the line and select "Normal" from the style drop-down.

I spend most of my stored procedure development time in Query Analyzer.

Haven't looked at the SQL Server 2005 Management/Development Studio much, but I've got a feeling they'll be a lot...

It does seem that the RETURN is not functioning as per Books Online ( wouldn't be the first time  )

"Although, oddly, the SELECT statements...