Comments
Sort by recent activity
Thank you all, your answers are very helpful, I will look into them. / comments
Thank you all, your answers are very helpful, I will look into them.
Thank you. Can I generate the doc with table and columns description field empty in a word document, and asked someone like business analyst to work on wording of the description of the table or column, then somehow load into the database, and regenerate the SQL doc? Thanks, / comments
Thank you.Can I generate the doc with table and columns description field empty in a word document, and asked someone like business analyst to work on wording of the description of the table or col...
Thanks, it was first not shown up in the programs panel right after I install, but now it shows up. Thanks, The reason is we only have a couple of licenses, but we have more developers, it limits our usage, and we currently use subversion and tortoise, which suit our needs. / comments
Thanks, it was first not shown up in the programs panel right after I install, but now it shows up. Thanks,The reason is we only have a couple of licenses, but we have more developers, it limits ou...
I found it.
It is actually hidden on the right corner tab, when I click a down error, it shows up. / comments
I found it.
It is actually hidden on the right corner tab, when I click a down error, it shows up.
Thanks, but even if I decrease the size, I don't think the trigger is affected.
It is just a trigger for update , delete.
Something like below:
I only increase the size of one column for example AccidentType
CREATE trigger [dbo].[Investigation_Trigger] on [dbo].[Investigation] for update, delete
as
set nocount on
insert Investigation (
LogDate,
LogNbr,
WorkgroupId,
CarrierId,
ControlNbr,
SchoolId,
SchoolYear,
StudentId,
InvestigationStatusId,
AccidentType,
CreateDate,
CreatedBy,
ChangeDate,
ChangedBy)
select LogDate,
LogNbr,
WorkgroupId,
CarrierId,
ControlNbr,
SchoolId,
SchoolYear,
StudentId,
InvestigationStatusId,
AccidentType
CreateDate,
CreatedBy,
ChangeDate,
ChangedBy
from deleted
GO / comments
Thanks, but even if I decrease the size, I don't think the trigger is affected.
It is just a trigger for update , delete.
Something like below:
I only increase the size of one column for example Ac...
But I only change the length of the column.
I didn't see why there is a need to refresh the trigger.
So is this a bug of SQL compare? / comments
But I only change the length of the column.
I didn't see why there is a need to refresh the trigger.
So is this a bug of SQL compare?
The error is something like cannot insert ....
I think my message is clear enough to show you what is the problem. / comments
The error is something like cannot insert ....
I think my message is clear enough to show you what is the problem.
Thank you, that's exactly what I want, I tried it works.
What's the difference using Sql server manamgent studio- generate script,
and Redgate, for this purpose to create a schema for exsiting database. / comments
Thank you, that's exactly what I want, I tried it works.
What's the difference using Sql server manamgent studio- generate script,
and Redgate, for this purpose to create a schema for exsiting data...
Thanks, that is helpful / comments
Thanks, that is helpful