Viewing 5 posts - 196 through 201 (of 201 total)
Two questions:
1) Have you considered using Common Table Expressions?
2) Why would you need to store calculated values?
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
October 17, 2007 at 4:11 am
Using your favourite XML/XML Schema editor you should design an appropriate XML Schema and then import it into your database as an XML SCHEMA COLLECTION.
You can then reference the schema...
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
October 17, 2007 at 4:07 am
So the CREATE USER event was simply a distraction? Tricky, tricky, tricky... ![]()
Anyway, you must agree that the CREATE USER event can only have...
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
October 11, 2006 at 1:29 am
From Books Online:
"Returns the current value of the TEXTSIZE option of the SET statement. This specifies the maximum length, in bytes, of varchar(max), nvarchar(max), varbinary(max), text, or image data that...
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
September 11, 2006 at 3:27 am
The EXTERNAL_ACCESS privilege must be granted to a database user that maps to a WindowsNT user. Usually, this is the SQL Service account.
This, of course, may be a security risk => consult...
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
July 5, 2006 at 9:22 am
Viewing 5 posts - 196 through 201 (of 201 total)