CREATE TABLE T2 ( state varchar(10), amt money, per varchar(10) )

INSERT INTO t2

SELECT 'NSW','130','person1'

UNION ALL

SELECT 'QLD','100','person1'

UNION ALL

SELECT 'NSW','120','person2'

UNION ALL

SELECT 'QLD','200','person2'

UNION ALL

SELECT 'NSW','110','person3'

UNION ALL

SELECT 'QLD','300','person3'

WITH A ( state, Totalvalue, Maxvalue) as

(SELECT...

Create table T1 (ModifiedDate Datetime, Ignition BIT)

INSERT INTO T1 (modifieddate,Ignition)

Select '2010-07-05 13:36:24.470', 0

UNION ALL

SELECT '2010-07-05 13:37:28.513', 0

UNION ALL

SELECT '2010-07-05 13:38:33.560' ,1

UNION ALL

SELECT '2010-07-05 13:39:38.623' ,1

UNION ALL

SELECT...

You need to install few DLL's to make it work.Follow the steps in this link

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

Thanks,

Ashwani

Hema,

If it is windows 2003 server, then the Inplace upgrade is pretty straight forward. The only thing is you will have to install SQL 2008 upgarde on both the nodes...

I did the Inplace ugrade from SQL 2005 to SQL 2008 recently. SQL2008 cluster setup does not install the binaries on another node automatically. You will have to install it...

To backup on the network, you need to use UNC - \\servername\sharename\backup.bak

To backup on the network, you need to use UNC - \\servername\sharename\backup.bak

SELECT orderid,buyerid,title,SUM(saleprice),partnum FROM @sourcetable Group by

Grouping sets ((orderid,buyerid,title,partnum ),(orderid),())

This Link helped me.

http://technet.microsoft.com/en-us/library/ms366281(SQL.90).aspx

Thanks for the response. But actually I am calling the encrypted column from another database in my query and it is not working. I am getting NULL's. If I...

Eddie,

Please help me also.

I have an encrypted column on a table on one Database and I want to decrypt it from another database.

USE DB2

GO

OPEN SYMMETRIC KEY SSNFieldSymmetricKey

DECRYPTION...

GilaMonster,

Thanks a lot for the tip. I was getting the same error and there was this job which was truncating the logs after the full backup

Thanks a lot

Did you get the solution to this problem? I am having the same problem and wonder if you could let me know the solution