Viewing 15 posts - 2,476 through 2,490 (of 3,221 total)
Not sure what you mean by "Friendly errors", SQL defines the Error messages (text) and the Severity Level of an error as:
Severity level Description
0-9
Informational messages that...
August 6, 2009 at 12:33 pm
For those who read this forum and who are living in the U.S.A and who have forgotten about the Do Not Call listing and who wish to stop telemarketing phone...
August 6, 2009 at 12:19 pm
mtassin
How in the world does that put records in?
Emphasis added.
DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS updates the suspect_pages table to indicate each page that it has deallocated or repaired.
An update certainly answers...
August 6, 2009 at 10:03 am
Starunit
When you do get it figured out, and make it work, think about posting your code here so as to help others with similiar problems.
If you are still having...
August 5, 2009 at 5:44 pm
This forum post although referencing importing Excel to 2008, I believe will also be applicable to 2005.
It supplies in great detail, and a complete script which may provide you with...
August 5, 2009 at 6:59 am
Bruce W. Cassidy
It should be a business friendly language
Then we could develope a command called MOVE CORRESPONDING
to designate a set based operation.
And use something like PERFORM paragraph1 THRU paragraph2. when...
August 4, 2009 at 3:51 pm
You might want to read from Books On Line the following:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/799b9934-0ec2-4f43-960b-5c9653f18374.htm
The information you are looking for is in the dbo.restorehistory table in the msdb database.
August 4, 2009 at 7:48 am
I mentioned this once before on the thread
http://www.sqlservercentral.com/Forums/Topic604325-61-712.aspx
The OP did receive a little help from SSC, and then went back to searching further on his own and solved his...
August 3, 2009 at 8:55 am
RBarryYoung
(I can call you "bit", right? )
Heck YES
I am honored ....
August 2, 2009 at 12:17 pm
For all the trials and tribulations there is occassionally a few that express appreciation for what help has been given, for example:
http://www.sqlservercentral.com/Forums/Topic763622-149-1.aspx.
Not to forget those who feed back knowledge to...
August 2, 2009 at 10:19 am
Chuck.Evans
With this I was able to import 39,000 line from 44 spreadsheets in about 30 seconds.
For the benefit of others would you consider posting your code or submitting it as...
August 2, 2009 at 9:05 am
novice_coder
As you have noted SSC is habited by people who are willing and able to help others in the community. I would sincerely hope that you have documented /...
August 2, 2009 at 7:58 am
Slick84
When data is inserted from a view into my table with these 2 constraint columns and more, all the dates are initially set to NULL
'tblcountryoforigin_archivedate_uq
Not knowing the use of...
August 1, 2009 at 4:17 pm
novice_coder
Read the article that Jeff has in his signature block. Remember SQL is set based and Jeff's post will show you how to avoid the row by agonizing row...
August 1, 2009 at 3:21 pm
You might want to look at this freebe from Microsoft:
Log Parser 2.2 available from:
Microsofts description
Log parser is a powerful, versatile tool that provides universal query access to text-based data...
July 31, 2009 at 3:18 pm
Viewing 15 posts - 2,476 through 2,490 (of 3,221 total)