Waseem Jaleel (3/29/2010)

---

since he knows the max size the log can reach, is it not ok to keep the initial size and max size the same with auto shrink disabled?...

Do not mistake "want" for "need". There is no need. Technically, you could run a 1 TB size database on one file and one filegroup.

The idea of splitting your database...

The one thing to note about killing connections this way is that it does NOT prevent those connections from reconnecting after they've been disconnected. The best way to do that...

I agree with Grant. If you can do it, go for it. I don't see any Cons to the situation and only Pros.

Just don't make the mistake of setting Max...

What exactly is your definition of a "Blocked Index"?

I've never heard that term before and I find myself wondering what it has to do with allow_page_locks being on or...

Not sure what MOSS is, but here goes.

Open up Books Online and lookup ALTER DATABASE...

river1 (3/29/2010)

---

I'm receiving this error when executed the stored procedure that i posted:

Msg 217, Level 16, State 1, Procedure RemoveLigacoes, Line 48

Maximum stored procedure, function, trigger, or view nesting level...

Full backup is not the same thing as Full Recovery Mode.

Right click the database, go to Properties. Check the Options page in the popup window. Does the second line (Recovery...

You have to assign that right through the Active Directory GPO. If the the...

And apparently we never caught the "all connections on the server" part of the OP.

DOH!

The date_modified...

One potential problem I see right off the bat. You're dropping the job off it's modified date instead of it's last run date, which is what you originally wanted. If...

Why not just do a restore-from-backup to the reporting instance and create the indexed views as part of the job that auto-restores for you?

EDIT: Then add specific perms for the...

Oh, well, I suppose *that* works too.

@=)

No, I don't have a query. I've never needed to write one.

It's not that hard, though. Look up the code in Books Online. It's the best way for you to...