Ei guys I’m Ryan from Philippines, I need your advice and recommendations about Windows 2003 Server and SQL Server 2000 installation. Well, here’s the scenario. First is for windows 2003 server: We have a windows 2003 server that is a Logon Server and we have at least 90 workstation here in o...more >>

Hi I have a Platinum database which stores dates in integer form e.g the date is formatted as below: Column_name Type Length Precision ------------------------------ ------------------------------ from_date int 4 ...more >>

I get this error when I try to create the following tables: ERROR 1005 (HY000): Can't create table '.\haps\transcript.frm' (errno: 150) create table teaching ( ProfId int, CrsCode varchar(10), Semester varchar(10), primary key(ProfId, CrsCode, Semester) ) engine=InnoDB; create ...more >>

Hi all, I have an issue on querying against UTF-16 encoded characters in SQL2000 database: For example the "L=F3pez" is saved into database as "L=C3=B3pez" (due to the UTF-16 encoding); somehow, when I query data with conditions of "like 'lop%'" or "like 'L=F3p%'", the row of L=F3pez would no...more >>

Hi, i have a table like this CREATE TABLE dbo.test ( num int NOT NULL, ename char(80), eadress char(200), archived char(1) PRIMARY KEY CLUSTERED (num) ) create index i_archived on dbo.test(archived) the are 500000 rows in this table,...more >>

I have a SqlServer 2000 running 7 databases. One in particular is slower than the rest specificaly on certain tables. It seems the problem comes from the volume of data, but I don't think 3000 lines can be considered a big table. I have indexes on the principal keys, but it did not help. ...more >>

Hello, We have an ADO.NET application using .NET version 1.1.4322 SP1. It is calling stored procedures in a database that it never written to. The only thing the stored procedures do is a select statement on a few tables that are joined. In the last few weeks we have experienced issues wher...more >>

I'm updating my local database installation using my netowrk login as the id under which SQLServer is being update (Administrator on the operating system and SA role on the database server itself). Has anyone encountered any problems and what is the work-around? ...more >>

Assistance Please I have a couple of scheduled jobs that are failing to e-mail notifications on completion (via SQL Agent Mail). I can send a Test e-mail without any problems. I can run the jobs manually, and the e-mail notification works effectively. Left to run according to the schedule...more >>

I have a Users table which contains a nvarchar column LastName. The first query below returns me all the records with LastName containing "opez" or "=C3=B3pez" in them. But the second query returns only records with "lopez" in the lastname and not records that contain "l=C3=B3pez". Can anyone pl...more >>

Hi, I have a sql 2000 server with 8 processors, server settings are as default. I read on Technet that it is good practise to remove the highest no. processors from being used for parallelism, corresponding to the no. of NICs in the server. One of our 3rd party developers has recommended only...more >>

Hi I'm currently having to design a database for a recruitment agency that's just started up and have one area where I'm a little unsure where to go. Basically I've implemented the 'standard' Customer, Contacts tables linked on CustomerID, and also have CallRecords (for phone calls etc mad...more >>

I have a table with structure below : Table_A { PGradeID int IDENTITY(1,1), PName varchar(20) } If I delete all records on Table_A, and then fill some records, PGradeID will no longer start from 1 anymore, everybody knows that. How to change it so PGradeID will start from 1 after all rec...more >>

Hello, It might be a basic question, but there it goes: I have a store procedure that first checks if the record exists and, if it doesn't, inserts the new record. Is the scenario below possible? (thread1) USER1 -> check if record "abc" exists (thread2) USER2 -> check if record "abc" e...more >>

Hey, Another 'must be simple' question.. I'm wishing to convert a binary field into a textual representation of that binary data. i.e. come out with what the query analyser would display, and not try to convert the binary into ascii/whatever encoded text. Cheers for any clues, Chris...more >>

If I on a remote hosting server have db_owner rights, do I then also have db_securityadmin and db_dlladmin rights? BRGS, TCHillII...more >>

Hi Group! I am struggling with a problem of giving a date range given the start date. Here is my example, I would need to get all the accounts opened between each month end and the first 5 days of the next month. For example, in the table created below, I would need accounts opened between ...more >>

I have not used the copy objects wizard that much. I used it today to copy 4 views from my dev box to production. It copied the views, but also wiped out my data in all the tables that the views are built around!!! In production!!!! Can someone provide me some insight into why this happened...more >>

What does "conditional" mean as a command? sp_who2 reports this for some sessions, along with "insert" etc. Thanks, Jim Geissman ...more >>

Sorry for the piece-by-piece nature of this post, I moved it from a dormant group to this one and it was 3 separate posts in the other group. Anyway... I'm trying to bulk insert a text file of 10 columns into a table with 12. How can I specify which columns to insert to? I think format file...more >>

Hi everyone, I just need a bit of advice as to where to start tackling a problem, if thats possible - thanks very much. I need a single stored procedure to make several inserts into my msde database. There will be two arguments to the stored proc. The first is a title argument which nee...more >>

SQL Server 2000 Just curious - was wondering why some SPIDS are left hanging out there for up to several weeks. There are no errors or anything. It looks like normal processing. Thanks, Craig ...more >>

I have an identical SQL database on two machines (my machine and a web server) that links to a database on a third server (S3). When I execute a stored procedure on my machine that accesses a database on S3, it always runs without a problem. However, when I run the same stored procedure on the w...more >>

Hi in T-SQL, (how) is it possible to concatenate 3 (varchar) fields into one; either in a SQL query or through a calculated field (or using a view, if anybody can explain to me how to use views), according to the following rules: { first 30 chars of Trim(AttributeVal1) if resulting s...more >>

Env: SQL Server 2000 It actually waited for 50 seconds instead of 5, tried WAITFOR DELAY '000:00:005' and WAITFOR DELAY '000:00:5' respectively, and got same behavior. Bug or ? TIA ...more >>

Hi, We will be developing a management reporting software for a bank. The user will see reports that get updated in near real time( e.g. every 5 min), with data regarding transaction amounts, etc. across a number of dimensions such as day, time, region, etc. The dimensions will be hierarchica...more >>

Hi all, I want to use a function with a tabel object as parameter. Does someone know a method to do this. I have read that a table as parameter is invalid. ...more >>

Hello all, I have a stored procedure with a parameter that I need to use in a subquery, but my query doesn't work. The stored procedure is some as: CREATE PROCEDURE dbo.Test @valore varchar(100) AS SELECT * FROM TABELLA WHERE i_campoID IN (@valore) ORDER BY i_campoID DESC GO Ho...more >>

Hello, we use two instances of the ms sql server 2000 (Version: 8.00.760) on a 4 processor windows 2000 (sp 4) machine. A dts-packet on one instance completly blocks the work on the other instance. Both instances have 2 dedicated processors. The two processors of the blocked instance are in i...more >>

Hi all, I was just wondering if it could be possible to excecute a statement which is extracted from variabele, Example: declare @SqlStatement varchar (100) set @SqlStatement = 'select * from company' the @SqlStatement contains the actual sql query, is it possible some how to straight aw...more >>

I am working with employee schedules. Each schedule is comprised of segments (shift, lunch, break, training, etc.) that have rankings. Each record has the employee id, the date the shift starts, the start and end time of each segment, the duration,the segment type and its rank. The start and e...more >>

Hello, Do you know if the algorithm for the BINARY_CHECKSUM function in documented somewhere? I would like to use it to avoid returning some string fields from the server. By returning only the checksum I could lookup the string in a hashtable and I think this could make the code more eff...more >>

-- tested schema below -- -- create tables -- create table tbl_test (serialnumber char(12)) go create table tbl_test2 (serialnumber char(12), exportedflag int) go --insert data -- insert into tbl_test2 values ('123456789010',0) insert into tbl_test2 values ('123456789011',0) insert into...more >>

Has anyone seen a 25 TB data warehouse on SQL Server? I do not know of such a thing, but maybe it exists out there. ...more >>

I have a requirement that requires detection of rows deleted/updated by other processes. My business objects call stored procedures to create, read, update, delete data in a SQL Server 2000 data store. I've done a fair amount of research on concurrency handling in newsgroups and other resources....more >>

Anyone, Is this possible? I am connecting to a TeraData server via MS SQL 8.0 using the OpenQuery statement. I need to pass a list of ever-changing deal numbers My list of numbers are stored as a table on MS SQL. So what I want is this Select * from OpenQuery(TeraSrvr, " Select Col1...more >>

I am by no means a "Database Expert" and have recently been asked to assist with a SQL 2000 database move to a new server. I was wondering if there was an easy way to reconfigure the ODBC pointers on the workstations? Thanks for the help in advance. ...more >>

Hey, I am having some confusion about how to formulate this particular query. I have 2 tables. Table A has 4 columns say a1,a2,a3,a4 with the columns a1,a2,a4 forming the primary key. Table B again has 3 columns with b1,b2,b3,b4 and like before, b1,b2 and b4 form the primary key. All columns...more >>

Hello Group, I'm working on two SQL server databases on two different remote servers. What client needs is that his database on one remote server should be mirrored to the other one. The changed should be propogated at regular intervals at the other server. For now i'm quite su...more >>

I'm using Idera's SQL Diagnostic Manager and its showing me my index is using the File Group "Primary" (which I recently read is bad) and I have 3 index levels with some Data values having in excess of 700K rows. Is this bad and should I be worried? Is there some housekeeping I should do in the...more >>

Hi, I'm am looking for a little help. I need to create a SQL view which joins a few tables, and I need to return an average for a particular column where a second duplicate ID exists... Heres an example of how the results could be returned... ID | Name | Order No. | Value ---+------+--...more >>

In SQL Server 2000 I have set up an Oracle linked server. When I run the following query it runs fine:- SELECT * FROM OPENQUERY(LINKEDSERVERNAME,'SELECT * FROM ORACLETABLENAME') However the following query does not work:- SELECT * FROM OPENQUERY(LINKEDSERVERNAME,'SELECT FIELDNAM...more >>

Hi, I've got the following Stored Procedure CREATE PROCEDURE pr_Admin_GetCtrlFields --Get the control fields, detail or flow according to the ModeID parameter @QueryID int, @ModeID int AS SELECT FieldID, FieldName, EntryInfo, ControlTypeID,ViewFieldTypeID, ViewTable, ViewField, F.Sort...more >>

Hi, I have a table with filled out below data: +------+-----+ |parent|child| +------+-----+ |A |B | |B |C | |B |E | |C |D | |E |F | |E |G | +------+-----+ So I have to make a query which get all 'parent' values values for given child value...more >>

We've got a couple of scripts that we routinely run on several SQL servers, and they usually run fine. But we're trying to run them on one particular server, and we're running into problems. I'm no expert with SQL, but two DBA's who I work with have spent hours on this and they're stumped, so I ...more >>

I am using SQL Server 2000 and SQL authentication in a web appliacation. All data access is done via single SQL Server account. In my front end I am using forms authentication. Is there a way to retrieve the forms identity (or just a username) from SQL Server? Thanks, Lac ...more >>

SQL Server 2000 Ya know, it is always the simplest stuff that gets ya !! I am having the hardest time getting a simple piece of code working. Must be brain dead today. Goal: Get the users full name from a string Here is sample data: "LDAP://blahblahblah/CN=Kevin Jones,OU=DevEng,DC=no...more >>

I have a worksheet written by another programmer that I have to modify. He uses MSquery to extract from a SQl 2003 DB. That part I understand and I can duplicate. The hard part, is that for each row that is displayed three additional columns show up (in all seven queries) and in one case he chan...more >>

I have 16,000 rows in tblClient and 3000 rows in NewTable. SELECT tblClient.* FROM tblClient INNER JOIN [New Table] ON tblClient.NoDossier <> [New Table].NoDossier if I use = (equal) instead of <> (exclude), the query returns 3000 rows when I use <> it returns 160000 row...more >>

hi all, This will be a easy question for all out here. I have a database of 28GB. having 3 Data Files 22 GB, 3.58 Gb and 2.70 GB respectively. and a Transaction Log file of 156 mb. When i executed DBCC Shrinkdatabase(databasename),it reduced size of datafile but the LOG file had gone up t...more >>

I may not be the best forum for this post, however I believe some one can still help me or direct me somewhere else. I'm finding that win 2003 x64 and SQL 2005 CTP is slower than win 2003 and SQL 2000. Machine A: Opteron 2.2 (248) w/ 2 cpus. 8GB memory. SCSI disk array. Windows Enterprise 2003 ...more >>

Hello everybody, i have a advance question about a specific sql problem: My table A have for example 3 columns. in the third column are words seperated by ~. ID COL2 COL3 -------------- 1 ab test~dummy~ddd 2 cd testdata2~sjhfdg~sdf 3 ef sd~test 4 gh sd~cv Now i ...more >>

This is probably straight forward, but let's see: Say I have a Family which includes an address field table and a related FamilyMembers table which includes an age field. I need to output a report on each Family where there is at least one family member with an age over 16. Any help grate...more >>

I'll try and keep this brief so in a nutshell: I have large distributed java system running on a Windows 2003 server (4cpu 8Gb memory). Periodically the following exceptions occurs in the servers: java.net.SocketException: No buffer space available (maximum connections reached?): recv fai...more >>

Hi All, I am working on a project where I had to upload data from Excel file into SQL Server. Now the problem is that the data in Excel sheet can have any data(garbage) ,the data entered may not have any significance to the data already present in the database. e.g I have an Auth...more >>

Hi all, need advice on the following task: copy the content of a big table from DB_A to DB_B in the same server the size of table: ~ 7 million rows, ~ 9G in size, 1 clustered pk index, 13 nonclustered index current practice: use DTS to copy the data, takes over 20 hours as -- first had...more >>

hi, Can you union 2 queries with an IF statement between them? e.g. select a, b from mtTable where a = c union if ab = x begin select a, b from mtTable where a = c end Cheers, Jack ...more >>

Here is a small sample of data from a table of about 500 rows (Using MSSqlserver 2000) EntryTime Speed Gross Net ------------------ ----- ----- 21:09:13.310 0 0 0 21:09:19.370 9000 NULL NULL 21:09:21.310 NULL 95 NULL 21:10:12.380 9000 NULL NULL 21:10:24.310 NULL 253 N...more >>

Hi again, Is there a way I can find out the ip address of the subscriber machine in a replication? I can't seem to find it in any of the tables under the distribution database. Thanks, Harold ...more >>

Hi all, I have an application that creates a publication on the server, and have multiple mobile devices creating annonymous subscriptions to that publications. I need to write a report that checks if each device have the replication synchronized successfully. I can run distribution.dbo.sp_...more >>

Hi! I'm experiencing the following experience problem with my SQL Server 2000. Explanation a' la example; 1. I insert data using my SP; EXEC dbo.up_DataInsert This is fine, SQL Profiler duration only a few ms. 2. I try to select the data. select * from dbo.tblData where DataNumber = ...more >>

This has to be a simple question for most of you, so here goes. My passwords for sa and another login that I created keep resetting. How can I turn off password expiration in SQL Server 2000? Thanks! MB ...more >>

Hi, Is 'sqlserver.exe' the only windows process does everything for that instance of the database? Please explain in details the SQL server process architecture. Thanks *** Sent via Developersdex http://www.developersdex.com ***...more >>

Good morning ! Anyone knows how can i change a SQL Server Serial number without uninstall it ? Thanks in advanced JLuis ...more >>

I'm using collation SQL_Latin1_General_CP1_CI_AS and I need to sort a varchar field. There are some elements, however, that I want to come AFTER any alphabetic characters. Is there any character that sorts after "Z"? In normal ASCII, there are various characters that would sort after "Z" (e.g. "...more >>

Hi, I am attempting a bulk copy from a c program into SQL Server 2000 using DBLib in freeTDS 0.63 RC11 (gcc 3.4.3, RH 9). I am getting an error message that I cannot find any documentation on. The server is sending back the following: "Received invalid row length 2 from bcp client. Minim...more >>

Greetings: I have to do a one-off forceful change of some data in a database. I need to disable some FK constraints, make the data change, and then re-enable the constraints. My process will be: ALTER TABLE TABLE1 NOCHECK CONSTRAINT FK_TABLE1_TABLE2 UPDATE TABLE1 SET COLUMN1=2 WHERE COLU...more >>

I've got a table (TYPE, DAYMTH) where it is a compound key and the DAYMTH is a datetime but all years are 1900 ONLY THE day and month are significant. What I want to do is for each type, find the next n dates - so for example: TYPE DAYMTH 1 1900-02-20 1 1900-05-05 1 ...more >>

Is there any way to do the following? select Max(FieldOne) From ( spGetSomeData 100,'test' ) Or do I need to define a view and have the stored proc use that view? The stored proc does some things with temp tables that would be difficult to replicate with a view which is why I'm asking. ...more >>

Hi, We're currently planning to migrate from SQL Auth to Windows Auth. Personally, I do not have too much experience with Windows authentication but have heard that there are some problems when working with it. The problems I've already ran into were: "Cannot Generate SSPI Context" (which I've...more >>

Is it possible to tell sql server to cast to a datatype and set the field length to a variable. e.g. :- declare @flen int set @flen = 10 select (cast somefield as char(@flen) newfield) into newtable from sometable I have also tried :- select (cast somefield as char(max(len(somefield...more >>

/* This is a long post. You can paste the whole message in the SQL Query Analyzer. I have a scenario where there are records with values pointing to wrong records and I need to fix them using an Update statement. I have a sample code to reproduce my problem. To simplify the scenario I am tr...more >>

I know to disable all constraint in a table just : ALTER TABLE table_A CHECK CONSTRAINT ALL but how to disable ALL tables at the same time? Thanks anyway ...more >>

Hi, I've got two primary keys in a table: Constraint(QueryId, ConstraintName) In a stored procedure I select {QueryId, ConstraintName} couples that match some criteria, and what I want to do is specifying in my a SELECT statement that I want all of the {QueryId, ConstraintName} that are not...more >>