You can put those sps in model.  So when the new dbs are created they will include those sps.

Giving them access to master might not be the best idea if...

Ya that's the quick and dirty way.  However even my search method willeventually come to that point where you backup and test a delete.  So it might be a little...

A bit extreme... but as long as it works .

BTW rebooting clears the proccache and the data in memory... so maybe that would have...

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 .