| ||
![[url]](/raster/images/iconweb.gif){kind=small}
![[email]](/raster/images/iconmail.gif){kind=small}
![[pgp key]](/raster/images/iconpgp.gif){kind=small}
| ||||
![[More Info]](/raster/images/qmark.gif){kind=small}
| ||||
![[RasterWeb]](/raster/images/rhead.gif)
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 inporting 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]](/raster/images/up.gif){kind=small}
![[horizontal rule]](/raster/images/tanline.gif){kind=small}