Hi

Did you consider win2k's EFS? im confused as to what "encrypt data files on a webserver?" actually means, are you talking

a) data inside of your db?

b) data files...

Hi there

I had this error just the other day on my data warehouse (SS7 SP1) when running SQL*Probe over the server (probably not related what so ever though!). I...

Just as I thought...

ALTER TABLE [dbo].[organisation] WITH NOCHECK ADD

CONSTRAINT [UC_ORG_EMPID] UNIQUE NONCLUSTERED (org_emp_id)

..gave me..

Server: Msg 1505, Level 16, State 1, Line 1

CREATE UNIQUE INDEX terminated because a duplicate...

Try this..

login locally to the server (dont login to the domain)... if you havent played with the builtin administrators account should should be able to connect via EE without any...

Thanks Paul, ill give it a burl when im back at work. I would have thought that the unique constraint was actually an unique index, and explained why...

Hi

Sure can. Remember that EFS is profile dependent (ie login dependent), so data is 'unencrypted' when you install etc and you wont have a problem. Other (simulatenous) users...

[boot loader]

timeout=30

default=multi(0)disk(0)rdisk(0)partition(1)\WINNT

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced Server" /fastdetect /3GB

Hi Steve

Check out technet.oracle.com, they have the books online etc as MSDN. I worked on a small project 1.5yrs ago with Oracles fine grained access control features and worked...

Hi

I am a little confused about the examples listed and the use of temp tables etc. In classic partitioned views I would do something like:

create table [partition1] <...> filegroup...

Nice article Mindy, very informative.

Hi

Did you refresh enterprise manager? 🙂

Cheers

Chris

Hi

I wrote a script a while back to assist you in recovering backups logged in the msdb databases. This may assist you in quickly viewing all backups and the...

Hi

Thats a BIG stored proc, whoever coded it must have no concept of modular programming. Anyhow, cache stored proc plans? didnt know you could "programmaticaly" (ie, force) do...

I agree with Andy, SQL Compare and its data comparison tools are excellent and I highly recommend them. EE does produce some dodgy script, dont get me wrong, it...

Hi

Can you post the backup command? the log (from memory) will not magically shrink backup once its extended. You need to manage this yourself. Check batch data...