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...

Server details are,

- Dual 3Ghz, 2GB Ram, basic OS/Logs/Data raid setup.

- Windows 2003 SP1

- 3 x SQL Server 2000 SP4

- Reporting Services SP2

- IIS configurations are all setup as per default...

Actually, I just took a look at the counts for today and we're up over 1100 reports all rendered and distributed in about 20mins. So I'm pretty happy with the...