Sorry Daniel, I don't see the extra END and the missing quotation marks. As far as I can tell SSMS uses the sp_executesql system stored procedure to create the procedure...

Hi Noel!

I can't find the sql_handle column in the SysProcesses table and "fn_get_sql is not a recognized function name"

Once I had to answer a personality test that was around 120 yes/no questions. I started to answer quickly because previously I answered a SQL test, so I felt tired.

One...

Which version the servers are? 2000 or 2005? What's the error?

I don't even find the message in Sys.Messages. It seems to be a deadlocks problem, you could try to figure it out using SQL Profiler.

What do you have in mind to make Excel and SQL Server talking to each other? For example: if you use bcp I don't see any problem in using Excel.

I'd like to know a little bit more about the scenario. I don't know if this would be helpful:

CREATE TABLE dbo.mytable(field1 int, field2 varchar(10))

GO

CREATE TRIGGER trgMyTable ON dbo.MyTable

FOR INSERT, UPDATE,...

How about Date1=Date2 instead of Date1-Date2 = 0? Obviously you'll have to deal with the time part of the dates.

You're right Peter! Thank you.

SELECT JH.instance_id, J.name AS JobName, JH.run_date, JH.run_time, JH.run_status

FROM dbo.SysJobHistory AS JH

INNER JOIN dbo.SysJobs AS J ON JH.Job_Id...

I was wrong, the primary key of the SysJobHistory table is instance_id, thus I can use Ninja's_RGR'us' solution.

Thank you Bill. BTW: I'm trying to obtain this information via T-SQL. I think I got it now:

SELECT J.name AS JobName, COUNT(*) AS TotalExecutions

, CONVERT(DECIMAL, ISNULL(JF.FailureQuantity, 0))*100.00/CONVERT(DECIMAL,COUNT(*)) AS FailureRate

FROM msdb.dbo.SysJobHistory...

Hi Francis.

I'm a little concerned about your tempdb issue. Perhaps you should re-check your proceses and figure out which is (are) the one that is consuming the resources in tempdb...

I completely agree with Steve. And women: remember that the elbows are the hardest part of the body. And the nose is one of the most sensibles

I agree with Frank. Recently I worked for a company where the project managers were more concerned about time than efficiency and security. And surely the reason for such a...

Another way to do it is generating a list of TRUNCATE TABLE statements. Something like this:

USE YourDatabase

SELECT 'TRUNCATE TABLE '+Name

FROM dbo.SysObjects --- Use Sys.Tables in SQL Server 2005

WHERE Type =...