Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to check data size?
This will give you your DB Size in MB... select "DBSize Meg" = sum( round( (a.low * convert(float, u.size)) / 1048576, 1)), "DBSpaceUsed Meg" =sum( round( (a.low * convert(float, u.size)) / 1048576, 1)) - sum((curunreservedpgs(u.dbid, u.lstart, u.unreservedpgs) * 2/...- Flem
- Post #4
- Forum: Sybase: Adaptive (SQL) Server
-
How do you search a field for a value, ex: search for "a" in Happy
Hi, Not sure that this will help but to get this done and me being a bit new to this area I would simply bcp out the table and import it to Excel, you can easily parse the field into the two fields and bcp it back in.. bcp DbName.Table out table.txt -c -Uuser -Ppassword -Sserver Then in...- Flem
- Post #2
- Forum: Sybase: Adaptive (SQL) Server
-
Loading an "unknown" Dump File
Hi , I have received a database dump on a tape with no details, I have copied it to the server and have 3 files. 1 2meg, 1 meg, and > 3GB . I guess these are trans log, header and database....when I try to which when I try to load any of the dumps I get the message : Backup Server session id...- Flem
- Thread
- Replies: 0
- Forum: Sybase: Adaptive (SQL) Server
