[an error occurred while processing this directive]
[url] rasterweb.net/raster/
[email] pete@rasterweb.net
[pgp key] public key

RasterWeb [More Info]
Home
About
Contact
Archives
Search
Mobile Edition
Kids
Misc
Rambles
Computers
Code

Code:
Code contains bits of text that are probably more interesting to computers than people...


[RasterWeb]

These are my MS SQL notes, of interest to probably only me... or maybe you...?


When tables go bad!

I had a table go bad, so I imported a new one from a backup - BUT - seems the owner got changed in the process
to 'dbo' which broke other things... I fixed it by renaming the table, creating a new table via SQL, and then importing
the old table into the new table. In theory I could have used the sysobjects table to reassign the owner, but of course,
that didn't work... argh!


Make a backup/copy of a table:

SELECT * into TableCopy from Table

See this page for more...


Perl to the rescue!

The Win32::ODBC perl module isn't great... but it seems to work ok... most of the time...




more to come (unfortunately!)



[top of page] [horizontal rule]

  Last Modified: 10/2/01..2001 by rasterboy