Those 12 parameters are meant to validate 4 separate values.  As it turns out, the validation routine had some redundant code in it that allowed the developer to pear it...

There is a small handful select statements (using index seeks) to pull values used in the validation process.  Min length, Max length, invalid characters, among others, are stored in a table.  These...

I would think that as long as your host name remains the same and you stay within the same domain, you should be OK.  DNS will resolve the hostname to...

I'm not clear on what you need to do here.  Can you provide table DDL and sample data for tables A and B.  Sample data for how you want your...

The basic shell to an update trigger would be as follows:

CREATE TRIGGER YourTriggerName ON YourTableName FOR UPDATE

AS

Begin

Your logic here

End

Go

I believe using sp_cycle_errorlog is your only option.  Windows will not let you open and remove the entries as long as SQL Server has a hold of the file.  After...

My bad.  We are talking about two different logs.  You are referring to the SQL Server error logs.  Look into sp_cycle_errorlog in BOL.  This is what you want.

Backup your transaction log, this should purge the inactive area of your file.  Look up transaction log truncation and BACKUP LOG in BOL.

I think your focus will depend on what type of DBA role you will be filling.  If you are a production DBA, then you will want to get yourself familiar...

Are you only wanting the DTS job to execute it's steps if it is the first Sat. of the month?  If so, the scheduler will allow you to set your...

There will be an entry in your SQL Server logs stating 'Starting up database <DB NAME>' every time SQL Server brings a database online.  I don't think SQL Server logs...

What is task 17 doing?  I've seen timeout expired errors due to poor or lack of indexing.

DECLARE CURPROCESSID CURSOR FOR SELECT SPID FROM #TMPLOG   

  WHERE DBNAME LIKE @DBNAME and loginame NOT IN 'sa,login1,login2'   

 OPEN CURPROCESSID  

I'm with you Steve.  I use my DVR so that I can watch the very few programs that I do watch, when I can fit them into my schedule.  I...

From MSDN T-SQL: Logbuffer waittype -- 'Occurs when a task is waiting for space in the log buffer to store a log record. Consistently high values may indicate that the...