It's simple

Go into the information for your service account and flag it as not expiring on the accout tab.  You can also set it so the user itself can not...

I use Clusty!  http://clusty.com/  well and Google.

Has some nice features, like grouping into categories.  Makes it a lot easier at times to find what you are looking for.

For the...

I invest wisely (for a low inflation economy at least), I pay off debt  

Now if the dollar would just pick up value...

Might want to restore the filelist to see that you had backed up what you wanted

restore filelistonly from <backup file/device>

Sometimes good enough is good enough...

Since I took over as DBA at this company (they had never had one) I have collected over 110 GB worth of traces on stored...

Check my question around in the XML forum somewhere.  I had similar problems with performing inserts from XML data.

I ended up having to select the portion of the XML I...

Steve,

license plates are weird since it depends on each state.  In Texas the plates stayed with the car, AND if sold trough a dealer they did not have to retitle...

P Jones touches on one thing I think is overlooked a lot in DR planning.  What would happen if key personel was suddenly gone?  And I am not talking an...

I have huge problems with the automated camers.  It leaves out due process.  After having had to prove 4 tickets for red lights on a car I no longer owned,...

Depends which part of the primary key you are querying against.  If you have col1, col2, col3, col4 in your PK, and your where clause references Col1 and Col2, the...

This white paper is the word from MS on licensing as far as I know.

http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

Yeah those suggestins are right from the Database Engine Tuning Advisor.  All I can say about those is "trust but verify".  And 90% of them don't verify

So you are  basically not storing it in bits.... 1110 0000 would be 128 + 64 + 32 + 0 = 224, not 7...

I understand that you are trying to...

Not sure how you get the leftmost 4 bits in 7 to be 1110.  Unless you are feeding the data from a system with opposite endian than what Wintel world is...

Well, what is a test server for anyhow?   Take backups, and do it on a Friday afternoon.