Nice simple one today, cheers Steve

got this one wrong, should have known really, but still all my tests returned apple and pear

nice and simple one to end the week,

cheers Steve

I believe OP was planning on replacing the name with a View but i agree a Synonym is a good way to go

Sorry mate not that im aware of. Object explorer (F7) on the views/procs so you can highlight multiple objects then right click drop and create to new window and do...

Hi There,

I use the below code to find references to text (in this case a table name) in objects,

Replace TEXT_TO_FIND with the table name you are looking for,

It uses dynamic...

was convinced i knew the answer,

clicked it

Incorrect....

Everyday is a school day 🙂

Thanks

Shayn

Hi All,

I have flagged this with our infrastructure team who seem to think that the storage subsystem was not set up correctly to optimize the use of SQL

With this and...

Hi Sue,

My apologies for not replying sooner i have been out of the office,

I will have a look into this and see what i can find,

Thanks for again for your...

Hi Sue,

Thanks for the link,

The numbers in my results/errors don't seem too high, at least not in comparison to the ones mentioned in the link, but i may be understanding...

Nice and easy one, Cheers Thomas

nice question

nice question

nice question steve, thanks

nice question and good reminder