Is there any harm in running the integrity check and a full index re-org every night as part of your nightly maint?

Say a full database backup, followed by those?

(Granted it...

Thank you for your help, this has been most informative!

I'm never going to know it all, but it never hurts to know a bit more here and there!

That does make sense.

Small indexes don't warrant the extra work of locating their own space just for them, so if it is less than 8 pages SQL Server just looks...

Would you mind explaining why it is fragmented?

Does it have to do with how the index is built and because it is such a small index it just appears fragmented...

No on both accounts...

If I remove security from the database it works fine (http://msdn.microsoft.com/en-us/library/aa141436(office.10).aspx)

Otherwise I get that error.

I don't get it, I provide SSIS with my the admin...

I started on my 2005, I was looking at 2008 in more detail and while I was aware of the few "major" features but a lot of the little things...

Sorry, I wasn't clear.

Rights to view all data tables for reporting purposes.

So they can't change anything, but they sure as heck could open up Access or Excel or whatever, connect...

ALZDBA (8/22/2008)

---

"hard coded with week password ... " sounds familiar :sick:

Most of the time, the installers just don't know it is stored in an ini-file or a reg.key.

Search "program files"...

Wow, so the ENTIRE SQL instance has full rights to the global temp table?

That just sounds crazy dangerous for some reason?

Then again, I suppose if security is so important to...

I have the trace with the column filters on LoginName setup in profiler and had it export it out to script trace definition for MSSQL 05.

Though if the script that...

K. Brian Kelley (8/14/2008)

---

You can't modify it on the fly, no. The question, though, is are you going to severely impair the performance of your SQL Server by doing multiple...

K. Brian Kelley (8/14/2008)

---

I would instantiate only one trace. The logon trigger can see if a trace is running (or you could write to a semaphore table or something) and...

GilaMonster (8/14/2008)

---

Pretty much, although you can interrogate SQL as to the traces that are running.

select * from fn_trace_getinfo(0)

Get profiler to generate the trace creation code for you. It's easier...

K. Brian Kelley (8/14/2008)

---

Actually, this is a good way to do it. Here is a code sample from the presentation I gave at SQL Saturday Jacksonville. And it's actually a...

So then in that case it sounds like I'd need the job to run on a regular basis (or be triggered) and then scoop up what was in the file...