Viewing 15 posts - 61 through 75 (of 92 total)
True, Calvin's and Greg's code is simpler but less flexible.
What if you only wanted to to delete multiple spaces?
i.e.
'Have a nice day!' to
'Have a nice day!'
...
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 21, 2003 at 3:38 pm
What version of SQL Server?
Is this a production database?
Are you able to connect to the database server and not the database?
What tool are you using?
Are your NT services running? ...
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 21, 2003 at 2:07 pm
All good info at that link but I'll stick to my tried and true...
If you can shut down the database I've always found that the quickest solution is immediately after...
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 21, 2003 at 1:59 pm
That's exactly what I did in PHP and it worked fine. Although, it seems to me there was some other character that needed replacing as well.
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 21, 2003 at 9:55 am
I ran into this problem a while back. I was building an application in PHP that accessed a SQL Server database and one thing I included was a timestamped...
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 21, 2003 at 9:24 am
I made something similar and built it into a function
-- =============================================
-- Create scalar function (FN)
-- =============================================
IF EXISTS (SELECT *
FROM sysobjects
WHERE...
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 20, 2003 at 3:33 pm
"...so, you might want to consider re-writing the whole schlamele from scratch..."
Best advice I've heard in this whole thread!
I've only done a few of these conversions and only one was...
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 20, 2003 at 8:38 am
Was this ever implemented?
It would be nice on the script screen to have a link to a forum thread or to start one. Often it seems that...
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 19, 2003 at 10:39 am
If you can shut down the database I've always found that the quickest solution is immediately after a full backup to use sp_detach_db, delete the physical log file and then...
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 19, 2003 at 9:42 am
Thanks for the input folks!
Feel free to continue adding your two cents.
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 8, 2003 at 11:09 am
Ok,
Peak traffic? - I don't have that info yet.
My business? - I'm new so I don't want to say specifically but let's just say that this is the database for...
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 8, 2003 at 7:47 am
Wow! I put a whole lot of 'guys' in that last post. I write goodly!
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
January 16, 2003 at 1:34 pm
I don't think capturing a stream of IM's is workable. You'd get a ton of junk along with a few tips.
As for Andy's points about you guys monitoring it...
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
January 16, 2003 at 1:33 pm
I realize it's similar to the forum but it has the added advantage of realtime communication.
Of course, the downside is that unlike the forum you would lose the...
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
January 15, 2003 at 3:17 pm
Sorry, should have added that I would never try this on a production server.
My background was as a DBA at a software development shop and all but one...
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
December 9, 2002 at 9:04 pm
Viewing 15 posts - 61 through 75 (of 92 total)