Help Desk

5 comments:

1. Unknown said...
   February 22, 2008 at 11:23 AM  

   All Friends
   
   Can some one help me how to create a database in SQL 2005 and also how to see how many database are created and i am using which database.
   
   Thanks in Advance
   Guru

2. Naveen Kumar said...
   February 22, 2008 at 12:03 PM  

   I am dividing your question in multiple questions and answer them one by one.
   
   Q1) How to create database(D in SQL 2005.
   A) You can create DB in two ways
   i. Management studio -> In object Explorer, expand your server name-> Databases -> Right click and select New Database
   ii. Query Analyser -> CREATE DATABASE MYDATABASENAME
   
   Q2) How many DB's
   A) Visually from Management Studio and from Query analyser -> select * from sys.databases
   
   Q3) Db in use
   A)select DB_NAME()
   
   Answered By Mr Ajit Kumar from Value Labs

3. Anonymous said...
   February 28, 2008 at 6:25 PM  

   I want to import all database names into my SQL Server using a query
   
   Can some one help me with the query?
   
   Thank
   sanjay patil

4. Miracle Kid said...
   February 29, 2008 at 12:39 PM  

   Hi,
   My understanding of the question: You want to get the list of databases on another server B and insert into a table on your server A
   
   Soln: 1. Link both the servers, i.e Link Server B from Server A, using GUI or Sp_Addlinkserver
   If your Link name is [remSrvr]
   Now use fully qualified name to query
   
   select * from remSrvr.master.sys.databases
   
   now if you insert the data into any table, then
   
   select * into myDBlist from remSrvr.master.sys.databases

5. Anonymous said...
   March 3, 2008 at 3:27 PM  

   Useful information in sql 2005 -
   
   One of new features in SQL 2005 that I haven't seen much talk about is that you can now add aggregate functions to any SELECT (even without a GROUP BY clause) by specifying an OVER() partition for each function. Unfortunately, it isn't especially powerful, and you can't do running totals with it, but it does help you make your code a little shorter and in many cases it might be just what you need.
   
   Regards
   SQL Experts

Post a Comment