I am adding tables to a DB. I want to put table and column descriptions in as I go.
1. Is there a "Description" property for the table? I see in the column properties list a "description".
2. Once I have my descriptions all in, indexes set etc, is there a system stored procedure that I can run that will generate the data dictionay? (With a table description.)
Thanks
Hi
Can anyone point me in right direction as to how to prepare a DATA DICTIONARY for a
given databse ??.
And what is the usual format of preparing a data dictionary...Any help in this regard is
greatly appreciated.
Thanks
VENU
Hi
can anyone forward me the format to prepare a DATA DICTIONARY For a GIVEN DATABASE. It's Kind off very urgent
Thanks VENU
We have several SQL 6.5 data bases and a few Access Data Bases. We would like to build a data dictionary. Has anyone seen any 3rd party products which might help, or any ideas of how to manipulate the existing objects to do so?
View 1 Replies View RelatedHi
I need to document all the tables & the fields of it & the data type , the PK & FK keys & all that
Can anyone suggest the fastest method to get all the data , or some link on how the format should be
Please help
Is there any tool for data dictionary? Basically there are no
descriptions/comments to many of the columns (about 99%) in the database. Datawarehouse team does not know exactly what those columns are, where its used, how its used. No comments have been defined in the system tables. We would like to have a tool where SME's/Bussiness analysts enter the description for the columns in the production database. We have SQL Server databases, many oracle dbs, few sybase databases, ACCESS. Sometimes we might have to search for strings in the descriptions entered.
Hello,I am working on a project to reverse engineer requirements for adatabase. The database is sitting on a MS SQL Server. How would Iget a listing of all tables and columns within each table to helpcreate a data dictionary.I have developed a script in Oracle to do this, but I am just notfamiliar with MS SQL Server synthax.Thanks,Hitesh
View 6 Replies View RelatedI need to build a data dictionary for a SQL 7 DB that already exists that has over 16000 columns. What I really need is to add a comment to the table and column names.We use ERWin and have looked at the Microsoft Repository
but I would like a quick interface to create the descriptions which neither one of these have. I scripted out all the table and column objects into tables and built a simple Access Form to handle the updates. Now I need to
commite these updates to the Microsoft Repository. Has anyone seen or tried something like this?
THanks
I have a data dictionay table with these columns
field_name
field_type
field_size
nulls
#1
#2
#3
column1
char
20
y
1
0
1
column2
char
30
y
1
1
1
column3
int
5
n
0
1
1
How to create a table using the content of the dd table above as the structure of my new table?
cb
In SQL 2k5 every db object say table , table fields etc have extension properties . I plan to populate these extension properties with meta data related information like field description , string length , case conversion , field alignment , enum options etc .
I wish to know if anybody has done, anything like this . Can this properties be easily avaialble in .Net development , reporting services , BIDS etc . Can there be significant advantages wrt this .
I would like to get user experiences .
Hi ,all here,
Would please anyone here give me any guidance and advices for best practice of data dictionary in SQL Server 2005?
I have restored a large insurance claims database with up to more than 300 tables, massively, most of them are empty tables, many of them dont have any keys, contrains, indexes, and more difficult, there is no any data dictionary for the database which gets me stuck in the understanding of the data at the moment. Thus I think data dictionary is very important for a database.
Will anyone gives me advices for that? Really need help.
Thank you very much in advance for any help.
With best regards,
Yours sincerely,
Hi all
Does somebody know how to get the code of a stored procedure?
I would like to know the name of the view in the data dictionary
which holds the code of the functions or stored procedures ...
Thanks for any help
Best regards
Frank Uray
Hi,
I'm thinking of implementing a rudimentary Data Dictionary for a database using extended properties to store table and column descriptions.
Does having this information for every table and column in a database (200 tables; 2000 columns) cause any (negative) impact on database performance? I'm guessing it shouldn't but want to make sure before implementing this in the production environment.
Thanks,
Smitha
I'm developing a report which contains a number of matrixes which are ordered in a hierarchy which can be navigated using a document map. One of the matrixes contains a subreport containing a table which displays a description for the matrix and the corresponding document map label. This is working without problem already in the production environment.
Recently, after updating my machine with numerous updates and patches, this stopped functioning. I now receive the error message, "The given key was not present in the dictionary" when I run this subreport, either as part of the greater report or on its own.
I have seen the posting which recommends deleting the report.rdl.data files. This did not solve the issue.
The data and the dataset are both in sync. When I click the "Print layout" button when previewing the report in Visual Studio .Net 2005, I can view the data. This looks like a bug in the VS.NET 2005 report designer.
I am running SQL Server 2005 SP2.
Any help is appreciated.
Regards,
Bill Mueller
Is dictionary is faster r hashtable.not only which is going to take less memory
With regards
mahender
I need to sort my data more than just order it using Order by clause.
I need the, to appear so that they are sorted like in dictionary's order.
example: if I have 0.1 and 0.2 and 0.11
They need to be ordered into 0.1 then 0.11. then 2.0. etc.
I thought I could use Val() function but it wasn't a successful attempt. Anyone can help me please?
I'm using ColdFusion and this is one of the query :
<cfparam name="sort" default="goal_cd">
<cfquery name="GetTheme" datasource="#application.OUSDSN#">
Select goal.*,theme.*
From goal,Theme
Where goal_theme_id = theme_id
Order by #sort#
<cfif sort is "goal_cd">
Order by Val(#sort#) <--------------------- This doesn't work!!!
<cfelse>
Order by #sort#
</cfif>
</cfquery>
When I try to preview a SSRS report in VS 2005 I get the following error: "The given key was not present in the dictionary", however when I deploy the report and view it in the Report Manager all is fine. I have not been able to find any useful info in MSDN, what I can try?
View 8 Replies View RelatedHi there,
I have a search page that redirects to another page transfering the search terms in a querystring. In the page to display the search results I use SQL parameters to show the results. Everything runs fine until I do a page refresh or use paging to bring up another set of results.
Everytime I try to refresh/page etc. I get the following error:
Item has already been added. Key in dictionary: "@CityTown" Key being added: "@CityTown"
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Item has already been added. Key in dictionary: "@CityTown" Key being added: "@CityTown"
Source Error:
Line 20:
Line 21: 'Creates parameters for the WHERE statement taking the querystring contents from previous page
Line 22: dsPropertyListing.Parameters.Add("@CityTown", CityTown)
Line 23: dsPropertyListing.Parameters.Add("@Suburb", Suburb)
Line 24: dsPropertyListing.Parameters.Add("@Rooms", Rooms)
Source File: K:detailsdetailspropertylisting.aspx Line: 22
Stack Trace:
[ArgumentException: Item has already been added. Key in dictionary: "@CityTown" Key being added: "@CityTown"]
System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) +931
System.Collections.Hashtable.Add(Object key, Object value) +11
ASP.detailspropertylisting_aspx.Page_Load(Object sender, EventArgs e) in K:detailsdetailspropertylisting.aspx:22
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Control.OnLoad(EventArgs e) +55
System.Web.UI.Control.LoadRecursive() +27
System.Web.UI.Page.ProcessRequestMain() +731
Any sugestions that anyone could provide would be greatly appreciated. This error obviously renders the search features useless.
Thanks in anticipation,
TCM
I currently have a udf written in T-SQL that's getting way too logically complicated!
It€™s typically accessed like this:
SELECT PartNumber,dbo.PartPrice(Manufacturer, Model, AssemblageInfo, Version, CustomerDiscountLevel) FROM WorkOrders where OrderNumber=123456
The udf does some complicated manipulations on the parameters and eventually does a SELECT on a lookup table and returns the result.
If I make this a managed code udf, the logic gets much simpler to write (great!).
But, my question is:
Can I take the lookup table and embed it in the udf--so the udf doesn't have to go to the database to do the lookup?
Would I do that in a STATIC dictionary<>?
Is it wise to keep the info statically?
The lookup table consists of 3600(+/-) elements and changes exactly once a month.
The SELECT statement using the udf typically returns several thousand rows.
The SELECT is done often.
--Mark
We are working on implementing DAX formula(s) on our tabular model (SSAS 2012). When we tried to deploy the solution, deployment wizard giving us then below error:The given key was not present in the dictionary...I checked all the formula(s) that we recently implemented and all looks fine.
View 4 Replies View RelatedHiI'm having problems following the tutorial on creating a data access layer - http://www.asp.net/learn/dataaccess/tutorial01cs.aspx?tabid=63 - when I try to compile in Visual Studio 2005 I get namespace could not be found. I followed exactly the tutorial - I created a dataset and added this code in my aspx page. <asp:GridView ID="GridView1" runat="server" CssClass="DataWebControlStyle"> <HeaderStyle CssClass="HeaderStyle" /> <AlternatingRowStyle CssClass="AlternatingRowStyle" />In my C# file I added these lines... using NorthwindTableAdapters; <<<<<this is the problem - where does this come from? protected void Page_Load(object sender, EventArgs e) { ProductsTableAdapter productsAdapter = new ProductsTableAdapter(); GridView1.DataSource = productsAdapter.GetProducts(); GridView1.DataBind(); }Thanks in advance
View 6 Replies View RelatedI am attempting to create a stored procedure that will launch at report runtime to summarize data in a table into a table that will reflect period data using an array type field. I know how to execute one line but I am not sure how to run the script so that it not only summarizes the data below but also creates and drops the table.
Any help would be greatly appreciated.
Current Table
Project | Task | Category | Fiscal Year | Fiscal Month | Total Hours
---------------------------------------------------------------------------------------------------------
Proj 1 | Task 1 | Cat 1 | 2007 | 01 | 40
Proj 1 | Task 1 | Cat 2 | 2007 | 02 | 20
Proj 1 | Task 1 | Cat 3 | 2007 | 03 | 35
Proj 1 | Task 1 | Cat 1 | 2008 | 01 | 40
Proj 1 | Task 1 | Cat 2 | 2008 | 02 | 40
Proj 1 | Task 1 | Cat 3 | 2008 | 03 | 40
Proposed Table
Project | Task | Category | Fiscal Month 01 | Fiscal Month 02 | Fiscal Month 03 | Fiscal Year
---------------------------------------------------------------------------------------------------------------------------------------------------
Proj 1 | Task 1 | Cat 1 | 40 | 0 | 0 | 2007
Proj 1 | Task 1 | Cat 2 | 0 | 20 | 0 | 2007Proj 1 | Task 1 | Cat 3 | 0 | 0 | 35 | 2007
Proj 1 | Task 1 | Cat 1 | 40 | 0 | 0 | 2008
Proj 1 | Task 1 | Cat 2 | 0 | 40 | 0 | 2008
Proj 1 | Task 1 | Cat 3 | 0 | 0 | 40 | 2008
Thanks,
Mike Misera
I have a table, TableA with amongst other fields, a field for Qty.Qty can range from 0 to 100.How do I count the number of rows with a qty between 1 and 10, 11 and20, 21 and 30, and so on using one SQL statement? Regards,Ciarán
View 16 Replies View RelatedHello, everybody.
In my web application, i'm using 2 tabels; Users(Username(PK), Pwd, Name, Deptid(FK)) n Dept(Deptid(PK), Deptname)).
For creating a Data Access Layer 4 my project, I added dataset as new item n followed the wizard 2 create the required functions.
I have a function GetUser(@uname, @pwd), which takes username n password as input. M using this for authentication purpose.
While executing it poping an ConstrainException.
Plz help me out.
I've tried 2 as clear as possible here. OR u may ask me any other questions for clear picture of the scenario.
Thanks and Regards,
Sankar.
I request you plz tell how to create Data Access Layer. I mean DataAccess.dll. So that I can call stored procedure from dataaccess.dll as below.
DataAccess.SqlHelper.ExecuteDataset(DataAccess.DSN.Connection("DBConnectionString"), CommandType.StoredProcedure, "SP_GetEmpIds");
I request you how can I add this stored procedures to DataAccess.dll and function. I am not having any idea in this area. I request you plz give me some suggestions to work with task.
I have a form with a drop down box so the user can select a quote.. When a quote is selected i need to populate a table of all the records associated with the quote id. I need the table to be created in such a way that the user can add new rows, delete rows and edit the data. Then all of the changes need to be written back to the database. Whats the most efficient/best way of doing this and if you have any ideas can you explain them as thoroughly as possible! I'm currently upgrading an access database to a sql server back end with an asp.net client and it's taking me a while to get to grips with all the changes!Thanks in advance,Chris
View 1 Replies View RelatedI use Visual Studio and VB.
If I want to create an SQL data table on the server, I go to Server
Explorer and make a small table with the corerct columns. Then I add
rows programatically as needed from the Application I'm working with.
It would suit me, for a current job, to be able to create the table itself programatically.
I don't know how to do this. Can it be done ? If so, could someone give
me a starter, please ? Four cols with a key in the first.
David Morley
When a new database is created in enterprise manager the path for the database and transaction logs are defaulted to d:mssql7data or wherever you installed SQL Server to initially. Is there a way to change the defaults to place the data on one drive and the logs on a different drive?
View 1 Replies View Relateda number of time I have come accross developers using functions like
GetProduct()
GetProductTitle()
GetProductCategory()
to get the value of the data instead of just using queries / stored procedures
I have not understood why
can you please point to some good forum messages / blogposts / articles on this ?
Whats your take on this ?
I am doing some work in microstrategy reports and using SQL data cube. I am creating a summary report (Counting on Unique ID) in MS where when I put in a particular attribute/column from cube it splits the data count down into 2 separate values that I have defined in the select case statement of the SQL query.
I want to work out a ratio of the count unique ID between these two values but can't do this in MS report as it is not a physical column but summary split of data.Is there a way I can do this in SQL? My summary looks something like this:
N E
====================== =========================
**Y** N **Y** N
========= ========== ========= =========
570 140 89 56
Where the Y/N field is the one I have split down against the N/E column. I want to work out ratio between the 2 "Y" fields but in SQL. Here is a SQL example snapshot of my data:
Unique_ID New/Existing Application Attend_Interview
========= ======================== ================
12554445 E Y
65766879 N N
53375654 N Y
44323224 E N
93656786 E Y
wondering if I might be able to do a procedure or similar or something more dynamic in SQL query?
hi, i'm trying to create a table and populate it with data from another database residing on the same server. i've done this on oracle using tables within the same database and am just making a first effort with the added twist of a different database. this is what i've been doing so far...
CREATE TABLE facility_dimension
(
fac_id INT IDENTITY(1,1),
tri_fac_id CHAR(17),
fac_nameVARCHAR(100),
street VARCHAR(100),
city VARCHAR(100),
county VARCHAR(50),
state VARCHAR(4),
longitude REAL,
latitude REAL,
PRIMARY KEY(fac_id)
)
SELECT tri_facility_id, facility_name, street_address,
city_name, county_name, state_abbr, fac_latitude,
fac_longitude
FROM TRI_2004.form_1;
....where TRI_2004 is the other database and form_1 is the table. the result is creation of the new table and then the output of the secondary query. i'm assuming this can even be done but if it can't that would be helpful to know as well. thanks in advance!
SQL Server 2000Is there any way to take sample data in my database and create an INSERT INTO script?I have a commercial application that I would like to include sample data, and instead of restoring a backup like I am doing now, I would like to first run a script that creates the database, stored procedures, etc, then run a script that inserts sample data if the customer so chooses.I know I can do this manually, but is there any way to create the script based on exisiting data?TIA-- Tim Morrison--------------------------------------------------------------------------------Vehicle Web Studio - The easiest way to create and maintain your vehicle related website.http://www.vehiclewebstudio.com
View 4 Replies View RelatedI am using SQLServer 8.
I have several files that were FTP'd from our legacy COBOL system. I am in the process of cleaning them up and saving them into CSV format.
I was told that I could use the BCP utility to import them into a SQL database, but the documentation I have is not real clear on that.
Does anyone have any suggestions for how to import these files? I have created the database but not the tables.
Thanks.