155 reputation
17
bio website cja.org.uk
location
age
visits member for 1 year, 10 months
seen Jun 24 at 12:51

Aug
8
awarded  Popular Question
Jun
24
awarded  Notable Question
Oct
25
awarded  Popular Question
Sep
16
awarded  Supporter
Feb
22
awarded  Commentator
Feb
22
comment How to include the value of the query parameter in the email body using sp_send_dbmail
I've not tried but I don't think it will cos my query is a stored procedure and it outputs via a select statement.
Feb
22
accepted How to include the value of the query parameter in the email body using sp_send_dbmail
Feb
22
comment How to include the value of the query parameter in the email body using sp_send_dbmail
Please can you give me an example? I'll accept it as the answer.
Feb
22
asked How to include the value of the query parameter in the email body using sp_send_dbmail
Jan
30
revised How to keep history of SQL Server stored procedure revisions
wrong url
Jan
25
comment How to keep history of SQL Server stored procedure revisions
I'm new here and people don't want to spend extra time using source control for stored procedures. There's no reason why SQL Server and its tools can't make it a lot easier.
Jan
25
comment How to keep history of SQL Server stored procedure revisions
Auditing is good. Version control is outside the scope of this question.
Jan
25
awarded  Scholar
Jan
25
comment How to keep history of SQL Server stored procedure revisions
Thank you. Accepting as answer pending testing.
Jan
25
accepted How to keep history of SQL Server stored procedure revisions
Jan
25
awarded  Student
Jan
25
comment How to keep history of SQL Server stored procedure revisions
@a_horse_with_no_name I like making things easy for people and to save them when they make mistakes, even if they are programmers.
Jan
25
comment How to keep history of SQL Server stored procedure revisions
This looks promising, although I have to implement it myself. stackoverflow.com/questions/10820024/…
Jan
25
comment How to keep history of SQL Server stored procedure revisions
I want a multilayered defence against losing important stuff.
Jan
25
awarded  Editor