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

Unfortionatly, I can't get in at all. I think I'm going to have to stop the services, save off the database and re-install. www.acushnetcompany.com www.titleist.com

I have run into that problem. If your device is empty just delete it from the backup folder. When you run the backup it will create a new one. If you need the backup sets in it, then save it off. Also check that no other programs like Tivoli or other backup utilities have a lock on your...

you can run sp_spaceused [index_name] to find how many rows and the size of you index. as for finding which indexes are being used that is going to be allot more difficult. if you know all the querries you can use query analyzer show plan. If you don't then you will need to run profiler to...

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 found a better way. I'll just do this to build my script. SELECT 'select OBJECTPROPERTY(object_id('+ name +'),CnstIsDisabled)' FROM sysobjects WHERE xtype = 'F' www.acushnetcompany.com www.titleist.com

Mr Denny. Thank you very much. the only problem I have is there are hundreds of FK's and I don't know which one could be disabled. The company which provided us this product also gave the developers a script to disable all constraints. Why they would do that I have no idea. Anyway, I am...

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

I know I can get current index usage from SQL Profiler, but I was hoping there was some unsupported DBCC command I didn't know about that would show me how often each index is accessed. Thanks for your help. www.acushnetcompany.com www.titleist.com

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

Once again Denis you come to the rescue! Thanks for your help. 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

SQLDenis That worked!!! Thanks for your help!! www.acushnetcompany.com www.titleist.com

Yes it is..But my boss would rather see the 27% So once I get the math to work for that percentage I will remove the percent free. 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 got it!..I forgot to convert the fields to decicmals. Thanks for your help. Here is my final query!. SELECT LD.[DEVICE ID], SUM(LD.[Size in MBytes]) AS 'Total Space in MB', SUM(LD.[Free Space in MBytes]) AS 'Free Space in MB', -- sum(ld.[size in MBytes]-ld.[free...

I feel stupid! This is my result set now? C: 6250963 4518721 .00 D: 26141720 15533886 .00 E: 4830965 3398903 .00 F: 11119681 6033662 .00 G: 1686799 972264 .00 H: 1012356 722261 .00 I: 406197 48508 .00...

This query is returning me disk information about all machines. We are going to use the results to halp design our SAN. www.acushnetcompany.com www.titleist.com

When I try to run that I get Server: Msg 170, Level 15, State 1, Line 4 Line 4: Incorrect syntax near 'SUM'. This is what I have. SELECT LD.[DEVICE ID], SUM(LD.[Size in MBytes]) AS 'Total Space in MB', SUM(LD.[Free Space in MBytes]) AS 'Free Space in MB'...

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