Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

SSIS Error Description

Hi I am running into a problem with getting error description from a OLEDB Destination. I have attached a script component to the Error output and am able to see the error description but this error description is very generic. In my case I have a DFT that inserts data into a table with many foreign key constraints. One of this FK is failing and I need to see that in the error description. Interestingly when you configure the Destination to fail component on error it gives a full description with the FK name that failed. But if you have redirect rows and get the error description using the script component (xxx = ComponentMetaData.GetErrorDescription(errorno)) then it only displays the following error "Data value violates Integrity Constraint". To find out the exact problem I have to run the profiler and then look for the errors. this approach although is fine when you are testing one DFT but we are in the process of migrating from our old system to SQL Server and will have 100's of DFT's.

I know SSIS is somehow able to get to this information because it is displayed when you configure to fail component option.



Please help!!!


Thanks in advance...


Jaspreet Baweja

View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error Accessing Windows Event Log

I am running dts in Sql Server 2005 management studio from Management, Legacy and data Transformation Services.
Once the dts has run, I get this error message "Error Source : Microsoft Data Transformation Services (DTS) Package  Error Description : Error accessing Windows Event Log."
Please help me
thanks in advance

View Replies !   View Related
SSIS Package Creation (No Description Found - Exception Thrown)


I Encounter  the following error when  i try to create the SSIS package using Csharp 2.0.


{"No description found"}

base {Microsoft.SqlServer.Dts.Runtime.DtsException}: {"No description found"}

and the error ID is "1073676268 ""


Below is the code used  for adding the connection to the connection manager


Microsoft.SqlServer.Dts.Runtime.Connections con = MainPackage.Connections;

objOLEDBConnection = con.Add("OLEDB");

objOLEDBConnection.Name = "Conn";

objOLEDBConnection.Description = "Conn";

objOLEDBConnection.ConnectionString = @"Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog = dct_700;Data Source = bp-dct-vdev01;";


I am getting the exception on the while adding the  OLEDB connection to the connection manager ( Code UnderLined)



I am making a Web Service call before the package creation to retrieve the configurations.If i replace the  web service call after the Package creation code it works successfully.Does the problem is because of the Web Service call?

Help is appreciated


Thanks in advance,


View Replies !   View Related
Getting Error Description
Hi all,
I need to get the error description from the SQL Server in a SP. For ex:

I have one insert statement which is inserting some values in a tabUserMaster table. If user tries to insert any duplicated row then following error is retruned [in Query analyzer].

Server: Msg 2601, Level 14, State 3, Procedure csp_ProvisionUser, Line 70
Cannot insert duplicate key row in object 'CoreUser' with unique index 'IDX_CoreUser_UserName'.
The statement has been terminated.

I want to trap this whole message in a variable. How to do this..... :(

View Replies !   View Related
Error Description
I want to club the ErrorDescription system variable property in OnError.

And I want to send this whole ErrorDescription variable on onTaskFailed.

Can you please suggest how to club this errordescription on OnError event 



View Replies !   View Related
On Error I Want To Send Error Description As Mail
I have create a SSIS package, for data export import process, but if my task get failed then i have to send a mail with proper error description as the SSIS generate in output window.

Can any one sugget me to, how can i store that error desciption in my variable.?

Thanks in advance.

View Replies !   View Related
Number / Description Of Sql Error
HiAll Sql Server errors have a number. Is there any MS or MSDN website or any .net method in which I can see these errors?Thanks a lotswitch (error.Number){case 17:msgErro =....break;case 4060:msgErro = ....break;case 18456:msgErro = .....break;default:msgErro = exSql.Message;break;}

View Replies !   View Related
SQL 17055 Error And 17122 Description
Hello !

I have this problem :

EVENT ID: 17055
17122 :
initdata: Warning: Could not set working set size to 519104 KB.

I have 1gb of memory.
In the SQL server properties, I configure my memory with 512Kb not in dynamic but with determinated memory !
I reserve 1024 for SQL request physical memory.

Do you have any suggestions to resolve it ?
My server reboot 3 times per day !!!!

Thanks so lot !


View Replies !   View Related
Error Description: Timeout Expired
i am using sql server 2000. and have a DTS with script in it. now the script if failing saying timeout expired.
The script has db connection and calls stored procedure to fetch data. The records are around 63K but its failing due to timeout expired.

is there a way to increase the timeout in script. i dont want to do any changes to sql server settings.

View Replies !   View Related
How Can I Get The Error Description In SQL Execute Task
I put a  SQL Execute Task on Control Flow TAB as error hanlde of data flow task.

In this SQL Execute Task I want to insert error description into a table.

how can I get the Error description in SQL Execute Task when data flow task failed.





View Replies !   View Related
Passing Error Description To Failure Task In DTS
In my DTS package, is there any way to pass the task name and error description to another task that gets called on the task's failure?

View Replies !   View Related
Capture Error Description In Stored Proc

I am executing a stored procedure. Once statement is raising error (No. 515). While executing the procedure it is showing the proper error description as below:
"Cannot insert the value NULL into column 'actual_activities', table 'NBS.dbo.JOB_MASTER'; column does not allow nulls. UPDATE fails."

But when I am trying to get the message from "MASTER.DBO.SYSMESSAGES" for the ERROR number = 515 I am getting the following message:
"Cannot insert the value NULL into column '%.*ls', table '%.*ls'; column does not allow nulls. %ls fails."

Can you please let me know how to get the actual message?

Thanks in advance.

Thanks & Regards,

View Replies !   View Related
How To Capture Detail Error Description Into Variable
Hi everybody, is anyway to capture error description into variable?

insert into tabMaster(col1) values(1)
select @@error

will produce output
Server: Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_TabMaster'. Cannot insert duplicate key in object 'TabMaster'.
The statement has been terminated.


(1 row(s) affected)

I want to capture " Violation of PRIMARY KEY constraint 'PK_TabMaster'. Cannot insert duplicate key in object 'TabMaster'."
and assign it to variable

BOL state:... All other parts of the error, such as its severity, state, and message text containing replacement strings such as object names, are returned only to the application in which they can be processed using the API error handling mechanisms

thank you

View Replies !   View Related
Copy Database Error: No Description Found
I'm trying to use the copy database wizard in sql server 2005, but I keep getting an error that says 'No description found.' I read a posting on another forum and someone said to remove the default associated objects for Logins so I unchecked everything except dbo owner and still got the same error. What would you recommend doing?


View Replies !   View Related
Records Erroring Out. Error Description --- &&> No Status Available
hi All,

In process of migrating a database we had developed a SSIS package that loads fairly straight forward data. It was all working fine but now suddenly around 95 % of the data is getting errored out and all i get as a Error Description is that 'No Status is Available'. I know its pretty tough to ask wht can be the reason ? But can someone guide me onto what exactly I look for ? Has some one before got into such thing and did some resolution ?

Thanks in advance.

View Replies !   View Related
Retrieving The Error Description In SQL SERVER 2000
Hello All,
I am stuck at a place in SQL SERVER 2000.
I have created stored procedures and I am checking whether any error has occured on execution of the statements in that procedure.
If the @@Error <>0 then I need to log this error into my error logging table.
For this, I need to retrieve the error description given by SQL SERVER 2000.
I tried this using the master.dbo.sysmessages table. But I get a text from master.dbo.sysmessages which has the placeholders like %l, %s, etc.

I dont want this type of error. I want the exact error description which has the actual objects names and not the placeholders.
I found some help at this link :
But i want to know whether there is any other way of doing this or not.
Kapadia Shalin P.

View Replies !   View Related
Can't Save Package To Server (No Description Found) ERROR - Again
Hello, I need some help with installing release copies of SQL05(+SSIS) and VS05 on Win03R2.  It is very frustrating when a basic install fails. I€™ve been going round and round with this.  M$ support has not been of help yet.

I have a new development box for SQL05/VS05 development, and when I do a clean install of release software from MSDN: Windows Server 2003 R2 ent; SQL Server 2005 dev; Visual Studio 2005 pro I find that the "save to server" in SSIS (and other utilities that save a package) fails with a non-informative message *No Description Found* (see error text below).

To setup this box I install Win03R2 first, promote it to a Active Directory DC (the one and only DC in a test forest), then install VS05 onto the E: drive.  Note, I must install VS05 first (before SQL05) so that all components get installed to the RAID5 *E:* drive.  If SQL05 is installed first then VS that comes with SQL gets installed on to C: (no way I see to get around this) then the full VS05 pro gets forced to install on the C: drive.

Then I install SQL05 (with everything including SSIS).  At this point every thing works fine, packages can be saved ok.

If I then install VS05 again so that all settings of VS05 are as expected of a standard VS05 install (not the SQL version) then the problem with saving packages arises.

If the error message was a little more informative, I might be able to track down the source of the problem.  Please help!  I have tried a bunch of things - creating credentials, proxies, using the most privileged accounts possible, etc.

Thanks, MikeC


Error from create SSIS package (save to server):

No description found (Microsoft Visual Studio)
Program Location: at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword) at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package) at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e)


Error from copy db wizard:

No description found (Copy Database Wizard)
Program Location: at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String
serverUserName, String serverPassword) at Microsoft.SqlServer.Management.CopyDatabaseWizard.PackageCreator.SavePackage()


View Replies !   View Related
Detailled Error Description In A Script Component (data Flow)

I'm pretty new in SSIS and i have some problems with error log. I want to get detailled error description in a script component of a dataflow. for the  moment I use thooses lines

        Row.ErrorDesc = ComponentMetaData.GetErrorDescription(Row.ErrorCode)

and for unique constraints on a sql table I have this error : The data value violates integrity constraints.

For the same error, if i use an event handler on error, i have more row and the first of them is more explicit (Variable System::ErrorDescription)

An OLE DB error has occurred. Error code: 0x80040E2F.
An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E2F  Description: "The statement has been terminated.".
An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E2F  Description: "Cannot insert duplicate key row in object 'dbo.dimDepot' with unique index 'IX_dimDepot'.".

Is that possible to have a so detailled error text in a script componnent of a data flow? If yes, How?
Or if i use error event how can authorize the dataflow go ahead even if there is error.

thanks for you help


View Replies !   View Related
How To Dynamically Enter Error Code And Description In A Pre-define Table?

I want to implement error handling my SSIS package. for this I am putting an execute SQL task for a container(which contains different interlinked tasks) in event handler.

Say my first task fails in this container.Immedaitely my sql task which inserts the error code and description should exceute in the event handler and populate my error table in OLAP database.

Any help will be great SSIS gurus.

Thanks in advance.



View Replies !   View Related
Could Not Load Package ... Because Of Error 0x80070005. Description: Access To The Path ... Is Denied.

Hi all,
I'm trying to let certain users execute an SSIS package through an SP in SQL.
I've set up a proxy account for xp_cmdshell that the other users will use to execute dtexec with, but i get this message:
Could not load package "File SystemCODA_Actuals" because of error 0x80070005.
Description: Access to the path 'C:Program FilesMicrosoft SQL Server90DTSPackagesCODA_Actuals.dtsx' is denied.
When i log onto the server with the proxy account, i can navigate to that folder and open the package.
When try to execute it from the command shell:
dtexec /DTS "File SystemCODA_Actuals" /Decrypt "password" /Reporting E /SET Package.Variables[User::JobId].Value;25'

i get the same message. How come? How do i fix this? I've read somewhere that i should grant read to the package store to that user , how do i do that? Can't find that option in the tools or manuals.
Thanks in advance,

View Replies !   View Related
Error Description Differs When Logged With Redirect Rows Compared With Debug Mode

Can any one please tell me how to get the complete error description for example when i dont Redirect Row for Error in OLEDB Source i get a detailed error message with column name as

[RCheck [385]] Error: There was an error with input column "CHECK_STATUS" (456) on input "OLE DB Destination Input" (398). The column status returned was: "The value could not be converted because of a potential loss of data.".

But when I set Redirect Row for error  and use the Script component to log them into a Table with ErrorDescription based on ErrorColumnID it only gives me this.

The data value cannot be converted for reasons other than sign mismatch or data overflow.  





View Replies !   View Related
An OLE DB Error Has Occurred - Description: &&"Class Not Registered&&"

I have a package the connection of which is defined in a config file. When the source is on SQLserver, the package executes fine but when i change the connection to Oracle then i am getting this error.


TITLE: Microsoft Visual Studio

Error at DMND_PROBS_EXTRACT [Connection manager "DLWSDV18.PM"]: An OLE DB error has occurred. Error code: 0x80040154.
An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".

Error at DMND_PROBS_EXTRACT [DEMANDPROBLEMDETAILS [1]]: The AcquireConnection method call to the connection manager "DLWSDV18.PM" failed with error code 0xC0202009.



Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)



Please let me know if theres any solutions.



View Replies !   View Related
Hresult: 0x80004005 Description: &&"Unspecified Error&&"

hello all
i m getting the following error while exporting an excel file in SSIS
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
is this a bug?
pls suggest a workaround.

View Replies !   View Related
Missing Error Message? &&"no Description Found&&"
Anyone know what causes this?

When trying to deploy a package using the deploy wizard, following error is received:
===================================Could not save the package "H:SSISRSlogRSExecutionLog_UpdateinDeploymentRSExecutionLog_Update.dtsx" to SQL Server "xxxxxxxxxxxxxxxxxxxxx".  (Package Installation Wizard)===================================No description found------------------------------Program Location:   at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)   at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames)   at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs)

View Replies !   View Related
&&"Microsoft JET Database Engine&&" Hresult: 0x80004005 Description: &&"Unspecified Error&&".
I have ran into the same problem ... Importing from Access into SQL 2005 using SSIS and get the error:

[Connection manager "SourceConnectionOLEDB"] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.  Source: "Microsoft JET Database Engine"  Hresult: 0x80004005  Description: "Unspecified error".

View Replies !   View Related
How To Get The Description ?
Hi,I have a SQL that is working fine:
SELECT DISTINCT T1.ATCkod FROM ATC_tot T1    JOIN ATC_tot T2 ON T2.ATCkod = T1.ATCkod and T2.Typ_lakemedel LIKE '%' + @Kod2 + '%'    JOIN ATC_tot T3 on T3.ATCkod = T1.ATCkod AND T3.Typ_lakemedel LIKE '%' + @Kod3 + '%'    WHERE T1.Typ_lakemedel = @KodNow I need to have a description together with the ATCkod, tablename ATC columnname ATCdesc. ATC_tot.ATCkod = ATC.ATCkod. I have tried Inner join without success. Any good suggestions ...?

View Replies !   View Related
How Can I Set Description Property By T-SQL ?
I would like to create table by T-SQLand need to specify DescriptionBut I can't find any sample to add Description property by T-SQL  Additionally, I also would like modify Description property by T-SQL. What can I do ?????  Please help me ...... 

View Replies !   View Related
Column Description
Hello, it seems I forgot how to do it,
I want to create a query to get the column description table, I mean get structure without data.
I remember it was select DESC or something like that, donno if im right!!!

View Replies !   View Related
Description Field

Getting an error on the following SQL. The field in question is the Description field which has * in the description. Not sure how I should have the SQL to solve this

UPDATE Taylors
SET Area=::Area::,Avail=::Avail::,Address=::Address::,Type=::Type::,Price=::Price::,Bedrooms=::Bedrooms::,HotProps=::HotProps::,Office=::Office::,Description=::Description::
WHERE RefNo =::RefNo::

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '* modern retirement flat * double bedroom * south lounge * fitted kitchen * good size bathroom * communal gardens * residence parking *'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

View Replies !   View Related
Get The Description Of A Column
Okay guys heres the senario.I have written a kick butt asp application that allows me to test sqlstatements and manage/display all my databases from the web but I havea feature I want to include that I can't figure out how. In EnterpriseManager, one of the column editable properties is the ColumnDescription. I can't find it in sql server itself. only in theEnterprise Manager. I need to access it using a sql statement so thatit will display in my table definiation view that I create in the aspapp.

View Replies !   View Related
Get Description In Table
i want get fields description in structure tables that i madetables.please help me for resolve this problem .thank you

View Replies !   View Related
Table Description
Hi All,In SQL Server how can I get the descriptions of tables in adatabase?From MSDN help I could find a way to get the description of columnsusing the following extended propertySELECT *FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table','Reports', 'column', default)ThanksRegardsSobhan

View Replies !   View Related
Syntax Description Help - *=
WHat does *= do in SQL syntax?

eg, SELECT * FROM Cars WHERE COLOR *= "Blue"


View Replies !   View Related
How Can I Add The Description To A Field
I am using SQL 2000 and i create a Table
The Table Structure like this
(ID int,
Name Varchar(16)

I want to add the Descrition of the 2 feilds
for ID .. i want to add 'Company ID'
for Name .. 'Company Name'

NOTE: I don't want to add using Enterprise Manager, i want to add using Query Analyzer
How can i add this

Thanks for your help.


View Replies !   View Related
Columns Description How To Use It On QA
how do you use columns description on QA? I want to type it in some description for my columns. I see this option on EM. Need to know how to do it on QA


View Replies !   View Related
Tables Description
I have hundreds of tables in my database.
Is there a way to get a list of them with a description
of their content (the procedure and the transaction they
are related to, the way columns are created)?

Thank you. Anna - Verona (Italy)

View Replies !   View Related
Retrieving Description From DTS
Hi, I try to retrieve information about  Package Stored in Meta Data Services .

I don't have any problem with those who are in stored in SQL SERVER but I'm not able to get thoses in Meta Dta Service Packages


Could you help me please?

View Replies !   View Related
ErrorCode Description

This is a request to the Microsoft SSIS staff.
I did a search for the keywords in the description and can already see a lot of people frustrated about this.
A lot of well designed integration packages will route error messages to an error table or file.
SSIS appends a couple of extra error columns called ErrorCode and ErrorColumn. At runtime, an extra
column is visible in the DataViewer called ErrorCode - Description.
The description is hardcoded into the dtsmsg.h file in the SDK folder of Sql Server.
This file is very hard to parse.
Can some from SSIS please post an XML or CSV file with all the error codes and descriptions for us to download please.
This will be such a big help in debugging.
Many Thanks.

Shailen Sukul
Software Architect/Developer/Consultant
(BSc | Mcts (Biztalk (IP))  | Mcpd | Mcts (Web, Win, Dist Apps) | Mcsd.NET | Mcsd | Mcad)
Ashlen Consulting Services Pty Ltd
MSN | Skype | GTalk Id: shailensukul
Ph:  +61 0421 277 812
Fax: +61 3 9011 9732
Linked In:

View Replies !   View Related
OLEDB Destination Error In SSIS Package Not Returning Error Column/desc
I have a SSIS package that reads data from a dump table, runs a custom script that takes date data and converts it to the correct format or nulls and formats amt fields to currency, then inserts it to a new table.  The new table redirects insert errors.  This process worked fine until about 3 weeks ago.  I am processing just under 6 million rows, with 460,000 or so insert errors that did give error column and code.

Now, I am getting 1.5 million errors. and nothing has changed, to my knowledge.  I receive the following information.

Error Code   -1071607685   Error Column   0   Error Desc   No status is available. 

The only thing I can find for the above error code is


To add to the confusion, I can not see any errors in the data written to the error table.  It appears that after a certain point is reached in the processing, everything, or most records, error out.

Any help is appreciated.



View Replies !   View Related
When I Use SSIS For Extract From OLAP Database, Then The Error Random Occurred,Error Code = 0x80040E05

 I have tired for this!

When I use SSIS for extract data from ssas, that means,I use mdx query.

then random error occured.


Hope some one can understand my poor English....


And the Error Info show below.


Code Snippet

Error: 0xC0202009 at Data Flow Task - For Individual User Tech Points, OLE DB Source 1 1 [31]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E05.
An OLE DB record is available.  Source: "Microsoft OLE DB Provider for Analysis Services 2005"  Hresult: 0x00000001  Description: "Error Code = 0x80040E05, External Code = 0x00000000:.".
Error: 0xC004701A at Data Flow Task - For Individual User Tech Points, DTS.Pipeline: component "OLE DB Source 1 1" (31) failed the pre-execute phase and returned error code 0xC0202009.


View Replies !   View Related
SSIS Error: The Connection Does Not Support Enlisting In Distributed Transaction. Error Code: 0x8000FFFF

Hi all,
can anyone tell me if an oleDb connection (provider is Jet 4.0 to Access database) can be enlisted in a Distributed Transaction?
The goal is to copy data from SqlServer to Access within a transaction.

View Replies !   View Related
Searching In Title And Description
hey guys, so i have my website, everything is ok, until i have to put in a title field, along side my description. so far i have this code which searches in the description, how can i make it so i can search in the title as well
SelectCommand="SELECT [Stock_ID], [cat_id], [description], [size],
[selling_price], [qty], [picture1] FROM [tbl_stock]
WHERE ([description] LIKE '%' + @description + '%')">
 Any help would be great

View Replies !   View Related
Item Description In Shorthand

If you browse to Amazon and drill down through categories until a paged
listing appears, you will see in each item of the listing that the
description rendered as Book Description, is a cutdown version of the
full description, with a ... and "Read More" hyperlink.  How is
this achieved programatically? I dont know if thre is an efficient way
in SQL Server to do this, or whether it would be easier to have a
ShortHand field and a Description field, both of which are teh full
description when shown in the Details page, but the ShortHand is the
field rendered in listings.  This seems like a simplistic solution
and I am thinking there may be programmatic means of doing the same -
has anybody got any experience in this area?



View Replies !   View Related
File / Table Description.
Newby question but can't find it myself.How can I get a file-description from a file / table ?eg. the decription must deliver the following info:Record nr.Field nr.FieldnameField descriptionData typeLenghtDecimalsetc....Can somebody please tell me what to do?ThanxMF

View Replies !   View Related
Systems Analyst - Job Description
Does anyone have a description of what is a System Analyst responsibility should involve. I was recently assigned the title and is no longer sure what my responsibility should entail. I asked mgmt for a description. Still waiting.


View Replies !   View Related
Accessing Description Field
On the Design Table screen for SQL 2000 there is a Description field along with the Default, Identity, etc. options. Once I put a description in there, is there a way to retrieve it through T-SQL?

Thank you!

View Replies !   View Related
Where Is The Column Description Stored?
In SQL 2000 I notice in table design they have a description field like access does. Where is this stored? We created a data dictionary for our db separate and I was wondering if there was a way that I could update the table that holds this.

View Replies !   View Related

I have a big problem with SQL server2000. I can't get COLUMN DESCRIPTION.
I will print DATADICTIONARY from a DB, I can get all elemnts (table name, columns name, datatype, precision, scale, FK, PK, default value..) I missed only DESCRIPTION. How I can get it????


View Replies !   View Related
Where Is &#34;description&#34; Col In Repository Metadata
I'm trying to create a Data Dictionary view from system table info like tablename, fieldname, datatype etc. I can find all that I need except for the "description" field which is displayed in Enterprise Manager/ Repository metadata pane.

How can I locate this field so I can reference it in a view? Isn't it stored in a system table? Master, model? Where is it?

Thank in advance,


View Replies !   View Related

Copyright © 2005-08, All rights reserved