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...

UPDATE [pitable].[dbo].[allpi]

SET val32= isnull(

(SELECT     *

FROM         OPENQUERY(pcnh, 'SELECT value as vh3   FROM picomp  WHERE time = date(''*'') AND tag = ''HQ0MP001MX''

')),0)

Indeed, it is like a fence. It prevents most from coming in, but soner or later, someone will jump over it.

Keep your DRP in mind when you choose a datasecurity...

in addition to the other replies.

You can also try to disencourage native db-access by using your own naming-conventions.

I have one db that has tables named A0001,.. with columns C0001,...

muts be a udf someone instaled for you.

I cannot find it on our (dev) sqlservers.

good hunting

welcome to the forum.

Maybe this can get you on track ...

http://www.sqlservercentral.com/columnists/jwiner/moreonreturningasubsetofarecordset_1.asp

just my 2 ct.

I guess your LAST_PAY_DATE column is defined smalldatetime.

You want to fill it with '5005-01-01' . that is not alowed.

BOL says :

smalldatetime