Recently I have changed the VB Application for Authentication method to connect to the SQL Server 7.0 database using the Windows NT Authentication. Later I had created permissions for Select, Insert, Update, Delete, Exec everything based on the Windows NT Authentication on an Active Directory...more >>

Hi all, We recently upsized two Microsoft Access Databases to SQL. We're using an ADP (2002) as the front end. All the conversion issues have been resolved, except for one: Whenever we insert a record into a table, the table isn't sorted by primary key like I would expect. Instead, the r...more >>

Hi all, i'm trying to find a solution for the following problem: I have two different database called A and B. On database A runs an application call AA. Some information from the database A is used in database B. Currently triggers are being used to update the data on database B when anyt...more >>

Hi, I am pretty sure that the answer to this one is a simple "no", but thought I would check anyway... If I upgrade a SQL7 server to SQL2000, leaving the SQL7 instance as the default instance on the new SQL2000 installation and install a named instance of SQL2000 -- Can I at a later date, m...more >>

Hi, In SQL Server 2000, if I have to create a table to store a very large number of 10 digit telephone numbers, would I be better off to have a bigint field or just use a varchar field? If I do a lot of querying based on the telephone numbers, would it be faster if I use bigint? Are there a...more >>

A common request for enhancement to applications is to "make this field bigger". I know I've been caught with increasing a field size, and then spending hours debugging because another stored proc has a variable or temp table that uses the field defined as the original varchar size. SQL Server...more >>

As a Sys Admin, I was wondering - if I have admin rights to a Win2k machine that is hosting SQL Server 2000, do I have the ability using any command-line tools such as OSQL or ISQL to add, delete, or change accounts registered in SQL Server for the various databases if I don't have access to a s...more >>

Hi NG, I have the following problem that I hope you can help me with (MS-SQL server 2000) Imagine a statement like this: "select id, firstname, (select top 1 id from testdata) as testid, lastname from nametable order by firstname" I would like to have this grouped by "lastname"...I ass...more >>

Hi, there is an existing application running on a SQL Server database. Now I have to built a different app, which will have two common tables with the existing database (Customers, sales) Is there any benefit (performance mainly) creating the tables for the new app in a new database? (On...more >>

It's better to use "null" values or "0" and "" ? thank you ...more >>

MSDE 2000 Release A installed under windows 2000 pro will not communicate with SQL Server Manager nor MS Access on peer computer. Can someone help? Have set DISABLENETWORKPROTOCOLS=0 at install time. Install log shows installation successful.. Control Panel> Admin Tools> Services section ...more >>

ver: SQL-DMO Version: 8.00.760 I have the option to automatically start SQL Server on startup, but when it does start up, the SQL Server Service Manager does not have the green arrow indicating that it is active. When I double-click it to display the SQL Server Service Manager, it shows the n...more >>

Please see the detail of tables with fields in SQL server 2000. ·Table Student .Table Good Qualities ( It is a list of Students) (It is a list of Good Qualities) 1- Student Id (P.Key) 1- Serial No. (P. Key) 2- Student Name 2- Good Quality · Table Bad Qua...more >>

Hello, I need some help understanding why my indexes do not seem to be affecting my searches. I would really appreciate help understanding what indexes I need to make this query run faster. I realize that I use wildcards when searching for g1.gene_name, but is there anything I can do to make t...more >>

hi all i am trying to update or delete a row/record in table cptcodes the error i am getting is key column information is insufficient or incorrect to many rows were affected by update.... can you tell me wat causes the above Error this is a new table no primary keys set or index's or cons...more >>

Today I need to copy 8 records in a table. I have to use Access 200 because of the limitation of Enterprise Manager's inability to cope with field with more than 900 characters. Selected records, cut, paste. I got an erroor message about not being able to have a null Key_ID (I copied the reords ...more >>

Hi all, We're looking at a vendor who uses the InterSystems Cache Database Platform, but our IT department has zero experience with this system. This software package will have a pivotal and mission critical roll in our organization, so I'd like some comments on what others think of this dat...more >>

Anybody nows a tool to analyze LDF files in MS SQL Server 2000? I mean, a tool that converts a LDF file in a set of SQL transactions? (similar to dbtran in sybase) thanks!...more >>

Jobs are run from a master server and all the servers run the same jobs. A new server has been added and the jobs tested so far, ran OK but for backups.(Transaction logs and database)with above listed error. The same domain account is used for the agent and the sql server engine for all da...more >>

Hey, I'm writing some automated unit tests for a database app. The app creates a database via script. I'm developing the system in a test-driven manner and need a way to determine if a parameter exists within a stored procedure using SQL. Any ideas? Thanks, Will foehammer@hotmail.com...more >>

I have to automate a process that assigns sales leads to sales people. For example: Every day we buy a list of sales leads, it ranges in size from 50 - 100 records. We have a team of sales people that also can range from 5 - 8 people. I need to take the new records and divide them evenly am...more >>

I am trying to get al the rows from table1 where datetime is between 9:00AM yesterday and 9:00AM today if the time now is less than 9:00AM. Otherwise it should return all where datetime>9:00 AM today. Is this possible as a query in sql2000? ...more >>

Hi I need some help on achieving the following: I wrote a querie which collects Data out of three Tables, the Result looks like this: SET NOCOUNT ON DECLARE @ROW INT DECLARE @CURPTNO CURSOR SET @CURPTNO = CURSOR FOR SELECT * FROM TEMP OPEN @CURPTNO FETCH NEXT FROM @CURP...more >>

The following SQL query :- SELECT CardHolder.RecordID, History.GenTime, History.Link1 FROM History FULL OUTER JOIN Card ON History.Param3 = LTRIM(RTRIM(Card.CardNumber)) FULL OUTER JOIN CardHolder ON Card.CardHolderID = CardHolder.Recor...more >>

Hello all, I have a question. If I have 1 table: Sells, like that: Id_Client Id_Product 210 1 210 2 211 1 210 3 211 2 210 4 212 2 212 4 I want ONLY the client who buy the ...more >>

Running the following query (on SQL Server 2000 SP3a) SELECT [Name] AS Blop, Id AS [Name] FROM SYSOBJECTS ORDER BY SYSOBJECTS.[Name] results in a set of records ordered by the Id column (aliased as Name), surely it should order them by SYSOBJECTS.[Name] as I tell it to? ...more >>

I am trying to determine the next registered session of a student so I can calculate the number of skipped sessions. Scenario: I have a student registration summary table. One row for each student and the student's registered session. I want to update a given row with the next higher registere...more >>

hello group, i want to denormalize data in a temporary table for a second business-system which cant read related datas what i have: table Partner: (Id_Partner, NamePartner, ...) table PartnerProduct: (Id_PartnerProduct, NamePartnerProduct, ...) table Partner2PartnerProduct: (Id, Id_Partne...more >>

We have a database on our central servers that is the backend to a web application we have in ColdFusion. About 4 times a year, we have a user that goes out to other locations without internet access that would need access to this application. Once she comes back to the office, we would like t...more >>

Hi, Please help, I'm getting desperate. Any ideas warmly welcomed! I'm trying to read from a basic excel file (1000 or so rows from column A) but am having problems. The code I am using is: Declare @Return Int SET NOCOUNT ON Exec @Return= [master]..[sp_addlinkedServer] 'READ_XLS', 'EXCEL',...more >>

hello, I have the following query. it returns result in less than 1 second. select * from employee e, address a where e.id=a.emp_id and e.id=1234 The problem is that it becomes extremely slow if i take the last line out. So the query looks like: select * from employee e, address a where...more >>

Hi, I have a question about a query which I want to share with you. Maybe someone knows how this strange behavior occurs. Here is what I do: SELECT top 1 actstage FROM v_OpportunityFase WHERE oppId = 247 This produces the result 4, which in my case is correct. And now the follow...more >>

I have a database and an application in .net using it. In that database I have a stored procedure where is an import mechaism using ODBC driver [Microsoft Text Driver (*.txt; *.csv)] and a .csv file. On my machine everything works fine, but on the other machine import fails with an exception ...more >>

I'm trying to pass a filename and path into an sp and I'm getting an error. I must be missing something easy. (Both UNC path and Drive letter path give an error) anyone know what might be the prob? (chars like : or \\ ????) TIA CBL error is: Server: Msg 170, Level 15, State 1, Line ...more >>

I need to log data collected from instruments in a laboratory at a very high rate. I need to log timestamps and values measured from various devices at a rate as high as once a second. This means my table will grow to tens or hundreds of gigabytes within a year. I want to know if SQL server w...more >>

Hello. Does someone of you know if is there a 'explain plan' like function in SQL Server (similar to explain plan in Oracle or DB2) If so then how it works, where stores data and how it can be retrieved? Best regards Bagieta =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= dbDeveloper - Multiple da...more >>

Hi, I have a question about a query which I want to share with you. Maybe someone knows how this strange behavior occurs. Here is what I do: SELECT top 1 actstage FROM v_OpportunityFase WHERE oppId = 247 This produces the result 4, which in my case is correct. And now the following q...more >>

I have a format file which is working but not correctly. It is, for some reason, dropping the first line of the input .csv file. The problem is something with the second coulumn of data having quotes in it. Any ideas? Below is some info. Format file (I use firstrow=2 in Bulk Import command...more >>

I have tried and tried to get this to work and I'm doing something dumb. I'm going to include sample data and my format file. Can someone help me figure out my dumb mistake on a bulk insert using a format file? Don't worry about data types, I'll handle that later. Thanks a lot!!! CSV File: ...more >>

Hello, I would like do an insert into a table. The table has an auto incrimenting unique int id. After I do the insert how do i get the unique int id of the record that I just inserted? Is there a straight forward way of accomplishing this? Thanks, Billy...more >>

We are experiencing a type 4 latch situation within our server application under the situation where we are updating approx 90,000 records in one shot, with and without explicit transactions. Are there any ways to program round this as this error has only recently appeared after the efficiency ...more >>

Hi guys, how to view the default instance name in my sql server? ...more >>

I'm also having problems getting the bulk insert to work. I don't know anything about it except what I've gleened from BOL but I'm not seeming to get anywhere...Hopefully there is some little (or big) problem with my code that someone can point out that may save me some time. TIA CBL ...more >>

Hi, I was wondering how to do this. I have a table with two columns in design view (start date, end date). How do I set it within sql server (as constraint) or whatever that the start date less than or equal to end date? Thanks :DHRUV...more >>

Hello, How do I concatinate a variable. Here's the scenarios: declare @var1 varchar(20) declare @var2 varchar(20) declare @var3 varchar(20) declare @var4 varchar(20) .. .. declare @var32 varchar(20) set @var1 = 'Something 1' set @var2 = 'Something 2' .... set @var32 = 'Something 3'...more >>

Hello, Is it possible? Can I select a specific record of the cursor to be sent to a seperate function to do all the computations etc.? Regards, VS...more >>

First time here so please bear with me. Set up a DTS package to export data to an excel sheet on an hourly basis. Problem is, it keeps appending to the same excel sheet. Any idea how to prevent that. All I want to accomplish is that every hour, the latest data is in the excel sheet and the...more >>

I have a table that has a int field that contains unique nubers. if I need to insert 4000 or so new records into this table using a SQL command how would I be able to fill this field with the next available number? This will be a manual procedure done maybe once a year so the next number wi...more >>

Hi: I'm trying to setup a MS Cluster but I don't know if it is feasible to configure it in the way I think. I have two machines with win2k server and MSSQL-2000 one of them is currently performing as the production database and the other one is the backup. The secondary one is keeping updat...more >>

Does anyone know the technical reason for why sp_executesql uses the N prefix before the string that is passed? For example: sp_executesql N'USE Northwind' Thanks!...more >>

Hello, I have been trying to load a delimited data file to SQL Server. I have tried both of the options that are available: each time, I get different errors. This is on an eval version of SQL Server 2K, with SP 3a on a Windows XP box. First, I tried to load the data with Bulk Insert. Th...more >>

Hi Folks: I'm a little new to SQLServer, so please pardon my ignorance! I've found the INFORMATION_SCHEMA views for TABLES, COLUMNS, and TABLE_CONSTRAINTS. I'm looking for the views that will give me the list of columns by constraint. For instance, if Table1 has a unique key called Table...more >>