Hello everyone, My company uses a FoxPro database right now as an interface and a database. For our situation, I have come to the conclusion that it would be a better choice for us to move to an SQL server of some sort. I have been given the task of overseeing the overhaul on the pro...more >>

Hi everybody! I'm working on a migration from Informix to SQL Server... I'm doing it through DTS and ODBC. What I'm doing is using the DTS, my data origin is tha Informix database and mi target is the SQL Server database that I just created, this is via IBM Informix ODBC and I copy the ta...more >>

I am getting this error while uploading a text file in a table: Error at Source for Row number 7370 Too Many Columns Found in the current row;;non-whitespace characters were found after the last defined column's data. Then I copied the row 7370 in one file and tried to only upload that. I ...more >>

With SQL 2005, did Microsoft introduce login triggers? I seem to remember hearing something about it but, I don't remember exactly what I heard. Thanks, JD ...more >>

Can anyone tell me how a program like this might work: http://www.red-gate.com/products/SQL_Data_Compare/index.htm I want to backup databases into a central repository but I only want the records that have changed for that day. This program seems to do it efficiently. Does Sql Server, Oracle, ...more >>

Hi all Could someone help me with the following problem? Hours of googling yesterday couldn't get me the answer. I'm using SQL 2000 and DTS and trying to import a huge fixed width text file. File is >1m rows and >200 columns and is defined by a proprietory (i.e. not bcp produced) for...more >>

Alright, so I have this problem. I want to make it easy for me and others to be able to run a query and easily choose whether we want Merchants or NonMerchants. Previously, we would have to comment out bits of code and would leave things messy (it would also leave room for error). So, I'm though...more >>

SQL Server 2000 (DDL below) If I try to run this code in QA: SET IDENTITY_INSERT tblAdminUsers ON INSERT INTO tblAdminUsers (fldUserID, fldUsername, fldPassword, fldFullname, fldPermission, fldEmail, fldInitials, fldLastLogon, fldBatch) SELECT fldUserID, fldUsername, ...more >>

Hi Folks! I have a strange thing happening; I have a field that Counts the number of records and another field that shows the number of clients (Count(RecordID)=3 and NoOfClients=2) When I do a simple expression "Count(RecordID)/NoOfClients" the expected result should be 1.5. Instead th...more >>

Ok...here's a good one. I wrote an ADP application in ACCESS XP with a SQL 2000 back end. Works Great! Recently we did a server migration and transfered the database to another server. Setup all the groups and security without a hitch. My users change the Connection to point to the new serv...more >>

Hi Does anyone know if there is a possibility to run a DTS with parameters ? David Greenberg ...more >>

Hi, I have a stored procedure that has to extract the child records for particular parent records. The issue is that in some cases I do not want to extract all the child records only a certain number of them. Firstly I identify all the parent records that have the requird number of child...more >>

Hi, I have a large SQL Server 2000 database with 3 core tables. Table A : 10 million + records Table B : 2 million + records Table C : 6 million + records One of the batch tasks that I have to perform firstly builds a list of all keys for records from each of the three tables that I need...more >>

Hi guys, I wanted to ask you for help as I am struggling with it second evening already... I have got tables DEVICES and PARTS. One device can consist of multiple parts. But... I have also another table - FILTERS (id int, type int, is_not int, phrase varchar(40)) where:id - just id, t...more >>

if I install SServer Express Edition Can I connect to SServer 2000 DB ? thanks ...more >>

Situation: at work we have a windows 2003 server with MS sql server 2005 express. With my pc at work, I can see my own database I created. At home. I can connect with VPN to the network. With extern desktop I can see the database and do everything. Now I want to create a login with visual web de...more >>

this is a slight change to a fequently asked question around here. I have a table which contains a "sortorder" column where a user can specify some arbitrary order for records to be displayed in. Users have sometimes ordered records the way we used to number lines in a BASIC program (10,20,30,...more >>

I was looking through our vendors views, searching for something I needed for our Datawarehouse and I came across something I do not understand: I found a view that lists data when I use it in t-sql, however when I try to use the statement when I modified the view (via MS SQL Server Management S...more >>

Hi! I am able to add records to my SQL 2005 database using bound forms in my Access application, but if I try to edit any records (not only the new records I create) using the same bound forms, I receive a write conflict. For the record, I am currently the only user of this application and ...more >>

hello! i'm looking for resources on database analysis. my main questions are: how does one determine the primary key of a table, and, how does one determine the relationships between the tables? if you know of any tips, books or websites, i'd love to know. my current skills for such quest...more >>

Hello I am using sql server 2005. I have two tables as described below. Table1 UserID UserSales --------------------- 1 10 2 13 3 17 4 19 5 21 6 10 7 12 8 ...more >>

I have a table with 4 relevant fields (blank lines added for clarity). State, City, Name, Primary_Contact IL, Springfield, Bill, n IL, Springfield, Frank, n IL, Springfield, Larry, n IL, Bloomington, Steve, n IL, Bloomington, Chris, y IL, Chicago, Betty, n IL, Chicago, Linda, n IL, Chic...more >>

This post is related to SQL server 2000 and SQL Server 2005 all editions. Many of my stored procedures create temporary tables in the code. I want to find a way to find the query plan for these procs Repro --*********************************** use pubs go CREATE PROCEDURE Test @percentage ...more >>

I don't know if this is possible, but I haven't been able to find any information. I have two tables, for example: Table 1 (two columns, id and foo) id foo --- ----- 1 foo_a 2 foo_b 3 foo_c Table 2 (two columns, t1_id, and bar) t1_id bar ------ ---- 1 bar_a 1 bar...more >>

I have a question on coding, just want to see if there is a better way to do this. Here is some sample data combinations that would come from 2 different tables. Item Method Price Cost Percentage A-1 L 100 50 10 A-2 D 110 55 15 A-3...more >>

I downloaded Quest Software's freeware version of Comparison Suite. When I attempt to install, it tells me that it requires .NET framework 1.1.4322. I already have .NET 2.0 installed (as part of the MS-SQL native client install) and I really don't want to mess that up. Is it *safe* to have ...more >>

I have a table called class_time. and the column name is start_time. datatype is datetime. id start_time 2 1900-01-01 15:00:00.000 4 1900-01-01 17:12:00.000 i want to the convert the start_time column into a format that only has the hour and minutes plus AM/PM ( for example, 3:00 pm,...more >>

(SQL Server 2000) I want to aggregate some data from a table, and because I'm going to feed the result set into a union, say, I want to put another column on there to carry some information that I know will always be the same in this particular result set. Simple example: I have a table Dim...more >>

"I have build a long sql data load script. What is the best way to do Testing of the script? I would like to automate the test!" ...more >>

I have a customer that purchased a program that uses the free version of MS Sql Server. I think it's called MSDE. This runs some expensive robots from data within the SQL Files. They are however in need of some indexing or something else as they are beginning to run very slow. Is there some ...more >>

Hi All, We have a budgeting table and a budgetAssistant table, I have 3 employee ID's, I need to assign each of them as budget assistant. Do you know of a quick update query I could write to accomplish this? The budget and budgetAssistant tables both have a budgetID field. Any ideas? I ...more >>

I am using the following C# code and T-SQL to get result object from a SQL Server database. When my application runs, the ExecuteScalar returns "10/24/2006 2:00:00 PM" if inserting a duplicated record. It returns null for all other conditions. Does anyone know why? Does anyone know how to get...more >>

Is it possible to run both SQL200 standard and SQL2005 Express on the same server? I need to test a database created in 2005 on our production server but don't want to upgrade our "live" databases yet. ...more >>

Brand new to this tool, and I am constructing a few queries. I am used to having a column list pop up when referencing table names in queries - the lat couple of products I used provided this feature. Is this available in the SQL Server Management studio tool - if so how? Tnx Gary ...more >>

Hi all I am having a SQL Server database of arround 110GB and 250 Users. What is best suited hardware requirements for handling of such a database. I am having following requirements from the server: 1. Feeding purpose : On which continously feeding is done by average 200 users. 2. Reporti...more >>

Hello, I want to generate a SQL Script of a SQL Server database. To do this, I right-click the database name and choose the option All Tasks/Generate SQL Script. Than I get a text file with a script that generates all objects, but the order in which the objects are generated is wrong. There...more >>

Hi, I've got a machine with about 750 databases on it, and growing. Enterprise Manager is very slow coming up on this machine and I was wondering what I could do about it. What's it doing, connecting to every database? ...more >>

Does the order of columns make a difference in the GROUP BY? Woulde GROUP BY A, B, C return different results than GROUP BY C,A,B ? ...more >>

Hi, I have no idea about SQL Server. my first question is, SQL server usually mean "MS" sql server. right? Also, my second question is, I made a webpage with PHP to connect My SQL. However, if i want to change from My sql to MS sql server, then how can i change the webpage? can I do it wit...more >>

I have build a long sql data load script. What is the best way to do Testing of the script? I would like to automate the test! ...more >>

I made ahuge load script in SQL Server 2000 as i load data from many tables(select some of each one collumns) into one single table and i want to test the loaded data against the selected data to make sure that the loaded data is the same the selected data is there a code or tool to make this te...more >>

I have a table with 6 million rows. I'm trying to perform a group by query that incudes a row count of the PK column: SELECT COUNT(DataID) AS Cnt, Column1Name FROM dbo.TableName WHERE (Column2Name = N'p') GROUP BY Column1Name I have the query timeout set to 0 in Enterprise Manger. However...more >>

Hi! This is what happened to me and my colleagues. We are using SQL 2005. When we were building a view from a table, the field we selected was not what came out in the output. Let's say you have 2 specific fields in the table, the second one of them begins with the letter "L". While your mou...more >>

Hi, I have been working on a code generator to convert a .SQL script to 1. html forms for data entry and editing 2. Perl scripts for saving the data to a given database. 3. Scripts to preview and edit A given row of data. As I was unable to find such a tool online The current version of the t...more >>

Hi all, I am new to these so plz never mind if this is funny. here is my problem : Table : moody Column : Title New column : Nospace I have data in "Title" column of many rows which are normal sentence. My requirment is to remove the "white space", +, | , ., / , ! @, $, % etc s...more >>

Hi alll I have these tables below with 3 fields each. I want to get the record in table 1 whose field number value is same in table 2 but field number 2 on both tables are different. I mean i want the record 1500 800 2. Insight: Table 1 is modules ordered and table 2 is modules delivered. I wan...more >>

Hello, I need to store the start and end time of each weekly class into a database. so that people can easily search for classes based on time. for example, someone might want to search all classes that are offered between 9am and 2pm. How can i implement this time field? i don't have a date ...more >>

Does anyone know how to do the following. I'm trying to mimic replication with triggers. I have 2 databases, each have these 2 tables. 1. USERS ID int NAME varchar(20) 2. CHANGES TABLE varchar(20) TYPE varchar(10) col1 varchar(20) col2 varchar(20) On the USERS table I have a for...more >>

(New to SQL Server Installs) I installed SQL Server 2005 Developer Edition on a WinXP-SP2 workstation and can see some enterprise databases on the network just fine. My problem is I cannot register a local database on the local drive for testing/education purposes. (I accepted all of the d...more >>

hi friends i need help in this sql query i have table like, id fid __ _____ autonumber text and i am storing values like id fid ___________________________________ 1 1,2,3,4,5 2 ...more >>