:w00t:

select serverproperty('isclustered') -- will give clusterd or not

declare @Out nvarchar(400) ...

Hi,

As per the MS, need to go for SP1.

More info available @

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

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

http://blog.sqlauthority.com/2011/05/03/sql-server-error-failed-to-retrieve-data-for-this-request-microsoft-sqlserver-management-sdk-sfc-databaseproperty-is-not-a-recognized-built-in-function-name-microsoft-sql-server-error-1/

Hi,

Which version of SQL Server you are using?

Have you configured the Reporting Services?

Did you faced any errors during instlation or configuration of reports?

Is your reporting services working?

Thanks,

Pradyothana

http://www.msqlserver.com/2011/01/sql-server-numa.html

There is no Such option, We have to restrict user @ Login level.

check the path where the reports are deployed...it might be issue with the path/url.

http://www.msqlserver.com/2011/11/script-to-schedule-backup-all-databases.html

Data part we have to deal , there are multiple options to deal. But as its an example my destination table was empty. In case we are discussing either we...

We can do in SSIS, Just I have tried in other way, What I have done here I merged the table contents, It allowed me to do so. In your...

SSIS has solution but need to check...how much it will help full...

Even we tried for the requirement, finally we opted excel which will give expanding option. PDF and HTML we don't have option as SSRS wont provide this facility.

Best solution is replication, Setup a replication made 5 SUBSCRIBERS for the DB need to merge as ONE from FIVE PUBLISHERS.

ROWLOCK

Use row-level locks when reading or modifying data.

PAGLOCK

Use page-level locks when reading or modifying data.

TABLOCK

Use a table lock when reading or modifying data.

DBLOCK

Use a database lock when reading or modifying...