Click here to Skip to main content
15,867,986 members
Home / Discussions / Database
   

Database

 
QuestionRe: Need to drop a schema in which there are some objects exist Pin
CHill606-Aug-18 1:40
mveCHill606-Aug-18 1:40 
GeneralLegacy software: can't load MSJTER35.DLL Pin
Keith Sheppard227-Jul-18 23:26
Keith Sheppard227-Jul-18 23:26 
GeneralRe: Legacy software: can't load MSJTER35.DLL Pin
Victor Nijegorodov27-Jul-18 23:45
Victor Nijegorodov27-Jul-18 23:45 
GeneralRe: Legacy software: can't load MSJTER35.DLL Pin
Keith Sheppard22-Aug-18 1:23
Keith Sheppard22-Aug-18 1:23 
Questioninner join results Pin
Member 1386716325-Jul-18 18:12
Member 1386716325-Jul-18 18:12 
AnswerRe: inner join results Pin
Richard Deeming26-Jul-18 1:50
mveRichard Deeming26-Jul-18 1:50 
AnswerRe: inner join results Pin
Victor Nijegorodov26-Jul-18 1:54
Victor Nijegorodov26-Jul-18 1:54 
QuestionCreation of documentation automatically when creating or updating a stored procedure Pin
indian14323-Jul-18 13:49
indian14323-Jul-18 13:49 
hi All,

Is there any setting in SQL Server when I am creating a stored procedure, it can automatically generate documentation for me that who is creating who is updating, date time of creation and update etc instead me typing all that by myself. Just like in the below example.
/****************************************************************************************************/
/* NAME     : [Usp_Get_vvvvvvById]                                                                  /
/ PURPOSE  : THIS STORED PROCEDURE RETRIEVES LIST OF vvvvv codes   /
/ TABLES USED:                                                                                         /
/              [dbo].[xxxxxxxxxx]  , [dbo].[xxxxxxxxxxxxxxx]                   /
<h2>/ VERSION HISTORY:-                                                                                    */</h2>

<h2>/* VERSION NUMBER|  DATE        |   AUTHOR                  |   CHANGES                                 */</h2>

/* 1.0           |  10/18/2017  |   xxx             |   INITIAL VERSION                         */

<hr />


I want it can be generated automatically instead of me typing every-time, anybody can help me please, any help can be a great help - thanks in advance.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."
AnswerRe: Creation of documentation automatically when creating or updating a stored procedure Pin
Victor Nijegorodov24-Jul-18 10:12
Victor Nijegorodov24-Jul-18 10:12 
AnswerRe: Creation of documentation automatically when creating or updating a stored procedure Pin
jschell28-Jul-18 7:13
jschell28-Jul-18 7:13 
QuestionJob runs 3 times longer Pin
VK1920-Jul-18 7:12
VK1920-Jul-18 7:12 
AnswerRe: Job runs 3 times longer Pin
Victor Nijegorodov20-Jul-18 8:01
Victor Nijegorodov20-Jul-18 8:01 
AnswerRe: Job runs 3 times longer Pin
Eddy Vluggen28-Jul-18 0:16
professionalEddy Vluggen28-Jul-18 0:16 
GeneralRe: Job runs 3 times longer Pin
jschell28-Jul-18 7:14
jschell28-Jul-18 7:14 
GeneralRe: Job runs 3 times longer Pin
Eddy Vluggen28-Jul-18 10:23
professionalEddy Vluggen28-Jul-18 10:23 
GeneralRe: Job runs 3 times longer Pin
Herman<T>.Instance14-Aug-18 3:01
Herman<T>.Instance14-Aug-18 3:01 
GeneralRe: Job runs 3 times longer Pin
Eddy Vluggen14-Aug-18 3:08
professionalEddy Vluggen14-Aug-18 3:08 
AnswerRe: Job runs 3 times longer Pin
Mycroft Holmes28-Jul-18 14:14
professionalMycroft Holmes28-Jul-18 14:14 
Questionjoin query Pin
Member 1391987420-Jul-18 4:53
Member 1391987420-Jul-18 4:53 
GeneralRe: join query Pin
Richard MacCutchan20-Jul-18 5:13
mveRichard MacCutchan20-Jul-18 5:13 
AnswerRe: join query Pin
Victor Nijegorodov20-Jul-18 7:59
Victor Nijegorodov20-Jul-18 7:59 
AnswerRe: join query Pin
Mycroft Holmes20-Jul-18 12:58
professionalMycroft Holmes20-Jul-18 12:58 
QuestionProblem sending email to group Pin
Danpeking10-Jul-18 23:33
Danpeking10-Jul-18 23:33 
AnswerRe: Problem sending email to group Pin
jschell16-Jul-18 16:12
jschell16-Jul-18 16:12 
GeneralRe: Problem sending email to group Pin
Danpeking16-Jul-18 22:42
Danpeking16-Jul-18 22:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.