SqlDbx
You are not logged in.
In this exemple the comment of p_test is not saved.
IF OBJECT_ID ('dbo.p_test') IS NOT NULL
DROP PROCEDURE dbo.p_test
GO
/*
Test Comment
*/
CREATE PROCEDURE p_test
AS
select 1
GO
Put your comment inside the procedure (view, function, ...). SqlDbx can do nothing for you, it's a server feature !
CREATE PROCEDURE p_test
AS
BEGIN
/*
Test Comment
*/
select 1
END
go
Offline
Sorry I'm french.
But the Query Analyzer of sql server can do that.
In SqlDbx => when "SCRIPT CREATE" the procedure I see the comment but it is not saved when i execute.
SqlDbx does not send comments to Server if they placed before
CREATE PROCEDURE statement. This is by design
Offline
There's a way to see what SqlDbx will send to the database server.
Put cursor before comment and press Ctrl+B. The
highlighted text is what will be send to the server.
Offline
I agree. Thank you for the information.
And thank you for this very good software.