Viewing 15 posts - 1 through 15 (of 348 total)
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
January 30, 2009 at 10:53 am
can anyone help me on my query.
January 28, 2009 at 9:29 am
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...
January 22, 2009 at 4:49 am
Requesting all guru's to help me on my query.
January 21, 2009 at 12:35 am
Thread will help in replicating Indexed views using Transactional Replication.
But i need help to replicate indexed views using Peer-to-Peer Replication.
January 20, 2009 at 12:28 pm
Is there a way to replicate indexed view articals in P2P replication as i have created unique key on it.
January 20, 2009 at 10:17 am
this Problem occurs when the column length is less then the passing value length.
Hope this help.
August 24, 2007 at 4:47 am
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.
August 23, 2007 at 3:50 pm
August 14, 2007 at 9:58 am
Is anyone there who can help me out of this.
August 10, 2007 at 9:42 pm
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...
December 18, 2006 at 12:04 am
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.
December 12, 2006 at 5:45 am
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...
December 12, 2006 at 5:42 am
linked server is created on sqlserver2000.
did u mapped the login on both the sqlserver.
December 11, 2006 at 3:26 am
What server u are accessing the data.
December 11, 2006 at 1:44 am