RasterWeb: Code: Microsoft SQL Notes

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:

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!)

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