Viewing 15 posts - 32,281 through 32,295 (of 59,102 total)
sqldba2k8 (10/15/2011)
Please provide me the learning material or books for sql...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2011 at 12:25 pm
Gugro (10/15/2011)
Todd Engen (3/6/2008)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2011 at 12:17 pm
erhanduman (10/15/2011)
I'm tried with join and pivot table methods. But I can't do it. Is there any suggestionThanks
Erhan
Cool... show us the code you tried and we'll show where you may...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2011 at 12:06 pm
Aspet Golestanian Namagerdi (10/15/2011)
DECLARE @Temp AS INTEGER
SET @Temp = 1
WHILE @Temp <1000
Begin
...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2011 at 12:03 pm
Ninja's_RGR'us (10/14/2011)
Brandie Tarvin (10/14/2011)
Or is there something in the code that makes even a screen shot show each...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2011 at 11:49 am
Ninja's_RGR'us (10/14/2011)
Is [font="Arial Black"]that [/font]why you stopped being a manager and went back to "normal" DBA?
Considering I covered several different topics in my post, is WHAT why?
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2011 at 11:45 am
rmechaber (10/14/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 14, 2011 at 10:06 am
It may not be a permissions issue... You also have to remember that xp_CmdShell will NOT find "mapped drives" using drive letters... only physical drives. Instead of mapped drives,...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 14, 2011 at 9:16 am
To add to ChrisM's code, please see the following article on how to display smaller hierarchies likes this...
http://www.sqlservercentral.com/articles/T-SQL/72503/
--Jeff Moden
Change is inevitable... Change for the better is not.
October 14, 2011 at 9:09 am
Brandie Tarvin (10/14/2011)
Performace Guard (Shehap) (10/14/2011)
Guys, please feel free to have a tour through different date time converstion per the link below :
Wow. That website is completely unreadable and horribly...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 14, 2011 at 8:50 am
R.P.Rozema (10/14/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 14, 2011 at 8:43 am
@opc.three,
What's funny about all of this is that xp_DirTree, xp_CmdShell, xp_FileExists, etc, etc, etc all live in a single DLL called XPSTAR.DLL. Why they didn't take it just one...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 14, 2011 at 12:55 am
I know it's an old post but right, back in SAQL Server 2000, if you right clicked on an extended sproc and told it to execute, the number of parameters...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 9:48 pm
sturner (6/22/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 9:43 pm
SQLRNNR (6/28/2011)
opc.three (6/28/2011)
SQLRNNR (6/28/2011)
Here's an article discussing the steps referenced by opc.threehttp://sqlblog.com/blogs/tibor_karaszi/archive/2007/08/23/xp-cmdshell-and-permissions.aspx
Thanks Jason, I will keep this one to pass along, at least until Jeff publishes his article on how...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 9:36 pm
Viewing 15 posts - 32,281 through 32,295 (of 59,102 total)