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????
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!!!
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)
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.
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?
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).
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.
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)
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.
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?
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'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.
What 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.
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..
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?
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.
Hi, 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.
HI,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~!
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..
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.