Hi All, Just wondering if anyone can tell me if tables in SQL Server 2000 default to a native logical ordering, particularly if there's a primary index on a field? IE, if I have a primary index on column member_id, and I do a select with various criteria but which doesn't have any order by cl...more >>

Can I create a new database using sql from outside sqlserver? for example can I send sql code to the server to create a database ...more >>

I know there are several parameters that can be set regarding server performance like memory and CPU. Is there any performance benefit to changing those settings from the default settings which essentially look like they are "all processors" and "all memory"? In other words, can I increase data...more >>

At the outset I apologize for this question, if it looks inappropriate here. There is a debate going on in oracle newsgroup about which database Microsoft is using for its internal implementation of SAP at their HeadQuarters. Per them it is Oracle, even though this one mentions it as SQLServer...more >>

Hi: I am starting to rip my hair out. I pretty much tried everything. I want to insert following values: sqlString = "INSERT into myTable (ProductID, Name, Title, CategoryID, Organization, Address, City, State, Zip, Country, Phone, Fax, Email, Heard, Referral, Computer, Implement, Descr...more >>

Hello - I have a fairly deep understanding of Oracle architecture and features for implementing quality data warehouse applications. I have some experience using SQLServer. Can someone recommend one or more books on SQL Server that discuss how to effectively exploit its features to implemen...more >>

Hi, all: I've got a table listing height measurements and their primary keys. For example: HeightTable: HeightID Height ----- 1................5'5" 2................5'6" 3................5'7" and so on... In another (linking) table, I've got a listing of people with height rang...more >>

Hello When using SQL server agent to schedule jobs, the minimum time between reoccurance is 1 hour, I need a SP to be run every 1 minute, is there an easy way to do this or do I need to write a VB (or similar) application to do this? regards Matt...more >>

With SQL 2000 can you encrypt data at the column level in a table?...more >>

Hello Some SQL guru please help me. I have bashed my brains using GROUP BY and HAVING but no luck. I have this table: id pn pf qty Loc 1 1234 1 1 aa 3 222 0 2 bb 4 222 1 2 cc 5 444 0 1 dd 6 444 0 2 ee 2 321 0 3 ff I need to get back the...more >>

i have three tables BOOKING bookId int uniqueidentifier bookOp varchar(255) BOOKING_DETAILS bookid int z_id nvarchar(255) detail nvarchar(255) BOOKING_STAFF bookId int staff nvarchar(255) z_id_row. I can create the relationship between BOOKING.bookId = BOOKING_DETAILS.bookid AND ...more >>

hi, I need to convert columns to rows here i have sample input data weekno manager1 manager2 51 33454 26749 52 33454 26749 i wnat the output like this weekno manager 51 33454 51 26749 52 33454 52 26749 colud u please help me out how to go a...more >>

Using SQL Server 2000 sp1 on windows xp pro. We sometimes use the formatmessage() function in a union query.to return a language-specific label such as '<All>', which we want at the top of the list. We've noticed that it seems to affect the sort order of the second select in a subtle way. Here...more >>

Hi, all, I have a simple jsp page which conneced to mysql database with no problem, but after I changed to production database server, MSSQL, I got nothing returned. I did changed jdbc drive, etc., please help. Thanks in advance. For example: in MySQL: -------------------------- 20040301 01...more >>

I am developing a database for a local business directory using SQL 2000 and I would like to be able, not only to validate email addresses, but also to verify that they actually exist. Is there a way to do this in SQL 2000? I also want to do the same thing with website addresses stored in the d...more >>

I need some information to understand what is the impact of Database size on the performemce. Few questions : 1. Is there any impact? 2. Does one very large table impact the performence of the the whole DB, meaning the overall performence and access the other tables. 3. What are the ...more >>

Dear Group I'm having trouble with the SQL statement below that works fine if not run as dynamic SQL but fails with an ambigious column name error on 'Status' if build dynamic. I explicitely qualified 'Status' with the table prefix but no luck. I reckon dynamic SQL doesn't recognize my tabl...more >>

Hi All, Just wondering if it's possible to retrieve a table's column names via SQL in SQL Server 2000? Any help appreciated! Much warmth, Murray...more >>

Im looking for reason of following error of mail-service [State=37000][Error=18025][Microsoft][ODBC SQL Server Driver][SQL Server]xp_sendmail: ist mit dem Mailfehler 0x80004005 fehlgeschlagen Michael ...more >>

Hi All, I'm running a one-time procedure to convert some data from an old format to a new format on SQL Server 2000. I've tested the procedure on a small DB, but now I'm running it on the main test DB and it has been running for an hour. I'd like to know when it is going to finish. Is...more >>

I have to implement a web server for a b2b solution. Customer doesn't want to use the SQL database used by applications. I think to use a new Sql server 7 on a server located in the dmz and use replication with transactional agent to sincronize the two databases. Is this the correct way to proce...more >>

Hi, I was wondering is there a way i can query a database to find out what tables there are in the database which are user created, then using something like vb loop through to find out details of each table in turn, i.e. Table size, rows that kind of thing. Ive been searching all over the ne...more >>

Dear Group I'm having some boolean values in my database which I'd like to display as 'Yes' for True and 'No' for False in my application datagrid. Is there any way I can do this at stored procedure level? I'm looking for something like an 'alias' for a value. The current SQL Statement loo...more >>

We have a stored procedure that generates a rather complex report on a daily basis. The query is very resource intensive and causes other OLTP processes to time out due to extended delays. We have tried to optimize the query as much as possible, but it still seems to cause problems. The same ...more >>

Hi there, I am trying to process Update/ Insert in one SP, through the use of a boolean variable. The SP is defined as follows : CREATE PROCEDURE dbo.[UpdtMaster] @whattodo int, @icode int, @iname char(100) AS if @whattodo = 0 begin Update ...more >>

Hi - I'm quite new to SQL Server - and wondered about backing it up. Some of my tables have relationships, which need to be retained - eg. tblCustomers --cust_id --cust_name --cust_address tblOrders --order_id --cust_id --order_amount etc. where the reltaionship is a one to many f...more >>

Dear Friends, Sql Server 2000 While creating the database script using EM right-click the database to script, point to All Tasks, and then click Generate SQL Scripts. This creates a script with owner of the objects, like CREATE TABLE [usera].[tbl_wi_lookup] ( [wi_lookup_id] [int] IDE...more >>

Hi, I am trying to connect a form in an access data project to a stored procedure on our SQL server. Without parameters, all I have to do is make a button on the form with a "run stored procedure" function attached to it. The code in the "run stored procedure" function that works when there...more >>

I've got a development database in sql7 running on a local machine. I have access 2003 and or enterprise manager (sql 7) for tools I've got a new hosted sql server 2000 account that will be my production environment. How can I get my dev. db to the new server? Do I need enterprise manager 200...more >>

1. I contend that it is NOT POSSIBLE to write a *meaningful* application that is completely database independent. 2. Anyone attempting to develop a vendor-neutral application will eventually be forced to make the following decision: - Write to a common standard (i.e., ANSI vanilla SQL), and esch...more >>

I'm building an e-commerce app and am keeping the client facing front end on a live web server and the admin section of the app on a local intranet server. All data is stored in an SQL DB on the live web server. I will be having in the region of 500 product images in the app and am looking for...more >>

Having problems getting my destination table to populate. I justed added 3 new fields to the source and destination tables: 1.[Group] 2.Empl 3.Sales My Source table has these 3 new fields poplulated, but sends not data to the destination. Could I have a syntax proiblem? Help appreciated. Thanks...more >>

Hello I am having some troubles with my cursor declaration, it looks like this declare journalhead cursor for select distinct bestnr from ##q_inlevextsystem where not exists (select count(*) from jibp where bestnr = @bestnr) I am trying to read from a global temp table, but I only want t...more >>

How do I get the column nams/ids in ROW of my query. Or how do I export them with the data? In Microsoft Query Analyzer I do the following select * from goober column1 | column2 | column3 | column4 data 1 | data 2 | data 3 | data 4 data 1 | data 2 | data 3 | data 4 data 1 | data 2 ...more >>

The SQL-server shall every day at 12.00 o clock import a XML file, anyone that can help me making this task? //Peter...more >>

I am trying to install the SQL Server 2000 Client Tools on a Windows Server 2003 Terminal Server (Standard Edition). I keep getting the same error message stating that the "product key is invalid". I have unsuccessfully tried the Developer, Standard, and Enterprise editions of SQL2K just to se...more >>

Hi there, I would like to know the difference between the Output parameter and the Return parameter sent back by an SP. In what situation, which is to be used. Further, how does one catch these parameters coming from the sp in Vb.net. Regards, and thanks in advance for your time, Sanj...more >>

Hi all, I have defined one primary index - PK_CODE, and another secondary index - IX_NAME on a table, with the objective of faster accessing the table contents based on the code and the name, respectively. In Query Analyzer, how does one switch between the two indexes. How does one tell SQL...more >>

hi, i have access database storing date values as datatype string no i want record of dates between 2 dates i mean select * from table where (adate) between '20/03/2004' and '02/04/2004' some times this workds but it compares only first 2 characters above result gives record with date mo...more >>

I have the following stored procedure that I use for sending out data to web services from within SQL. The stored procedure itself runs fine with no errors but I keep getting errors in the event viewer everytime it runs. The two errors are 17052 errors. Error: 0, Severity: 19, State: 0 Sql...more >>

I recently upgraded a machine from SQL 2000 Personal Edition to SQL 2000 Standard Edition. The Setup Wizard guided me through the various options (just an upgrade, no additional components), and presented me with the "Finish" button to begin the upgrade. I pressed it, and the Setup program dis...more >>

We have a legacy COBOL application where the SQL access is granted through a Transoft interface U/SQL. Instead of bogging down the legacy server, we have installed an SQL server, of which one task is to pull in application data on a nightly basis. To do this we simply do a Transform task, [co...more >>

Hi all, One of our clients is using SQL7/SP4 and their database is working correctly with our application and not producing any errors. To help locate an intermittent problem with our application I did a backup of the database and returned it to our office. The backup went fine and was ver...more >>

Hi all, Our VB6 application uses MSDE 1.0 for the database at present and we would like to upgrade to MSDE 2000 in the near future. What's the recommended method of upgrading the database? Is it just a matter of backing up the database to a BAK file in MSDE 1.0 and restoring to MSDE 2000, ...more >>

I have a column which is data type 'int' Is there a way to pad this column with zeros? I want the values to always be 3 digits, ranging from 001 to 999 But with int data type, 001 turns into 1 Thanks, Stephen...more >>

I want to truncate a number to 2 decimal places. Here is an example of my current code: ResultSet rs = stmt.executeQuery("SELECT Date = convert(char(10), Date, 101), Incoming, Handled, Incoming - Handled as Abandoned, 100.00 * (Incoming - Handled) / Handled as AbandonRate") I want Abandone...more >>

I can use sp_spaceused @objname = 'pages' to find table sizes, but I would like to find and sum these results in MB for all tables that begin with something like "ph_". The table names would be something like 'ph_pages' and 'ph_calendar', and 'ph_news', etc. I will be doing this once for each gro...more >>

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 >>