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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
use query results in new query
query1 select blah from table query2 select blah2 from table2 where blah1 = query1.blahid -
Backup in floopy disks, How?
Use winzip and have it span the backup to multiple floppys. When you zip a database it almost always decreases the size by 80%. Joshua Tipton DBA United Parcel Service- tjosh
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Can you start a dts from a stored procedure?
the user executing this package must have execute rights to the sp_OA* sps in master. This code calls some sp_s in the master database that do not exsist on a default install. You must run it get the error and then look up the SPs in Books online and create them. Hope this helps and if you...- tjosh
- Post #2
- Forum: Microsoft SQL Server: Programming
