Does Builtin/Administrators still have authority to access your SQL Server and if so is it still a member of sysadmin?  If not you need to add it back.  (try adding...

Your choice Jeff.  The advantage of a stored proc is that it can be used in more than one job, tested more easily if changes are required.  It may be...

Cross-database referential integrity must be implemented through triggers.  Keep in mind what might happen if database B were down (for maintenance or some problem) while database A tried to check...

I depends on your learning style.  I personally like online training on my own.  Sometime classroom style doesn't move at the pace I want.  Think about what's best for you. ...

We upgraded MDAC.  no problem.   Did you try to back up using QA on that server?  I wonder if the error message might be more clear.  Check the SQL Log...

I think you should apply the SP3A patch.  Is there a reason that you think you should not?

I missread the question.  I thought you wanted the number, not the actual rows.  That is I thought you wanted to supply the numbers 5, 2 and get the answer...

You will find it difficult to create a UDF for this as there are some limitations in SQL data types. For example, 21! is creater than the largest number a...

In general the formula for a combination of M things taken N at a time is:

C(M,N)=M!/(N!)(M-N)!

For example:

In numbers, C(5,3) = (5*4*3*2*1)/(3*2*1)(2*1) = 60/6 = 10. These numbers mean that there...

You backup databases with the BACKUP DATABASE Command and you can backup logs with the BACKUP LOG command.  The Backup Log command backs up changes made since the last BACKUP...

I'm not a big fan of VISIO.  But to get it to create a diagram, open a new Database- ER diagram.  Go to the Database Menu and select Reverse Engineer...

Lots of ggod info on this site.  Try some searches.   You could start with http://www.sqlservercentral.com/columnists/RDyess/displayingexecutionplans.asp

If you have SQL Mail defined click on the notification tab of a JOB properties and indicate you want to be emailed when job fials.

If you have not installed SQL...

Here are two SQL statements, the first list all saved backups and dates for a database.  The seconds displaces the latest backup file name.

DECLARE @db  as sysname

SET @db = 'databasename'

select...

Why do it in 3 lines when it can be done in one?  Nice one Johnathon.  Convert the time to be added to the same thing (minutes) and add it...