Is this you need

create table #Temp (id int,name varchar(30), surname varchar(30) ,age tinyint)

insert into #Temp values (1, 'John', 'Smith', 20)

insert into #Temp values (2, 'Pen', 'Drive', 14)

Select COL_NAME(OBJECT_ID('#Temp'), 1)+':'+convert(varchar,Id)+';'+COL_NAME(OBJECT_ID('#Temp'),...

Ninja's_RGR'us (4/18/2011)

---

Agreed, but I can't remember the last time I use a temp table with only 1 column in prod... hence always seems like a nice argument to have...

It is a very good practice to have column name even though there is a single column ,I just said because TheSQLGuru has stated that it will not work.In order...

asterman_3 (4/17/2011)

---

Hi,

I would like to ask whether it is possible in SQL 2008, when creating database audit specifications, to specify Column Level. Whenever a column is "touched" (ex. updated), to...

TheSQLGuru (4/18/2011)

---

Your problem has nothing to do with dynamic sql. You CANNOT use a SELECT * in an IN clause. You must specify a single column name there,...

Have a look on the following links to have some idea

Monitoring Job Activity

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

Job Activity Monitor

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

Hi

1.create table #Temp (t int,J int)

2.create clustered index T_temp on #Temp(t)

3.Select * from #Temp where t=0 and j=1

4.create nonclustered index T_tempNon on #Temp(j)

5.Select * from #Temp

6.Drop table #Temp

1.Table created

2.Clustered index...

Im..In that which column where encrypted (all the columns or only few).

How was the encrypted data any sample you can have over...

How did you find that columns where Encrypted ?

Change data capture provides information about DML changes on a table and a database. By using change data capture, you eliminate expensive techniques such as user triggers, timestamp columns, and...

Try this

DECLARE @SQLString nvarchar(500);

DECLARE @ParmDefinition nvarchar(500);

DECLARE @TDATA varchar(30);

declare @QName varchar(50)='TBL_Q6310'

SET @SQLString = N'SELECT @TDATAOUT = Count(*) FROM '+@QName

SET @ParmDefinition = N' @TDATAOUT varchar(30) OUTPUT';

print @SQLString

print @ParmDefinition

EXECUTE sp_executesql @SQLString, @ParmDefinition, ...

kr.nithin (4/14/2011)

---

Our Current Production Server runs on SQL Server 2008 R2 Enterprise Edition. We want to implement a separate Report Server & Tables on the report server will...

Try with

Exec sp_MSforeachdb

Not sure about it have a try.

Look at

http://support.microsoft.com/kb/246133

http://support.microsoft.com/kb/918992

http://support.microsoft.com/kb/240872

The datatype which your table might be having as prec 8,2 so it is returning as 0.00...