Hi, I'm stuck on the following query. Any help would be greatly appreciated! table1: Customers uid, name 1, bob 2, jane 3, john table2: Purchases uid, custID, datepurchase, item 1, 1, 1/1/2004, mouse 2, 1, 1/2/2004, keyboard 3, 1, 1/3/2004, usb key 4, 2, 1/1/2004, mouse 5, 2, 6/19/2...more >>

Hi I currently have a problem with registering a new server in my Enterprise Manager on a new PC. I need to connect to a MSSQL2K server on a windows 2003. My current PC is on the same LAN as the server and has no problem registering the server in Enterprise manager. This PC uses NT (about tim...more >>

I've upgraded MS-Access 2002 to a MS-Access Project (adp), so now I have to deal with more sophisticated queries (may I call them so?) like stored procedures. I have a form with a combobox for selections and a textbox to enter a certain value. Let us say I call the combobox @select and the textb...more >>

I have 2 databases, one that we use called MyShop and one that I develop on called TestShop. After I have a stored procedure working the way I want in TestShop , is there a way to just copy the SP to the other database without the copy and paste method?. Same if I have a new table. Any way to a...more >>

Hi, Has any one ever compared the performance of calling a DataTable's Select method with a stored procedure doing the same thing? My point is: dataRows = DataTable.Select(filter) is better or Passing paramters to stored procedure? The datatable holds about 500-700 rows at any given tim...more >>

Hi all, I'm building an ASP app on a Windows 2000/IIS machine which interfaces with our SQL Server 2000 database via OLE DB. Since we're based in the UK I want the users to be able to type in dates in UK date format to input into the database. In Enterprise Manager on the SQL Server I can ...more >>

Hi. I would like to setup a job that monitors other jobs and will fail (so I can receive an email/or see it in the Event Viewer) when any of these other jobs have not completed after running for a set duration. Or more precisely, I would like to check if one of my existing jobs have freezed, ...more >>

Help, I have a database that has a data file of 2GB and a log file of 31GB. In enterprise manager, when I choose shrink it says there is 30GB of unused space. When I shrink the database, it does not shrink, (however it says it has completed). I've done a complete backup, tried shrink again, n...more >>

Hi, I'm trying to run a select statement that takes includes an if/else clause. I need to select the 'tran_date' between.... if the current month is greater than 10 i.e. after OCT then the tran_date will be between '01-Oct' - plus current year or the tran_date is '01-Oct' plus previous yea...more >>

I'm trying to get the machine free ram value using either T-SQL or SQL-DMO. I found .Registry.PhysicalMemory which takes care of the total ram but I still need eithrt the free or the used. Any ideas? Thanks! ...more >>

Hi, does someone know how much memory a user session takes on a SQLServer database server? How many concurrent user sessions can a normal server (4 GB primary memory) handle, before connection pooling is needed? /Fredrik...more >>

Can anyone help me understand what it takes to define a Linked Server connection to an IBM eSeries (AS400)? Do I need Microsoft's SNA Server or some other product or can I simply do it with the tools provided with SQL Server 2000? Any guidance would be very appreciated. Thanks. Farid ...more >>

I want to use System Monitor to moniter the performance of SQL Server. My SQL DBA book tells me how to add counters to system monitor. But the book shows a Performance Object called SQLServer:Databases. This isn't appearing in the list of Performance Objects on my computer. How do I get the SQ...more >>

I can't get my head around this: I want to select all IDs from table A that do not have a related record in table B according to some condition: Table A contains, say, Parents and table B contains Children. I want to select all Parents that have no children called "Sally" (this is a nodd...more >>

Let's say I have a type hierarchy: (just an example) the general entity customer: CREATE TABLE customer(customer_id int, customer_name varchar(250), customer_type int) three specific customer subtypes: 1 - business, 2 - home, 3 - university represented by the following three tables (be...more >>

"Do something for each row of the query" The only way I know is: --- declare @C cursor set @C= cursor for select F from T where ... declare @F int open @C while 0=0 begin fetch next from @C into @F if not(@@FETCH_STATUS = 0) break exec myStoredProc @F end close @C deallocate...more >>

Hi Few questions more newbie kind of things hope you can help out: 1- SQL 2000 on Windows 2000 ( and XP ), how can I utilize performance monitoring tools on a daily basis to detect workload, usage and keep it in a text file as a base line. What are thye most important parms to set? Is perf ...more >>

I know passing table/column name as parameter to a stored procedure is not good practice, but sometimes I need to do that occasionally. I know there's a way can do that but forget how. Can someone refresh my memory? Thanks. Saiyou...more >>

Ok, I'm a beginner so forgive me for my ignorance. Could someone help me with this? tbl_x has two fields xid and xlist xlist being a list of numbers.....1, 5, 6, 8 i want to create a new table from tbl_x that converts each number in that xlist into a row in tbl_new so for example tbl_x...more >>

I'm working on a website remotely through a VPN and my client uses SQL Server. There's a requirement for a database and my client uses SQL Server 2000. Is it possible to administer this database remotely, just like I do with MySQL/PHP MyAdmin? Please elaborate. Thanks, Marjorie...more >>

Hi, there are functions YEAR, MONTH, DAY ... in the MS-SQL for extracting of year, mothn,... from date data. I cannot find anything analogous for extracting time part. Like year(1999-12-30 13:00:00.000) = 1999 time(1999-12-30 13:00:00.000) = 13:00:00.000 or if I'm more demanding hour(18...more >>

Hello, I have the following problem; In my application I have certain items that have properties. Item Property --------- ----------------------- ToyBear Hairy, Soft, Brown ToyCar Brown, Plastic, Wheels To...more >>

I have a question...say I have an asp app that works as a front end to an sql server 2000 database. Would it be better, performance wise, to seperate the webserver from the sqlserver or to have them on the same machine? -Jim...more >>

Information: Server A: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server Enterprise Edition. SQL Service pack is 3a. Member of domain ABCDomain. Server A is going to function as a Distributor. Location: New York. Server B: SQL Server 200...more >>

Let us suppose that I have two similar databases and need to create an sql-script upgrating one database structure to another. For example, these databases are from different versions of some software, first is from early version, next is from current, and second one contains several new tables, ...more >>

We use an oracle database. I want to select adress, postal code en city from the table 'subject'. But those fields are not allways filled. If they are empty, there is allways an unique adres number. This number can be matched with the table 'adress'. So if the fields 'adress' 'postal code' and '...more >>

I am having multiple threads in my c program to execute same procedure with differnt parameter values every time. I have created different functions to execute the same. However when SQLExecute is run on one of the thread it returns an error saying [Microsoft][ODBC SQL Server Driver]Connection ...more >>

I'm using ms access 2000 .adp file, and tables on sql server / msde. On the menu there's a backup option. It creates a file with a .Dat extension. How do I take the Dat file and restore data? This news group has been real helpful-- thanks. ...more >>

I'm fairly new to sql. I've got a database that all I want to do is view some records from some tables. But the thing is, I do not know the table names or their relationships. I've got access to the database thru query analyzer. Can someone assist me in gettign the correct statements ...more >>

Hi, I am trying to convert string entered in a field to uppercase using its formula property. I know it can be done using trigger but still I want to use formula property to achieve the same. Any help will be greatly appreciated. -Max...more >>

Hi, I am having a problem with IDENTITY_INSERT command with MSDE 2000 (ADO 2.8) in that I cannot insert a specific value to an identity field. (lines below with >>> are code lines. I am using Python, but the syntax should be about the same as VBScript) First, I create an ADO Connection an...more >>

Hi all. Does anyone know of any good DTS tutorials? I am relatively new to this and will need some help getting started. Thanks in advance! --James...more >>

Hi folks I know just enough about MS-SQL to be dangerous, so feel free to warn me off this it's too much for a non-expert. We are using SQL 2000 as the back-end for website. We would like to create a duplicate of the database (on the same server). Then we'd use them like this: Database A...more >>

Hello, I not exactly sure how to determine the table when given the following information: -- Could not find the index for RID '999999' in index page ('1:99999999'), index id ), database (whatever). -- Can you someone tell how I use the system tables to determine what table this index ...more >>

Hi ! when installing sqlserver 2000 on a Windows 2003 server it explicitly tells "server not compatible with Windows 2003" during install, but it can carry on. After we applied serfice pack 3a then the db server seems to run normally, but does it risk to behave randomly afterwards ??? Is sql...more >>

This works fine: Dim STRSQL, VTEMP VTEMP = Text3 STRSQL = "SELECT * FROM Instructors" _ & " WHERE FIRSTNAME LIKE ('s' + '%')" Form_INSTDATA.RecordSource = STRSQL This does not work: Dim STRSQL, VTEMP VTEMP = Text3 STRSQL = "SELECT * FROM Instructors" _ & " WHERE FIRSTNAME LIKE (text3 +...more >>

Hi! I'm looking for ideas on what would the best approach to design a search system for a RSS feeds. I will have some 50 RSS feeds (all RSS 2.0 compliant) stored locally on the web server. Now I'm wondering what would the best method to allow searching of these RSS files. Since the search will c...more >>

If I need to upload a single value from some singular query to the local variable it may be like this: set @var = (select F from T where...) Next, what to do if I need more than one? Is it necessary to create a cursor, then open it, fetch and so on? Or may be something like set @var1, @v...more >>

I have a table [myOrders] with three columns. One of the columns contains text output data [myText] nvarchar(500), one of them contains a filename [myFileName] nvarchar(50), one of the columns is a bit to record if it has been output yet[isOutput] bit default value = 0. I am creating a SQL Age...more >>

Hi! This is a very basic question.. don't make fun of me please! I'm confused by all this logins, users, roles etc.. What I want to do it is to have an ASP.NET application that uses MSSQL as a backend. I'm using SQL Authentication and e.g. Each employee for Comapny A will have a login e.g....more >>

I've created a DB in SQL Server, and a user 'X', administrator on it. The DB is genereted by a file, using osql. The tables' owner is 'X', but when I try to insert some rows into the tables (by osql), the response is: "INSERT permission denied on object 'DUMMY', database 'EC_PROVA', owner 'X' "...more >>

hi, when i execute : CCommand<CManualAccessor, CBulkRowset, CNoMultipleResults> rs; rs.SetRows(100); HRESULT code_resultat = rs.Open(session, requete, &propset, NULL, DBGUID_DBSQL, FALSE); with a requete with length = 13000, it works perfectly but when my requete length is 200000 (ex...more >>

I am writing an installer that needs to put a dll file with a bunch of extended stored procedures in the BINN directory. The problem is that if the machine is running multiple instances of SQL Server, there is more than one BINN directory. The installer has a dynamically populated dropdown wit...more >>

Hi there. I have to change the drive letter where SQL server have his datfiles (master included). If I do that, ob the SQL fail to start, becouse it's unable to find the master datfiles. Is it possible changing driver letter without reinstalling the complete product? BR amnésia ...more >>

Hello MY SQL Server is causing me this problem : Microsoft VBScript runtime error '800a000d' Type mismatch: 'ident' >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> I am getting from the table datingnew the value of the ident field. "select max(ident)as test from datingnew" id...more >>

Hi, I guess SQL server does not release claimed memory even if it is not used. Is there anyway to free the unused memory? Thanks, John Jayaseelan *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hello, I am starting to examine using SQLServer instead of Oracle. I went through the SQLServer import utility to copy tables from Oracle into SQLServer. I then checked the size of the database. I then started to specify indices for the tables. I did not see the database file size grow a...more >>

Hi, I am slightly confused about the meaning of a 'device cal' (specifically for sql server but I guess the same applies to other ms licences) In the examples about device cals, there is a picture of a number of windows desktops connected to a database server. each desktop can potentially ...more >>

I am having a problem with a procedure. I can run it from QA and it takes 50 minutes. When I have it in a scheduled job, it takes 3 hours!! What could be the cause of this? Why the big time difference? Thanks...more >>

Is there any way to allow a user to use the xp_cmdshell extended stored procedure without giving that user execute permissions to xp_cmdshell in SQL server 6.5? Let me clarify. Lets say I (as the dbo) create a stored procedure called sp_send_err: CREATE PROCEDURE sp_send_err @CompID varchar(...more >>

I have a SQL db on a shared server. The db is for an asp website. To connect to the remote server I use the 'export data/import data' wizards in Enterprise Manager, logging in with a user ID and password. When I connect I get a list of all the databases on the server. Is there anything to stop a...more >>

Hi, For some magical reason, my database replication has suddenly stopped working. I modified the publication but the Distribution agent will not run; the snapshot does not get applied to the subscriber, and changes made at the publisher do not get replicated. My configuration is: Transac...more >>

Hi, I've got SQL2000 Evaluation edition running on my own Windows XP Pro computer. I've installed it fine, and created some sample databases. It works fine. I can connect using Windows authentication. But when I try to connect with username & password I get the error message: "Login failed...more >>

I have had an installation fail twice now. The first time, the setup process went all the way through OK but than hung showing the message: 'Setup is starting the server and installing your chosen configuration' I have had to kill the setup process after a while and try again. The second ins...more >>

I have created a view named viewOutput that shows one column in a table. I insert a row into the table and then I'm using this code to create a file with the text in the single row. This code works fine when I'm signed on with an account that has server admin rights, however it fails when I s...more >>

Our server guys are pushing VMWare at us, anybody encounter any issues running SQL Server 2K under VMWare ? I have an instance running on a test server, but the application doesn't do a whole heck of a lot. thx...more >>

I have the following query: SELECT dbo.tSymExch.exCode, dbo.tSymGrp.sgCode, dbo.tSymMain.smCode FROM dbo.tSymExch FULL OUTER JOIN dbo.tSymGrp ON dbo.tSymExch.exID = dbo.tSymGrp.sgexID FULL OUTER JOIN dbo.tSymMain ON dbo.tSymGrp.sgID = db...more >>

Hello everyone, I have around 20 reports in an ASP web-application which connects to a SQL Server 2000 dB, executes stored procedures based on input parameters and returns the data in a nice tabular format. The data which is used in these reports actually originates from a 3rd party account...more >>

Hi, Does anyone know how to correct the following error message that is causing an application to fail: Error is DB Error 80040e31 ODBC Driver Error #3121 Timeout Expired There are some troubleshooting tips as well that address pooling configuration issues. I see others have said it i...more >>

I am still using SQL7 as my server engine, but we are in the process of migrating to SQL2000. I recently installed the SQL2000 tools on my primary workstation. I have noticed that after importing rows into a table with the DTS Wizard, the record count displayed in the Table Properties window in ...more >>

Hi, Does anyone know how to correct the following error message that is causing an application to fail: Error is DB Error 80040e31 ODBC Driver Error #3121 Timeout Expired There are some troubleshooting tips as well that address pooling configuration issues. I see others have said it i...more >>

I have a problem in full population for a full text index. When I run the population; these are the results - Population duration : 3-5 seconds. - item count : 0 - catalog size : 0 - unique key count : 1 although I have 7 million of records in that table I need explanation please. Than yo...more >>