Foo - Got to thinking...

Bikeforums.net is a forum about nothing but bikes. Our community can help you find information about hard-to-find and localized information like bicycle tours, specialties like where in your area to have your recumbent bike serviced, or what are the best bicycle tires and seats for the activities you use your bike for.




View Full Version : Got to thinking...


chevy42083
09-08-09, 10:20 AM
...am I the only/first person to use American Racing billet wheel polish on Campy? Something about it just seems wrong.

Spent a couple hours polishing up the metal bits on my Bianchi yesterday. Sure is pretty though


jsharr
09-08-09, 10:32 AM
This thread makes me feel sick, sort of IL Duce.................

overthehillmedi
09-08-09, 11:24 AM
take it easy,all that thinking might strain your brain!


chevy42083
09-09-09, 07:32 AM
I think I'm almost recovered. Thanks though.

I want to take it for a ride tonight, but it rained this morning, and there will probably still be puddles this evening :(

jsharr
09-09-09, 07:44 AM
I think I'm almost recovered. Thanks though.

I want to take it for a ride tonight, but it rained this morning, and there will probably still be puddles this evening :(

needs to be in the top 10 reasons not to ride thread.

Also, you need to eat these when polishing Campy with AR products.

http://farm4.static.flickr.com/3299/3237339329_1edb2917aa.jpg

Brian
09-09-09, 07:51 AM
I have a black wire tie from my new mouse. It's been bent into the shape of a little French mustache, and when things get slow or tense at work, I hold it up under my nose and say "I geev op".

jsharr
09-09-09, 07:53 AM
I have a black wire tie from my new mouse. It's been bent into the shape of a little French mustache, and when things get slow or tense at work, I hold it up under my nose and say "I geev op".

Is this before or after you ask "Would you like to Supersize your order?":innocent:

Brian
09-09-09, 08:05 AM
Is this before or after you ask "Would you like to Supersize your order?":innocent:

Hmmm. I was just getting ready to execute this:


USE master
GO
IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL
DROP PROCEDURE sp_hexadecimal
GO
CREATE PROCEDURE sp_hexadecimal
@binvalue varbinary(256),
@hexvalue varchar(256) OUTPUT
AS
DECLARE @charvalue varchar(256)
DECLARE @i int
DECLARE @length int
DECLARE @hexstring char(16)
SELECT @charvalue = '0x'
SELECT @i = 1
SELECT @length = DATALENGTH (@binvalue)
SELECT @hexstring = '0123456789ABCDEF'
WHILE (@i <= @length)
BEGIN
DECLARE @tempint int
DECLARE @firstint int
DECLARE @secondint int
SELECT @tempint = CONVERT(int, SUBSTRING(@binvalue,@i,1))
SELECT @firstint = FLOOR(@tempint/16)
SELECT @secondint = @tempint - (@firstint*16)
SELECT @charvalue = @charvalue +
SUBSTRING(@hexstring, @firstint+1, 1) +
SUBSTRING(@hexstring, @secondint+1, 1)
SELECT @i = @i + 1
END
SELECT @hexvalue = @charvalue
GO

IF OBJECT_ID ('sp_help_revlogin') IS NOT NULL
DROP PROCEDURE sp_help_revlogin
GO
CREATE PROCEDURE sp_help_revlogin @login_name sysname = NULL AS
DECLARE @name sysname
DECLARE @xstatus int
DECLARE @binpwd varbinary (256)
DECLARE @txtpwd sysname
DECLARE @tmpstr varchar (256)
DECLARE @SID_varbinary varbinary(85)
DECLARE @SID_string varchar(256)

IF (@login_name IS NULL)
DECLARE login_curs CURSOR FOR
SELECT sid, name, xstatus, password FROM master..sysxlogins
WHERE srvid IS NULL AND name <> 'sa'
ELSE
DECLARE login_curs CURSOR FOR
SELECT sid, name, xstatus, password FROM master..sysxlogins
WHERE srvid IS NULL AND name = @login_name
OPEN login_curs
FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @xstatus, @binpwd
IF (@@fetch_status = -1)
BEGIN
PRINT 'No login(s) found.'
CLOSE login_curs
DEALLOCATE login_curs
RETURN -1
END
SET @tmpstr = '/* sp_help_revlogin script '
PRINT @tmpstr
SET @tmpstr = '** Generated '
+ CONVERT (varchar, GETDATE()) + ' on ' + @@SERVERNAME + ' */'
PRINT @tmpstr
PRINT ''
PRINT 'DECLARE @pwd sysname'
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
PRINT ''
SET @tmpstr = '-- Login: ' + @name
PRINT @tmpstr
IF (@xstatus & 4) = 4
BEGIN -- NT authenticated account/group
IF (@xstatus & 1) = 1
BEGIN -- NT login is denied access
SET @tmpstr = 'EXEC master..sp_denylogin ''' + @name + ''''
PRINT @tmpstr
END
ELSE BEGIN -- NT login has access
SET @tmpstr = 'EXEC master..sp_grantlogin ''' + @name + ''''
PRINT @tmpstr
END
END
ELSE BEGIN -- SQL Server authentication
IF (@binpwd IS NOT NULL)
BEGIN -- Non-null password
EXEC sp_hexadecimal @binpwd, @txtpwd OUT
IF (@xstatus & 2048) = 2048
SET @tmpstr = 'SET @pwd = CONVERT (varchar(256), ' + @txtpwd + ')'
ELSE
SET @tmpstr = 'SET @pwd = CONVERT (varbinary(256), ' + @txtpwd + ')'
PRINT @tmpstr
EXEC sp_hexadecimal @SID_varbinary,@SID_string OUT
SET @tmpstr = 'EXEC master..sp_addlogin ''' + @name
+ ''', @pwd, @sid = ' + @SID_string + ', @encryptopt = '
END
ELSE BEGIN
-- Null password
EXEC sp_hexadecimal @SID_varbinary,@SID_string OUT
SET @tmpstr = 'EXEC master..sp_addlogin ''' + @name
+ ''', NULL, @sid = ' + @SID_string + ', @encryptopt = '
END
IF (@xstatus & 2048) = 2048
-- login upgraded from 6.5
SET @tmpstr = @tmpstr + '''skip_encryption_old'''
ELSE
SET @tmpstr = @tmpstr + '''skip_encryption'''
PRINT @tmpstr
END
END
FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @xstatus, @binpwd
END
CLOSE login_curs
DEALLOCATE login_curs
RETURN 0
GO


exec sp_help_revlogin

jsharr
09-09-09, 08:08 AM
It must be slow if you can write code on the cash register.

Brian
09-09-09, 08:12 AM
It must be slow if you can write code on the cash register.

It's for migrating SQL logins. Free fries for everyone!

chevy42083
09-09-09, 08:24 AM
I'll take a large please! Carbo load on the potatoes!

KingTermite
09-09-09, 08:58 AM
...am I the only/first person to use American Racing billet wheel polish on Campy? Something about it just seems wrong.

Spent a couple hours polishing up the metal bits on my Bianchi yesterday. Sure is pretty though

You know....there's a place for people like you (http://en.wikipedia.org/wiki/Bellevue_Hospital_Center).

Brian
09-09-09, 09:08 AM
You know....there's a place for people like you (http://en.wikipedia.org/wiki/Bellevue_Hospital_Center).

That's one of our clients.