thanks:)

sp_readerrorlog works fine, while we have to read all the errors in the log file, but is there a way to check only the login failures??

🙂

Hi, you could use the msdb database and query from sysjobschedules to get the schedule, like if the job name is daily 5:30 then query :

select * from sysjobschedules where...

rinu philip (7/17/2008)

---

thanks everyone,

I got it ...you can use this in a job to send mail, once database mail is configured in sql 2005!!

use msdb

EXEC msdb.dbo.sp_send_dbmail

@recipients=N'test@test.com',

@body= 'Test Email Body',

@subject...

kristen (7/20/2008)

---

One other key difference is that Stored Procedures are stored inside a database whereas SSIS is a service that runs on a SQL server - SSIS packages are run...

george sibbald (7/20/2008)

---

rinu philip (7/20/2008)

---

Processed 1768 pages for database 'DB', file 'System_Data' on file 1.

Processed 85000 pages for database 'DB', file 'DB_Data' on file 1.

Processed 15272 pages for database 'DB',...

hi , think Rooman technologies or Jetking would provide you with required information:)

@recipients=N'rinup@xyz.com';'zbc@aby.com',---> delimit semi colan

forgot the quotes;)

takutoyamada (4/25/2008)

---

A clarification question. Upon a failed job, I want to send an email to 2 different email addresses. So, I created 2 operators and checked them to...

This could be achieved ny giving specific permissions to the customers. If you...

I would love to see some interesting facts and learn more about Cusors!

Randy Barlow (3/23/2006)

---

Dumb Question: Can someone direct me to something that tells me how to set up Windows XP to work with SQL. When I click on Query, up junps...

Stored Procedures :

A pre-complied collection of sql statements, processed as a unit. Example: sp_who, has queries that will show...

http://www.dotnetspider.com/forum/158771-Sql-Server-Integration-services-Interview-questions.aspx

check it out!!:)

thats right, you can use...