Delete all MS SQL Stored Procedure

Here is a code that you can user to delete all ms sql stored procedure

DECLARE @procedureName varchar(500)
DECLARE cur CURSOR
      FOR SELECT [name] FROM sys.objects WHERE type = 'p'
      OPEN cur

      FETCH NEXT FROM cur INTO @procedureName
      WHILE @@fetch_status = 0
      BEGIN
            EXEC('DROP PROCEDURE ' + @procedureName)
            FETCH NEXT FROM cur INTO @procedureName
      END
      CLOSE cur
      DEALLOCATE cur

MS SQL Generate Script with Data

Here is a step on how you can make MS SQL Generate Script with Data.

  1. Open your Sql Server Management Studio.
  2. Select your database and right click on it follow just like what is in the image below. Refer to image 1
  3. Click Next until you when thru to the image below and click Advance. Refer to image 2
  4. Scroll down and until this row and update the value just like what is below. Refer to image 3
  5. Click Ok and next until you have generated the said script. Refer to image 4
  6. Now you have a create script that includes the schema at it’s data.

IIS Missing ASP .Net 4.0 Pool

Have you’ve been missing some pool in your IIS for your ASP .Net?

The this article entitle IIS Missing ASP .Net 4.0 Pool will help you.

Chances are, you need to install .NET 4 (Which will also take care of a new AppPool for you)

  1. Open your command prompt (Windows + R) and type cmd and press ENTER
    You may need to start this as an administrator if you have UAC enabled.
    To do so, locate the exe (usually you can start typing with Start Menu open), right click and select “Run as Administrator”
  2. Type cd C:\Windows\Microsoft.NET\Framework\v4.0.30319\ and press ENTER.
  3. Type aspnet_regiis.exe -ir and press ENTER again.
    • at this point you will see it begin working on installing .NET’s framework in to IIS for you
  4. Close the DOS prompt, re-open your start menu and right click Computer and select Manage
  5. Expand the left-hand side (Services and Applications) and select Internet Information Services
    • You’ll now have a new applet within the content window exclusively for IIS.
  6. Expand out your computer and locate the Application Pools node, and select it. (You should now see ASP.NET v4.0 listed)
  7. Expand out your Sites node and locate the site you want to modify (select it)
  8. To the right you’ll notice Basic Settings… just below the Edit Site text. Click this, and a new window should appear
  9. Select the .NET 4 AppPool using the Select… button and click ok.
  10. Restart the site, and you should be good-to-go.

(You can repeat steps 7-on for every site you want to apply .NET 4 on as well)

That’s it!

Thanks,
Thomie

Thank You Boss and Sykes Friends!

Thank you Boss Ariel Morales and Sykes family. Na surprise po talaga ako.. Thank you….

March 15 Android 4.0 on SII

March 15 Android 4.0 on SII

On March 15, Android 4.0 update will be rolling out for Samsung Galaxy SII. Its amazing that Samung provide excellent mobile phone and at the same time provide update so fast. I really love Samsung. As they call it, Sammy, I love you Samsung Keep up the good work!

Thanks,
Thomie 

Fix for Visual Studio 2010 Registration Details

Do you have a licensed Microsoft Visual Studio 2010? But the Licensed appears to be named to Microsoft? Then here is a Fix for Visual Studio 2010 Registration Details.

Registration Details Fix

Just Download it and Read the read me and viola it is now fix.

Google Implement latest Privacy Policy Last March 1

Hi Everyone,

We all know that Google Implement latest Privacy Policy Last March 1. One of this policy can make our browsing affect what advertisements shows according to what we mostly visit. Some of us might not want that to happen. So if your Google chrome, and I think you are, then you should install this extension that Google themselves encourage their users to have.

Its called Keep My Opt-Outs. Keep My Opt-Outs is an extension for Google Chrome that Permanently opts your browser out of online ad personalization via cookies which the new policy of Google is doing. What you need to do is just install it on your Google Chrome and your ready to go.

Download it now!

Thanks,
Thomie 

Windows 8 Consumer Preview on your PC?

Hi Friends!

Wondering if your computer can seamlessly run Windows 8 Consumer Preview on your PC? The should check this short specification that your computer should meet:

  • 1 GHz or faster processor 
  • 1 GB RAM (32-bit) or 2 GB RAM (64-bit)
  • 16 GB available hard disk space (32-bit) or 20 GB (64-bit)
  • DirectX 9 graphics device with WDDM 1.0 or higher driver
  • 1024 x 768 minimum screen resolution

Take note that 1024 x 768 resolution it alittle sad if your using a notebook because most notebook resolution is 1024 x 600 which doesn’t meet the said requirement. 

Later this day I will try to install it and tell you if it will work.

Also You may download it here

(64bit users) Download this if you are using morethan 4GB of RAM

(32bit users) Else Download this

Product Key:   DNJXJ-7XBW8-2378T-X22TX-BKG7J

Thanks,
Thomie

Remove a Website From Google

Have you ever wondered how to remove a website from Google? Or may be its your website that you don’t want anyone to see on Google when other people search about you. Then You are reading the right article. It just simple as 1-2-3.

Here its how it is done

  1. Go to this website.
  2. Choose either from the two selection if its your website or not and follow the steps
  3. Put the link to your desired page and wait for an approval

That’s it all other things will be taken care by Google. Hope it help you.

Thanks,
Thomie Jose San Agustin

Backup Sticky Notes

I am Roaming around to backup sticky notes on Windows 7 or Windows Vista. And finally I found a solution from the internet.

Here are the steps:

  1. Start
  2. Computer
  3. Navigate to C:\Users\<USER>\AppData\Roaming\Microsoft\Sticky Notes
    • Supply the <USER> with your computer user name
  4. And there is a StickyNotes.snt file you need to be backup-ed.

That’s it you have your sticky note backup-ed.

Globe IMMORTAL is Back!

Yep you here it right! Globe IMMORTAL is Back!

How to access it?

Just dial *143*1# and press call

Here are their promos:

  1. IMMORTALTRIO
    • FOR P25, enjoy 50 texts to Globe/TM, 5 texts to ALL NETOWRKS plus 5 mins of calls to Globe or TM, NO EXPIRY!
       
  2. IMMORTALTXT
    • For only P15, enjoy 25 texts to Globe/TM plus 5 texts to ALL NETWORKS, NO EXPIRY!

The only twist now is that you can only accumulate up to 100 immortal text and 10 minutes immortal call. 🙁