Solved

SQL 2005 database

Posted on 2008-10-23
3
157 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

809 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