Viewing 15 posts - 31,711 through 31,725 (of 39,917 total)
I haven't seen this, but SQLDiag grabs a lot of info and could eat up space. I think you can determine where this space is, so maybe you can run...
August 23, 2007 at 7:39 am
Sorry, I misread a portion. I've changed the answer to include the currency symbol and edited the explanation (and thrown the question out).
August 22, 2007 at 2:39 pm
It's being fixed!
We're in beta now and we should have this rolled out in a few weeks as we tweak the last few things.
If you want yours changed, send it...
August 22, 2007 at 1:38 pm
The answer is correct and the explanation according to the documentation. It's hard to show them on the screen and perhaps we could use [] or something else, but the...
August 22, 2007 at 10:33 am
August 22, 2007 at 8:57 am
We'll build a cage around it, like the missle launchers in "War Games" and give the key to the SOX guys ![]()
You have a...
August 22, 2007 at 6:43 am
We don't work in Denver!! We order hardware that's shipped out while we ride our horses ![]()
August 22, 2007 at 6:29 am
You are welcome and definitely be sure you work through how to add and delete all the objects (users,schema, linked servers, logins, etc.). It helps to just go through it....
August 21, 2007 at 4:34 pm
Honestly, if you are thinking of this, I'd do it this way.
Replicate back to separate DBs on your main server. This gives you some DR stuff since you can quickly...
August 21, 2007 at 9:56 am
You might be better off with taking your list and running a "connect" to each one as a domain admin (should work) and getting the version. I think that's what...
August 21, 2007 at 9:54 am
missing a comma up there before one of the CASE statements.
CASE when ... end
is like a column. Needs commas to separate out.
You have
select x
, y
case...
August 21, 2007 at 9:52 am
The code pages for the data are different. Meaning the way in which the data is encoded is causing problems. Since the OR works, I'm guessing there's some bug here.
Report...
August 21, 2007 at 9:50 am
It's the cross apply with the function that gets the text. It's not in a table, need a handle to the plan to get it.
August 21, 2007 at 9:48 am
I've run out of INTs in some situations. Like SMS, constant scan type of stuff.
Eventually it's an issue. BigINT gives you more space. If you run out, need to move...
August 21, 2007 at 9:46 am
Viewing 15 posts - 31,711 through 31,725 (of 39,917 total)