Search results for query: *

I have a 700 gb db running on SQL 2000 Ent fix 997. The OS is Win2K3. We have been having a non paged pool memory error. Microsoft has suggested removing the 3db switch from the boot.ini. If I do this,it is my understanding that SQL will not longer be able to use more than 2gb of memory. Is...

I've just been handed a sql server 2000 sp4 install without the sa password. To make matters worse the built in admin has been removed. Short of re-installing is there a way in to the system to run sp_password www.acushnetcompany.com www.titleist.com

I'm look to see if any of my Foreign Key constraints have been disabled. Is there an easy way to do this? I have run the following select which will show my all my FK constraints. select * from sysobjects where xtype = 'F' How can I tell if any have been disabled with the following syntax...

In MSSQL 2000 Ent edition is there anyway to tell how often or even if an Index has ever been used? www.acushnetcompany.com www.titleist.com

I have two data fields. They are both datetime datatypes [Date open] and [Closed on] I need to select all the records in my table where [Date Open] - [Closed on] < 4 hours Does anybody know how to do that? www.acushnetcompany.com www.titleist.com

I have the following query that calculates Total disk space and percent free for all of our servers. My boss has asked me to add the Percent used to the query. When I try the following I don't get the correct value for Percent Used. SELECT LD.[DEVICE ID], SUM(LD.[Size in MBytes])...

I have the following query on a database for Altiris. it returns the device name, total space and free spcace for all of our servers in the company. SELECT LD.[DEVICE ID], SUM(LD.[Size in MBytes]) AS 'Total Space', SUM(LD.[Free Space in MBytes]) AS 'Free Space' FROM (...

I have the following query that I need to turn into an update to set the oh.OAMODL field to 'USM' select oh.oaorno, sum(OBORQA) as totqt from MVXCJDTTST.oohead oh, MVXCJDTTST.ooline oo, MVXCJDTTST.mitmas m where oh.OAMODL='RSG' and oh.oaorst < '44' and oo.obitno=mmitno and oh.oaorno...

Has anybody noticed that in the new SQL Server management Studio it doesn't show the log shipping monitor for 2000 SQL servers? I have a monitor server for a log shipping process and when I open the server using Enterprise Manager I can view my monitor, however, If I open it up in the 2005...

I have a table that has multiple clocknum's. I am looking for the most recent record for each clocknum. I am trying to get it by a datetime field called EFFDT. For some reason I am only getting back one record. Shouldn't this query return me a record for each clocknum? SELECT a.clocknum...

We are having problems with Heap dump files being created on our websphere app server. I have found some documentation that suggests we can point these files to different directories. Is it possible to set a varaiable so that it doesn't write heap dump files at all? www.acushnetcompany.com...

I'm trying to run the following query. I'm only looking for data the mmlmdt greater than the previous days date. I should only get back 49 rows. However when I run my query here I get back data from 2004 as well. We are running this on and AS400 db so I'm not sure sure if current date works...

I have two tables that should be the same. in FHDWHSDB.dbo.Results I have 1846191 rows in FHECOMDB.dbo.Results I have 1846182 rows I need to identitfy the missing 9 rows. But the query I'm trying is just not working. Can anybody help with this? SELECT n.* FROM FHDWHSDB.dbo.Results n WHERE...

I am having a problem with the following proc. Two processes can call the proc and they both get the same next id. I need to lock the record when I select it. Does anybody know how to use HOLDLOCK or SET CONCURRENCY LOCKCC. CREATE PROCEDURE Webm_GetNextTransactionID @Transaction_Type...

I'm having a problem with DTS packages on one of my servers not opening from Enterprise Mgr when on the server. But I can open the package from EM on my local PC? When I try to open the package on the server I get an error message that says 'Access denied or server could not be found.' These...

I get the following error on this update. Error: SQL0811 - Result of SELECT more than one row. update mvxcjdttst.opricl l set l.OMFMID = (select s.odfmid from mvxcjdttst.oprbas s,mvxcjdttst.opricl l where l.omcono = s.odcono and l.omitno = s.oditno and s.odfmid <> ' ' ) Can anybody help with...

I keep getting an error on this update. For some reason it doesn't like the FROM clause. Can anyone help? UPDATE MITBAL SET MBWHSL = 'SPECIAL' FROM MVXCJDTDVL.MITMAS, MVXCJDTDVL.MITBAL WHERE MVXCJDTDVL.MITMAS.MMITTY in ( 'wM1','WM2' ,'3LY','3L1') AND MVXCJDTDVL.MITMAS.MMCONO =...

Does anybody know if it is possible to change the collation to case sensitive. (sort order id 51) without running the rebuild master utility? www.acushnetcompany.com

I have identified my duplicate rows. SELECT * FROM customer WHERE (emailaddress IN (SELECT emailaddress FROM customer GROUP BY emailaddress HAVING (COUNT(emailaddress) > 1))) Now I need to delete the duplicate rows with the min(id). That would be the oldest record. I thought this might do...

I have a user who wants to be able to add her own accounts to the sql server. The problem is as follows. To execute sp_addlogin you must be an 'SA' or in the server security role. I don't mind adding this person to the sercurity role. Once the login has been created the user needs to be added...