SQL Server Management Studio Express CTP is a freely downloadable utility
(http://www.microsoft.com/downloads/d...82afbd59-57a4-
455e-a2d6-1d4c98d40f6e&di splaylang=en)
something like but not as extensive as MS-SQL Enterprise Manager.
Im am posting about this because:
I have not seen its use mentioned a lot here.
Some capabilities of Access 2003 (and prior) ADP MS-SQL interfaces fail for
SQL Studio Express; other capabilites of SQL Studio Express are not seen at
all in these interfaces.
Perhaps this information will be helpful for someone who is currently
unaware of its existence.
I find it ti be very powerful. An example is a rule for a column.
CurrentProject. Connection.Exec ute "CREATE RULE no_ZLS_rule AS LEN
(@ApplyColumn) > 0"
CurrentProject. Connection.Exec ute "EXEC sp_bindrule 'no_ZLS_rule',
'[4060148Accounts].CommonName'"
This simply prevents a zls from being inserted into a column. This can
occur even when nulls are not allowed, and has happened to me when an ASP
page is refreshed.
I have not previously been able to find an interface for SQL Server Studio
Express that shows me rules for columns and have had to resort to T-SQL to
examine the Rule "property".
In SQL Server Management Studio Express the Rule is clearly shown in Column
Properties.
I expect there are other ways of finding this way. I am pointing out that I
find SQL Server Management Studio Express CTP to be a convenient and
helpful utility.
Of course, the Rule thing is only a tiny part of its capability.
--
Lyle Fairfield
(http://www.microsoft.com/downloads/d...82afbd59-57a4-
455e-a2d6-1d4c98d40f6e&di splaylang=en)
something like but not as extensive as MS-SQL Enterprise Manager.
Im am posting about this because:
I have not seen its use mentioned a lot here.
Some capabilities of Access 2003 (and prior) ADP MS-SQL interfaces fail for
SQL Studio Express; other capabilites of SQL Studio Express are not seen at
all in these interfaces.
Perhaps this information will be helpful for someone who is currently
unaware of its existence.
I find it ti be very powerful. An example is a rule for a column.
CurrentProject. Connection.Exec ute "CREATE RULE no_ZLS_rule AS LEN
(@ApplyColumn) > 0"
CurrentProject. Connection.Exec ute "EXEC sp_bindrule 'no_ZLS_rule',
'[4060148Accounts].CommonName'"
This simply prevents a zls from being inserted into a column. This can
occur even when nulls are not allowed, and has happened to me when an ASP
page is refreshed.
I have not previously been able to find an interface for SQL Server Studio
Express that shows me rules for columns and have had to resort to T-SQL to
examine the Rule "property".
In SQL Server Management Studio Express the Rule is clearly shown in Column
Properties.
I expect there are other ways of finding this way. I am pointing out that I
find SQL Server Management Studio Express CTP to be a convenient and
helpful utility.
Of course, the Rule thing is only a tiny part of its capability.
--
Lyle Fairfield