My regards for all on this NG! My client need to use Windows 2003 Server, but it have some databases and systems that use SQLServer 7.0 I need to know if MS SQL Server 7.0 can be instaled and if will run with no problems into Windows 2003 Server. Thanks a lot!! Lucio ...more >>

Hi, I have set the DB to auto grow by 30 %. As well I have set it to unrestricted size.... However , I see the available size continually being reduced to now less then .54 MB... Why is there not enough available ? G ...more >>

Having trouble with this assignment. My teachers say it should work but it just doesn't. This part of a macro is designed to take payment from the cost and show the balance owing. What am I doing wrong. The sql is shown below. No error message is showing but the process still dosen't work. ...more >>

Dear Group Can anyone provide a sample query for the following scenario? Let's assume I want to search for an order someone placed which might be an individual or company. An individuals first name is stored in column FirstName And the individuls last name in column LastName of the contac...more >>

Select Cast('100.1234' as float) give me the result 100.1234 Now when I convert it back to char I want exactly 100.1234 Select Convert(char(100),Cast('100.1234' as float)) Gives me 100.123 (Here I was expecting 100.1234) When I do Select STR(Cast('100.1234' as float),25,4) I get back the re...more >>

with datediff all I can get it to return is months or a total of the days... so if the difference in dates is 12 months 4 days how do I adjust the SQL to accommodate both? ...more >>

I have a table that contains articles (as in, newspaper articles, blog articles, whatever). I need to use a column of type uniqueidentifier because one of the requirements is that I be able to write the articles out to XML or import them from XML, and references (as in, "for more info read this...more >>

Hi, I=B4m facing teh following situation: This are just sample table names, but should do for discussing purpouses. Create table Invoice ( InvoiceID Integer Not Null, CustomerType Integer Not Null, CustomerCode Integer Not Null, Amount DECIMAL(10,2) Not Null, ....................more >>

Hi there. As you will see from my questions, I am an SQL newb. I dabble but never get to spend enough time to get proficient so base any feeedback on that basis please. This is all theoretical information at this point so I am also going to post this in a MySQL related group. I will create s...more >>

Is there any advantage to doing this: ALTER TABLE testtable ADD CONSTRAINT PK_sysUser PRIMARY KEY NONCLUSTERED (UserID) WITH FILLFACTOR = 100, CONSTRAINT IX_sysUser UNIQUE NONCLUSTERED (UserID) WITH FILLFACTOR = 100 GO over just having the primary key? Does having both ...more >>

Hi, Is SQL Query Analyzer available anywhere as a stand alone application? Thanks...more >>

I know in SQL Server the terms Database and Catalog are used interchangably. But a table is also assigned a schema. As seen in the INFORMATION_SCHEMA.Tables View. I don't get what this schema qualifier is all about. Like if a table has a schema of dbo. Can someone explain the relationship the ...more >>

I need some help. I am trying to write a query which does the following SELECT * from table1 where field1=(SELECT distinct field1 FROM table1 WHERE field2='2005' or field2='2010') I need all the values from table1 which match any value from field 1 from the subquery. Any help ...more >>

Hi Group It's a rainy day and because of pure boredom have right-clicked a row in EM and selected 'Properties'. Just being curious what the dialog coming up is all about (call me ignorant!) and where I can find more information (Keyword?)in BOL? One thing I wonder however and maybe some...more >>

Hello, I have problem with linked servers (MS SQL Server 2k)- when I try to execute query(update, insert..) with linked servers, I have message Login failed for user 'null'. This is very strange problem, some computers in AD (2k3 std) don't have this error, when the other have this problem for f...more >>

Let's say i have a database with the following structure and data tablename: customers customerID| customername | PictureID| 1 | MyCustomer | 1.jpg | 1 | MyCustomer | 1_1.jpg | 1 | MyCustomer | 1_3.jpg | 2 | MyCustomer2 | 2.jpg | 3 ...more >>

Hi, I need what would be similar to a cross tab query in Access. First Column down needs to show all the months, column headings would be the day of the month.... 1 2 3 4 etc... Jan Feb Mar etc how do i set this up in a stored procedure? any help to get me in the right dire...more >>

I am a developer and I have a problem trying to design a system to manage data coming from web surveys. Each section can potentially have dozens of questions, i.e., fields. I am focusing here only on the table(s) that will hold the survey data. I do not have any DDL as I am still trying to under...more >>

I have an application that segregates data into two different databases. Database A has stored procs that perform joins between tables in database A and database B. I am thinking that I have reached the limits of Application Roles, but correct me if I am wrong. My application creates a connectio...more >>

I have a table called WorkItem. It models a chunk of work done during a working day. It has two columns that I'm interested in: Start (smalldatetime) - the TIME the work block is begun Duration (int) - the duration in minutes of the work block. In another table called OvertimeRates I hav...more >>

OK, i'm trying to do some error checking on stored procedures and am following the advise in Erland Sommarskog's 'Implementing Error Handling with Stored Procedures' document. Can anybody help with my stored procedures and why it keeps erroring at the '-- Create new Address Detail stage'? The ...more >>

Hi all, I am thinking of opening a case with Microsoft unless someone else has seen this bug before (or knows a quick fix, BESIDES using a temporary table). DECLARE @T TABLE (CHECKDATE VARCHAR(50)) INSERT INTO @T SELECT '01/01/2005' INSERT INTO @T SELECT '02-02-206' -- bad value INSERT IN...more >>

Two Servers, 1st 2nd database a -------> after replication a' b' <------- after replication b on 1st server a is replicated to 2nd on 2nd server b is replicated to 1st I tried with merge replication it i...more >>

I am creating a drill through that will go out and find the correc report out of 27 that equal my 2 parameters NAME_ID and DETAIL_ID. Does anyone out there have any ideas for me? I can make it conect to report. I do not know how to make it search for the correct repor ...more >>

We have a transaction record that, for the sake of brevity, I will us a simple paradigm to convey my need: A sales clerk sells several pairs of shoes over the period of a day each & every day the clerk works. Each transaction is recorded i a database. All clerks use a single physical register b...more >>

Hi I have a problem to insert(update) a long text (more than 64K) into SQL 2000 (datatype - 'text'). It cuts the data and insert only 64K. MSDN says: "When the ntext, text, and image data values get larger, however, they must be handled on a block-by-block basis. Bot Transact SQL and the datab...more >>

I have a database with three tables tbl_listings - listings of houses on for sale tbl_intersted - table which tracks if a user is interested in the listing, it has two columns mls(the key for tbl_listings) and user(user login) tbl_review - table which trackes if a user has reviewed the list...more >>

Environment 1)We are using VBA,MS Access 2000/2003 and SQL Server 2000 in our project. 2)We need to use Rational clear case as the SCM tool. Our Work Our work primarily falls in developing SQL Server stored procedures, functions and few VisualBasicForAccess(VBA) code. Technical...more >>

I can't get SQL Server to install and I can't figure out why. All I am doing is trying to install SQL Server 2000 on my Windows XP Pro (SP2) dev machine. But it just hangs - the processes SETUPSQL.EXE and SQLSTP.exe load and do nothing... Here is the full chain of events that has lead me to...more >>

Hi all, I am brandnew with SQL2000, so sorry in advance for stupidities.... SQL2000, SP3, running on a SBS2003-server with WindowsSharePoint Services. I want to make a dataconnection (from within the LAN with InfoPath) from a client to this server. I got the error that whether the server ...more >>

Assume I have a table like: CustomerName OrderDate OrderPartID London 7/7/99 33 Paris 7/6/99 22 Rome 7/5/99 22 London 6/3/99 44 Paris 6/4/99 11 Rome 6/20/99 99 London 4/3/99 12 Paris 4/4/99 13 Rome 4/20/99 94 I a looking of a singl...more >>

Dear Group I'd be grateful if you can give me some advice on the following. An application I wrote uses an MSDE backend and I wonder whether there's a way (even for the system administrator) of not seeing or tracing stored procedure code, view and table designs? And I also wonder whether ...more >>

Dear all, I have illustared with code and sample output data my request in thsi post. I simply was expecting some results from my search "amd socket a 32 bit cache 512 dell" that includes a logical AND for all the words in that search. Since i assume that any word might be an item_name, item_key...more >>

I am writing a program in .Net to retrieve properties of Sql Server. How can I find the following properties without querying the database: 1. Replication enabled 2. Default language 3. Processors and threads running. Thanks, verve ...more >>

Newby question but can't find it myself. How can I get a file-description from a file / table ? eg. the decription must deliver the following info: Record nr. Field nr. Fieldname Field description Data type Lenght Decimals etc.... Can somebody please tell me what to do? Thanx...more >>

I have a database with 2 users - 'dbo' and 'user1'. Currently: => 'dbo' is tied to login - 'login1' => 'user1' is not tied to any login. I want to change the login tied to the database users to: => 'dbo' tied to no login => 'user1' tied to 'login1' I try to use: sp_change_users_login '...more >>

Hello, At work we have various servers, therefore we have various DTS Interfaces which transfer data between them. However when trying to save a new View to one server which gets its data from another server nothing happens, I get an hourglass and nothing else. Then I have to exit out of ...more >>

I apologize ahead of time for the long post... Background: Working on a CRM type custom application. The application is for an event management company. The company will provide the application for other organizations to manage their own events. The events include conferences, corp meetings, ...more >>

I am reading Administering SQL Server, a study guide for 70-228 on page 27, it says: "INSTEAD OF triggers are useful when a DML operation is unsuccessful." I think this is nonsense. Any comments? ...more >>

I have masde Installation which have to execute dts packages to connect to my sql server and load the data to the SQL databases. Would anyone have any experience with this and know how to make this work? Thanking you in anticipation. Ajay Garg ...more >>

Hello, the following problem: I use Delphi 6 to access a MS Access Database. In short, the Delphi Code looks like this: ADOConnection1.Open; ADOQuery1.Close; ADOQuery1.SQL.Text :=3D 'SELECT * FROM database1 WHERE value1=3D1 AND value2=3D ' + ...more >>

Hi All, I am having a serious problem of removing and adding again an user in a database. Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack Somehow, the u...more >>

Is there an way to create a table of months using SQL functions? If "July" is entered for the beginning month, and "December" is entered for the ending month, then I'd like to create a table with 6 rows, one for July, August,....December. Thanks. ...more >>

Hi, I have a table with composite key: ID1 and ID2 and it also has a priority field. I want to get all the information for all records with the minimum priority group by ID2. How can I achieve that? Thanks. Donna ...more >>

hello I have strange problem. I write to MySQL data to table with one column of varchar(8000). I write 750000 bytes, so it get 93 records of 8000 bytes and the last - 6000bytes. but what is strange - when I check length of this records: select len(column_name) from table_name this last r...more >>

Hi Guys! Is there anything like cross tab of access in sql server? Thanks. ...more >>

I am new to SQL, as old as it is. I am not new to programming I normally just use Access. I have two tables for a little project manager I made. After updates I sent an email to the user. I need to populate the user based on the "Assigned To" field I use, but I only log the username and not th...more >>

I can't get a script to run that's supposed to generate a Query Parameters dialogue to take inputs and then run the query - for example, the following .. . . and fl.flow_name = [[TRUE][FLOW NAME][@?]] .. . . generates SQL Query Analyzer exceptions about "Incorrect syntax near 'FLOW NAME'....more >>

hello How could I check how many chars are in record, defined as varchar(8000). It's obvious that in such defined record could be 1 char to 8000 char. But what query to SQL database should I post to give information about realy lenght of this records ? thanks from advance Adam ...more >>

I want to distinguish between static SQL, dynamic SQL, and embedded SQL, but couldn't find too much useful resources in the web. For example, if we put SQL statements (SELECT, INSERT, UPDATE, etc...) inside an application (e.g. Java application, VB application, etc...), do we consider those SQ...more >>

Hello, I am selling "Microsoft Office Standard Student and Teacher Edition 2003" the price is only 70.00$ including shipping ANYWHERE!!! The price is real,quantity available-10,you can either buy retail or only one copy,for more information please visit the auction on epier: http://www.epier....more >>

Hi all, I'm trying to run a select where a uniqueidentifier/GUID equals a hex, but I don't seem to be getting matches. For example, this query returns the expected record: select * from items where itemGUID = '{11111111-2222-3333-4444-555555555555}' But this one does not: select * from...more >>

Hi to all. Many times i saw that some people wrap the single insert, delete or update statements to transaction. My question is suppose i have procedure , and inside this procedure i perform update i exatly know that only one row will be updated , is necessary or when i need to wrap it with...more >>

I have an ODBC 3.0 Application on Windows NT Server maintaining a connection to a SQL Server 2000 database on the same machine. When an error occurs, I'd like to be able to determine whether the error is serious enough that the database connection has been lost, so I can have the application try...more >>

I have a table as below --------------------------- name linkcode level --------------------------- brando 1,3,8 1 damroo 1,5 2 rogers 2,7 1 shane 1,7 1 Now I want a query where I pass a level and linkcode (one of the codes in Comma Seper...more >>

A stored procedure was running slowly so I took the code, removed the subselect and included a join, then took the max and included as part of a correlated subquery. The result is below, however, this is no improvement over the original. An advice would be greatly appreciated. SELECT FSALT....more >>

Hi, I'm trying to find out if we can use bulkcopy via odbc in sql server 2005. With sql server 200 we could use the odbcbcp.dll. I can not find any info regarding this for ms sql server 2005. Thanks, Jos van der Velden ...more >>