Instead of tables I would do views. Less data space and once you create the first one in the QA such as:

CREATE VIEW Top_90_AK

AS

SELECT TOP 90 PERCENT *

FROM TableName

WHERE...

Assuming that your key field is not the top 10 percent field, I think it would be something like below. I maybe overly complicating it...but this is how I...

The catch is that the smalldatetime still has the hours:minutes in it. If the data is stored as smalldatetime you have to do a between. Or the where clause...

No pretty way to do it.

DECLARE @BeginDate as datetime

DECLARE @EndDate as datetime

select @BeginDate = CAST(cast(right('0000' + cast(datepart(year,getdate()) as varchar),4) as NVarchar) + '-' +

...

What account is the local server registered with? LocalSystem? It does not have rights to register any non-local server. If a domain user account, does it have access/permission to the...

Now the other half of that coin -- the files consuming disk space. Being a good DBA, you should be playing Doom or Quake not watching your SQL server chug...

Okay. Just went through this several weeks ago. ...

Is this a stand alone server? If so does that local user account have full permissions to all the data and executable paths?

If a member of the domain - are...

Oh, don't forget your manager, his manager, director and possibly the VP or CIO of IT.

You actually have that many layers. For me it's my manger, the VP for...

I was a developer -- 99% Access front-ends on delivered databases -- that was moved into DBA. They created the position for me because I ended up being so far...

My boss -- former New Horizons instructor -- suggested the 291. I used the preplogic test. Not even close .

Besides - I'm thinking, eventually,...

Not to throw too big a monkey-wrench at your ideas....but... What is your (the mangement) expectation for recovery time.

With a 2.5GB database backups should take less than 5 minutes unless...

Is the MSSQLSERVER service running?

The SQLSERVERAGENT service will not start unless the MSSQLSERVER is running. When you fire SQLSERVERAGENT, by default, it tries to start MSSQLSERVER.

In this post 9/21/2004...

Ahhhh.....that explains it.

I've gotten used to just stopping the services, changing the userid, and then starting the services.

My shortcuts have led to errors...

Yeahh, Yeah, my bad.....

But if I read the above correctly "The SQL Server 2000 Setup program grants these rights automatically" you need to re-run...