→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎03-24-2010 10:51 AM
‎04-12-2010 08:24 PM
‎04-05-2010 10:49 AM
‎04-06-2010 01:36 PM
Lansweeper wrote:
This looks correct.
How many computers are affected by this problem?
‎04-02-2010 10:24 PM
‎04-05-2010 08:15 AM
Lansweeper wrote:
Did you had a chance to test this?
‎03-27-2010 09:28 AM
Select clmns.name As Name, usrt.name As DataType, IsNull(baset.name,
N'') As SystemType, Cast(Case
When baset.name In (N'nchar', N'nvarchar') And clmns.max_length <>
-1 Then clmns.max_length / 2 Else clmns.max_length
End As int) As Length, Cast(clmns.precision As int) As NumericPrecision
From sys.tables As tbl Inner Join
sys.all_columns As clmns On clmns.object_id = tbl.object_id Left Outer Join
sys.types As usrt On usrt.user_type_id = clmns.user_type_id Left Outer Join
sys.types As baset On baset.user_type_id = clmns.system_type_id And
baset.user_type_id = baset.system_type_id
Where tbl.name = 'tblerrors' And Schema_Name(tbl.schema_id) = N'dbo'
Order By clmns.column_id
‎03-26-2010 12:13 PM
‎03-26-2010 02:41 PM
‎03-26-2010 10:01 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now