Viewing 15 posts - 31,606 through 31,620 (of 39,820 total)
Martin,
I'd be interested in knowing exactly how or why it's harder to write stored procedures. In most cases you take your T-SQL, move the variables to parameters and wrap the...
August 23, 2007 at 8:07 am
Agree with Antares above. Get the drivers from IBM, install on your server. You can use DTS or a linked server to get the data.
One issue we've had is that...
August 23, 2007 at 8:02 am
Fishbarnriots has a good point. (what is with that nickname?)
To get close to 100%, I'd actually go through a cleaning process. See if you can wipe out stuff before the...
August 23, 2007 at 8:00 am
Why shorten the column? It's varchar, so no savings in space if everything is under 20.
August 23, 2007 at 7:57 am
There's no way to do this. The SQL login is not related to the Windows login. You could add the Windows login and map it to the database user, but...
August 23, 2007 at 7:54 am
Can you give an example of what you mean by the identity ranges not matching? It's not clear from your first post.
August 23, 2007 at 7:53 am
Hans,
that makes some sense, but a recordset or a table is a fixed width item. So if some rows have 3 column values and some have 5, it doesn't...
August 23, 2007 at 7:48 am
Really you need some third party system or a script as mentioned above. You should have somehting like this to check for other services, not starting, etc.
http://www.serversalive.com/salive/index.asp is reasonable. What's...
August 23, 2007 at 7:42 am
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
Viewing 15 posts - 31,606 through 31,620 (of 39,820 total)