Below is the test code:

CREATE VIEW SalesOrderDetialsViews WITH SCHEMABINDING AS

SELECT SalesOrderDetailID,ProductID,UnitPrice,count_big(*) as cnt from Sales.SalesOrderDetail

group by SalesOrderDetailID,ProductID,UnitPrice

can anyone help me on my query.

I have created a simple view with schema binding and created a index on one of the view column having unique data.

Table is having few columns without any index or...

Requesting all guru's to help me on my query.

Thread will help in replicating Indexed views using Transactional Replication.

But i need help to replicate indexed views using Peer-to-Peer Replication.

Is there a way to replicate indexed view articals in P2P replication as i have created unique key on it.

Hi,

this Problem occurs when the column length is less then the passing value length.

Hope this help.

Raj.

After Banging my head for 5 hours i  got the resolution.

Package Source : SSIS Package Store

To execute the DTS Package the Windows user should be the member of Administrator Group.

Hope...

Thanks Greg.

Is anyone there who can help me out of this.

regards

Raj

Dear,

Most of the time table give errors when index pages goes wrong.

Pls read books online about DBCC checktable with the tablename.

U can repair the table with the option given for...

Goto Enterprise Manager and check the properties of the database.

there u can see all the option about file growth of datafile and log file.

What I can tell you is link from SQL 2005 to SQL 2000 or vice versa work

fine for me. I created linked server by EM, I think you should...

linked server is created on sqlserver2000.

did u mapped the login on both the sqlserver.

What server u are accessing the data.