Ya but it doesn't make them search safe.  I had a few cases like this one :

vwOrders

and

vwOrdersDetails

If you search for vwOrders you'll find hits for both view names.  That's...

Dirty way : rename it and wait for a complaint.

Hard way (for the server anyways) : Run a trace and scan for the use of that object.  Depending on the...

Is it possible that it somehow times out because the table is too big now?

Have you tried recompiling the objects linked to that table?

... Just throwing ideas in here, I...

Why use a cursor at all??

What do you need to do exactly?

IIRC UPDATE top 1000 doesn't work with sql 7 and 2000.

UPDATE dbo.YourTable SET Colname = LEFT(ColName, 200)

ALTER TABLE dbo.YourTable

ALTER COLUMN ColName CHAR(200)

What's the order in which you need to base this counter?

What if it's your Grand mother's stock exchange monitoring program for her whole lifesavings?

Thanx for the info.

Just out of curiosity, what didn't you like about those e-mails?.. maybe we can do something about it!

Thanx, that made my day .

I won't have that power untill I become a moderator but here's how to do it :

Goto top right menu MyAccount / MyProfile.

Then at the bottom of the page...

Glad to help.  Come back anytime you need something .

In what area??

There are way too many answers to that questions... Where do you need help with?

I'll also be humble for once in my life and I won't put my...

VBA.

BTW my pseudo-code will need a lot of syntax checking .

I don't have any written code in access but here's the logic :

set NumbeOfDays = 25000 'your choice here

set StartDate = '2007/01/01 'again when do you need this to...