Viewing 15 posts - 391 through 405 (of 500 total)
I guess you're referring to the alert in the status line of management studio: "Query complete with errors"
For a very long insert script the Messages pane may be full...
May 21, 2009 at 4:12 am
Samuel Vella (5/21/2009)
Lynn Pettis (5/20/2009)
I'm going to have to say yes. We have two and they can definately be just as bad as the kids at times.
My cat was...
May 21, 2009 at 2:47 am
GilaMonster (5/21/2009)
Lynn Pettis (5/20/2009)
Bob Hovious (5/20/2009)
Gail: There's hope!Many people have cats but go on to live perfectly normal lives. 😛
As long as you remember this...
May 21, 2009 at 2:02 am
Visual studio would be my tool of choice
However - we are not trusted to change anything on the server, and VS requires security settings in web.config - The powers that...
May 20, 2009 at 9:42 am
Lynn Pettis (5/20/2009)
Roy Ernest (5/20/2009)
I liked the answer from Window washer "Are you using SQL Server 2005 Express" and the answer "I am using SQL Server 2005" 🙂
Reminds me of...
May 20, 2009 at 9:36 am
Or this http://www.sqlservercentral.com/scripts/Miscellaneous/31520/ could be what you're looking for
May 20, 2009 at 4:44 am
I'm confused. Do you mean number base 64 or Base64 Text Encoding. The text encoding method will pad to a 4-byte boundary so the result should be B7==....
May 20, 2009 at 4:37 am
The syntax of DELETE on a JOIN can be tricky.
For example, suppose you have Table1 and Table2 joined on Primary Key From Table1 to Foreign Key on Table2
DELETE FROM T1
FROM...
May 19, 2009 at 8:35 am
Here the people who run the live servers do just that. They are Windows server experts who do the clustering, monitoring, hardware, Service Packs, hotfixes, backups etc.
A...
May 19, 2009 at 8:27 am
You can enclose clauses from nested IFs in BEGIN ... END blocks to explicitally show the logic. If there is more than 1 statement in a clause, you...
May 19, 2009 at 8:20 am
FNS (5/19/2009)
Now where's the emoticon for a beer...
Steve ... ?
We could do with a few more emoticons
these ones don't display properly :beer: :rocks: ...
May 19, 2009 at 6:52 am
---- Edit ----------------------------------------------------------
Sorry ignore this: I've just noticed its the SQL2000 group, and ROW_NUMBER() isn't available. But I've left it here for information only.
-------------------------------------------------------------------
Another de-duping method, using the...
May 19, 2009 at 6:12 am
I'm guessing you have 2 Access databases set up as linked servers to SQL 2005 - and the problem is with one of them only.
If so - some things to...
May 19, 2009 at 5:24 am
If you have access to visual studio .NET it may be worth looking at a CLR function. You will have access to the regular expression class which will make...
May 19, 2009 at 5:12 am
Bravo!
code informatique exécution par excellence.
- In case Google didn't translate this correctly - I meant to say
Well done, thats a gread bit of coding. 😀
May 19, 2009 at 3:04 am
Viewing 15 posts - 391 through 405 (of 500 total)