Viewing 15 posts - 6,106 through 6,120 (of 9,722 total)
Silly question, why not stick the results into a Temp table, then haul out the commands on a line by line basis, since you have so many tables to deal...
April 13, 2011 at 4:12 am
thulani.moyana 79207 (4/12/2011)
To Brandie: I think the remote connection timeout is used by the SSMS when connecting to other servers not the application. Please verify.
So far as I know, a...
April 13, 2011 at 4:08 am
CirquedeSQLeil (4/12/2011)
Brandie Tarvin (4/12/2011)
April 12, 2011 at 12:16 pm
Hey, Ninja, I just realized that Varchar(MAX) isn't big enough to handle a database with a lot of tables. I've tried it on two of my "larger" databases (object-wise, not...
April 12, 2011 at 12:08 pm
I'm curious. Why does a simple concat need variable = variable + string logic? I only ever use that when I'm COALESCING or looping (Cursor or While).
What are you...
April 12, 2011 at 12:03 pm
The context is this:
RE: datatypes discussion
April 12, 2011 at 8:09 am
WayneS (4/12/2011)
Brandie Tarvin (4/12/2011)
DECLARE OMG_NotAnotherCursor CURSOR GLOBAL_SCREAM BACKWARD_FACING
STATIC_THE_SUPERHERO PESSIMISTIC DB_LOCKDOWN
FOR
SELECT Superpower
FROM dbo.JusticeLeague
WHERE SupType = 'Lightning'
OPEN OMG_NotAnotherCursor
FETCH LAST FROM OMG_NotAnotherCursor
...
April 12, 2011 at 7:53 am
You probably didn't see my edited comment.
Check the Server / Instance's "remote query timeout" property. This can be found by right-clicking the server\instance name, navigating to Properties, the clicking on...
April 12, 2011 at 7:52 am
This .net application, is it making a Web Service call or is it a direct programmed connection string?
Is there a firewall between the PC this app runs on and the...
April 12, 2011 at 7:37 am
I think this cursor suits Stefan's needs best.
DECLARE OMG_NotAnotherCursor CURSOR GLOBAL_SCREAM BACKWARD_FACING
STATIC_THE_SUPERHERO PESSIMISTIC DB_LOCKDOWN
FOR
SELECT Superpower
FROM dbo.JusticeLeague
WHERE SupType = 'Lightning'
OPEN OMG_NotAnotherCursor
FETCH LAST FROM OMG_NotAnotherCursor
INTO @WhatsThisVariableForAgain
WHILE...
April 12, 2011 at 5:58 am
Stefan Krzywicki (4/11/2011)
GilaMonster (4/11/2011)
Stefan Krzywicki (4/11/2011)
Believe me, I don't want to be using a cursor, but it is part of production code and every time I mention changing it to...
April 11, 2011 at 11:56 am
Peter Trast (4/11/2011)
Brandie Tarvin (4/11/2011)
Scope creep.(and, lemme tell you, Mr. Scope is definitely creepy. @=)
Is it possible to stop?
Sure it is. Just remove everyone's system access. Then they can't give...
April 11, 2011 at 11:35 am
Scope creep.
(and, lemme tell you, Mr. Scope is definitely creepy. @=)
April 11, 2011 at 11:09 am
Steve Jones - SSC Editor (4/11/2011)
Happy Monday. :hehe:
HA! As if.
Cluster down again. Much scrambling to get things working before the BU showed up.
Does it count as murder if...
April 11, 2011 at 10:41 am
That's what I figured. But fortunately, that's not a problem for me today.
April 11, 2011 at 8:58 am
Viewing 15 posts - 6,106 through 6,120 (of 9,722 total)