Previous Thread:   Trigger on views

1/21/2006 1:28:50 PM    Re: Name property of SqlUserDefinedType
"Leila" <Leilas@hotpop.com> wrote in  
  
news:#maMbvsHGHA.2300@TK2MSFTNGP15.phx.gbl:  
  
That statement is a bit misleading. The name property defines what name  
  
the UDT will be created as, in SQL Server, if created through the auto  
  
deployment features in VS.  
  
So, if you have set the Name property and subsequently deployed the type  
  
from within VS, you should see a type in the database with the same name  
  
as the property.  
  
Niels  
  
--  
  
**************************************************  
  
* Niels Berglund  
  
* http://staff.develop.com/nielsb  
  
* nielsb@no-spam.develop.com  
  
* "A First Look at SQL Server 2005 for Developers"  
  
* http://www.awprofessional.com/title/0321180593  
  
**************************************************



1/21/2006 10:37:52 PM    Re: Name property of SqlUserDefinedType
Have you deployed the UDT from IDE? The Name property defines SQL Server  
  
name of the type, which is used by IDE when deploying the type (i.e. when  
  
IDE prepares the CREATE TYPE statement).  
  
--  
  
Dejan Sarka, SQL Server MVP  
  
Mentor, www.SolidQualityLearning.com  
  
Anything written in this message represents solely the point of view of the  
  
sender.  
  
This message does not imply endorsement from Solid Quality Learning, and it  
  
does not represent the point of view of Solid Quality Learning or any other  
  
person, company or institution mentioned in this message

1/22/2006 12:15:32 AM    Name property of SqlUserDefinedType
Hi,  
  
MSDN describes that Name property of  
  
Microsoft.SqlServer.Server.SqlUserDefinedType is not used by SQL Server, but  
  
by VS.NET IDE. I have set a name for my UDT, how can I see its effect it  
  
VS.NET IDE?  
  
Thanks in advance,  
  
Leila