I think you need to add indexes to that rebuild list as well!!!

Depending on the DR needs, you have to delete the backups eventually. You need to figure out when a backup is no longer needed, then create a job that...

You need one extra table called CityCounties

CityID

CountyID

That's easier said than done. Doing that work for the entire US is not a small task. I'm guessing you'll have to...

One more thing to keep in mind, if the proc has more than 4000 characters and that the objects used is splitted between 2 rows in syscomments, that still won't...

Looks like a case where you'll need to manually look at the data and clean it. The first names will not be writtent he same in both tables and...

Can we see the code you are using?

Restore most recent backup under a different DB name. Bilk import the records from that restored table.

Otherwise you need a log explorer like lynn suggested. You might need...

Was too slow... but just for the fun of it :

SELECT OBJECT_NAME(C1.id) AS Obj FROM sys.syscomments C1 LEFT OUTER JOIN sys.syscomments c2 on C1.id = C2.id AND C1.Colid =...

Just open a cursor, loop and print it out. Copy / paste from there into the script window.

The question now, is it possible to change the server settings from CS to CI... never tried it and I have no solutions on top of my head.

who's the owner??

if you run as sa, drop the dbo part and test again.

Could also be a view that tries to select from the base table which does not include...

The recommendation is to not create objects in production code.

You are in dev mode, which is mode than fine.

select * from dbo.[db.document]

That works for me.

CREATE TABLE dbo.[db.documents]

( a int

)

GO

INSERT INTO dbo.[db.documents] (a) values (1)

SELECT a FROM dbo.[db.documents]

GO

DROP TABLE dbo.[db.documents]

GO

No, you're dead on...

I've seen names like this: l'aéropt du-Québec

That's the tablename... and I can access it with brackets, so a simple dot should not stop it!

Good point, but I'm assuming that this search is done in the inserted table (which is always scanned anyways)... but he must keep this in mind.