xp_sqlagent_enum_jobs is undocumented.  As such, Microsoft makes no claims as to its availability or functionality in future releases,  and generally discourages customers' reliance on them.  You may want to consider...

I disagree with the advice given to shrink the log once per week.  When you shrink it on a regular basis, you are forcing it to expand when it runs...

I had interviewed for positions in the company I am employed with twice previous to interviewing for my current job.  In this company the interview process is multi-tiered, one tier...

Henry,

Me thinks you misunderstood the "pre tense" (yup, mispelled in this context) of Athurgar's post! 

Is you by any chance a English teacher?

Steve (me's tongue...

SQL provides the DateTime format.  If you use that, there are no conversion issues.  Otherwise, if you are storing dates in other formats, int, char, varchar, you can CAST those...

Frank,

A full backup will not and should not ever truncate a transaction log.  If you have your database set to the Full Recovery Model, you should be taking regular transaction log...

Certainly.  Same way.

alter database pubs

 modify file (name = 'pubs_log', newname = 'newpubs_log')

Steve

Just out of curiosity, have you tried a blank sa password?  That was the default, and many instances were installed without changing it.

Steve

Everything to do with sysindexes!  The EM counts are based on sysindexes which are updated when the statistics are updated.  Should be a reasonable estimate, but never guaranteed.

Steve

Restore, yes.  Backup, not a chance.  Are there any other users that might have deleted it?  Are you absolutely sure that the row isn't there?  Did you inadvertantly update the...

Assign the role of db_ddladmin.

dbo would work as well, if you want to go that far.

Steve

You can change the LOGICAL filename of your primary file using ALTER DATABASE-

ALTER DATABASE pubs

 MODIFY FILE (NAME = 'pubs', NEWNAME = 'pubs_data')

You can only change the physical filename using ALTER...

Hey noeld,

What if you're running personal edition on a box that doesn't support services, like Win 95 or 98, it would run as a console app, right?  Would that be the...

I'm not sure why your OK button is unavailable.  The fact that your databases are in Simple Recovery Model is definitely why your transaction log backups are failing.  Simple Recovery...

Farrel, The thought of taking offense never even occurred to me!  No problem!  I just figured "hearing" first hand is better than... "My friend at work said that his brother-in-law's...