?
Solved

SQL 2005 database

Posted on 2008-10-23
3
Medium Priority
?
168 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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

612 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