Margaret,

It really depends on the insert/delete/update activity on the table(s).  In particular, inserts and deletes cause index fragmentation.  There's no harm in rebuilding the indexes every night if you have...

Margaret,

Also, realize that there is a difference between "shrinking" a log and "truncating" a log.  Truncating removes the inactive transactions from the log, but does not reduce the physical size...

For system procedures that return multiple result sets, I don't think it can be done.  However, you can script the procedure in Query Analyzer, and probably parse out the piece...

How big are the full backups?  Generally will be the size of the used part of the data file + the used part of the log.  If this is the...

Whether your transaction log should be that big depends on a number of factors, including whether and how often you perform reindexing.  As a general rule though, a smaller transaction...

I've been known to chastise people for not thoroughly reading a question before posting a reply.  Guess I shouldn't do that anymore.  Sorry.

This still isn't what you asked for, but...

specifically sp_help_job or in general?  It can be done very easily with stored procedures that return a single result set, but sp_help_job returns multiple result sets which prevent you from...

Your database user is orphaned.  SQL uses security identification numbers (SIDs) to identify users.  The userid is provided a SID when it is created on a server.  The SID for...

Try this...

SELECT count(*) RecNum,

       a.LastName

     FROM Northwind.dbo.Employees a join

          Northwind.dbo.Employees b

          on a.LastName >= b.LastName

     group by a.LastName

     order by a.LastName

Steve

If the connections that are causing problems are simply inactive connections of users who failed to log out, simply killing the connection shouldn't be an issue.  And since the plant...

Have you considered sp_attach_single_file_db?

Steve

I'm not feeling well, and not thinking clearly, so if I'm way off base, just ignore me, ok? 

I think that what you are asking for is not how to...

You should be able to run them at the same time, but, the tran log job will hang until the diff job completes.  Then it should complete normally.  But to...

Your reindex and maintenance are whats causing the log file to grow so large.  As Kathi said, the full backup won't clear anything from the log, so your first log...

It may not be any different than the Enterprise Manager method, which may actually be doing this behind the scenes, but take a look at sp_attach_single_file_db in books online.

Steve