Coppock's Coolness

Check out this keyboard!

2011-04-20T12:29:00.002-05:00

Totally stole this from a work-email

2011-03-23T15:04:00.002-06:00

These came from the annual "Dark and Stormy Night" competition. Actual analogies and metaphors found in high school essays:

1. Her face was a perfect oval, like a circle that had its two sides gently compressed by a Thigh Master.

2. His thoughts tumbled in his head, making and breaking alliances like underpants in a dryer without Cling Free.

3. He spoke with the wisdom that can only come from experience, like a guy who went blind because he looked at a solar eclipse without one of those boxes with a pinhole in it and now goes around the country speaking at high schools about the dangers of looking at a solar eclipse without one of those boxes with a pinhole in it.

4. She grew on him like she was a colony of E. coli and he was room-temperature Canadian beef.

5. She had a deep, throaty, genuine laugh, like that sound a dog makes just before it throws up.

6. Her vocabulary was as bad as, like, whatever.

7. He was as tall as a six-foot-three-inch tree.

8. The revelation that his marriage of 30 years had disintegrated because of his wife's infidelity came as a rude shock, like a surcharge at a formerly surcharge-free ATM.

9. The little boat gently drifted across the pond exactly the way a bowling ball wouldn't.

10. McBride fell 12 stories, hitting the pavement like a Hefty bag filled with vegetable soup.

11. From the attic came an unearthly howl. The whole scene had an eerie, surreal quality, like when you're on vacation in another city and Jeopardy comes on at 7:00 p.m. instead of 7:30.

12. Her hair glistened in the rain like a nose hair after a sneeze.

13. The hailstones leaped from the pavement, just like maggots when you fry them in hot grease.

14. Long separated by cruel fate, the star-crossed lovers raced across the grassy field toward each other like two freight trains, one having left Cleveland at 6:36 p.m. traveling at 55 mph, the other from Topeka at 4:19 p.m. at a speed of 35 mph.

15. They lived in a typical suburban neighborhood with picket fences that resembled Nancy Kerrigan's teeth.

16. John and Mary had never met. They were like two hummingbirds who had also never met.

17. He fell for her like his heart was a mob informant and she was the East River.

18. Even in his last years, Grandpappy had a mind like a steel trap, only one that had been left out so long, it had rusted shut.

19. Shots rang out, as shots are wont to do.

20.. The plan was simple, like my brother-in-law Phil. But unlike Phil, this plan just might work.

21. The young fighter had a hungry look, the kind you get from not eating for a while.

22. He was as lame as a duck. Not the metaphorical lame duck, either, but a real duck that was actually lame, maybe from stepping on a land mine or something.

23. The ballerina rose gracefully en pointe and extended one slender leg behind her, like a dog at a fire hydrant.

24. It was an American tradition, like fathers chasing kids around with power tools.

25. He was deeply in love. When she spoke, he thought he heard bells, as if she were a garbage truck backing up.

26. Her eyes were like limpid pools, only they had forgotten to put in any pH cleanser.

27. She walked into my office like a centipede with 98 missing legs.

C Sharp Method for Integer Testing

2011-03-18T10:23:00.010-06:00

I was amazed when I found out that there wasn't a decent way to test a string value like you can do in VB. So I wrote my own:

public int StringToInt(string strEntry)
{
   int iRetVal = 0;
   return Int32.TryParse(strEntry, out iRetVal) ? iRetVal : 0;
}

So then to test it, I simply do something like:


string myTestString = "Test";
if(StringToInt(myTestString) > 0) ...

2010-12-28T12:06:00.000-06:00

James is unloading 8 rounds in this scene.

Andrea's 20 Gauge

2010-12-28T12:03:00.001-06:00

Andrea got herself a 20 Gauge and tries it out for the first time here.

Dustin shooting JoJo's .38

2010-12-28T11:48:00.001-06:00

We recorded Dustin trying out how it feels to shoot a .38 snub nose!

Drews 22

2010-12-28T11:30:00.001-06:00

James recorded this with my BlackBerry while we were at the shooting range on Christmas Eve.

SSRS 2008 Report Fails on SSRS 2005 Server

2010-05-14T14:30:00.002-05:00

It may not come as a shock to some, but this one took me by surprise. It took some Google-ing to find the answer, but the short of it is: it does not work.

You have to deploy SSRS 2008 reports to an instance of SSRS running on SQL Server 2008 under an IIS site configured to use an SQL 2008 database.

Sorry this post is so short. I will update this post with a pertinent link as soon as I find it in my browser history on my work desktop.

:) - Cheers.

Concerning the Flu Virus and Vaccines

2009-08-20T10:05:00.003-05:00

The only times in my life that I have had the flu was during my enlistment in the United States Air Force, when I was required to be vaccinated. Every year I got the shot, and every year, I got the flu. Since then, I have not had one year that I contracted the flu.

Now, they tell us that we have to be vaccinated against H1N1! I am not. I refuse! I will defend my right to refuse to be vaccinated. I urge anyone to do their research before allowing anyone to instill PANIC and FEAR in you.

I do not understand

2009-07-10T15:30:00.003-05:00

Why is it, now that the Democrats have control, they are spending money we don't have? When I mentioned this to a co-worker, he said, "Oh, you mean like the Republicans did with the war?"

So, spending money on abortions on demand is okay, but funding the war on terror is wrong? He may be right, that we didn't have the money allocated to fund the war. But how can that even be on the same playing field as the Liberal Health Care for Everyone plan, that is going to fully authorize any form of abortion, and stem cell research, and all manner of programs that are okay on their side of social norms?

So help me understand, if you can.

I am an SA - Assistant Scoutmaster

2009-06-18T09:46:00.003-05:00

During the Webelos Crossover Ceremony at our June 5-7 campout, I made the transition from the Pack Cubmaster to the Troop Asst Scoutmaster. I was welcomed by Mr. Mark (Scoutmaster) and Mr. Woody (Chartered Org Rep). Ms. Adrianne moved up from Den Leader to Cubmaster for the Pack.
Best wishes to the Pack! Lookout Troop; here I come!

Had to share this post...

2009-06-04T12:46:00.001-05:00

American capitalism gone with a whimper . . . . .

It must be said, that like the breaking of a great dam, the American decent into Marxism is happening with breath taking speed, against the back drop of a passive, hapless sheeple, excuse me dear reader, I meant people.

True, the situation has been well prepared on and off for the past century, especially the past twenty years. The initial testing grounds was conducted upon our Holy Russia and a bloody test it was. But we Russians would not just roll over and give up our freedoms and our souls, no matter how much money Wall Street poured into the fists of the Marxists.

Those lessons were taken and used to properly prepare the American populace for the surrender of their freedoms and souls, to the whims of their elites and betters.

First, the population was dumbed down through a politicized and substandard education system based on pop culture, rather than the classics. Americans know more about their favorite TV dramas than the drama in DC that directly affects their lives. They care more for their "right" to choke down a McDonalds burger or a BurgerKing burger than for their constitutional rights. Then they turn around and lecture us (Russia) about our rights and about our "democracy". Pride blinds the foolish.

Then their faith in God was destroyed, until their churches, all tens of thousands of different "branches and denominations" were for the most part little more then Sunday circuses and their televangelists and top protestant mega preachers were more then happy to sell out their souls and flocks to be on the "winning" side of one pseudo Marxist politician or another. Their flocks may complain, but when explained that they would be on the "winning" side, their flocks were ever so quick to reject Christ in hopes for earthly power. Even our Holy Orthodox (Russian Orthodox) churches are scandalously liberalized in America.

The final collapse has come with the election of Barack Obama. His speed in the past three months has been truly impressive. His spending and money printing has been a record setting, not just in America's short history but in the world. If this keeps up for more than another year, and there is no sign that it will not, America at best will resemble the Wiemar Republic and at worst Zimbabwe.

These past two weeks have been the most breath taking of all. First came the announcement of a planned redesign of the American Byzantine tax system, by the very thieves who used it to bankroll their thefts, loses and swindles of hundreds of billions of dollars. These make our Russian oligarchs look little more than ordinary street thugs, in comparison. Yes, the Americans have beat our own thieves in the shear volumes. Should we congratulate them?

These men, of course, are not an elected panel but made up of appointees picked from the very financial oligarchs and their henchmen who are now gorging themselves on trillions of American dollars, in one bailout after another. They are also usurping the rights, duties and powers of the American congress (parliament). Again, congress has put up little more then a whimper to their masters.

Then came Barack Obama's command that GM's (General Motor) president step down from leadership of his company. That is correct, dear reader, in the land of "pure" free markets, the American president now has the power, the self given power, to fire CEOs and we can assume other employees of private companies, at will. Come hither, go dither, the centurion commands his minions.

So it should be no surprise that the American president has followed this up with a "bold" move of declaring that he and another group of unelected, chosen stooges will now redesign the entire automotive industry and will even be the guarantee of automobile policies. I am sure that if given the chance, they would happily try and redesign it for the whole of the world, too. Prime Minister Putin, less then two months ago, warned Obama and UK's Blair, not to follow the path to Marxism, it only leads to disaster. Apparently, even though we suffered 70 years of this Western sponsored horror show, we know nothing, as foolish, drunken Russians, so let our "wise" Anglo-Saxon fools find out the folly of their own pride.

Again, the American public has taken this with barely a whimper...but a "freeman" whimper.

So, should it be any surprise to discover that the Democratically controlled Congress of America is working on passing a new regulation that would give the American Treasury department the power to set "fair" maximum salaries, evaluate performance and control how private companies give out pay raises and bonuses? Senator Barney Franks, a social pervert basking in his homosexuality (of course, amongst the modern, enlightened American societal norm, as well as that of the general West, homosexuality is not only not a looked down upon life choice, but is often praised as a virtue) and his Marxist enlightenment, has led this effort. He stresses that this only affects companies that receive government monies, but it is retroactive and taken to a logical extreme, this would include any company or industry that has ever received a tax break or incentive.

The Russian owners of American companies and industries should look thoughtfully at this and the option of closing their facilities down and fleeing the land of the Red as fast as possible. In other words, divest while there is still value left.

The proud American will go down into his slavery with out a fight, beating his chest and proclaiming to the world, how free he really is. The world will only snicker.

Stanislav Mishin

Trouble with Report in Browser

2009-02-19T13:15:00.002-06:00

I'll try to make this clear and concise. I have a report that has 2 required parameters. When run from the Reports site, the user picks the first parameter, then the browser refreshes with a drop-down list populated with values that are dependent on the resultset from the first parameter. This all works perfectly, until I want to call the report from an outside application.

The 1st drop-down list is populated from a dataset with all Load Numbers.
The 2nd drop-down list is populated from a dataset with Order Numbers associated with that Load Number.

Do do this, I have to use the ReportServer site. It works from here too when I pick a Load Number from the drop-down list, or when I manually enter the first parameter into the querystring (address bar) with something like: &MyLoadNumber=9999

The report will load correctly when I choose the 2nd parameter from the drop-down list and click the View Report button.

The problems creep in when I add the second parameter on the querystring like &MyOrders=BR549 - The browser goes out and gets the report, but what I get back is the report asking me for the 2nd parameter, even though it is right there in the querystring!

I know it is a problem that the 2nd parameter isn't requested until the 1st one is loaded correctly, and the dataset for the 2nd parameter has the 1st parameter as a required parameter for it.

If you are reading this and you know what I can do to solve this, please post a comment. I'll be sure to tell my boss you helped me! ;)

Emergency Preparedness Plan

2009-02-16T13:44:00.002-06:00

EPP: We should all be ready with an emergency prep plan. Who knows what is in store for us in the days to come? We need to keep our faith up and look to Christ to strengthen us, and we need to do our part! Keep our lanterns filled with oil, and have oil ready for others who need us.

IIS startup after install for .Net 2.0

2008-07-15T13:20:00.002-05:00

Find the latest version of .net (like v1.0.x or v1.1.x or v2.0.x) looking in: C:\Windows\Microsoft.Net\Framework\
Run this command: "net stop w3svc" to stop web services
Run "aspnet_regiis.exe -ua" to uninstall all instances of ASP.NET from IIS
Now run "aspnet_regiis.exe -i" to install ASP.NET into IIS
Finally restart web services with "net start w3svc"

No Longer Sharepoint Admin

2008-06-03T09:27:00.002-05:00

Well, I took the plunge and traded hats: Sharepoint Admin for Clarion Programmer. I left CMI for CAT² on May 16th. I've been training in Clarion 5.5 and 6.3 for 2 weeks now, and I am very near to beginning my first real assignment.

I'll let you know how I do on this soon!

SharePoint Subsite Move Up 1 Level

2008-05-01T15:16:00.002-05:00

by Zac Smith, 9 July 2007
Had a situation recently where I needed to promote a subsite to a top level site. As STSADM backup/restore can only be used at the site collection level, a different approach was required.
As of WSS v3, there are two new STSADM commands - import and export.
The basic procedure to promote the subsite was to STSADM export the site to a file and then STSADM import it at the toplevel.
Here are the basic commands I used:

Export subsite
stsadm -o export -url http://toplevel/sub_site/subsite -filename c:\subsite.bak -includeusersecurity -versions 4

Import subsite
stsadm -o import -url http://toplevel/subsite/ -filename c:\subsite.bak -includeusersecurity

A couple of things to note:
The -includeusersecurity switch ensures that all the columns such as modifed by, created by are maintained.

The -versions 4 switch will ensure that all versions of list items/documents are exported.

You must import/export to sites that share the same template. So a team site can only be exported and imported into another team site. You will know you are trying to import into non matching templates if you get the following error:

"The exported site is based on the template STS#1 but the destination site is based on the template STS#0"

This means that a site based on the blank template is trying to be imported into a site based on the team template. To my knowledge there is no easy way of changing a sites templates.
The following lists some of the common WSS templates:

Team Site	STS#0
Blank Site	STS#1
Document Workspace	STS#2
Wiki Site	WIKI#0
Blog	BLOG#0

NPC Skill Chart

2008-04-23T11:43:00.010-05:00

Detail	Green	Rookie	Regular	Veteran	Expert	Elite
Initiative	1	2	3	4	5	6
Observation	6	8	10	12	14	16
Primary Wpn. Skill	1	2-3	4-5	6-7	8-9	9-10
Avg. Stat.	3	4	5	6	7	8
Wpn. Bonus	45%	55%	65%	70%	75%	80%
Armor Bonus	40%	50%	55%	60%	65%	75%
Gear Bonus	35%	40%	45%	50%	55%	70%
Loyalty Base	1	2	4	6	8	10
Loyalty Bonus	-2	-1	0	2	4	6

SQL 2005 would not let me drop a database

2008-04-14T14:42:00.005-05:00

I did some digging to see if there was a 'real' reason for this. All I could find was the the database was in use.

I found this t-sql script to help me find out why the db was in use.


USE Master

DECLARE @dbid INT
DECLARE @dbname nvarchar(40)
SET @dbname = '[your_db_name_here]'
SELECT @dbid = dbid FROM sys.sysdatabases WHERE name = @dbname

IF EXISTS (SELECT spid FROM sys.sysprocesses WHERE dbid = @dbid)
BEGIN
   --RAISERROR ('The restore cannot be done', 16, 1)
   SELECT 'These processes are blocking the db in question' AS Note,
   spid, last_batch, [status], hostname, loginame FROM sys.sysprocesses
   WHERE dbid = @dbid
END
ELSE
BEGIN
   SELECT 'There were no SPIDS using the database: ' + @dbname as Note
END

I ran this t-sql and saw that I had a single SPID (51) that was connected to my database. I executed 'kill [spid]' and then tried my drop db command again. Of course it didn't work. I then ran this script repeatedly by highlighting the code ind the SQL Server Management Studio code window and pressed F5 over and over until I could see that the command to drop the db was working.

Not sure why that SPID kept reappearing. But the problem is fixed.

T2K Base Hit Numbers (d20)

2008-03-05T18:41:00.022-06:00

We talked about posting a new hit chart including point blank and extreme range.
So I'll post the table here...

Skill	PB (+6)	Short (+4)	Med (+2)	Long (stat)	Ext (-4)
10	16	14	12	10	6
9	15	13	11	9	5
8	14	12	10	8	4
7	13	11	9	7	3
6	12	10	8	6	2
5	11	9	7	5	1
4	10	8	6	4	-
3	9	7	5	3	-
2	8	6	4	2	-
1	7	5	3	1	-

Stat	1	2	3	4	5	6	7	8	9	10
Adj.	-3	-2	-2	-1	0	+1	+1	+2	+2	+3

Me.Brain.Dead()

2008-03-04T14:05:00.003-06:00

Me.Stomach.Empty(true)
Me.Oh.My
My.Head.Hurts
My.Bologna.FirstName('OSCAR')
Me.My.Big.Mouth(!funny)

(and so on)

ProjectServer 2007 Project Not Showing In Project Center

2008-03-04T11:31:00.003-06:00

This one had me stumped for over a week! (Embarrased about this, now that I know how easy it should have been.)
Could see project from Project Professional by viewing Project Center.
Could *NOT* see project from PWA by viewing Project Center.
Fix:
Make sure you posted project to correct PWA server. (use profiles if necessary)

Open Project Professional
Click File - Open - (choose "Retrieve the list of all projects from Project Server" in the list of previously opened projects) and click Open
Choose Project from list (if project does not appear, you have connected to the wrong PWA source)

Now: Choose File - Publish (it's that easy!)

To create profiles:

Tools - Enterprise Options - Micorosoft Office Project Server Accounts
or Alt T - E - P
Make sure your URL appears in the list with your domain name as the name used in the project --- if not, click Add and complete the form as needed
If you have multiple PWA sources, choose the "Manully control connection state" radio button on this utility

Happy Servering!

Question: DB from SQL 2005 to SQL 2000

2008-02-18T14:26:00.003-06:00

When initially trying to migrate SharePoint databases from the same machine that is running the whole FARM, I got this error:

SqlException: Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE DATABASE is terminating abnormally.

Afer researching this, I discovered that it should work after upgrading the SQL 2000 engine to SP4 (as we had SP3). Over the weekend, we upgraded our production database to SP4. Then I tried the SharePoint restore to that production database again
(using stsadm -o restore -directory \\server2\disks\sharepointbackup -restoremethod new and applying the new db server name, server db and log file location, and then the new db names). The new error is:

SqlException: The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database. RESTORE DATABASE is terminating abnormally.

If anyone else is having a similary issue and knows how to get around this, please post a comment or email me.

osql query to text file - thanks to Brain Knight

2008-02-15T10:01:00.007-06:00


Piping a Query to a Text File
By Brian Knight, 2001/05/21

The case where one has to send the results of a query to a text file comes up quite often. General this case take the form of a maintenance script that you run through Agent nightly and would like to see the results in the morning.
In the above example, you can create a CMDEXEC job to run the below command. This will output the results of the query inside c:\inputquery.txt to a separate file.


\mssql7\binn\osql -Usa -Ppassword -Ic:\inputquery.txt -Oc:\outputdir\output.txt


You can also use -E switch for trusted connection if you don't want to hard code a password into your job. From an Query Analyzer window or inside the stored procedure you can run the above statement with an extended stored procedure called XP_CMDSHELL:


master..xp_cmdshell 'osql
 -Usa
 -Pmisty
 -dNorthwind
 -Q"select * from products"
 -oc:\output.txt'


The -Q parameter in the above syntax runs the query then exits ISQL. You may also want to add the additional NO_OUTPUT parameter at the end of query as shown below to supress any output to the client:


master..xp_cmdshell 'osql
 -Usa
 -Pmisty
 -dNorthwind
 -Q"select * from products"
 -oc:\output.txt', no_output


There are other methods of piping a query to a text file by using OLE Automation but they are much more complex than this method.


By Brian Knight, 2001/05/21


usage: osql              [-U login id]          [-P password]
  [-S server]            [-H hostname]          [-E trusted connection]
  [-d use database name] [-l login timeout]     [-t query timeout]
  [-h headers]           [-s colseparator]      [-w columnwidth]
  [-a packetsize]        [-e echo input]        [-I Enable Quoted Identifiers]
  [-L list servers]      [-c cmdend]            [-D ODBC DSN name]
  [-q "cmdline query"]   [-Q "cmdline query" and exit]
  [-n remove numbering]  [-m errorlevel]
  [-r msgs to stderr]    [-V severitylevel]
  [-i inputfile]         [-o outputfile]
  [-p print statistics]  [-b On error batch abort]
  [-O use Old ISQL behavior disables the following]
       batch processing
      Auto console width scaling
      Wide messages
      default errorlevel is -1 vs 1
  [-? show syntax summary]

Petit Jean National State Park, 2006

2008-02-14T22:31:00.003-06:00

Here are my boys, my daughter, and 2 of my neices and 2 of my nephews. This pic was taken at Petit Jean Ntl Park during the winter of 2006. Here's a mountaintop view of the beautiful falls there.

IPTV at the Coppock Household

2008-02-14T22:02:00.005-06:00

The day has finally arived! A box shipped today from the company we've chosen to replace Charter Communication as our TV entertainment provider. We chose Sky Angel (www.skyangel.com) due to the now available Family Package along with their Faith Package. We were blowing through about $80/month to have digital cable (expanded basic). Now, through our broadband connection, we are watching TV over our home network. (They even have the Miliary Channel and NFL Network!) And the best part so far is that the commercials are not offensive, violent, sexually suggestive, or in any way a thing that would cause myself or my wife to yell out, "Close your eyes!" or "Don't look!" We are a family that loves God, and chooses to please Him. We couldn't be happier with our choice to drop cable and go with IPTV. If you are interested, you'll look at the price difference. I don't want to post them; I am not trying to be as salesman for them.

IIS 7.0 Config change

2008-02-14T13:47:00.008-06:00

This command-line execution will correctly configure your IIS settings after they get hosed by inadvertent changes or applications that make unwanted changes.

From: Drew Coppock
Sent: Wednesday, November 07, 2007 3:27 PM
To: Drew Coppock
Subject: IIS 7.0 Config change

RUN:
C:\Windows\system32\inetsrv\APPCMD.EXE set app "Default Web Site/" /applicationPool:"Classic .NET AppPool"

Should see
APP object "Default Web Site/" changed

Did I mention I am a Cubmaster?

2008-02-14T13:29:00.004-06:00

Yep, it's true. I am the Cubmaster for Agape Church Cub Scout Pack 70 in Little Rock, Arkansas. Need to ask me about this? email me.
Check out the BLOG for our Pack - http://quapawpack70.blogspot.com/
Check out the BLOG for our Troop - http://quapawtroop70.blogspot.com/

SQL 2005 User migration script

2008-02-14T13:03:00.005-06:00

I found this script very useful when migrating databases from 2000 to 2005. The security accounts were successfuly imported with the tables and views, but none of them worked properly. This script fixed things in a jiffy!

----- Begin Script, Create sp_help_revlogin procedure -----

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

----- End Script -----

To make SQL Server Express 2005 work in Management Studio

2008-02-14T10:57:00.002-06:00

1. Run SAC (Surface Area Configuration)
2. Add authority for user
3. Run Configuration Manager
4. Set to run as Local System, not Network Service
5. Should restart automatically

Twilight2K

2008-02-13T23:27:00.001-06:00

My younger brother and his 2 oldest sons play Twilight 2000 with me. We will post some gaming details here.

Welcome!

2008-02-13T22:14:00.005-06:00

Greets! I am excited to have finally gotten started in the whole blogging world. This has all happened at the bequest of a certain blogger I met just today. (Robin Meuré) I say met, but actually, I just IM'd with him. He asked me if I had a blog. I had to admit reluctantly that I had not taken that step as yet. His is glorix.blogspot.com.

I will be posting on different topics on this blog. Topics will include my professional life and skills I have developed, as well as important issues to me (like family life).

My professional life has given me the opportunity to grow in many different areas, but not excel enough to be a guru in any area. I have been doing HTML since 1997, a skill I picked up while killing time at the University of Central Arkansas' Computer Science Unix Lab. In 1998, I started an internship with Acxiom Corp (http://www.acxiom.com/) working on their Y2k intranet. In 1999, I started full time with them in an R&D group, doing VBScript (ASP) and Javascript to provision a site for their much-touted Acxiom Data Network. While working, I picked up some T-SQL skills, and SQLServer skills, but not enough to succeed at being a DBA. (Which just happened to be my next gig.) In 2003, I moved on to work for a 1-man shop doing T-SQL, DTS Packages, and batch scripts for automation as a consultant with Alltel. After 6 months of this, I moved on to a small company in the area who shut their doors after I worked for them for 2 weeks. I then moved on to work as a consultant for the state as an area coordinator. While doing this work, I maintained the web site and database. I stuck with this consultancy role far too long. I ended up being hired by the state in 2005 to fill a role that was not IT related. I just considered all my IT skills a bonus. So did the director. In total, I filled that role for a year and a half. During that time, I was able to attend an ASP.Net training class at Complete Computing (http://www.complete.com/). I left this role for the opportunity to be a consultant for this division, but according to the lawyers, a state employee may not leave the employ of the state and subsequently enter into a consultancy until after a 12 month time period has passed. So, I moved on to my next gig; working for a school district's IT department, doing ASP, ASP.Net, T-SQL, Javascript, HTML, and heavy DHTML. I moved on after 6 months of fun. Since 2006, I've been with a company serving as a Solutions Developer, working on VBA, VB.Net, ASP.Net, DotNetNuke, T-SQL, DTS Packages, SQLServer 2000 and 2005, as well as my HTML/DHTML and Javascript.

That's enough about work. Now for a little about my family. I've been married to my wife since 1995, and we have 2 boys who are 9 and 6. We also have a daughter who is 17. She is mine, but many people say she looks enough like my wife that folks cannot tell. All of my family currently live in Arkansas. My Mom lives a bit more than an hour away in North Central Arkansas. My Dad lives in Conway, my sister and her family live in Conway, and my younger brother and his family live in Conway. My older brother and his family live west of Little Rock. So I can visit any of my family within about an hour drive. We are a very close family, and we celebrate our closeness as often as we can. We enjoy food. Can I say that again? We enjoy putting a feed on! I may end up posting some of our favorite recipies here, too! (Not too many, though!) This is a guy's blog, after all.

Enough of the introductions. I'll post some more later.
Thanks for visiting!

Skill	PB (+6)	Short (+4)	Med (+2)	Long (stat)	Ext (-4)
10	16	14	12	10	6
9	15	13	11	9	5
8	14	12	10	8	4
7	13	11	9	7	3
6	12	10	8	6	2
5	11	9	7	5	1
4	10	8	6	4	-
3	9	7	5	3	-
2	8	6	4	2	-
1	7	5	3	1	-

Skill	PB (+6)	Short (+4)	Med (+2)	Long (stat)	Ext (-4)
10	16	14	12	10	6
9	15	13	11	9	5
8	14	12	10	8	4
7	13	11	9	7	3
6	12	10	8	6	2
5	11	9	7	5	1
4	10	8	6	4	-
3	9	7	5	3	-
2	8	6	4	2	-
1	7	5	3	1	-

Skill	PB (+6)	Short (+4)	Med (+2)	Long (stat)	Ext (-4)
10	16	14	12	10	6
9	15	13	11	9	5
8	14	12	10	8	4
7	13	11	9	7	3
6	12	10	8	6	2
5	11	9	7	5	1
4	10	8	6	4	-
3	9	7	5	3	-
2	8	6	4	2	-
1	7	5	3	1	-