prakashdotc (12/22/2008)

---

Hi All,

Here's my description about my Query

i Have a Table with Columns as ProdId, Value, Date

Users will enter some value for each product on various date

The Task is to...

subha.v (12/22/2008)

---

Hi All,

I have run the query like

Select ColB,ColC from table1 where ColD= 123.

It takes nearly 30 min to finish the execution.

In this table ColD have a non-clustered index. And...

sowmya.br (12/16/2008)

---

Hi All,

I have a problem using temperory table in dynamic TSQL

I am building one sql statement dynamically through stored procedure parameters and then trying to use this sql result...

rajoo.sharma (12/16/2008)

---

Hi,

Thank you so much for helping me.

I added the alias as you suggested but what should I do now?

I explain the complete setup:

The machine on which SQL server is...

Hans Peeters (12/9/2008)

---

Hi,

I looked at the video of File System task.

I know how to copy 1 single file from 1 directory to another.

I cannot find how it works with multiple...

Gauthama Kolivad (12/10/2008)

---

Using the same DB... I mean without using backup ... we cant restore a stored procedure to the previous version.

As Gail Shaw mentioned if you have backup...

Graeme100 (12/10/2008)

---

Hi,

Haven't been a round for a while, but will try to be more active 🙂

I quick question.

I have a sql2000 sp4 server...that's fine.

Now in Enterprise Manager it is now...

charbeljoseph (12/10/2008)

---

Hi All,

We have two clustered SQL Server 2005 Standard Edition based on Windows Server 2003 Enterprise R2 32Bit with those hardware specification:

Intel Xeon CPU 3.16Ghz with 24GB of...

sotn (12/2/2008)

---

I have to take a mySQL database (150+ tables) and place into a SQL Server database

I know I can create 1 ado net source (data flow source) per table...

Stuart Wells (12/2/2008)

---

Hi

I have a storedprocedures which need to to execute some dynamic SQL via sp_executesql.

The only access a 'normal' user has to my storedprocedures is via GRANT EXECUTE on...

Swirl80 (12/1/2008)

---

When i try to access the "Windows Integrated Security" tab under reporting services on SAC i get this error:

The underlying connection was closed: An unexpected error occurred on a...

Dean Jones (12/2/2008)

---

Hi All,

I was wondering whether there is a script/way out there in which one can monitor disk space on a network shared drive, I know once can use...

see the link:

http://support.microsoft.com/default.aspx/kb/274750

http://msdn.microsoft.com/en-us/library/ms175581.aspx

use can change the database...

avhlasith (12/1/2008)

---

hi all,

i need to inner join temp tables to get data set.i have create temp table as follows

declare @TableVariable table(id int,[name] varchar(20))

declare @TableVariable1 table(id int,[name] varchar(20))

insert into @TableVariable values(1,'Microsoft')

insert...