I am using Report Writer for Ingres II. Is it possible to write a query in a loop? e.g. My table is like this time position 09:01 pos01 09:02 pos03 09:02 pos01 09:04 pos05 Can I loop a query to count the number of times each position occurs in each 30 minute period in ...more >>

Hi, I have yet to find an answer for this: I want to do a case-sensitive query using "like" on a table in sql 7. Currently, "like" performs case-insensitive query. I understand that you can use the following query in sql 2000: SELECT * FROM table_x WHERE col1 collate ...more >>

Hello, I am running SQl Server 7.0. I have a database maintenance plan that runs once a day to perform backups. It seemed that the database backup files were created successfully. The problem is that if i go to "SQL Server Agent" --> "Jobs", the status of the backup job always shows "Executin...more >>

I need to implement a dirt cheap replication method for some dirt cheap servers. We are using the SQL Server workgroup license. Is there anything in this that prevents using log shipping for replication in Workgroup versus Enterprise? Thanks Travis...more >>

Hi all, Are there a functions for last day of the month or first day of the month? Thanks in advance, Jen -- Fast Track On Line -Web Design and Development Portfolio http://www.fasttrackonline.co.uk --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system...more >>

I have 2 tables say table1 and table2 with the same structure. Each record is identified by a field 'SerialNo'. Now there should be a total of 500000 records in both tables with serialno from 1 to 500000. Either a record is in table1 or table2. I want to find records (or SerialNo's) that are in ...more >>

Hi I tried to use the alias a1 for the column f1 like this, but it fails: create table a (f1 int not null primary key) insert into a (f1) values (2) select f1 a1 from a where a1 = 2 Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'a1'. In my real situation f1 is a "pret...more >>

hi For an unavoidable reason, I have to use row-by-row processing (update) on a temporary table to update a history table every day. I have around 60,000 records in temporary table and about 2 million in the history table. Could any one please suggest different methods to imporve the runtim...more >>

Excuse me in advance fo my little English. I've got this stored procedure **************************************************************************** ********** declare @Azienda as varchar(3), @Utente as varchar(20), @DataDa as datetime, @DataA as datetime, @AreaDa ...more >>

I have seen many postings regarding asp. sql and images. One posting on another group stated that images (jpg, etc) can be called by a db instead of being stored on the db. I am asking for some help with coding such a thing. What I want to do is include in the db the location (url) for the ima...more >>

We ran into a problem loading access where tables where if we did not select the property allow zero length we got an error message when loading data with some empty values. We are now ramping up SQL server and the question came up will SQL server have the same problem with empty data values. ...more >>

I am looking for a better way to schedule jobs in SQL Server. I found this tool called SQLschedule at www.idera.com and am using the 30 day trial. This tool really has a cool GUI, and seems to work well. Does anyone else have any experience with their tools?...more >>

I am a noob to sql and asp programming. I am working on a db for the gaming squad I am a member of. One of the pages I created is a roster list of all the squad members. Part of this roster is listing each member's email address. What several people have asked of me is to make it so the email ad...more >>

Hi, Is it possible to write a Stored Procedure which can update the data from one SQL Server to another SQL Server ? I know its possible through DTS, but want to know if its possible using a Stored Proc by passing the two server names as parameters to the Stored Procedures. Thanks, Vikram...more >>

Consider a scenario, I am a DBA for the Database server where the size of the hard disk is 100 GB. On that database server, i have the Database whose size is 40 GB. Also, i restrict the size of the database file to 95 GB, by specifying the "maximum file size" to "Restrict file growth" option , ...more >>

I have a problem with record locking / blocking within an application. The app is quite straight forward. Written in Delphi 5 using BDE to access a SQL 7 database (Win2K server). Every so often the users (when they bother to tell me) find that the application locks up and they are unable to wo...more >>

I have the Transact-SQL Programming book from O'Reilly. It was published in 1999. It states that "SELECT ... INTO" statements end up locking the entire database of the target table. Since the tempdb is also involved (in many cases), this creates major deadlocks for the entire database and all...more >>

Hi all, I have a internet page written in asp to submit into authors curriculum vitae publications (title, author, year, etc.). If the author submit less than 8000 characters it functions OK, but If the author try's to submit more than 8000 characters the asp page does not return an error but...more >>

can we secure mdf file, if it's copied from one location to another could not be used ??? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

When I am trying to use backup or restore from the EM, a dialog box never pops up, and the EM interface locks up. Has anyone else had problems like this? Looks like all other functions from EM are working fine. Thanks, Dave...more >>

I am debugging an app which blocks many processes in a SQL7 server DB. The app log writes every transaction "open" and "close". The weird thing is : when the app logfile says the transaction is dropped (object closed) the db keeps showing the process "running", in a sleeping mode, with open_tran...more >>

-- Example Schema posted at end of message: --- For reporting purposes, I need to build a single comma delimited string of values from the "many" table of a database. The easiest way to see what I want is to look at the sample after my signature. By the way, this is actually a busines pro...more >>

Guys, I'm stumped. While its not pertinent to the matter, we are running a Vignette content management system on Win2k with Sql 2000 Enterprise on a cluster. The server has 2 Gig of RAM , 2 CPU's and the database size is 1.5G. The query below is fired at login. The indexes seem fin...more >>

Greetings: I am trying to conceive what risks might be created by running multiple SQL servers within a domain under a single domain account, as opposed to 1) running under the local service account or 2) multiple domain service accounts. In this case, all the SQL servers are SQL2000 runnin...more >>

hi there, a while back i got into a bit of ASP programming and needed database access. since msAccess was installed on the system i was using at the time i used that and have used that since. but then i heard something about sql and that it's better to change to that as early as you can beca...more >>

Hello gurus: Hopefully someone can shed some light on some questions I have. I am tasked to build an application that will schedule and track tasks. I firmly believe in not reinventing the wheel however also feel that customizing is certainly not out of the question. I am looking to build s...more >>

Hi I have this error: Servidor: mensaje 229, nivel 14, estado 5, línea 1 SELECT permission denied on object 'sysobjects', database 'SED', owner 'dbo'. with this sentence: select * from sysobjects I only resolve this grant System Administrators to my user, but I need make select to...more >>

I have a million record mainframe flat file that I BULK INSERT into a SQL table with CHAR(fieldlength) deined for every column to prevent import errors. Once imported I "INSERT INTO ... SELECT dbo.MyScrubFunction(columnN),..." My scrub functions will take for example a char(8) YYYYMMDD date f...more >>

I was at a Microsoft sales presentation last week for the new version of SQL Server, Yukon. They had an extensive presentation on SQL Server and Reporting Services but didn't mention Analysis Services. When I asked about the future of the product the MS Sales rep couldn't give me any info. Wh...more >>

Hi all, I am doing the change from having worked in Oracle for a long time to MS SQL server and am frustrated with a couple of simple SQL stmt's. Or at least they have always been easy. The SQL is pretty straightforward. I am updating a field with a Max effective dated row criteria. (Pepopl...more >>

I have a set of udf's dealing that return a one column table of values parsed from a comma delimeted string. For example: CREATE FUNCTION [dbo].[udf_filter_patient] ( @patient_list varchar(2000) ) RETURNS @patient TABLE ( patient_id int ) AS BEGIN insert into @patient ...more >>

hi, my sql database log file has been fulled recently ..... becuase there are 55 millions records in main 3 tables .... so how i can empty log file ... i don't want to attach new log file or save any pervious log info ..... thanks for helping me ... and my company .. Abdul Sala...more >>

Why can I not sort my stored procedure listing by creation date? I am seeing these dates (omitted the time as not relevant) 2004-03-06 2004-05-14 2004-05-18 2004-03-06 After clicking the 'Create Date' header. What gives??...more >>

I seem to be having problems with a very simple install of MSDE on a Windows 2000 Server. When attempting to add new records, I receive the message "Could not allocate space for object 'MyTable' in database 'MyDatabase' because the 'PRIMARY' filegroup is full." I have dealt with countless iss...more >>

hi, i ran the follow command: select #tempra.ranumber,#tempra.amountdue,#tempquickrec.totalrec, #temparap.amountpaid,bal=amountdue - totalrec+amountpaid from #tempra left join #tempquickrec on #tempquickrec.hrr = #tempra.ranumber left join #temparap on #temparap.ranumber = #tempra.ranumber re...more >>

Hi I want to select the minium of two fields: create table a (f1 int, f2 int, f3 int) insert into a (f1, f2, f3) values (1,19, 150) insert into a (f1, f2, f3) values (2,18, 160) insert into a (f1, f2, f3) values (5, 17, 200) insert into a (f1, f2, f3) values (3, 18, 250) I want to select...more >>

The following are a few rows in my table: StatedValue VehType Deductible Rate 10000 Truck 1000 9.16 11000 Truck 1000 9.02 12000 Truck 1000 8.82 13000 Truck 1000 8.64 14000 Truck 1000 8...more >>

I was trying to relocate my transaction log to a bigger drive using sp_movedevice but I made a mistake in the syntax of the second parameter and put only the path, not the path and the file name. Now my database is marked as "suspect" and I get an error message in my log upon database start up s...more >>

I have a need to concatenate all Descriptions from a select statement SELECT t_ReviewSection.PeerRevSectionDescription FROM t_ReviewSection WHERE t_ReviewSection.PeerRevID = @lngRevID ORDER BY t_ReviewSection.PeerRevSectionOrder I want to return a single string ...more >>

Hi all Is there a TSQL function like Oracle's Translate function? Where: Translate('13,000 Miles','abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ, ',' ') would return '13000'? I'm trying to extract a number from a string. REPLACE doesn't quite do what I want. Thank...more >>

Hi, I was going to buy a server with Raid 1 as I thought that it meant that if one of the two mirrored drives fail, you simply take it out and put a new one in. At which point presumably the hardware takes over and copies the other drive over to mirror it again. However, my sql server admin b...more >>

When I create tables in SQL I can specify dbo as the owner using the syntax below but when using the upsize wizard in Access 2000 I own everything. Is there a way that the system administrator can change ownership after the fact? CREATE TABLE dbo.mytable (c1 int not null) Thank You, R...more >>

Hello, I am working on a project to reverse engineer requirements for a database. The database is sitting on a MS SQL Server. How would I get a listing of all tables and columns within each table to help create a data dictionary. I have developed a script in Oracle to do this, but I am ju...more >>

If I have two NT accounts and performance using one account is pretty awful what might be the most likely reasons for the difference in performance? We're talking about a few hundred thousand rows being returned from a SELECT statement within a stored procedure with a few INNER JOINS....more >>

I have this piece of script and I'm trying to understand what the 'SET t.Z_ASSOC_ROW = (t.rowid - m.MinRowID) + 1' and the 'INNER JOIN' line is doing UPDATE t SET t.Z_ASSOC_ROW = (t.rowid - m.MinRowID) + 1 FROM tassoc t INNER JOIN (SELECT Booking,MIN(rowid) AS 'MinRowID' FROM tassoc...more >>

Hi, how can i update the data in a field like that: \organization\name\surename\zip\city I want to update the content from "\organization" into "\neworganization" followed by "\name\surename\zip\city" yours marvin...more >>

Can anybody help on this question? When I select 3 values from the drop down list box, how can I insert into a table? Please help ...more >>

I would appreciate any help, I'm trying to connect a web front-end to an Access 2000 database using MSDE, and I have it working using Jet but would like to connect the database using MSDE. I would appreciate any advice to where I need to edit the code, the code is as follows: <%@ La...more >>

Hi, I have sql server on a web server. The machine grinds almost to a halt at peak times, as the asp pages are causing sql server to use most of the cpu. Looking at the graph it is at 100% for about 20 seconds at a time, then drops, then goes back up. Is there anything I can do to make sql...more >>

Hi I am using the DTS package with SQL SERVER 2000. I have a table, and in one of the columns are links to websites. I am trying to export this to Excel 2002 SP3 a typical text string stored in the table is =HYPERLINK("www.asite.com","Click") I had hoped the field would be transferred ...more >>

I want to take a copy of a database, and mail it to another sql-server, and then get it up and running. I normally detach it, and copy the .MDF. But there are users using the database, so that option is out. I checked out the copy database wizard, but it can't copy it to the same sql-server...more >>

Hi All I'm creating some SPs and I've got a query which is inserting data into a table with a a unique constraint: CREATE TABLE [fil_Films] ( [fil_ID] [int] IDENTITY (1, 1) NOT NULL , [fil_Film] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , CONSTRAINT [PK_Tfil_Film] P...more >>

What do people think is normal for memory utilization? I know that's too broad, so here are some basics. MS SQL Server 2000, Windows 2000 Server, 2GB RAM Db 1, size = 2.0 GB Db 2, size = 300MB Db 3, size = 50MB Db 4, size = 30MB Db 5, size = 30MB Typically 4-6 users, moderate usage...more >>

I have been reading everything i can find regarding sql mail and sql agent mail. We have a win2k server, sql 2000 and NO, NO, NO exchange server(all up to date on service packs). I have tried repeatadly for days to make this work, and have had no luck so far. 1. I have a valid profile th...more >>

alguien sabe como es la siguiente consulta en my sql??? SELECT IS NULL(Alicuotas.Alicuota_Valor, 0) AS Alicuota1, IS NULL(Alicuotas1.Alicuota_Valor, 0) AS Alicuota2 FROM winmed.Deudores LEFT OUTER JOIN winmed.Alicuotas Alicuotas1 ON winmed.Deudores.Alicuota_Codigo_2 = Alicuotas1.Ali...more >>

Example, suppose you have these 2 tables (NOTE: My example is totally different, but I'm simply trying to setup the a simpler version, so excuse the bad design; not the point here) CarsSold { CarsSoldID int (primary key) MonthID int DealershipID int NumberCarsSold int } D...more >>

Hi, We have troubles when we try to use the 'dbuse' calls with databases larger than 28 characters, looks like the dbuse truncates the name after it. Any ideas ???...more >>

After setting up the linked server connection at the standby server, I tried to xcopy a file through the sql server 2000 schedule task to the standby server's shared directory. But it keeps giving me the error message with 'Invalid Drive Specification'. My whole process includes 1) set up li...more >>

Hi All! Has anyone has seen this error before? Event Type: Information Event Source: Application Popup Event Category: None Event ID: 26 Date: 5/14/2004 Time: 10:06:45 AM User: N/A Description: Application popup: sqlmangr.exe - Entry Point Not Found : The procedure entry point Trac...more >>

I have a stored procedure in sql 2000 that requires steps to be fully completed before moving to the next command in the procedure. I have tried to place the word "GO" after each statement. When I create the procedure then take a look at it through em, it only shows the code up until the word "G...more >>

I have read about Views vs. SP's and I have question to which I could not readily find the answer. The database I'm creating will only have 1 user from the start and up to three maximum. Is there any reason that I shouldn't just use SP's for everything or might there be an advantage to using v...more >>

All I am trying to do is return the row number (calculated field?) with each row returned from an SQL query. I think I have done this in the past but am a bit rusty after not using SQL for a while. If anyone could help with a code snippet this would be gretly appreciated....more >>

Hello, I have a problem with EM and the msdb. I get an error message 14274 when I try to edit or delete a job. The data in the msdb for the jobs was generated by a restored backup that came from another machine, and a different instance of SQL Server. The old default server instance was calle...more >>

Hi, I am not getting option as 'new view' and 'new table' when I right click on views and tables option in VisualStudio.net IDE server explorer sqlservers database to create new objects. Looks like some setup issue in my database. Thanks for your help in advance. Rgds CV...more >>