Viewing 15 posts - 5,431 through 5,445 (of 9,715 total)
I don't know how it works in other RDBMS, but in SQL Server, the identity function prevents you from inserting new numbers unless you specifically tell SQL that you're inserting...
July 28, 2011 at 7:43 am
Did you review the summary log to see what it said? Or the bootstrap log?
July 28, 2011 at 7:39 am
Ninja's_RGR'us (7/28/2011)
Wow that's so nice. I had heard about it but never played with it. It's like the Loch Ness Monster, so glad I finally saw it 😉
It's...
July 28, 2011 at 7:36 am
Kiara (7/28/2011)
Ninja's_RGR'us (7/28/2011)
What's their let's go home time?
Ah! *comprehension dawns* You mean the time where the work location shifts from the desk to the car and then to the sofa!...
July 28, 2011 at 7:30 am
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
Viewing 15 posts - 5,431 through 5,445 (of 9,715 total)