I have a database (A) with one single table. I have a database (B) in an alternate location. I would like to move a subset of the data in database (A) to database (B) on a monthly basis. Database (A) is fed from a download of financial information which is imported from a text file. Once a ...more >>

I've looked on many different tools that microsoft has to offer in MSSQL, but i could not find the one that will do the following for me: 1 - the production database was set up 6 months ago, on the production server... 2 - the development database was set up the same time, had the same stru...more >>

From: hyper_x_43@yahoo.com (HyperX) Newsgroups: comp.databases.ms-sqlserver Subject: Can anyone please help me with this simple sql? NNTP-Posting-Host: 68.72.235.2 Message-ID: <4de684ec.0403271929.c6ed730@posting.google.com> Hey guys, This is a very very simple problem... Can anyone please...more >>

Hey guys, This is a very very simple problem... Can anyone please help me with this sql? I'm sure some of you would have come across this problem. I'm hitting a wall here... ----------------------My select command Begin...-------------- Select User, Item, Price, Qty, (Price * Qty) as Tota...more >>

Hey there, Does anyone know where there is a list of MS Sql Server 2000 functions that correlate to Oracle v 8i and above? Like date math is handled by datediff() in SqlServer, NVL is what in SQL server, etc. Thanks, Allan Palmer...more >>

Can anyone point to an example on the web or elsewhere of calling a stored procedure from Visual C++ (ideally from an MFC perspective, but anything would help) If it makes a difference, it is a just a select procedure that takes parameters for what to query and returns a table. Alternately, an...more >>

Hi, I want to make a stored procedure that returns either the NULL results, or the NOT NULL results from table comparison based on a parameter passed into it. For example, something like this: WHERE ((MyData IS NULL) = @ShowNulls) In other words, if the @ShowNulls parameter is true, show ...more >>

Using Rational Rose to reverse/forward engineer databases - functionality like that of Case Studio 2?????? First of all, where can I get a MySQL extension/plugin for Rational Rose / do I need one? I'm trying to create an ERD using Rose from a MySQL database. I've exported all the m...more >>

Corrupt SQL2000 DB with no backup for several days. Can the DB be restored up using latest backup, and then the log file used to bring it back to say midnight last night? Anybody know if this is possible, and how? Thanks S ...more >>

As a general rule, are there performance benefits in using Numeric columns as indexes over Char columns? If so, are there any sources which quantify this? I'm thinking, for example, of where one may have a Char(6) Customer Code which is used as the primary key, what performance increase, if an...more >>

Can I create an array (n-dimensional) on a field on a table? How can I do that? Tx ...more >>

Hi, I have SQL Server 2000 and 50 GB databas, on server is 1 GB free hard disk space. I try to delete data from tables but MS tempdb is growing tu much. Does anyone know a SQL command which delete for example 1000 entries witch special clause ? Thanks, Fibre Optic ...more >>

I am currently working on a SQL table in which I am calculating a percentage of several fields and then converting that number to a percentage. The formula is working, but it is giving me a number with 6 decimal places. What is the best way to truncate this number to 2 digits? Thanks....more >>

I am fairly new to SQL and in my Results Statement, I want to add and divide various fields of information but I am unsure exactly how the correct format should be for this function. Any help would be greatly appreciated....more >>

Hi, I have got a huge sproc which contains queries that create various temporary tables. Scenario - In simplistic terms - I end up with 4 temporary tables containing data that looks like: (The data comes from different sql tables) Month Sales A Jan 2004 20 Feb 2004 30 ...more >>

Hi All, I'm currently thinking about getting myself certified as an SQL Server 2000 DBA and I've been looking into this on the web. I notice that Microsoft itself offers e-learning certification courses, and I'm wondering if anyone here has been through these courses and if they offer a goo...more >>

This is a problem my collegue asked me for help with, but I don't see any light either. Neither of us has had a training in SQL, that's probably why ;) A simplification of the problem we have: suppose you have a table with a datetime column and a numeric column (for example the results of ...more >>

Just curious if indexes are automatically created on primary and foreign keys in SQL Server 2000 or do I have to create these manually? TIA - Rob ...more >>

I have a SQL Server 2000 view that shows the answers submitted via a feedback form, including the questions and the available options. The column headings are: QuestionnaireID, QuestionID, QuestionType, QuestionText, Element1, Element2, Element3, Element4, Element5, ResponseID, TextValue, I...more >>

Hello, I have the following table: ----------------------------------------------- ID | Reference | ----------------------------------------------- 01 | 12, 44, 1, 2, 4, 99, 50, 10 | 02 | 33, 55, 1, 5, ...more >>

Running SQLServer 2000 SP3. We have a problem with an application that sets the application role upon connection using sp_setapprole. Because connection pooling is enabled an attempt to set the role fails on reuse of the connection because it has been set already. This is documented, see:...more >>

We have a clustered installation with one server being a hot backup for another. If the first one goies down, the second one is started and one of the services launched is SQLServer. The service runs under a OS login id (not Administrator!), defined on the local domain. If the login is lock...more >>

Is it possible to just have the DTSRUN utility installed in a box to run the ..DTS file I have created? I just don't want to install the whole SQL server. Thanks. ...more >>

Hi there, i am wondering if anyone some sql statements that can determine the quartile.. eg: 8 numbers, 1,2,3,4,5,6,7,8 0th quartile: 1 (min(*)) 1st quartile: 2.75 2nd quartile: 4.5 3rd quartile: 6.25 4th quartile: 8 (max(*)) the quartile value is found by using excel. Thanks...more >>

Hello, I need a text box that the user puts in part of a name and hits find and it returns the values that contain the words. It works fine in when i type it in manually. SELECT * FROM table WHERE column_name LIKE 'value%' But im using a stored procedure taking a parameter from VS a...more >>

We have a SQLServer installation where the installation was made under a non-Administrator OS login (let's call is "sqlserver"). If patches and updates are being made to the middleware (SQLServer), should this login be used over all others? Second question: We make use of "firecall" OS login...more >>

Hi all, I'm observing strange behavior when accessing SQL Server 2000 via OLEDB (SQLOLEDB - native OLEDB provider for SQL Server). MDAC versions are: 2.7 and 2.8 (the behavior doesn't change). The strange behavior (see below) is consistent when using ADO and Visual C++ 2003 Wizard-generated A...more >>

Is there a way to create a new database and have the mdf and ldf files located on another physical machine? thanks -Jim...more >>

What advantages are gained by writing something as a view over writing the same thing as a user defined function that returns a table?...more >>

I recently got a big help with the question of how to compare two lists of words for matching content. The most effective solution was to join each list by the criteria being searched for. Then, all of the non-NULLs were matches, as follows: SELECT W1.List, W1.Word FROM (SELECT Word...more >>

Hi, I am using ASP form to upload the image (gif/jpg). I want to save this image into SQL database (Image Datatype), by passing this image content into stored procedure. Thanks in advance, Om Prakash...more >>

Hi, I have an existin DB in MYSQL with city and postcode stored as a single attribute, anybody got a trick for seperating them now, they are for germany so Postcode is just number, if that helps! ex: 60325 Frankfurt / Main 60486 Frankfurt / Main 68161 Mannheim 70771 Leinfelden- E...more >>

I want to run a SQL script from the command line (using ISQL) and want get the return status (ERRORLEVEL) Don't know how to do it. basically the script I want to run will use the master DB perform a number of select and stored procedure attach/detach another DB perform a number of selec...more >>

I have a table that contains a start date field. I would like to create a view or even just a calulated field in the same table that would show how many years this person was with the company for each row. Like: Today - StartDate = My calculated field in Years format. If I can't do this in a...more >>

I am switching over some tables to use a guid as the primary key instead of an int identity value. After inserting a new value in the table I'd like to return the new primary key value. When I used an int identity value I returned scope_identity() for this purpose. Is there a function to r...more >>

Is there any way to take a named instance and make it the default instance? I realize we may need to do something to the existing default instance (remove, etc). However the existing instance is corrupt (msdb columns missing) and I want to take my newly created one and make it the default. Thank...more >>

I need to write a script that will insert incremental numeric values into a table. I assume I could do something like this (partial script, not tested, not developed) x= 1 INSERT INTO Sometable (Column1) VALUES (x) x = x +1 loop back to the INSERT question My real question is that I want...more >>

how I see only user table ,view,... in sql server Manager?...more >>

Hello, I'm having a problem with a Linked Server Text Database. This problem occurs on SQL Server 2000 running on Windows 2003 server, but it works fine on XP system. I can read records when running a select query in the Query Analyzer, but when my ASP page executes a stored procedure to do...more >>

I have an SQL Server table containing about 7,000,000 rows. It has an index built on a column called dbStatsInboundDateTime, and another index on column dbStatsANI. The following query runs in about 1 second (returning zero rows): select dbStatsInboundDateTime, dbStatsEvent, dbStatsANI, dbS...more >>

Hi all we have a small SQL server 2000 database with the tables sat on a Raid 5 HD. The database backs up to its c: drive every night, and then the whole system is copied daily to Tape. Although the database is small, we are very aware that if the whole system died before the tape backup ...more >>

Hi all, Need a little help with recurring queries that I have showing up in data conversion scripts running on SQL Server 2000. The system keeps track of cases and case events. I have a demoralized "flat file" table that contains the case_id, event_type, action_date, process_date and user_...more >>

I'm in the process of writing some utility scripts which will interface SQL2K to our backup storage system, Tivoli. In our shop we "fire" the backup process from the Tivoli storage server by invoking a command scripts on the client server. The issue I've run into is that some of our servers wer...more >>

It has been suggested to me by one of my vendors that I need to have AUTOCLOSE turned on for my SQL Server 2000 backups to be reliable. I have never heard this before. Does anyone feel AUTOCLOSE needs to be set to True for Enterprise Manager/Agent/Jobs backups to be reliable? Please explain....more >>

We recently upgraded from version 6.5 to 2000. During the process the Wizard did not complete. It apparently built all selected databases but did not migrate the data. The last line in the summary log reads "Preparing SQL-DMO for upgrade=0". We decided to press on with the upgrade by using DTS t...more >>

Hi, I would like to create a front end in MS ACCESS that: 1. generates the SQL script to drop all objects in the DEV_Server_Database 2. runs the SQL script in the DEV_Server_Database 3. then runs the DTS copying the LIVE_Server_Database to the DEV_Server_Database (including d...more >>

I migrated Epicor accounting database from sql server6.5 to 2000 , everything look ok all table , storeprocedure , view and other things is in SQL Server2000. Then I ran Epicor Accounting program connecting to server , it connecting fine and open the system manager program (main screen). but wh...more >>

Hi, I wan to ask you a simpe question : Can ORDER BY in select command benefit from non-cluser index ? From my trial, using 1 million rows, it seems that order by can not benefit from non-cluster index. Below is the data : CREATE TABLE Test ( aa char (20) NOT NULL , bb datetime N...more >>

Hi, I've been looking on the groups all day, but the solutions I've found haven't worked, or aren't applicable....so here's what's up: mssql_connect(): message: Login failed for user 'xxx'. Reason: Not associated with a trusted SQL Server connection I don't get this message when I serve t...more >>

Greetings, MS SQL Server 2000. Our PrintManager server runs under the user 'PMPUser'. PMPUser needs to insert and update the JobLog table. I've granted SELECT/INSERT/UPDATE on the JobLog table to PMPUser. But the PrintManager still can not write anything in the JobLog table. Did I ...more >>

I am running into trouble because I have a stored procedure that accesses a large number of tables. Not all the users that I want to be able to run the procedure have access to all the tables, so an error is generated. Is it possible to have the procedure connect using a different user (one wi...more >>

IS there in the internet any collection of queries for Northwind. I need lot's of examples how to use select, where, having,group by .......... ...more >>

Morning All I have an issue with the formatting of data generated from a stored procedure that runs xp_sendmail. The results that are generated are sent in a standard text file format (have also tried .csv). Basically, it generates a five column results file that can have a variable amount ...more >>

I very much appreciate if anyone could show me way(s) to transfer a linked server from a SQL Server 2000 server to another. Thanks much again HN ...more >>

Hi I have a transactional log that size is 7286.12mb and space used is 548.42mb. When i shrink log to 1000mb i get something like this: Current size: 7286.12mb and space used: 623.53mb. I think that current size should be 1000mb. Why current size still 7286.12mb. thanks alex *** Sent vi...more >>

Hi I need some help importing XML files to my SQL-server. The SQL-server shall every day at 12.00 a clock import a XML file, anyone that can help me making this task? //Peter ...more >>

This is making me crazy and I'd appreciate any pointers. I have 3 tables (test1, test2 & test3). Test1 has pri key FirstColumn. Test2 has pri key "SecondColumn" with foreign key pointing back to Test1:FirstColumn. Test3 has pri key "ThirdColumn" with foreign key pointing back to Test2:Second...more >>

In the process of moving application data from from MSSQL 7.0 to a new server, it has been suggested to install 7.0 on the new server and then once the data is migrated and verified, then to upgrade to MSSQL 2000. I already have 2000 installed on the new server. Is there a program/utility/script...more >>

I'm having a little difficulty with adding bulk data into a table. The table is part of a third party app which I shouldn't really change, but will probably be able to get them to agree to what I want provided it gets changed back afterwards. We're looking to insert 30,000 odd records into thi...more >>

I am Inserting into a sql database from VB a single value , for example 'P'. The field is set up to support up to two characters. However, when I look in the table the record always shows as 'P ' (there is a space after the P). Can anyone offer any help on this. Thanks. ...more >>

Please help. I am trying to import a big TextFile (around 200000 records) with the following code, but failed. Please help: Set cnn = New ADODB.Connection Set rs = New ADODB.Recordset cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & "C:\Import" & ";" & _ ...more >>