Can you please post table structure, index definitions, the execution plan (as a .sqlplan file, zipped and attached) and an estimate of the number of rows in the table and...

Are you the administrator? If not, ask your admin to reset password.

If you are the admin, is there a windows authentication login that exists with sysadmin permissions?

Milu (9/27/2008)

---

rbarryyoung i am not clear what you are trying to say to me, its not automatically create one index in sql 2005? my qst is is it creating is...

Add more disks

Delete unnecessary files.

One other misconception. A clustered index scan is not better than a table scan. It's the same thing. It's called a table scan when run on a heap (table without...

How is that going to find indexes that the queries never use?

In SQL 2000, there's...

There are some cases where the 2005 optimiser produces worse plans to the 2000 one. Short of a rewrite or query hints, there's not way to force the optimiser to...

Not sure why you're getting an access violation. What do the procs do? Any linked servers involved?

There is another issue with the trigger

select

@status ...

How are you restoring? What options have you checked?

SELECT dateadd(dd, datediff(dd,0, getdate()),0)

The varchar method works, but is slower. See - http://sqlinthewild.co.za/index.php/2008/09/04/comparing-date-truncations/

RAJNISH AWASTHI (9/25/2008)

---

HI All,

Wanted to know that :-

...

Check out Paul's blog post on attaching corrupt databases. It may help you. If you get problem, post in the corruption forumn here (the SQL 2000 one) as Paul sometimes...

I'm no AD expert, however those are not SQL-related errors. They point at a problem communicating with the DC. If that was my server, I'd be passing those over to...

That's how I thought the null bitmap...

Matt Miller (9/25/2008)

---

On the large table - what's the fill factor of the clustered index? Speaking of which - have you tried rebuilding the clustered index? You may...