August 30, 2010 at 8:48 am
Some previous DB guy added the new UD Datype using sp_addtype,
he used that in one procedures , Bu i cant understand what dataype he used in that..
Please let me know how to check that dataype definitions
August 31, 2010 at 5:29 am
Try this:
SELECT s.name,s2.name,s.max_length
FROM sys.types s INNER JOIN sys.types s2 ON s.system_type_id = s2.system_type_id
WHERE s.user_type_id > 256
and s2.user_type_id <= 256 and s.name='urDataTypeName'
August 31, 2010 at 5:42 am
As from sql2005 you need to be granted the "view definition" to be able to see the actual ddl.
If you are the object owner you have this authority for this object.
If you are member of the db_owner database role, you have this authority for the database.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply