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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to restore database from data files
What version do u use ? If u use SQL Server 2000, you can easily do this kinda problem.... Coz, SQL Server 2000 has added new feature for easy to use, named = Attach Database. To find this new feature, kindly do a right-click on your mouse at Database and you can find a dropdown menu named =...- Jokauw
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Querying a query inside another query !
why don't u try to use VIEW tables in SQL Server ??? In your Database Treeview, you will see some child nodes from the Database, they are, Diagram, Tables, Views, Store Procedures, ....etc... Choose View, nd create your own view. If u have 3 queries, you can do this.... Create ViewA and ViewB...- Jokauw
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Can not connect to sql2000 from some WS
hmmm.... I've experienced this too... I don't know the exact solutions.... I'm trying to search for the solutions also... But, for a moment, you can try to install SQL Tools named = Connectivity tools. Try to install it from your SQL Server 2000 CD. It works for me... Jokauw- Jokauw
- Post #3
- Forum: Microsoft SQL Server: Programming
