Thanks Jeff. It really wasn't that much work. I just wanted to...

Failed logins are really the most important. It just depends on how busy your system is. It is all preference on what you would like to monitor.

I use the...

I found a missing quote at the end. Try this.

ALTER PROCEDURE SP_TEST

@P_TABLEN varchar(30),

@P_STARTDATE datetime,

@P_ENDDATE datetime,

...

Try replacing the @query variable with the following.

SELECT @query= 'SELECT * FROM ' +@P_TABLEN+'

WHERE ' + @COLUMNNAME + '>='

...

You can use bcp also.

EXEC xp_cmdshell 'bcp "SELECT * FROM sysfiles" queryout "C:\bcptest.txt" -T -c -t,'

http://msdn.microsoft.com/en-us/library/ms162802.aspx

You can use this to find stored procedures that contain the given search criteria.

select name, text from sys.objects A

JOIN sys.syscomments B ON A.object_id = B.id

where type = 'P' and...

Keep in mind that I am counting a NULL value as No also.

You can use a case statement.

Declare @TST1 bit

Declare @tst2 bit

Set @TST1 = 1

Set @tst2 = 0

Select Case @TST1 When 1 Then 'Yes' Else 'No'...

You may not have installed the Database Services. Go through the install again and make sure to select "SQL Server Database Services". Here is an article with screen shots.

...

I think you are talking about having to sync the logins. Once you failover you can sync the logins and you should be fine. The following artilce should...

Look up how to use a nums or tally table. Hopefully this will get you started.

Declare @NoofPayments int

Declare @TotalAmt int

Declare @startdayofmonth int

Set @NoofPayments = 4

Set @TotalAmt = 4542

Set @startdayofmonth =...

I saw some earlier posts where the poster was looking for some good books with some real world examples, I was giving them the benefit of the doubt and thinking...

I use xml in order to aviod having to use dynamic sql. This should explain how you would use both.

http://www.mssqltips.com/tip.asp?tip=1568

Here is a good list of things a DBA should be doing on a daily basis. This should help you out with a resume. It also has the...

That is normal. The client tools only install on the machine you are installing from. If you want the client tools on the other node you can go...