Yes i Agree,

However in second line of question, following is also mentioned.

"The values are listed as ID, TEST1, TEST2. For example: "

So reading full question and all details can...

Hi chaseurpuli,

I think the data in "empid 1" is not matching due to spellings mis-match. Please make sue whatever you are asking is really correct. Please try to better format...

Hugo Kornelis (6/25/2012)

---

When I answered the question, I *knew* I was taking a gamble on the intended interpretation.

What convinced me to pick the "wrong" answer was the wording: "can have...

Hi,

Following links might be helpful for someone which states limitation of SSRS2005 and a "Legitimate" way of pushing people to next version of SQL Server.

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/9d8cd766-ff78-490f-8a5d-bb4a0debdfc1/

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

Thanks.

Hi,

Finally i found a solution myself.

All above steps are correct plus following using SSCM

On the same machine, i have given different IP to both instance and different post

DefaultInst =...

Thanks arthurolcot,

The idea is to take a certain DML action on all nodes, based on the newly added attribute and according to the requirement at a particular time.

I tried different...

Strange!!!

How long it takes to run same on Production? OR is there significant change in test and prod instance data? May be someone has populated/doubled the data on test for...

Agree. Ok then "Mark-101232" solution is already there.

Thanks.

How much max memory allocated to SQL Server instance?

select

'A' as [test/value1],

'B' as [test/value2]

for xml path(''), type

Please put a case statement on logtext column,

CASE WHEN LogText Like '%error%' then 'Failed'

ELSE 'Success' -- "Database backed up."

END

Cheers.

Please read the scripts and change the parameters where necessary.

Sometimes your required information might be in archived files. so change the xp_readlog paramter values to 1,2,3

I believe it...

Hi johnnyrmtl,

You could use following script to get the details of your completed backups.

USE msdb

GO

/*

Following statements can be used to further narrow down the information.

Please change query parameter/variables...

Hi johnnyrmtl,

The backups related detailed information of completed backups is available in msdb.

However, Error/success can be obtained from sql server logs. Please try the following script.

GO

/*

Using sys.xp_readerrorlog. Please check...

sukhoi971,

If you just want to rebuild indexes then you could use this script. This is the simplest version to do this. There are few others complex script which are based...