SQL server remap user - blank Login name

i come across this situation: my customer backup a db and i restore in our development server. The login user have empty "Login name". Hence, i'm not able to connect using this user name.



finally, i found out that we can use sp_change_users_login to map with login name.

for my case, my database name is HHotel, user login will be 'lam' and password 'l!a2m#'

USE HHotel;
GO
EXEC sp_change_users_login 'Auto_Fix', 'lam', NULL, 'l!a2m#';
GO

It's fixed after run above script.

For more example: http://msdn.microsoft.com/en-us/library/ms174378.aspx

Change stored proc owner in MSSQL 2000 & 2005

Below show how to change stored procedure owner in MS SQL 2000 and 2005

http://dotnetfish.blogspot.com/2008/04/change-table-and-stored-procedure.html

Remove Messenger (MSN or Yahoo) advertisement

I have applied a patch that able to remove the annoying advertisement for MSN Messenger. The patch not only able to remove the advertisement but many others [features] that come with the messenger.

My MSN Messenger is Version 2008 (Build 8.5.xxxxx). Go to http://apatch.org/downloads.php and download A-Patch for Windows Live Messenger 8.5. Extract the zip file and run the .exe file. No worry, it's safe. This is a cool patch with preview feature during the selection of unwanted feature. Try it.

DllRegisterServer failed with error code 0x80004005 ...

I was trying to register a dll with command prompt in Vista but error message prompt ".. DllRegisterServer failed with error code 0x80004005 ...."



finally i found out that is because of security issue. To solve this,
Go to Start --> All Programs --> Accessories, right-click Command Prompt, and then click Run as Administrator

Then use regsvr32 to register the DLL.

It's work.

Automate SQL 2005 Express Database backup

I just want to share a very cool SQL Agent that allowed us to automate the database backup by simple setting. Thanks to the author Danilo Corallo for sharing and make life our easier.

Please check on http://www.codeproject.com/KB/database/SQLAgent.aspx

osticket - admin login error "Authentication Required"

i have tried to setup osticket few times and i'm very sure that my admin username and password is correct but i still got error message "Authentication Required"

After browse and google around, i found one solution to enable me to login but i'm not sure what is the effact for this change.

go to scp/staff.inc.php, and find the line below

//1) is the user Logged in for real && is staff.
if(!is_object($thisuser) !$thisuser->getId() !$thisuser->isValid()){

comment out !$thisuser->isValid() and now become

if(!is_object($thisuser) !$thisuser->getId() /* !$thisuser->isValid()*/){

go to try again. it's working. Perhap, someone can tell me what is the issue and i'm not php expert. Not working on 15 Sep 2008

Update: 15 Sep 2008
No Luck. It only work for one day. Not sure what happen and now not working. I'll keep updating this post until get some solution or work around. I have to un comment previous changes.

Solution:
line 41 in scp\login.php, comment out @header("Location: $dest"); and try again.
// @header("Location: $dest");
it's work for me, at least for now.

Update: 21 Sep 2008
It's working fine since changes on 15 Sep 2008. SOLVED!

The user instance login flag is not supported on this version of SQL Server. The connection will be closed.

I have download an open source asp.net app. The database supported is SQL Express. When i try to run the app, error message [The user instance login flag is not supported on this version of SQL Server. The connection will be closed. ].

The reason is my installed database is full version of mssql 2005 and not express version. In order to make it run in my development machine, i have change the connectionstring in tag
<connectionstrings> from


<add name="TDConnectionString" connectionString="data source=.\SQLExpress;Integrated Security=SSPI;AttachDBFilename=DataDirectoryTD.mdf;User Instance=true"
providerName="System.Data.SqlClient" />

to


<add name="TDConnectionString"
connectionString="server=.\SQLSERVER2005;database=TD;uid=xxx;pwd=xxxxx"
providerName="System.Data.SqlClient" />

where ".\SQLSERVER2005" is my database server.

It's works now.

Call VBScript in Javascript

Well, it's actually working fine in IE but not other browser. As we all know, client side vbscript is microsoft product and it's only support in IE.

Try this,

<HTML>
<HEAD>

<SCRIPT LANGUAGE=vbscript>
Function vbFunc()
Msgbox("VBScript: Vb function")
End Function

</SCRIPT>

<SCRIPT LANGUAGE=javascript>

function jsFunc()
{
alert("Javascript: jsFunc function");
vbFunc();
}

</SCRIPT>

</HEAD>
<BODY onload="jsFunc()" >
</BODY>
</HTML>

Streamyx with D-Link 2640T Wireless ADSL Router

Just test on streamyx connection with D-Link 2640T Wireless ADSL Router.

For streamyx setting:

1. Open your internet browser and go to http://192.168.1.1/, default user name/password: admin/admin
2. Click on wizard to run the setting. Click next to begin.
3. 1st setting will be "Choose Time Zone", select the one relavent to your time zone. For me, i select [(GMT+08:00) Hong Kong,Perth,Singapore,Taipei] since there is no Kuala Lumpur. Click on Next.
4. 2nd setting will be "Select Internet Connection Type (WAN)". For streamyx i select PPPoE/PPPoA and click next.
5. 3rd setting is "Set PPPoE / PPPoA". For steamyx user, keyin your user name and password.
   User Name: xxx@streamyx
   Password: xxxxxxxx
   VPI: 0 ---- 8 wont work for me, the status is waiting for response if i choose VPI: 8
   VCI: 35
   Connection Type: PPPOE LLC
6. 4th setting is "Set Wireless LAN Connection". This is up to user to set on it. Read the menu correctly.
7. Save and restart your router. The status should be "connected" if you check the status tab.

Happy surfing!

Thank You

Thanks For your support!