Viewing 15 posts - 5,446 through 5,460 (of 9,726 total)
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
July 28, 2011 at 6:24 am
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,...
July 28, 2011 at 6:21 am
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...
July 28, 2011 at 6:15 am
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...
July 28, 2011 at 6:13 am
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...
July 28, 2011 at 6:05 am
Kiara (7/28/2011)
Brandie Tarvin (7/28/2011)
So, are there any pastries or donuts at the water cooler today? I am in desperate need of sugar.
I can offer two day old peanut butter and...
July 28, 2011 at 6:01 am
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...
July 28, 2011 at 5:59 am
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...
July 28, 2011 at 5:57 am
forsqlserver (7/28/2011)
2008 R2Are u sure Backup compression is not used in 2008?
1) Please don't use text or L33T speak in the forums. There's enough acronyms and such flying around these...
July 28, 2011 at 5:49 am
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...
July 28, 2011 at 5:44 am
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...
July 28, 2011 at 5:42 am
GilaMonster (7/28/2011)
Brandie Tarvin (7/28/2011)
So, are there any pastries or donuts at the water cooler today? I am in desperate need of sugar.
I have hot cross buns. And I'm not sharing.
Grrrrrrr!
😛
July 28, 2011 at 5:17 am
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...
July 28, 2011 at 5:13 am
Eugene Elutin (7/28/2011)
1. If you re using SSRS to produce report, grouping can be done in SSRD itself
FYI: I agree with the above statement. In fact, in SSRS, you can...
July 28, 2011 at 5:00 am
Viewing 15 posts - 5,446 through 5,460 (of 9,726 total)