Viewing 15 posts - 1 through 15 (of 172 total)
confidently answer question
get it wrong
notice the "-"
drink more coffee....
April 28, 2020 at 9:52 am
Nice simple one today, cheers Steve
April 16, 2020 at 2:44 pm
got this one wrong, should have known really, but still all my tests returned apple and pear
March 17, 2020 at 8:12 am
nice and simple one to end the week,
March 6, 2020 at 8:07 am
I believe OP was planning on replacing the name with a View but i agree a Synonym is a good way to go
February 24, 2020 at 6:35 pm
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...
February 24, 2020 at 5:33 pm
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...
February 24, 2020 at 4:31 pm
was convinced i knew the answer,
Everyday is a school day 🙂
February 19, 2020 at 12:30 pm
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...
February 14, 2020 at 11:53 am
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...
February 10, 2020 at 9:13 am
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...
February 5, 2020 at 4:05 pm
Nice and easy one, Cheers Thomas
January 23, 2020 at 8:32 am
January 6, 2020 at 4:20 pm
December 31, 2019 at 8:31 am
nice question steve, thanks
December 27, 2019 at 2:42 pm