Comments
Sort by recent activity
I agree, this would be a useful feature as we want to maintain the documentation on "documentation" databases in a development area - not necessarily in the live database. So to be able to generate a script of the properties created by SQLDoc would be useful.
Or do you know another way of quickly scripting the extended properties only in a database (I tried playing with the SSMS script options, but this didn't seem to be possible)
If I find a usable alternative method I will post the results here.
Thanks
Alex / comments
I agree, this would be a useful feature as we want to maintain the documentation on "documentation" databases in a development area - not necessarily in the live database. So to be able to genera...
:idea:
If you used and supplied intermediate XML files and customisable XSLT files to generate the HTML files (and hpp and index files) - then the more experimental among us could play with :
a) custom properties
b) custom html files and
c) custom contents tree (maybe I want my tables to be grouped by schema?)
That would allow me to tick all the boxes for what I want from a SQL DB Documentation tool.
Otherwise a fantastic simple-to-use tool.
Make it so - please?!? [image] / comments
:idea:
If you used and supplied intermediate XML files and customisable XSLT files to generate the HTML files (and hpp and index files) - then the more experimental among us could play with :
a) cu...
I would be interested in trying out RC version of 6.2 of SQL Compare 6. We use VSS and follow the model that DBGhost has promoted of different sub-projects for different object types (as we currently use DBGhost).
Please could you let me know when a RC would be available.
Thanks
Alex / comments
I would be interested in trying out RC version of 6.2 of SQL Compare 6. We use VSS and follow the model that DBGhost has promoted of different sub-projects for different object types (as we current...
I think that the lack of posts since the expiry period passed demonstrates that setting a 2 week expiry time was a bit restrictive. It means that you are no longer getting feedback! :-(
I'll be PMing to ask for an extension.
Thanks,
Alex Weatherall
TeleWare.com / comments
I think that the lack of posts since the expiry period passed demonstrates that setting a 2 week expiry time was a bit restrictive. It means that you are no longer getting feedback! :-(
I'll be PMi...
You are stars, that's cheered me up after one of those days :-)
Alex / comments
You are stars, that's cheered me up after one of those days :-)
Alex
Thanks Neil,
Microsoft are unlikely to fix the bug (see previous post), they said, but I was wondering if there was anything you might be able to do to work it out.
I've noticed that the status column in sysobjects does have the 30th bit set with the SET ANSI_NULLS ON option on which seems to be the important one for use with indexed views, but OBJECTPROPERTY function doesn't report it.
If nothing can be done with it, so be it, it's MS's fault, but it's really frustrating not to be able to rely on SQL Compare to migrate with these functions with the correct set options.
Thanks
Alex Weatherall / comments
Thanks Neil,
Microsoft are unlikely to fix the bug (see previous post), they said, but I was wondering if there was anything you might be able to do to work it out.
I've noticed that the status col...
I take it that's a no then :-( / comments
I take it that's a no then :-(
Hi Brian,
No, its a bug in the way it reports the Quoted Identifier and ansi nulls options.
f I create a table-valued function (note this is SQL Server 2000) with the QUOTED_IDENTIFIER and ANSI_NULLS options both set to ON e.g. SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE FUNCTION dbo.tfn_Test()
RETURNS TABLE
AS
RETURN (SELECT 1 AS test)
GO
Then when Scripting this function out again (or using external tools to analyse it - SQL Compare for example), it is scripted as SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE FUNCTION dbo.tfn_Test()
RETURNS TABLE
AS
RETURN (SELECT 1 AS test)
GO
It appears to run OK with the original settings, but obviously this script is incorrect.
And if I run this script against my database :
SELECT Name,
Type,
OBJECTPROPERTY(id, 'ExecIsQuotedIdentOn') IsQuotedIdentOn,
OBJECTPROPERTY(id, 'ExecIsAnsiNullsOn') IsAnsiNullsOn
FROM sysobjects
WHERE type IN ('FN','IF','TF')
Then I get NULLs back for the ObjectProperty statements when the type is TF. The other function types return 1 or 0 as expected.
This also means that I can't edit this Table Functions in SQL Server Management Studio as it returns an error, because it can't get at these options.
I've put this on the Microsoft SQL Server forum, but not got a reply yet.
Thanks
Alex Weatherall
TeleWare.com / comments
Hi Brian,
No, its a bug in the way it reports the Quoted Identifier and ansi nulls options.
f I create a table-valued function (note this is SQL Server 2000) with the QUOTED_IDENTIFIER and ANSI_NUL...
I was just wondering whether anyone at Red-gate has been able to reproduce this problem.
It's an issue for us when using the product as we have functions that access indexed views which require both these options to be set on.
When we synchronise any changes to these functions, the set options are lost, so we have to follow a manual process.
Please let me know if you can reproduce the problem.
Please also see bugs (FDBK47725) and (FDBK48533) in http://lab.msdn.microsoft.com/productfeedback/
One is my bug submission, but the other is a related bug in SQL Server 2005 with Multi-Statment table valued functions.
Thanks
Alex Weatherall
TeleWare.com / comments
I was just wondering whether anyone at Red-gate has been able to reproduce this problem.
It's an issue for us when using the product as we have functions that access indexed views which require bot...
Just wondering if there might be a response to this? ;-) / comments
Just wondering if there might be a response to this? ;-)