What is the maximum length of an extended property?



What is the maximum length of an extended property?..

Answer / Vidhi Chauhan

The maximum length of an extended property in SQL Server varies depending on the system. For user-defined properties, it can be up to 512 characters. However, some system properties have a limited size.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Development Interview Questions

What is a database development?

1 Answers  


Write short notes on XSU and JAVA

1 Answers  


what is the use of foreginkey

2 Answers  


1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? <?xml version="1.0"?> <breakfast_menu> <food> <name>Belgian Waffles</name> <price>$5.95</price> <description> two of our famous Belgian Waffles with plenty of real maple syrup </description> <calories>650</calories> </food> <food> <name>Strawberry Belgian Waffles</name> <price>$7.95</price> <description> light Belgian waffles covered with strawberries and whipped cream </description> <calories>900</calories> </food> <food> <name>Berry-Berry Belgian Waffles</name> <price>$8.95</price> <description> light Belgian waffles covered with an assortment of fresh berries and whipped cream </description> <calories>900</calories> </food> <food> <name>French Toast</name> <price>$4.50</price> <description> thick slices made from our homemade sourdough bread </description> <calories>600</calories> </food> <food> <name>Homestyle Breakfast</name> <price>$6.95</price> <description> two eggs, bacon or sausage, toast, and our ever-popular hash browns </description> <calories>950</calories> </food> </breakfast_menu>

1 Answers  


Write short notes on manual refreshes.

1 Answers  


Where is dbms used?

1 Answers  


How can you log an error to the server event log from a stored procedure?

1 Answers  


Explain the general syntax for a SELECT statements covering all the options.

3 Answers  


Explain the process of the user request and data generating?

1 Answers  


To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

1 Answers  


Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

1 Answers  


What is data modeling with example?

1 Answers  


Categories