Viewing 15 posts - 3,436 through 3,450 (of 5,393 total)
First of all, I would check who has sysadmin rights on the server.
Probably somebody with little understanding of this setting has enough rights to change it.
-- Gianluca Sartori
February 21, 2011 at 4:03 am
The CTE is just an alternative syntax, it is not "called" or "executed": it is used in the statement as if it was a view.
The optimizer expands the CTE and...
-- Gianluca Sartori
February 21, 2011 at 3:10 am
Tom.Thomson (2/18/2011)
Gianluca Sartori (2/18/2011)
If I didn't post on THE THREAD a "Lennie alert" nobody would have noticed, Lennie would have got his answer...
-- Gianluca Sartori
February 18, 2011 at 8:42 am
David Burrows (2/18/2011)
Gianluca Sartori (2/18/2011)
If I didn't post on THE THREAD a "Lennie alert" nobody would have noticed, Lennie would have got his...
-- Gianluca Sartori
February 18, 2011 at 7:35 am
Thank you, guys.
BTW, nobody fixed my English: I'll have to assume it was right, was it? 🙂
-- Gianluca Sartori
February 18, 2011 at 7:04 am
I have to admit it was my fault.
If I didn't post on THE THREAD a "Lennie alert" nobody would have noticed, Lennie would have got his answer and everyone then...
-- Gianluca Sartori
February 18, 2011 at 6:51 am
Koen Verbeeck (2/18/2011)
Gianluca Sartori (2/18/2011)
GilaMonster (2/18/2011)
Craig Farrell (2/18/2011)
Stefan proved to me he's a much better abuser of fools than I am. May I request recruiting his assistance? 🙂
No! Leave...
-- Gianluca Sartori
February 18, 2011 at 3:07 am
GilaMonster (2/18/2011)
Craig Farrell (2/18/2011)
Stefan proved to me he's a much better abuser of fools than I am. May I request recruiting his assistance? 🙂
No! Leave Lennie alone. We don't...
-- Gianluca Sartori
February 18, 2011 at 3:01 am
I suggest everybody to stop posting to this thread.
Lennie seems to know everything he needs, and much more.
-- Gianluca Sartori
February 18, 2011 at 2:43 am
Craig Farrell (2/18/2011)
Gianluca Sartori (2/18/2011)
power chords. 😛Rockband DBA for the win!
:hehe::hehe::hehe: Sorry for the misspelling, it's all Thomas Larock's fault[/url]!!! :hehe::-D:hehe:
-- Gianluca Sartori
February 18, 2011 at 2:25 am
Guys, behave yourselves, please.
Don't let this thread go sideways.
-- Gianluca Sartori
February 18, 2011 at 2:09 am
Do you remember Lennie, the guy with sock-puppets friends?
He's back again. Nothing worth worrying about, at the moment.
http://www.sqlservercentral.com/Forums/Topic1066085-9-1.aspx
-- Gianluca Sartori
February 18, 2011 at 1:30 am
dso808 (2/17/2011)
The bosses are leaning towards this method because they want job application functions run under specific domain accounts. Our SQL servers are running under a service account too.
I...
-- Gianluca Sartori
February 18, 2011 at 1:20 am
Adding this user to the model database, associated with db_backupoperator role will do.
Every new database will be created with this user mapping already set.
Hope this helps
Gianluca
-- Gianluca Sartori
February 18, 2011 at 1:18 am
Last year I went to an Oracle Exadata presentation. They say the future for DBAs will be plugging ethernet and power chords. 😛
-- Gianluca Sartori
February 18, 2011 at 1:13 am
Viewing 15 posts - 3,436 through 3,450 (of 5,393 total)