Kiara (7/28/2011)

Ah! *comprehension dawns* You mean the time where the work location shifts from the desk to the car and then to the sofa!...

Don't use the registry. The setting is in the SQL Agent Properties.

See this link: http://blogs.msdn.com/b/sqlagent/archive/2010/10/15/turning-on-verbose-logging-in-sql-agent.aspx

I understand your problem, but your clients really should do the following:

1) Back up SQL Server locally

2) Back up the SQL Backup location to another drive (network drive, tape drive,...

Just an FYI, trying to concat anything numerical tends to add it, not to concat it. So you will always need to convert numbers to strings before concateonating to make...

I agree with Sean that you are playing with fire. However....

IF (SELECT data_type FROM Information_Schema.Columns WHERE Table_Name = 'MyTable'

AND Column_Name = 'MyColumn' AND data_type...

What you posted, and the title of your post, are two different things. I don't think you need to loop at all.

What you need is to write up your OUTER...

Kiara (7/28/2011)

I can offer two day old peanut butter and...

As Gail said, SQL Server makes the choice in the deadlock situation. You don't get to pick. The only way you could pick is to do it manually, but usually...

I agree with the others. Something else is calling this job or starting it.

Check msdb.dbo.sysjobs joined to msdb.dbo.sysjobsteps to find any job steps that use the sp_start_job proc or call...

Start here:

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

1) Please don't use text or L33T speak in the forums. There's enough acronyms and such flying around these...

Your phrasing is unclear. What do you mean by join two tables using wildcards?

What have you tried? What is your table ddl? Give us create table statements, sample data, and...

Run PerfMon and a server-side sql trace. You might also check the default trace, see if it has enough back log to show you what was going on the last...

Grrrrrrr!

😛

I'm seeing two things. 1) In your result set, you refer to customer 9181, who doesn't exist in the test data. I'm assuming you meant 9151 and this is just...