Viewing 15 posts - 466 through 480 (of 631 total)
Grant Fritchey (9/27/2013)
Yeah, I think the best mechanism is through security. You can't even set up a trigger on something like this.
I thought about setting backup operator permissions to disallow...
September 27, 2013 at 4:04 pm
Kurt W. Zimmerman (9/27/2013)
September 27, 2013 at 4:01 pm
Dave Schutz (9/26/2013)
September 26, 2013 at 1:34 pm
Jeff Moden (9/20/2013)
Are you good folks saying that any form of SELECT/INTO is bad? If so, why?
Certainly not. However, in the form highlighted in the original post, it's...
September 23, 2013 at 5:16 am
venoym (9/19/2013)
andrew gothard (9/19/2013)
Stefan Krzywicki (9/18/2013)
GilaMonster (9/18/2013)
L' Eomot Inversé (9/18/2013)
Don't need to is surely an understatement: you are not allowed to, I think?
If you mean the SELECT * INTO, unfortunately...
September 20, 2013 at 5:15 am
Stefan Krzywicki (9/18/2013)
GilaMonster (9/18/2013)
L' Eomot Inversé (9/18/2013)
Don't need to is surely an understatement: you are not allowed to, I think?
If you mean the SELECT * INTO, unfortunately that's allowed. I've...
September 19, 2013 at 5:20 am
Even if you have a 2012 database in 2008 compatability mode, it's still a 2012 database internally, and therefore incompatible with 2008. Possibly the most straightforward way would...
September 16, 2013 at 5:15 am
Steven.Howes (9/6/2013)
September 9, 2013 at 2:12 am
GPO (8/7/2013)
Wouldn't it be good if they created a licensing structure that forced db designers to normalise their OLTP databases properly. I'm...
August 7, 2013 at 4:21 am
... Remember being able to PIN TABLE ...
:exclamation: you have no idea how happy I am that vendors do not have access to that
August 5, 2013 at 6:01 am
It looks like the link to the article is broken.
July 29, 2013 at 2:57 am
Gail's point still stands regarding 2008 to 2008 R2
July 26, 2013 at 5:05 am
It's certainly an option, or even standard local system would do, that's easy enough to assign remote permissions for. I was just wondering if I was missing something obvious...
July 2, 2013 at 6:37 am
Sai Viswanath (6/19/2013)
Thanks for the comments, and here's the code that I could get from the SQL Server Profiler when I worked with a report. The tables its...
June 19, 2013 at 3:14 pm
"Am the so called consultant they have hired. My background is - Data Modelling, and they have picked me as Sr. DBA for this project. Fixing of queries for performance...
June 19, 2013 at 5:57 am
Viewing 15 posts - 466 through 480 (of 631 total)