I'm trying to set a computed column involving a custom clr datatype to
persisted and getting this error:
Computed column 'ft' in table 'test1' cannot be persisted because the column
is non-deterministic

Hello, how do I generate a schema of a database in sql server 2005? I want to
see a graphic representation of all the table and fields, what the primary
keys are, relathionships, and so forth.
thanks

This is a follow on from my last post about putting a CLR function/procedure
into SQL Server when it takes a UDT as a parameter. To recap,
I have a function (MyFunc) in a .NET assembly (MyAssembly) in a class
(MyClass). The function takes a single parameter @MyParam, of type ...

How to genericaly search the entire db for any text string in any stored
procedure, function, table definition, agent job, etc. Any one command or
anyone have a stored proc that does this wide search?

how to find out if a TSQL table is being updated?
for example if someone does an update to a table that takes a long time, is
there anyway for me to check the status of that update process?