quote: To the best of my knowledge the answer is no. I also know of no tool to correct a broken file. Even i can open (in HEX) the backup file and verify the data is inside ??? I think is just a matter of structure of bak file. Anyway .. thanks a lot
2003-11-26
Where do you see 16%? The CPU column should be ms used. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-11-18
Just for completeness, there is an undocumented extended stored procedure converting hex to int DECLARE @dec varbinary(10) DECLARE @result varchar(255) SET @dec = 813185089 EXEC master..xp_varbintohexstr @dec, @result OUT PRINT @result Cheers, Frank
2003-07-23
2003-06-30
1 reads
Nice article. On a related note do you have any ideas on how to detect whether a stored procedure completed execution when run from ADO? For instance take the following SQL; CREATE TABLE TestTable ( x INT NOT NULL CONSTRAINT CK_TestTable_x CHECK(x = 1) ) GO CREATE PROCEDURE TestSP AS BEGIN BEGIN TRANSACTION INSERT INTO […]
2003-06-26
2 reads
Delayed thanks to David - I've been busy getting the new server into production. Your ref was very useful, I'll explore that site further ... Over and out!
2003-06-12
Sounds like there's wax in the network card. Take an ear bud and give it a clean. Sorry, a VERY lame attempt at humour. It's late Cheers, Crispin
2003-05-22
1 reads
I'm also having this problem. (See my slightly earlier post "Maintenance plan/DBCC problem"). It might be worth having a look at a MS knowledgebase article: http://support.microsoft.com/?kbid=301292 Although this hasn't helped me! Anyone got any other ideas? Thanks
2003-05-19
2 reads
Hi David, quote: p.s. I disagree with 'You cannot use CHARINDEX on textfields', I can on SQL7 SP4. From BOL (SQL2k) ... These functions and statements can be used with ntext, text, or image data. Functions DATALENGTH PATINDEX SUBSTRING TEXTPTR TEXTVALID ... ...but it seems to work in some cases?!? Anyway, using DATALENGTH is a […]
2003-05-19
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers