00088.jpg
View from the Sofitel (c/o Wendy Rourke)
HPIM0063.jpg
pretty colours!
de-commissioned crane
00099.jpg
miscellaneous 069.jpg
HPIM0236.jpg

 

September 2010
M T W T F S S
« Jun    
 12345
6789101112
13141516171819
20212223242526
27282930  

The proposed new database owner is already a user in the database.

This is an error to do with a syncing issue as described here
Sp_changedbowner will return message ‘the proposed new database owner is already a user in the database’ if the sysdatabases/sysusers mapping is out of sync and the sysusers dbo SID is already mapped to the login. All you need to do is execute sp_changedbowner [...]

Popularity: 31% [?]

Everybody's a critic WTF?? Nothing about this made senseas useful as a blindfolded monkey throwing dartsmediocre ... at bestsolved my problem but needed modificationspectacular.  \'Nuff said (3 votes, average: 4.00 out of 5)
Loading ... Loading ...

Views accessing other databases

The default behaviour of SQL Server 2000 post servicepack 3 is for databases not to be able to access other databases through views. This is a really, really stupid thing - when I first approached this, I got really stumped about how to allow a view to access a table in another database with [...]

Popularity: 11% [?]

Everybody's a critic WTF?? Nothing about this made senseas useful as a blindfolded monkey throwing dartsmediocre ... at bestsolved my problem but needed modificationspectacular.  \'Nuff said (Be the first to rate this post)
Loading ... Loading ...

Parsing the same line multiple times in ActiveX

For work, it was neccessary to split out a single line that was separated by “ý” characters into a single column with multiple rows.
Popularity: 12% [?]

Popularity: 12% [?]

Everybody's a critic WTF?? Nothing about this made senseas useful as a blindfolded monkey throwing dartsmediocre ... at bestsolved my problem but needed modificationspectacular.  \'Nuff said (Be the first to rate this post)
Loading ... Loading ...

SQL activeX file concatenation

Believe it or not, vbscript doesn’t seem to have a filesystem object that allows file concatenation.
Popularity: 46% [?]

Popularity: 46% [?]

Everybody's a critic WTF?? Nothing about this made senseas useful as a blindfolded monkey throwing dartsmediocre ... at bestsolved my problem but needed modificationspectacular.  \'Nuff said (Be the first to rate this post)
Loading ... Loading ...

SQL activeX script failure

Sometimes, when using activeX scripts written in basic (aka activeX), the failure of a portion of the script doesn’t trigger a failure trigger.
Popularity: 25% [?]

Popularity: 25% [?]

Everybody's a critic WTF?? Nothing about this made senseas useful as a blindfolded monkey throwing dartsmediocre ... at bestsolved my problem but needed modificationspectacular.  \'Nuff said (Be the first to rate this post)
Loading ... Loading ...