I have a table which contains approx 3,00,000 records. I need to import this data into another table by executing a stored procedure. This stored procedure accepts the values from the table as params. My current solution is reading the table in cursor and executing the stored procedure. This ta...more >>

Hi, How Can I create a case sensitive unique index so that A1 and a1 are treated as different ? I dont mind if I have to make a global DB change. Steve ...more >>

Hi, Does anyone know any good book(s) about MS-SQL, especially about Replication - basically, I need in-depth explanation about how to setup/maintain Snap Shot, Transactional, Merge Replication and different agents - with good examples? Hopefully, the book(s) is recent enough to cover SQLCE m...more >>

I'm in the process of designing a database and would like some suggestion on how to architect it. I have 3 'objects', frequency, task, skill. For each task there is a frequency however for some tasks there are a number of different skills, each of which have different frequencies, so, for e...more >>

I have two questions: (1) How can we diagnose the reason of database suspect? The error log doesn't tell me much. (2) After restart the server, the suspect is gone, but how can I ensure everthing is fine? DBCC check? Thanks! Saiyou...more >>

Hi, I have a problem here when I code stored procedure to manipulate data in database. My idea is that if I can save all data I get in some arrays I should be able to manipulate the arrays directly. But I do not know how to declare arrays in SQL server stored procedure and do not know other w...more >>

We have remote users running MSDE entering information into a database. To send the data back to the home office, we've written some routines that export the data into SQL Scripts in text files: DELETE <table> where KeyID=<x> INSERT INOT <table> (fields) VALUES (fields). We then zip up thes...more >>

Hi, I am new to XML and need a structure of table in XML format, which needs to be created as a table in another server.The Source and destination servers are SQL Server 2000. Could anyone help me on this. Balaji.S. -- Posted via http://dbforums.com...more >>

I've got a question that may not be especially appropriate to this group but since it involves a SQL Server 7 job, thought I'd ask. The company I work for has NT4 servers with SQL Server 7 in many of its units. I wrote a vb script which runs just fine on the server itself. I saved it to a fo...more >>

Hi, We need help on following things, 1. Inputs on creating comments on the columns & Tables of a SQL Database & generating the sql script of that. 2. Is it possible to call a .exe file in SQL server like following code in ORACLE create procedure CERT_VERIFY_PROCEDURE ( in :X Y by v...more >>

Hi all, One of my database was suspected, So I try to recover database then it gives this error Err. 823 Torn Page Detected 823, ... 24, spid51 i/o error Torn Page (Detected) during read at offset 0x0000000040e0000 in file ......... How can I recover my SQL Server 2000 Database? Ple...more >>

This is driving me bananas. Can't find any info on this anywhere.... SQL 2000 seems to replace double space with a single space when I set a varchar field to " " (2spaces), it only stores " " (1space). Why on earth would microsoft do this? If I save 2 spaces - I WANT TO SEE 2 SPACES!!!! ...more >>

Hello, I plan to create a table with 3 unique keys. Combination of three fields has to be unique for each row in a table that are vendor ID (char 8), vendor name (char 40), and vendor office (5). Will it be okay to have a unique key which has a long character such as vendor name? ...more >>

I am trying to find a select on sysprocesses that would list all the active logins. An active login is a login that has a TSQL statment being executed on the server, This didnt work to well! Any ideas. Thanks in advance. select sp.loginame, -- more columns fr...more >>

Hello: I've just converted my Access 2K db to SQL Server 2K and the conversion went smoothly. I created users, roles, views and forms and gave the users permissions to use them. I "THINK" I have done everything, but......you cannto update the form, view, or table. I get "Recordset Not Updat...more >>

My colleagues and I have not been able to successfully set up SQL = debugging on a SQL 2000 instance running on Windows 2000. Is there a checklist posted somewhere? We have verified that the SQL = Server is not running with System Account Credentials. It runs as a = Domain Administrator. We ...more >>

Hi all, I have bought Visual C# .NET 2003 Standard and downloaded the MSDE to use with it. I did install it with it's default options and now i'd like to administer it with Web Data Administrator but it keeps telling me that i should enable SQL Server Authentication. So i tried debugging...more >>

Hello, So my table contains say 100,000 records, and I need to group the categories in fld1 by the highest count of subcategories. Say fld1 contains categories A, B, C, D, E. All of these categories contain subcategories AA, AB, AC, AD,...AJ, BA, BB...BJ, CA, CB, CC...CJ, etc in fld2. I...more >>

This is very much a newbie question as I have not worked with MSSQL Server before. I may be hosting a MS SQL Server database for a web site soon and will require to generate reports from the data. I assume I can just use SQL queries within my ASP web pages? Will I need to buy the MS SQL Serv...more >>

hello, my problem is how to move data files drom drive c: to drive d: ?? -- MarcinS ...more >>

Hello, I'm using SS2000 on NT4. If I run the following query, is it garanteed that the field "OldField1Value" will hold the value Field1 had before the query was run? UPDATE MyTable SET Field1 = 42, OldField1Value = Field1 .... and in this query? UPDATE MyTable SET OldField1...more >>

Greetings, I have the follow table structure: CREATE TABLE [dbo].[Strategies_data] ( [Symbol] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [dateTraded] [smalldatetime] NOT NULL , [Strategy] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Signal] ...more >>

Hi I have problem with scheduling tasks. I have one SP, where I decide to fire or not another SP and I prepare parameters for this new SP. The problem is I want to fire this new SP with delay. For example SP1 is executing at 4:00 PM and this SP1 makes SP2 to fire at 1:00 AM. Is it possible t...more >>

Hi I'm interested in using the timestamp data type & I have some questions. As far as I can understand the contant of a timestamp column is a binary value. Is there any connection between that value and a valid date (as the word timestamp means) or is it a left over from the days when the t...more >>

Folks, My secnario involves two tables - ObservationRegister, and Person. ObservationRegister contains most of the "useful" fields, including the UserID of the person that raised the record, and the UserID of the person to whom the record was assigned for action. I need to write a query to re...more >>

Hello, A very simple question: What happens when two people work at the same time in the same record? The Last win or the first?...more >>

HI... i need test papers on SQL DB. multiple choice with 3 levels of difficulty: beginner, intermediate and advanced. can anyone tell me where i can get them made? or anyone who can help me with this? any sites... any info will be helpful. thanks in advance....more >>

I am looking for some papers/information that compare relational databases such as oracle, mysql, sql server etc. I am particularly interested in their features such as locking mechanisms, integrity constraints, views... Anyone know where I can find the information? Thanks, Susan...more >>

In meen. primary keys, NOT NULL, IDENTETIES...et.c I have to do a maunally, one time, building of a database. Sometables has to stay an some are to be exchanged. The foreignkey inforcemnt ill do for my self so everything is correct. I just need to be allowed to de thede task for a while. Is it...more >>

I do a: SELECT * FROM xxx And Get: Date Place Sum A M 1 A O 3=20 A P 2 B O 5 B M 4 B P 2 And I want it to look like: Date M O P A 1 3 2 B 4 5 2 Can you think of an EASY way to do this? I can do it with a cur...more >>

Hi, I'm doing an Orcle to SQL port. Simply all I want to do is run a script / DTS package that reads Oracle sequences value and writes the current value of it in to a MSSQL table - of SequenceName, Value Can this be done ? If so how ? (Please provide example) Steve ...more >>

Hi group, I have a select statement that if run against a 1 million record database directly in query analyzer takes less than 1 second. However, if I execute the select statement in a stored procedure instead, calling the stored proc from query analyzer, then it takes 12-17 seconds. Here...more >>

This is probably a stupid question, but here goes: I am trying to update a table differently based on what is in one of the columns within the table. For example, I want to set Fld1 to be "On" if Fld2 is "A", and I want to set Fld1 to be "Off" if Fld2 is "B". This is easy to do in two SQL sta...more >>

Using SQL Server 7.0 Trying to change an objects ownership to dbo with EXEC sp_changeobjectowner 'AssignInvoiceNumbers', 'dbo' which gives the following error: Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line 26 AssignInvoiceNumbers does not exist. which it...more >>

Hello, I received the error message below when i'm trying to install SQL Server 2000 standard edition into a Windows 2000 Professionale workstation. Error : Microsoft SQL server 2000 Standard Edition server components is not supported on this operating system. Only client components will...more >>

I'm running a simple DBCC DBREINDEX ('myTable') and I receive the following error: "Server: Msg 169, Level 15, State 2, Line 2 A column has been specified more than once in the order by list. Columns in the order by list must be unique. DBCC execution completed. If DBCC printed error messa...more >>

Hi there How can I debug Stored Procedure? Thanks...more >>

I have many tables and in those i require to change some data. Say from ARCA to ARCAEX. I am sure that the string is unique in the sense there will be no ARCAABC. So what do i do change by not manually needing to search in each table and the whole database and still can be sure that the changes ...more >>

I was hoping I can get some help regarding subject mater located at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_92k3.asp MyTable has 23 fields with 100,000 records. Field1 nvarchar 90 Field2 char 6 Field3 varch...more >>

I have two tables: eg. a person-table (no nulls allowed), with an id and so on, and a person_course table (an intermediate table in a many-to many relationship between person table and courses tables), with two fields person_id and course_id. But I want to make ONE multipurpose stored procedu...more >>

This don't work. I don't know why? Do you? Thanks Mike strSQL ="SELECT * FROM annons where lan=" & "'" &_ request.form("lanSelect") & "'" & " AND Rubrik Like" &_ "'%" & request.form("searchStr") & "%'" &_ " AND (registrerad BETWEEN " & FormatDateTime(DateAdd("d", -strTime, date),...more >>

I would really appreciate it if someone could give me the answers or direct me to a place that would have the answers to the following 5 questions. 1. I need an example of SQL select statement. (table tblSource, fields A,B,C where C<100).. "is this an example that I have in ( )? 2. I need to...more >>

Hi: Anyone has a detailed procedure description about how to setup a standby server? Microsoft makes it sounds very easy which are more complicated. How to handle system databases, does standby server need to be exact hardware as the primary one? Thanks in advance, Xiaodong *** S...more >>

HI! I have a little problem: I have change the administrator password (Windows 2003 Server) which MS SQL 2000 use to login. And now the SQL server can't stand up. What should I do? thx! gicio -- Posted via http://dbforums.com...more >>

I have set up a server with a publication of a very large database. A backup server needs to retrieve the data and do some massive calculations (which isn't really relevant). On the backup server I've created a subscription to retrieve the database but I get the following error: Message: The p...more >>

Is it possible to run SQL certain script from the client application ? thanx ...more >>

Hi I am trying to create a stored procedure that checks if a table exists and if so delete the table, ( I guess this is already written many times but anyway)... Here is what I try: create proc sp_dropTable(@tableName nchar(100)) as if exists (select * from INFORMATION_SCHEMA.TABLES w...more >>

What is "MetaData" in "Data Transormation service" and what is "MetaData services" ? and in which field I can use them? Thanks...more >>

Hello -- I'm trying to get SQL Server 2000 on a Windows 2000 Server to be able to query an Active Directory. We've got two domain servers one Win2000 and one Win2003. However, I'm having problems: I've run the following query to setup the linked server: sp_addlinkedserver 'ADSI', 'Active...more >>

Hello friends, What is MVP? IS it similar to MCDBA. What is the process of becoming a MVP Thanks... San...more >>

Dear All, I'm facing a problem with creating a view.I have a table with following description Tab1 ------------------------------------ Col1 col2 ---- ----- Val1 Tom Val2 Cat Val3 Jack Val4 ...more >>

I am looking for some published paper regarding database performance tunning performance strategies. This is for academic purpose so it needs not to be any commerical database specific. It will be even better if the paper has some kind of methods to quantify/measure performance. Has anyone co...more >>

hi there, we have a ms-sql server 7.0 and want to migrate to sapdb on unix. are there any tools to convert a ms-sql to sapdb, including stored procedures, keys and views? tia stefan...more >>

What is a good method/mechanism to swap the position of multiple columns? For instance, tblXZY has the followings columns and respective positions: tblXZY ====== xyzUUID 1 fn 2 ln 3 phone 4 email 5 city 6 state 7 .... Now, I need to make city as 2 and state as 3. ...more >>

The only DB newsletter I am currently subscribed to is database journal.Are there any other newsletter that I can subscribe too regarding DB? -- Posted via http://dbforums.com...more >>

hi i'm using mssql server 2000 i want to remove a not null column constraint from the column answertext in table answertext. i tried the following line ALTER TABLE AnswerText ALTER COLUMN AnswerText DROP NOT NULL; it didn't work and this error message apeared (sorry about the german) ...more >>

Hello, If I run an action SP from MS Access using ADO: ... cmd.execute where the SP is something like Create... Update tbl1 set fld1 = 'something' where... how can I retrive the count of records affected like from Query analyzer? Thanks, Rich *** Sent via Developersdex http://www...more >>

Aside from temp table, in what circumstance one would have only one column for a table (be it data or key)? I can't think of any case but some of you may. Thanks....more >>

I have a table contains huge rows of data. Performance issue raised. I am thinking archive some data so that the table will not be that big. The most convience way is move it to another table. The problem is: will this solve my performance problem? or I need to move it to another database to redu...more >>

Hi, what I am trying to discern is if there is any way of logging SP activity on a SQL server 2k DB. Ideally I would want to log SP name, parameters, user and time. I found sp_monitor in MSDN but that just gives overall statistics. Not specific enough to aid debugging. Thanks in advanc...more >>

I have the following cutdown version of table: VehicleID Time Station ------------- ------- ---------- 1 9:00 A 1 9:10 B 1 9:20 C 1 9:30 A 1 9:40 B 1 9:50 C 1 ...more >>