Have you tried Microsoft's TechNet site?

Here's the link: http://www.microsoft.com/technet/

-SQLBill

My SQL Advanced Server 2000 database is currently 161 GB and growing daily. I have 1100 GB of space and expect to use most of it for my database.

-SQLBill

Don't reboot your server. That's not necessary (but it will work). A quick way to 'reclaim' the tempdb space is to stop the MSSQLSERVER service and restart it.

-Bill

I'm gonna give it a stab...try this:

SELECT DISTINCT CM.ID,NAME1,PHONE,CITY,STATE,QUALIFIED_EQUIP,INSURANCE_EXP,INSURANCE_EXP2,INSURANCE_AMT

FROM CONTRACTOR_MASTER CM INNER JOIN CONTRACTOR_DRIVER_PROFILE CDP

ON CM.ID = CDP.CONTRACTOR_ID UNNEST QUALIFIED_EQUIP

WHERE (CDP.CONT_TYPE = 2 AND CDP.BROKER < 21185 AND CDP.CANCEL_DATE...

Thanks again. Stopped and closed the trace. Then I could view the data (after I adjusted my filter, it's not working with the LIKE %Crystal).

-Bill

Thanks, I will try stopping it and see if that gives me the data. Using Profiler didn't require me to stop the trace, as the application was used I saw...

Is is definitely stored as a varchar field and not a datetime field?

-Bill

Try this:

declare @my_date smalldatetime

set @my_date = dateadd(month, -12, getdate())

select *

from mytable

where date >= @my_date

and date <= getdate()

-Bill

The sound you may have heard this morning is me slapping my forehead. Profiler is giving me just what I wanted. Now I'm going to check out the site you...

I'm running a DELL two-node active/passive cluster with 1100 GB of memory, 4 processor, 4 GB RAM and using Veritas Backup Exec 8.6 SANS version. I have licenses for two...

I see that accwip is short for accumulated wip. And that accwip is the sum of the wipqnty's for a specific ponum (ie. P001). But what I can't figure out...

What type of computer? Do you need easy access to it? One option is a Raritan KVM module. You take your computer, put it where it can't be accessed easily...

OOPPPSSS, I meant 'column name' and not 'table name' in the first line of my response.

-SQLBill

I looked through BOL and it appears to me that when you set the variable using a table name, you must have a FROM.

So it should be:

select @date = first_m_Date

FROM...

As Andy says, put it in a room and lock the door with you being the only person with the combo or key.

We have our server hardware in two racks...