It's about 65 BG. IT now says it has 25% free space. Before the shrinking it said 30% free space.

I posted a question last week about where it is getting...

If you are using Enterprise Manager it is the fist checkbox which is unchecked by default. (right click db>all tasks> shrink db

quote:

---

How...

Yes, that shows valuable info. but I would have to spool that info. to a table and do some derived columns to see who is a candidate.

When you use the...

I got it,sorry:

UPDATE table_x

SET end_Date = b.end_Date

FROM table_x , table_x b

WHERE table_x.elig_tag<>b.elig_tag and table_x.elig_tag=1

I am still suspicious of what it is doing on my side.

One of my fellow dba's thinks the sql engine behaves differently when you use the gui in comparison to...

THANKS!

SD,

Thankyou for the syntax help but I still have to run the output sql. I cannot schedule this to return the results to a table.

-K

Thanks.

We fixed the share problem by making the service pack on the SQL instances the same. 🙂

-K

Memory is not the issue. It has plenty.

CPU is maxed at 100%.

I am investigating it further I just wanted to know the effects of multiple instances.

I am using sql 2000. There is no problem witht he colation. I am going from text file to db table.

The format file must not match the data being sent....

That's it!!!

I knew it was something stupid like that 🙂

-K

Sorry, I already knew the answer to that is yes.

-K

My PC is running WIN2K and I am running Standard edition locally.

The servers are also running standard edition.

select @@version ...should give me accurate edition , right?

I have no other...

Thankyou. I'm an idiot. I was unselecting the 'CREATE' and 'DROP' clauses.

-Kevin

I tried this. It doesn't do anything regarding NY accounts. Only yht sql accounts (nt is the majority of our authorization method)

-Kevin