SQL Query to Find List of Open Connection Objects in MS SQL Server

Asked by Lisa on 12/7/2009 3:41:21 PM

I want to see all the connection objects that are opened in a single point of time. What is that sql query that i can write to figure out the answer? If you know the sql query that works with any version of MS SQL Server then that will be a real help to me.


Comment (1)

How to Write a Query to Search Multiple Strings From Multiple Columns

Asked by Lisa on 4/27/2009 2:18:09 PM

I am trying to code a special search module for my website and I am lost here. I want to write a fast performing sql query so that it return data from table very fast. I have array of keywords to search from various fields of the table. Can anyone help me in writing such queries?


Comment (0)

How can I query two SQL Servers from one application

Asked by Lisa on 3/2/2009 4:22:06 PM

I have an application where I have to make a join query from 2 tables from different servers. How do i write this query to get the result set? Please give me an example query to work from. Thanks a lot for helping me in advance.


Comment (0)

I am getting error while importing from xl sheet to SQL Server 2008

Asked by Andy on 3/2/2009 3:42:50 PM

I have installed SQL Server 2008 after installing visual studio 2008, now i want to import some data from a xl sheet but I am getting error while trying to import from that. I know people are finding tough when they installed SQL Server 2008 after installing visual studio, is that the fact? Should I just re-install all or there is another solution that i can follow to solve this.


Comment (0)

Remote Connection Error While Connecting SQL Server 2008

Asked by Khusi on 2/16/2009 3:55:35 PM

I installed SQL Server 2008 and it is running fine while i am using the server locally but I am getting error when I am trying to connect it remotely. Here is the details of the error:

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections."

Please help me in finding the solution to this problem.


Comment (0)

How to use data compression in sql server 2008

Asked by Lisa on 2/12/2009 5:01:51 PM

I know that sql server 2008 takes very less space to store data and there is a feature called data compression that can be used for reducing the data size. I have a big data base that needed to be reduced. please tell me the best approach to proceed for this so that i should land safe with no issues.


Comment (0)

I want to schedule a job in SQL Server 2008

Asked by Ritu on 2/6/2009 4:26:11 PM

I have a folder that gets updated with some files, I want my sql server to run script on every time that folder gets updated. I want to schedule one job but kind of not sure how to do it. Is it something to do from the windows scheduler or from the SQL Server scheduler? Let me know the best approach to get the desired result.


Comment (0)

How to create a new table using existing tables

Asked by Sangeeta on 2/6/2009 8:14:42 AM

I have to create a new table using the columns and records present in another tables. I can create the new table by writing the CREATE TABLE .... Query but as my database already has the tables with same column name, I want to reuse the column names as well as the records present in those columns.

Can anyone tell me the SQL Query for it?


Comment (0)

How to get records present in one table but not in other

Asked by Sangeeta on 2/5/2009 9:59:10 AM

I have two tables with an identical data structure. There are records in both tables but they are incomplete without one another because both the tables have unique data to represent.

I need to get all the records by consolidating the two tables into one with all unique records from each table i.e. a SQL Query which will select all the records from table 2 that don’t present in table 1.

Can anyone tell me how to fix this issue?


Comment (0)

How do I start SQL Server 2008 Services

Asked by Andy on 2/4/2009 3:04:00 PM

I have installed sql server 2008 express edition with the client tool but kinda not sure about the ways to start the services. Where is the icon or menu to start the sql server 2008 express edition. Is this easy to learn?

Please help me in learning sql server 2008.


Comment (0)