eranna (8/21/2009)

---

i cannot access this server remotely, thats the whole issue. I think we can configure only through SSMS to allow remote connections, pls let me know if there's any...

Can you access this instance remotely or is there a particular reason you need to work on the server?

Regards,

Andras

naumanikram2008 (6/11/2009)

---

scope of my work is

my select statement is having null value in a column as shown below,

1first

2NULL

32nd

4NULL

5NULL

6NULL

what i want if there is any null value found previous column...

bill.summers (6/10/2009)

---

I have some name and address data that has the city and state in one column. I have created a state column and moved the states into that...

jain_abhishek (6/10/2009)

---

Hi I have two databases on same server and both databases.These do databases are same (we can say replica) .There is a table name 'Transactions' on both databases.Now I...

reachviji83 (6/10/2009)

---

guptaopus (3/10/2008)

---

Hi,

I would like to use a stored procedure that calls other stored procedures and use a

temporary table to pass the results back and forth.(from Parent to child)

anybody help...

priya_jengathe (4/8/2009)

---

Hi,

I come to know that we cannot pass Table variable as a parameter to storeprocedure in

SQL SERVER 2005 . Please consider below senario ...

have datatable and wanted to insert...

How are you storing the xml that you generate? Are you using the xml data type on SQL Server 2005?

An example would certainly help.

- Regards,

Andras

Could you provide more details about which option that is greyed out?

- Andras

Alan-of-Boston (12/18/2008)

---

Yesterday I downloaded and installed SP3 and got build 4028.

This morning I downloaded build 4035.

What is the difference? (aside from the date and slight difference in phase...

To do this you can get the current def trace file name by

SELECT value FROM ::fn_trace_getinfo(0) where property = 2

then substitute the filename, and search for events 104 (indicating...

The primary key in this case will not help performance, but it will not make it worse either 🙂 But it will add the benefit of enforcing that the rows...

It could be an expensive operation, but it should work. Note that by default when you add a primary key constraint to a table, and a clustered index does not...

dva2007 (10/8/2008)

---

Again i am thinking about year 2008. We will get more and more data as time goes and in this way it will work only for certain months and...

You can do this by using sum, group by and case:

SELECT [Name]

, SUM(CASE WHEN [Month] = 'Apr-08' THEN [Total]

...