Just had to look at this because it had 666 views

"host tech support is telling me it's my fault - I need to optimize my code"

Geez I just love constructive replies like this. How about you ask this lovely support...

Do you have auto-update statistics turned on as well? If you've got a regular re-indexing job already setup then turn off the auto-update.

Error 112 generally indicates that there is not enough space on the disk to complete the backup and is the most likely cause.

It could also be cause by HD I/O error,...

Hence the mantra ... "Do not use/rely on any undocumented system objects"

In regards to the second question,

"To sort of keep track of all the action made to the Account table, so if someone were to manipulate it, we'd know which...

"Hey Phill - if everyone read BOL then you'd be out of a job..."

Actually, I might be able to do a bit more SQL 2005 investigation and training...

Not to mention...

Come on Erik, surely you can read Books Online

bitwise_operator

Is the bitwise operator to use in the comparison.

updated_bitmask

Is the integer bitmask of those...

Highlight row and press,

Ctrl+Shift+C - Comment

Ctrl+Shift+R - Un-comment

Tab  - indent

Shift+Tab - un-indent

There are heaps more check "SQL Query Analyzer Keyboard Shortcuts" in Books Online.

"When I r-clicked and selected Script to...

Ok, when the services run under the local system account they have no authentication for network resources. You'll need to change this, and the SQLServerAgent account, to an Active Directory...

You have two SQL Services MSSQLServer and SQLServerAgent, each of these runs under an account you specify when you install SQL Server.

Check "Services" in the Administration Tools folder.

Couple of points,

You shouldn't really be placing your own stored procedures in the master database. Who knows what could happen with the next service pack, etc...

Better off creating your own...

Last time I looked around ( quite a few months ago now ), best tool I came across was Embarcadero's Change Manager.

I especially liked it's ability to capture all...

... but you're using CONTAINSTABLE and the poster is using FREETEXTTABLE. Aren't these two different things, or are you saying that Books Online is wrong and FREETEXTABLE does support variables?

Also, one little know tip for the Quick Launch menu, re-size the toolbar so that only the double arrows are visible, if you click the arrows a popup menu appears and you can...