could you please take me...

Hi all,

Is installing SQL Server 2005 Enterprise edtion and Standard edition on same Server is supported by MS? If yes, please take me that link

Thanks

Thanks,

I need to change last line in code as below right?

Alter VIEW dbo.View_abcValue

AS

SELECT TOP 100 PERCENT View_abc.ObjectID AS [PropertyID], CBZ_Object.ObjectID AS [ObjectID], View_abc.ObjectName AS PropertyName,

View_abc.ObjectAlias AS PropertyAlias, View_abc.ObjectTypeNamespace AS PropertyNamespace,

View_abc.ObjectTypeAlias...

I think there is only one cumulative update "CU2" for SQL Server 2005 SP3.

As I know if you have share point databases in SQL Server 2005, then CU2 need to...

In Installation Wizard, after selecting the feature to install, go to Advanced button and there you change the installation path.

Hi,

We are getting the below alaram frequently in Spot light

Alarm raisedPhysical disk #0 C: containing paging file(s) 'C:\pagefile.sys' is experiencing a high rate of I/O (99.07% busy) unrelated to...

Thank You,

On SQL Server 2000, performed the below steps

1. DROP STATISTICS TableName.Statistics Name

2. DBCC CHECKCATALOG (PROD) -> No errors

3. DBCC CHECKDB (PROD) WITH NO_INFOMSGS, ALL_ERRORMSGS -> No errors

4. Backed the...

Selected the default path for database engine, reporting services and integrations services(C:\program files\Microsoft SQL Server\) - because it did not allow us to select other than C:drive(I do not know...

I think I can not use the below command because the reporting Services is running under LocalSyatem..

rsconfig –c –m Server B computername –s Server A SQL Server instance...

I added the IP addresses in host file in both servers as you suggested. Still when I browse the Reportserver, Iam getting the same error

The report server cannot open a...

We 2 servers Server A (For RS) and Server B (For storing ReportServer n ReportTempDb). So in which server Do I need to look for the IP in the path...

rsconfig -c -s -dreportserver -aSQL -u -p

In above, for My case

rsconfig -c -sserverB -dreportserver -aSQL -uSa -pxxxxxxx is that right??? and this should be run from...

I did not understand why Iam getting the error

The report server cannot open a connection to the report server database. A connection to the database is required for all...

The catch here is...the 2 servers are not in domain. So No AD accounts and I can not create domain accounts.

Server A has Reporting services installed and in server...

Could you please give some info. Because the application not bringing the reports from report server and its giving report server can not be connected???