Viewing 15 posts - 3,946 through 3,960 (of 14,953 total)
ghousebmd (6/17/2011)
yes, you people are right, i was mistaken...the right question i have is....advantages of stored procedures compared to views
Stored procedures can perform more complex actions, and can take input...
June 20, 2011 at 6:08 am
Phil Parkin (6/17/2011)
June 20, 2011 at 6:02 am
You can also try server-name "(local)". With parentheses, not with quotation marks.
If you need to find the server name, check what services are running on your machine. You're...
June 20, 2011 at 5:59 am
Eric M Russell (6/16/2011)
June 20, 2011 at 5:53 am
Okay, now I'm curious, because I can't see any correlation between SSIS being used, and xp_CmdShell being enabled.
An SSIS package, even if run under sysadmin rights can still only do...
June 20, 2011 at 5:52 am
Mike, don't worry about Joe's accusation of violating Netiquette. He actually, per his own confession, tries to be extremely rude in his online personna. He accuses everyone of...
June 20, 2011 at 5:40 am
Ross McMicken (6/17/2011)
Steve Jones - SSC Editor (6/14/2011)
June 17, 2011 at 9:11 am
george sibbald (6/17/2011)
Part of my requirement for dev is that it be set up in such a way that breaking it inconveniences nobody except the devs.
How do you...
June 17, 2011 at 9:04 am
Jeff Moden (6/17/2011)
Brandie Tarvin (6/16/2011)
June 17, 2011 at 7:51 am
george sibbald (6/17/2011)
Gus, SA in dev, really? Should that ever be a necessity?
any more for...
June 17, 2011 at 7:34 am
What's an "over view"? Never heard of such a thing.
A "view"? Sure. An "over view"? No clue.
Assuming you mean "view", and misunderstood the question you're being...
June 17, 2011 at 7:01 am
I'm accustomed to using "AS" for aliasing, so it's what I use. Can't say it's got a real advantage.
Since table aliases have to be "following style" (using "AS" or...
June 17, 2011 at 6:57 am
george sibbald (6/17/2011)
quick straw poll if you don't mind guys -how much access should developers have in a development environment?
As much as they need. Really, in a dev environment,...
June 17, 2011 at 6:50 am
opc.three (6/17/2011)
You're not going to "physical order" are you? I'm pretty sure all that's needed is logical order. Once the data...
June 17, 2011 at 6:47 am
Jeff Moden (6/17/2011)
opc.three (6/16/2011)
:Wow: I just set myself up big time huh?
Nah... considering the number of hacker attacks designed specifically to exploit OLE DB Automation, I can see your point...
June 17, 2011 at 6:41 am
Viewing 15 posts - 3,946 through 3,960 (of 14,953 total)