Table - Column - Enterprise Mgr. Descriptions

Apr 22, 2004

I wrote this quick SQL for project documentation purposes.

/*
Provides Table Name, Column Name, Extended Description
*/
select
a.name as tbl_name,
b.name as column_name,
d.name as data_type,
d.length as length,
d.xprec as prec,
d.scale as scale,
b.usertype,
b.scale,
c.value
from sysobjects as a
inner join
syscolumns as b
on a.id = b.id
inner join
sysproperties as c
on b.colid = c.smallid and a.id = c.id
inner join
systypes as d
on b.xtype = d.xtype

View 7 Replies


ADVERTISEMENT

Exporting Table And Column Descriptions From Database To Cube

May 22, 2008



Can somebody tell me how to transfer table and column descriptions from SQL 2005 database to dimensions and attributes in Analysis Services?

Thanks!

View 2 Replies View Related

Column Descriptions

Jun 21, 2001

How do you give a column a description in SQL.
I have a project where the table will created with SQL using the legacy database systems 6 byte field names.
the old system (DB2/400) has field(column) descriptions that I would like to move over but how?

I know I could create a view over the table and use the more descriptive field names.. but I would like for them to be in the same table..

like
emhrdt - column name (for reference to the legacy systems source code)
Employee Hire Date - column descriptions (so programmers for the new system know what it means).

View 1 Replies View Related

Column Descriptions

May 10, 2007

Is there a way to get a list column names and their descriptions?

View 6 Replies View Related

How To Display Column Descriptions?

Sep 18, 2004

Hello!

I am wracking my brain, trying to figure out how to return & display a column's description.

I work in Cold Fusion with SQL 2000 database.

My table name is "clients" and the column in question is "client_firstname"

The description of this column, as entered in Ent. Mgr, is "First Name"

If anyone can please help me, it would be very greatly appreciated!

Thanks!

Now for the details...

I am trying this:

----------------------------------------------------------------
<cfquery name="get_ext2" datasource="#application.dsn#">
SELECT
objname As 'Column'
, value As 'Description'
FROM
::fn_listextendedproperty
('MS_Description', 'user', 'dbo', 'table','client', 'client_firstname', default)
</cfquery>

<cfoutput>
"#get_ext2.Column#"
"#get_ext2.Description#"
</cfoutput>
----------------------------------------------------------------

... and it is returning this:

"" ""

In my debug output, the query result appears as such:

----------------------------------------------------------------
get_ext2 (Records=0, Time=16ms)
SQL =
SELECT
objname As 'Column'
, value As 'Description'
FROM
::fn_listextendedproperty
('MS_Description', 'user', 'dbo', 'table','client', 'client_firstname', default)
----------------------------------------------------------------

Haaalp!

Thanks....

Richard

View 1 Replies View Related

Export Column Descriptions

Jul 24, 2007

I am trying to export a table from SQL Server 2000 with the following columns:

TableName (the name of a table in the database)
FieldName (the name of a field in the table)
FieldDescription (the Description of the field)

The field descriptions are accessed in Enterprise Manager by right-clicking on a table and choosing Design Table, on the Columns tab - "Description".

Can this be done?
thanks

View 8 Replies View Related

Selecting Multiple Descriptions

Feb 28, 2006

I want to select multiple records based on descriptions that are the same. Descriptions is my column and I really want to find duplicate records based on the description column.

View 2 Replies View Related

Adding Descriptions To Database Objects

May 16, 2008

Is there an easy way to add descriptions or comments to database objects? So, for instance, I might have a table that a number of analysts are using, and I'd like an easy way to save comments or descriptive data about each of the columns in the table. That way, all consumers of the DB can easily look up the meaning of each column, table, stored procedure, etc. I could maintain all of this information in a system separate from my RDBMS, but I'm wondering if there are existing ways to do this already built into SQL Server. I've seen something similar to this built into Oracle systems.

Thanks!

View 2 Replies View Related

How Can I Create A Script To List All JobId And Job Descriptions

Oct 22, 2007

Hi Guys,
I just need a script to get all Job Id and Job Descriptions from Sql Server Agent/Jobs and then save it into a text file.   I'm not sure how to accomplish this using Sql Server Management Objects(SMO).   Any sample scripts and/or stored procedures, etc. would be appreciated. 
Thanks for your help.
-W2528

View 6 Replies View Related

Analysis :: Add Descriptions To Attributes In Role Playing Dimensions

Jul 28, 2015

I have a requirement to set Description values for our cube dimensions and attributes. 

I've done this for regular dimensions but I cant seem to find a way for role playing dimensions. I can set the base dimension descriptions but not the 'clones'. Is this possible? 

View 2 Replies View Related

SQL Server 2012 :: Return Descriptions From Table2 In Same Format As Codes From Table1?

Apr 22, 2015

Table1 contains a CODES column which may store multiple codes separated by commas.

The descriptions for these codes are stored individually in a column in in Table2.

I would like to return the descriptions from Table2 in the same format as the codes from Table1.

Table1 Stores multiple codes per ID in a single column.

ID CODES
-- --------------
01 Code1,Code2,Code3

Table2 Stores the definitions for the codes in Table1

CODE DESCRIPTION
----- ---------------
Code1 Description1
Code2 Description2
Code3 Description3

The tables are what the tables are. Here is what I am trying to accomplish:

ID CODES DESCRIPTIONS
-- ----------------- --------------------------------------
01 Code1,etc Description1,Description2,Description3

I've found two different queries which return each code and associated description by ID in separate rows. Perhaps the next step is to aggregate from this?

View 7 Replies View Related

How Do I Enter NULL In A Table Cell In The Enterprise Manager UI For Table Data Entry?

Sep 9, 2005

I have a column defined as smalldatetime. Default length (4), and "allow NULLS" is checked.In the Enterprise Manager UI, when i enter data into that table row, if i just tab past that column, all is well, and the value is represented in the UI as <NULL>.The problem comes once i ever enter a date into that column.  Say i have entered a date (all is well), and now i want to remove that entry and go back to NULL (after the date value has been committed, different entry session, say).How is that done?It seems to me, once a date has ever been entered into that column, now, if i try to remove it, i get the error "The value you entered is not consistant with the data type or length of the column, or over grid buffer limit".  I have tried deleting the value, entering spaces, entering the string NULL or the string <NULL>; maybe some other tries as well, but none works, i always get that error message and am not allowed to proceed past that cell until i restore a date value to it.  I want to get back to <NULL>.Anybody know?Thank you.Tom

View 1 Replies View Related

High Value In The CPU Column (Enterprise Manager SP Activity)

Mar 22, 2002

Hi,

I could see number process is having high value in the CPU colun of the Enterprise Manager Sp Activity.

Even I took some of the process SQL and did an explain and found to be fine.

Could you tell me why it is having high CPU value and what is its effect in system performance.

Thanks
John Jayaseelan

View 4 Replies View Related

My DTS Package In Via Enterprise Manager Will Not Export Entire Column To A Text File

Nov 28, 2007

I have created a DTS package that pulls data from one column (varchar,600) in a table and exports it to a text file. The max length in this field is only 285 characters long, however, the end of one of the records is being truncated in the text file. Data is tab delimited in the table and is being exported that way.

Any tips would be greatly appreciated.

View 13 Replies View Related

How Can I Create A New Table With Its Column Named From Another Table's One Column Value By Using A Select Sentence?

Sep 27, 2006

For example,I have a table "authors" with a column "author_name",and it has three value "Anne Ringer,Ann Dull,Johnson White".Here I want to create a new table by using a select sentence,its columns come from the values of the column "author_name".

can you tell me how can I complete this with the SQL?

View 2 Replies View Related

A Table/column To Table/column Data Check (was Help Please, SQL Something Simple)

Sep 15, 2006

Hi all, I am not over familiar with SQL, I am a VB programmer, simply I need to achieve the following within Enterprise Manager.

I have 2 tables, different designs, different number of rows, I simply need to check whether the contents of a column in the first table is in a column in the second table, just simply a table/column to table/column data check for the same data content.

Easy Peasy for you guys, any help would be appreciated.

View 6 Replies View Related

Export SQL Table Using SQL Enterprise Manager

Apr 25, 2005

How do I export an sql table from a server db using SQL Enterprise Manager?
I have tried using Microsoft Web Data Administrator but it can't connect to the db.
The db that is live has all the data, but I don't have a copy locally (I accidently deleted it)...which is why i need to export it to an sql file.
Can someone please help me as I have exhausted my own knowledge.
Cheers

View 4 Replies View Related

Sql Enterprise Manager - Copy Table

Sep 2, 2003

Hi,

I can't work out how to easily copy a table through sql enterprise manager including all data structure and the data ... I tried exporting one table then importing it into another but it wont transfer any of the actual data. I don't feel like retyping all 6000 records and I need somehow duplicate this table ... any ideas ???????

Cheers

View 9 Replies View Related

How To Create Key Time Column And Key Column For A Case Table And A Nested Table For Time Series Algorithm?

Jun 18, 2007

Hi, all experts here,



Thanks for your kind attention.



I want to use time series algorithm to mine data from my case table and nested table. Case table is Date table, while nested table is the fact table. E.g, I want to predict the monthly sales amount for different region (I have region table related to the fact table), how can I achieve this?

Thanks a lot and I hope it is clear for your help and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,



View 6 Replies View Related

Questions On Key Column In Case Table And Key Time Column In Nested Table Using Time Series Algorithm

Jun 4, 2007

Hi, all experts here,



Thank you very much for your kind attention.



I am confused on key column of case table and key time column of nested table by using Time Series algorithm.

In my case, the case table structure is as below:

Territory key text (the ID is actually dimrisk_key, in this case, I use the name column binding to combine the Territory column of case table Dimrisks),

While the nested table structure is as below:

Cal_month key time (in this case, actually the ID is dimdate_key, again, I used name column bining property to bind the Cal_month to the ID)

So my question is, as the key column of case table has been set to be Territory, as a result, does the model training still cover all the cases (rows) based on the ID of the table?

Also, in the nested table, as the key time column has been set to Cal_month rather than Dimdate_key of the nested table, as a result, would the single series based on the cal_month?



Hope it is clear for your advices and help.

And I am looking forward to hearing from you shortly.



With best regards,



Yours sincerely,





View 1 Replies View Related

How Do I Copy A Table From SQL Server Enterprise V8 Into 2005.

Sep 17, 2007

Hello All,
I have a table in SQL Server Enterprise V8 that i  want copied in SQL Server Enterprise 2005.  I first  generated the script out of V8 and then i tried using the query function in 2005 to execute it.  It does does not work.  Do i have to complete re-recreate the table in 2005?
-Kagome 
 
 

View 3 Replies View Related

Enterprise Manager - Unable To Open A Table

Jul 26, 2001

After having installed my software at customer's I found out that it's impossible to open tables from Enteprise Manager (Query Designer error). I'm not sure it's because of my soft, but my clients are quite annoyed.
I have had this situation on my own server , and the only thing I could do was to reinstall the server.
Any other ideas? And what is the origin for this error?

Thanks in advance,

Asnate

View 2 Replies View Related

Cannot Open Table In SQL Server Enterprise Manager

Nov 6, 2000

When do right click on the table in SQL EM and select Open Table | Return all rows, get Error:
An unexpected error happened during this operation. [Query]- Query Designer encountered a query error: unspecified error.

It's happening on all tables, all databases, all protocols, all servers, on 2(!) of 3 installations of SQL EM. I can successfully run Select in Query Analyser against the same servers/dababases.

Today is the first day it started. I cannot recall anything particular I've done on Friday that can cause this.

Thanks

View 1 Replies View Related

Rows In Table Not Showing Up In Enterprise Manager

Nov 20, 2000

I have just installed SQL Server 7 on a server. Everything was installed fine without any errors. The only problem occurs when I use Enterprise Manager, I right click on a table in the Northwinds database to open table and return all rows. The form pops up and no rows appear. Nothing in the table form works. I can view the records from Query Analyzer, and can also view them through Enterprise Manager when using a workstation client. This problem only occurs at the server. Any thoughts.

View 1 Replies View Related

Cannot Open Table In SQL Server Enterprise Manager

Oct 24, 2005

I recently installed SQL 2000, runing on a Win2000 Server. If I try to use Enterprise Manager to open a table using the return rows command, I get the following error

"An unpected error happened during this operation"

Reinstalling the client Tools has not helped.


Any help would be appreciated.

View 3 Replies View Related

Grid Pane In The Table In Enterprise Manager

Jan 13, 2004

HI
When you right click open table to return all rows, click on the "Show/Hide Grid pane" icon . When you click on any row the first column called "Column" a dropdown shows all the filed names of that particular table.
This feature used to work fine untill recently wherein when I click on the column, I don't get to see all the filed names but now it just shows TableName.* i.e. all columns.
This is the case when I try to create a view in enterprise manager also. When you add a table to create a view, I cannot see all the filed names . I'm not sure what to do , to get the field names to appear? Is it some kind of setting in enterprise manager.
All the info would be appreciated.
Ta
N

View 2 Replies View Related

Upgrading SQL 2005 Enterprise Evaluation To Enterprise Full Not Supported On Win XP Professional

Jul 11, 2006

This may be a stupid question, but can someone from MS SQL Server Team kind enough to confirm it, please?

View 3 Replies View Related

Unspecified Error Opening Table(s) In Enterprise Manager

Sep 21, 2000

Greetings:
We have a database with approximately 15-20 tables. Last week, using Enterprise Manager, we were able to open any of these tables and return all rows. Yesterday, when we tried to do this, we got the following message:

An Unexpected Error happened during this operation.
[Query] - Query Designer encountered a Query Error: Unspecified Error

Can anyone tell me what might be causing this and how to fix it? Barring that, can anyone suggest some general steps I might take to possibly eliminate this problem without knowing the cause? Last, can you point me to a good resource for investigating problems of this kind, such as a knowledge base (other than Microsoft's TechNet)?

Many, many thanks.

View 1 Replies View Related

Enterprise Manager Cannot Display Table Records Or Run Query

Jul 23, 2005

I have a new installation of SQL Server 2000 Dev Edition on a Win2K3 Standard Edition Server that I used for development. I just set this machine up in th last week and installed all Win2K3 patches and then installed SQL2K and SP3a. I have a single named instance. I just noticed today that I cannot view table data or use the Query part of EM. When I right click a table and select Open Table->Return All Rows it gives me an error dialog "An unexpected error happened during this operation". While the EM is diplaying this dialog the EM screen looks like Internet Explorer and says "Action Canceled - You might not have permission to view this directory or page using the credentials you supplied." I believe that this is a EM issue as I cannot view table content on other remote server. ANy ideas? Might this be an IE security patch disallowing some connectivity ?--Frank--Message posted via http://www.sqlmonster.com

View 1 Replies View Related

Help: Table Name Displaying Twice In SQL Statement Inside SQL Server Enterprise Manager

Oct 16, 2005

For some reason whenever I look at the SQL statement of a particular table, the table name displays twice.For example,SELECT * FROM State StateEven when I execute this statement, it still returns the correct results.   It does this for all tables in this particular database.  I also check another database and thoses display the table names in the SQL statements correctly.  Does anyone know why the table name would display twice in a table inside of a particular database?

View 4 Replies View Related

How To Switch Off Automatic Blanking Of Table Views In Enterprise Manager ?

Aug 10, 2006

Hi Sqlserver experts,I use the SQL Server enterprise manager of MSSQL 2000 regularly.I'm often annoyed by the automatic blanking of the table views.If this happens then mostly with the hint :"The Results pane have been cleared to conserve server resources.To re-establish the result set, run query again."Is there any possibility to switch that blanking off ?Best regards,Daniel Wetzler

View 5 Replies View Related

TSQL - Using ALTER TABLE - ALTER COLUMN To Modify Column Type / Set Identity Column

Sep 7, 2007

Hi guys,
If I have a temporary table called #CTE
With the columns
[Account]
[Name]
[RowID Table Level]
[RowID Data Level]
and I need to change the column type for the columns:
[RowID Table Level]
[RowID Data Level]
to integer, and set the column [RowID Table Level] as Identity (index) starting from 1, incrementing 1 each time.
What will be the right syntax using SQL SERVER 2000?

I am trying to solve the question in the link below:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2093921&SiteID=1

Thanks in advance,
Aldo.

I have tried the code below, but getting syntax error...



ALTER TABLE #CTE
ALTER COLUMN
[RowID Table Level] INT IDENTITY(1,1),
[RowID Data Level] INT;


I have also tried:

ALTER TABLE #CTE
MODIFY
[RowID Table Level] INT IDENTITY(1,1),
[RowID Data Level] INT;







View 18 Replies View Related

ALTER TABLE DROP COLUMN LastUpdated Failed Because One Or More Objects Access This Column.

Mar 7, 2008

Hi I’m trying to alter a table and delete a column I get the following error. The object 'DF__Morningst__LastU__19EB91BA' is dependent on column 'LastUpdated'.
ALTER TABLE DROP COLUMN LastUpdated failed because one or more objects access this column. I tried deleting the concerned constraint. But the next time I get the same error with a different constraint name. I want to find out if I can dynamically check the constraint name and delete it and then drop the column. Can anyone help.IF EXISTS(SELECT 1FROM sysobjects,syscolumnsWHERE sysobjects.id = syscolumns.idAND sysobjects.name = TablenameAND syscolumns.name = column name)BEGIN EXECUTE ('ALTER TABLE tablename DROP CONSTRAINT DF__SecurityM__DsegL__08C105B8')EXECUTE ('ALTER TABLE tablenameDrop column columnname)ENDGO
 

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved