HI
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????
Medo
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!!!
regards
I am having trouble bringing "description" column in to my sp and them at the out put. in the ppatient_status_mstr there is a column called“description” which has patient status such as “discharged” “termed collection” etc... How do I use the SP to bring this description into application? I am assigning it to @mytext. I am not sure how to declare “description” in the SP? Every time I use it I get errors like:
Msg 4104, Level 16, State 1, Procedure CheckStatus, Line 20
The multi-part identifier "pm.alerts_ind" could not be bound.
Msg 207, Level 16, State 1, Procedure CheckStatus, Line 40
Invalid column name 'description'.
Msg 207, Level 16, State 1, Procedure CheckStatus, Line 43
Invalid column name 'description'.
I want to say if user picks a description from application . show me that description in output. But I am having trouble how to use the description? I am not sure if my “IF” statements are correct either?
Here is the procedure
ALTER PROCEDURE [dbo].[CheckStatus] (@enc_id varchar(36) OUTPUT, @Mytext varchar(50) OUTPUT, @data_ind Char(1) OUTPUT)
AS
BEGIN
DECLARE
@alerts_ind char(1)
[code]....
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 1 Replies View RelatedHello everybody,
If I know the table name, is there any command to list all "Column Name" and the Columns "Description" as shown in the Design Table window.
Any feedback is welcome!
Thank you,
Edi
I dont know,how can I get column description from Sql Server 2005 and use it in vb.net 2005? would you please help me solve it?
View 1 Replies View RelatedHi,
I want to set column description in .Net 2005, Please guide me.
thanx very much
I've tried looking in sys.syscolums and sys.syscomments, but I can't seem to find where the Description information is retain for a Field in the system tables -- any hints?
Thanks, Rob.
I have this easy sql for a drop down.
select code_value, desc1
from dbo.market_area_code
where code_value in ('1', '2', '4')
How can I add something to display something like
if code_value = '1' then display 'Blue'
if code_value = '2' then display 'Orange'
if code_value = '4' then display 'Red'
Hi, all..
I want to know the query to retrieve Column information that we can see from table Design view of Enterprise manager, such as Column name, Pk or not, FK table, Data Type, Null or not, Description(Specially Descrition).
Is there any sp for this or any query for this?
Thank you all...
How can I query/script Column or Table description (extended property MS_Description') in SQLserver 2005 db.
View 4 Replies View RelatedI am migrating between SQL Server 2000 and SQL Server 2005 but hit a snag when attempting to write a query to display the column's description.
I used this code with SQL Server 2000 to get the "Description" data.
select o.name 'table' , c.name 'column' , p.value as 'description' , t.name 'datatype' , c.isnullable 'nullable?' , c.length, m.text 'default_text' from sysobjects o
join syscolumns c on o.id = c.id
join sysproperties p on o.id = p.id and p.smallid = c.colid
join systypes t on c.xtype = t.xtype
left outer join syscomments m on m.id = c.cdefault
order by 'table' , 'column'
How can I reproduce this with SQL Server 2005? I tried using the following which gives me a lot of the same data but not "Description":
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
Any help here would be greatly appreciated.
How can I get the SQL Server 2000 Column Description within ADO.NET 2.0?
BR / Chris
Hello All.
I have created a table with short name as the file name but have entered the description in the column box (when creating a new table - see attached). I would like to show this description information in query analyser. Can this be done? I used sp_help <table name> but it doesn't show the description.
Please advise. Thank you.
Best regards
I am trying to get the schema of database using the getschema method. However, the schema that is being returned does not include the description. I have added in table and column descriptions for some of my tables and columns but the dataset returned does not include the description column.
Any idea on how to get the description to be output?
Dim testCn As System.Data.OleDb.OleDbConnection
testCn = New System.Data.OleDb.OleDbConnection(step2.GetRevEngConn.ConnectionString)
Dim testDS As DataTable
testCn.Open()
testDS = testCn.GetSchema("TABLES")
testds.writexml("c:schematables.xml")
testDS = testCn.GetSchema("COLUMNS")
testDS.writexml("C:schemacol.xml")
testCn.Close()
- <Columns>
<TABLE_CATALOG>XDMDB_LAPTOP</TABLE_CATALOG>
<TABLE_SCHEMA>dbo</TABLE_SCHEMA>
<TABLE_NAME>PropertyValue</TABLE_NAME>
<COLUMN_NAME>property_value</COLUMN_NAME>
<ORDINAL_POSITION>6</ORDINAL_POSITION>
<COLUMN_HASDEFAULT>false</COLUMN_HASDEFAULT>
<COLUMN_FLAGS>230</COLUMN_FLAGS>
<IS_NULLABLE>true</IS_NULLABLE>
<DATA_TYPE>130</DATA_TYPE>
<CHARACTER_MAXIMUM_LENGTH>0</CHARACTER_MAXIMUM_LENGTH>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<CHARACTER_SET_CATALOG>master</CHARACTER_SET_CATALOG>
<CHARACTER_SET_SCHEMA>dbo</CHARACTER_SET_SCHEMA>
<CHARACTER_SET_NAME>iso_1</CHARACTER_SET_NAME>
<COLLATION_CATALOG>master</COLLATION_CATALOG>
<COLLATION_SCHEMA>dbo</COLLATION_SCHEMA>
<COLLATION_NAME>SQL_Latin1_General_CP1_CI_AS</COLLATION_NAME>
<COLUMN_LCID>1033</COLUMN_LCID>
<COLUMN_COMPFLAGS>196609</COLUMN_COMPFLAGS>
<COLUMN_SORTID>52</COLUMN_SORTID>
<COLUMN_TDSCOLLATION>CQTQADQ=</COLUMN_TDSCOLLATION>
<IS_COMPUTED>false</IS_COMPUTED>
</Columns>
I am trying to figure out how to set the Description of a Column in my database table by making a SQL function call. I know that I can go into Microsoft Studio Express and type in each desciption for each column. I just have about 1000 variables and each variable's description is in an Excel spreadsheet. I want to be able to build SQL code that will set each of the 1000 variables own description.
Thanks for any help.
Wesley Marshall
I have a subselect that should be working but doesn't. Been at it too long today.
DECLARE @Calendar1 AS DateTime
SET @Calendar1 = '{{{ Please choose a start date. }}}'
SELECT
('0' + CONVERT (varchar (10), W.WorkerID)) AS VendorID,
(W.FirstName + ' ' + W.LastName) AS VendorName,
(W.FirstName + ' ' + W.LastName) AS Contact,
[code].....
Where did I go wrong?
When I try to install MS SQl server2000 on windows XP machine,it says the server component is not supported by OS.What should I do to get it run on my machine?
View 3 Replies View RelatedHi,
I'm Arash Baseri a Sql Server2000 developer and mail you from Dubai (U.A.E). I have a problem in Sql Server locking table. My problem is not reasonable so the more I researched the more I understand it is not my problem .it is a bug in Sql Server2000.
Now I explain the situation:
I have two tables (Table A and Table B).Table A has a clustered index on col1 and col2, Table B has a clustered index on col1 and col2. I join these tables and update col3 in table A, like this
begin tran
insert [Table A]
select * from Arshiv_Master where Col1 between 26001 AND 26001
Update AI31 set Col3=Case
when 1=1 then 1
Else 0 End
From [Table A]AI5, [Table B]AI31
where AI5.Col1=AI31.Col1 And AI31.Col1 Between 26001 And 26001
/* intentionally I didn't rollback or commit transaction to hold locks on table*/
In another connection I execute this query and I face "Lock request timeout period exceeded" error message.
set lock_timeout 1
set transaction isolation level read uncommitted
Update AI31 set Col3=Case
when 1=1 then 0
Else 0 End
From [Table A] AI5, [Table B] AI31 where AI5.Col1=AI31.Col1 and AI31.Col1 between 45018 And 60000
Now the most interesting part is here .when I use a smaller data range for Col1 no error message is shown. A query like this
set lock_timeout 1
set transaction isolation level read uncommitted
Update AI31 set Col3=Case
when 1=1 then 0
Else 0 End
From [Table A] AI5, [Table B] AI31 where AI5.Col1=AI31.Col1 and AI31.Col1 between 45018 And 50000
As you see the difference between the last two queries is on WHERE clause especially on data rages of Col1.
As you know Sql Server 2000 has row level lock and when I acquire a lock on a record the other records are free. So what's wrong with Sql Server that assumes the others records are locked. I tested this situation in Sql Server 2005 and this problem was not seen so I think it's a bug in Sql Server 2000.Who can help me about this problem?
Hi,
I'm Arash Baseri a Sql Server2000 developer and mail you from Dubai (U.A.E). I have a problem in Sql Server locking table. My problem is not reasonable so the more I researched the more I understand it is not my problem .it is a bug in Sql Server2000.
Now I explain the situation:
I have two tables (Table A and Table B).Table A has a clustered index on col1 and col2, Table B has a clustered index on col1 and col2. I join these tables and update col3 in table A, like this
begin tran
insert [Table A]
select * from Arshiv_Master where Col1 between 26001 AND 26001
Update AI31 set Col3=Case
when 1=1 then 1
Else 0 End
From [Table A]AI5, [Table B]AI31
where AI5.Col1=AI31.Col1 And AI31.Col1 Between 26001 And 26001
/* intentionally I didn't rollback or commit transaction to hold locks on table*/
In another connection I execute this query and I face "Lock request timeout period exceeded" error message.
set lock_timeout 1
set transaction isolation level read uncommitted
Update AI31 set Col3=Case
when 1=1 then 0
Else 0 End
From [Table A] AI5, [Table B] AI31 where AI5.Col1=AI31.Col1 and AI31.Col1 between 45018 And 60000
Now the most interesting part is here .when I use a smaller data range for Col1 no error message is shown. A query like this
set lock_timeout 1
set transaction isolation level read uncommitted
Update AI31 set Col3=Case
when 1=1 then 0
Else 0 End
From [Table A] AI5, [Table B] AI31 where AI5.Col1=AI31.Col1 and AI31.Col1 between 45018 And 50000
As you see the difference between the last two queries is on WHERE clause especially on data rages of Col1.
As you know Sql Server 2000 has row level lock and when I acquire a lock on a record the other records are free. So what's wrong with Sql Server that assumes the others records are locked. I tested this situation in Sql Server 2005 and this problem was not seen so I think it's a bug in Sql Server 2000.Who can help me about this problem?
HI,
I have a application which has Access as Front end and SQLServer as BackEnd.
I have a table which has student details.
Table Fields are:
Record#,FirstName,LastName,MiddleName,Address,City ,State,Pin,.....
The table has about 1200 records.
Every Thing works fine but in the front end when i try to do a search by
FirstName it is VERY SLOW.But it is okey if i search by the Record#.
I need to search by lastname or Firstname and speed up the process.
Any Help will be appreciated,
Thanks,
Rang.
What are the experiences of those who have upgraded to
View 2 Replies View RelatedWhat are the experiences of those who have upgraded to SQL Server 2000?
I am writing a paper for my company and wish to list features of SQL Server 2000 from a user/developer/business aspect. We are on
SQL Server 6.5 and I need to highlight the advantages and disadvatages of upgrading.
Thanks
Jeff
Hi everybody,
I configured Logshipping in sql server 2000(Enterprise edition).in destination server copy and restore is failing(but there is no error).Out ofsync threshold value is set 27 minutes, after 27 minutes i found the error message in sql server error logs "The log shipping destination HARSHA.Northwind1 is out of sync by 27 minutes..
Any body help me
Hi gang,
Just trying to get some information on what is required to migrate from Access 2000 to SQL Server?? Is it pretty difficult to do? Are there any changes to the data or structure that is needed? Is SQL Server more secure? What about MSDE instead of SQL?? I'm just needing some tips and info on what to expect and all as I think we are going there kinda soon. I can do many things in Access but not sure how to go about them in SQL Server? Can you also do reports from there as well?
Inquiring mind wants to know
have a nice one,
Bud
There is a Server with 4G Memory. I installed a SQL Server 2000 standardversion on it.I heard that SQLServer2000 could use only up to 2GB memory. Is it true?How can I use those 4GB memory? I can not upgrade to SQL Server 2005 orother version because i don't want to take this risk.Thank you very much.
View 8 Replies View RelatedHi, Is it possible to use ssis for the etl processes and still have an existing 2000 db? For e.g. CanI create a ssis pkg and use the xml task to download data to a 2000 db.
View 4 Replies View RelatedHI,Thank you to pay attention to this thread.i am chinese,may be i coudln't say my problem clearly,it's.....
okay,i use the TextBox,SQL Server 2000,i fill the TextBox as Chinese,then,I use the T-Sql INSERT to Finish Inserting A record,but when i open the SQL Server 2000,i find that the char showed in field as the char '???',i don't understand what happened,if the fault of UnicodeEncoding?can you help me? Thx~!
dear sir/madam,
i have to create a cube in analysis manager in sql server 2000.as i want to see the data according to my organisation levels.
organisation level:
1.Business unit
2.Team manager
3.Sales manager.
and also i create the three user respectively and assign all user has adminstrator category in user accounts of windows XP.
after create the user and design the manage role to restrict the levels which i have create the dimension.after login which i have to create the user i can see all levels of data.
so pls solution for see data which i have to restrict the dimenssion only..
thanks
kesavan
Please Help me on this.
I installed the two instances SQL on one box. ONe is default instance called ACSQL1(actually machine name) and the other one is called ACSQL1/DEVELOPMENT. THrought the my client site of SQL 2000 I can access both instances. When I try to get connection from VB. I can access the default instance but I can not access the second instance. Any ideas about this???
Qun Lu
Hi,
I am new in SQL SERVER.I wanted to setup high availability database.It would be great if any one could answers my questions please.
-What are the options availability for HA except clustering?
-How to set up log shipping HA ?
-How to monitor log shipping?
-Is standby DB and log shipping same ?
-Can I setup log shipping without backup/restore method.Like I have to create db1 on server A and create db1 on server B and then configure log shipping?
-Is it necessary to ship log for master database or only user Database?
Thx
-Blace
I want make setup cd for my program and i use visualbasic 6 and SQL Server 2000 .
What i should make and include my setup file to make it work with any one install it in his computer and we assume he dont have SQL Server2000 in his computer .
Please help me on that
Should SQL Server 2000 must alreeady installed on his computer?
If its must be installed,Is there any way to make it easy through my setup file to make it install sql server automatic ?
Can i make my program in visual basic create database and tables and relations and so.
Please help me on that becuase its too Important.
Thanks.
Hi,
I want to install the sql server2000 analysis service.Can you please tell me the website from which I can install that.