can you post the full ddl of the table/indexes/triggers ?

Just to check : There is an index defined for PoliID ?

An other difference is that nonclustering indexes have the actual RID (page-row-address) when there is no clustered index defined for the object.

If there is a clustered index defined, it contains a...

How about :

Set Nocount On

IF UPDATE(PoliInstalments)

 UPDATE tblPoliPolicy

 SET PoliSettlementDueDate = Min_PremInstalmentDate

 FROM 

( SELECT PremPoliID , MIN(PremInstalmentDate) as Min_PremInstalmentDate

          FROM tblPremPolicyPremium T1

             inner join Inserted I2

          on T1.PremPoliID = I2.PoliID

           and T1.PremDeleted = 'N'

           AND T1.PremIncludeInTotal = 'Y'

          GROUP BY PremPoliID...

How about :

SELECT A1.ProductID

FROM tblProductAttributeValues A1

inner join tblProductAttributeValues A2

on  A1.ProductID = A2.ProductID

 and A2.Active = 1 

 AND A2.AttributeID = 15

AND A2.AttributeValue =1

inner join tblProductAttributeValues A3

on  A1.ProductID = A2.ProductID

 and A3.Active...

No, but you can use dts to export/import the data.

Basicaly simple recovery works like this :

Your log is still in use for data-transaction-integrity. Once data gets committed, the space used in the log for that transaction is marked for...

Check

- Table and Index Architecture in BOL

- http://www.sqlservercentral.com/columnists/chedgate/clusterthatindex.asp

- http://www.sqlservercentral.com/columnists/sjones/sqlserver2000indexing.asp

- http://www.sqlservercentral.com/columnists/dharris/indexesanoverviewandmaintenanceforperformance.asp

To perform PIT(point in time)-recovery we perform log-backups before every other type of backup.

If you are not interested in PIT-recovery, you can fall back to other ways :

- make frequent full...

You could start with a simple view test.

Start sql Query analyser and build a query the has all the security-features in it wich you desire.

E.g.

Create Myview

as

Select mycol1 from sales...

Hi Brian,

You'll off course have to select the server-instance which you want to alter the tcpip properties.

I have a server with 3 virtual instances and all 3 are listed in...

If you can build the query/procedure which contains the mechanism to determine "their clients" only, you can implement that.

Maybe this is what you are looking for :

SQL Server Network utilities (Server-box)

    TCPIP-properties

       Hide server

That is what it is supposed to do. !!

clusterd as discribed in BOL :

CLUSTERED

Creates an object where the physical order of rows is the same as the indexed order...

it can take a while, but you'll get used to it.

In sqlserver there is no such thing as date or time, you only have datetime and smalldatetime which is date with time.

If you want...