Solved

SQL 2005 database

Posted on 2008-10-23
3
155 Views
Last Modified: 2012-05-05
CAn someone please write a sql script that will generate field lenght on all user tables in SQL 2005
0
Comment
Question by:Abeokuta
  • 2
3 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22784942
what do you mean generate field lenght?
for which field?
you have that data in information_schema.columns
0
 

Accepted Solution

by:
Abeokuta earned 0 total points
ID: 22785097
i want to  convert some of my database table to unicode but the lenght of some of the fileds are 7500 ,but the maximun lenght for unicode is 4000 In sql 2005 , if i specify nvarchar max would that be able to accomdate unicode for that field
0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22785128
nvarchar(max) in sql server 2005 is able to accomodate up to 1,073,741,823 characters
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Stored Procedure error 45 48
Sql Permission 6 53
SQL 2005 - Memory Table Column Names 11 69
Help with simplifying SQL 6 51
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now