Viewing 15 posts - 7,396 through 7,410 (of 14,953 total)
You can either uninstall Express, or install Dev Edition as a second instance. Personally, I'd uninstall Express.
December 17, 2009 at 1:24 pm
blandry (12/16/2009)
December 17, 2009 at 10:05 am
Adam Gojdas (12/16/2009)
Using a DROP/CREATE with an IF EXISTS clause instead of an ALTER statement for deploying SQL Server objects like stored procedures is one example of a standard that...
December 17, 2009 at 10:02 am
Bru Medishetty (12/16/2009)
December 17, 2009 at 6:49 am
CirquedeSQLeil (12/16/2009)
john.arnott (12/16/2009)
CirquedeSQLeil (12/14/2009)
Alvin Ramard (12/14/2009)
GSquared (12/14/2009)
CirquedeSQLeil (12/11/2009)
December 16, 2009 at 2:40 pm
Take a look at Try Catch in Books Online. It has all the details.
Basically, errors with a severity below 11 won't fire off the Catch block. Errors 11...
December 16, 2009 at 2:31 pm
Can you provide the table definitions and some sample data for the current tables?
From what you're describing, it seems like the whole thing could be simply a few joins and...
December 16, 2009 at 1:45 pm
Lynn Pettis (12/16/2009)
December 16, 2009 at 12:39 pm
Peter E. Kierstead (12/16/2009)
Dude, you rock! I totally missed that in BOL... But I'm still not going to take back the MICROSOFT @)(@#$)(*@#$#@$...
Thank you.
As for the comment about MS: Trust...
December 16, 2009 at 12:35 pm
I've used Apex SQL Edit. It works. Might do what you need. Haven't used TOAD, but from what I've heard, I'm probably not missing much.
December 16, 2009 at 11:57 am
Grant Fritchey (12/16/2009)
GilaMonster (12/16/2009)
December 16, 2009 at 11:53 am
Computers are becoming easier for end-users, not for DBAs. For us, it gets more complex all the time!
This site had a series of articles last year (I think it...
December 16, 2009 at 11:37 am
You don't have to convert/cast the data. Use "type" in the For XML clause.
select (select 1 as Val for xml raw, type);
If you don't use "type", it comes out...
December 16, 2009 at 11:32 am
Not a problem. Easy mistake to make.
December 16, 2009 at 10:09 am
The "success" block IS the try block. If something succeeds in the try block, it just moves on to the next command.
December 16, 2009 at 10:09 am
Viewing 15 posts - 7,396 through 7,410 (of 14,953 total)