Viewing 15 posts - 4,921 through 4,935 (of 5,590 total)
Lynn Pettis (12/4/2009)
GSquared (12/4/2009)
WayneS (12/4/2009)
I'm having a weird issue. I can run a select * from a view from SSMS, no problem. Web site can't run it, and can't...
December 4, 2009 at 9:13 am
Hey gang...
I'm having a weird issue. I can run a select * from a view from SSMS, no problem. Web site can't run it, and can't open the view from...
December 4, 2009 at 8:35 am
Gus - definitely not looking good. Like you said, might be good or bad news. Agree with all others to start looking.
Best of luck!
December 4, 2009 at 8:33 am
Jason Miller-476791 (12/3/2009)
... It comes down to having to trust SOMEONE at some point...
Aren't these the people that you get insurance bonding for? So it really comes down to...
December 3, 2009 at 7:52 am
From what I've read about this issue, your job step needs to be set to Operating System (CmdExec), and you have to type the full path to the 32-bit version...
December 1, 2009 at 7:32 am
Gail, I'm so glad that you gave such a good response here earlier. We just discovered this on one of our prod dbs, and using option 2 we were able...
November 10, 2009 at 5:21 pm
Jack Corbett (11/9/2009)
What VPN client are you using?
We've been using "The Greenbow VPN", but are shifting to "OpenVPN". Both are having this issue.
You might want to check to see if...
November 9, 2009 at 9:34 pm
Paul White (11/1/2009)
November 2, 2009 at 6:10 pm
Paul White (11/1/2009)
or by creating a (very reasonable) PRIMARY KEY on the RowID column of the #Update table.
I was going to ask what kind of indexes you'll thought would be...
November 1, 2009 at 7:17 pm
Bob Hovious 24601 (10/31/2009)
November 1, 2009 at 9:42 am
About the only time I use a select * inside code is when I've done something in a CTE that then defines the columns.
Even then, it's rare. But the point...
October 31, 2009 at 7:54 pm
Even though I posted this looking for a SQL 2005 solution, I tried out Paul's newest code. And I'm happy to announce that this new bit of code has redeemed...
October 31, 2009 at 7:35 pm
Attachment added to original post... I know I had it there the first time (it was the first thing I did so that I wouldn't forget), but I wonder what...
October 31, 2009 at 3:41 pm
Bob Hovious 24601 (10/29/2009)
I wonder if, under the covers, an UNPIVOT is really just a cross join like Peter's solution.
I don't think so... it doesn't perform like one.
October 31, 2009 at 11:17 am
Viewing 15 posts - 4,921 through 4,935 (of 5,590 total)