This is one of the most usefull sp's ever!

The problem is that the user in the database is an "orphan". This means that there is no login id or password associated with the user. This is true even if there is a login id that matches the user, since there is a GUID (called a SID in Microsoft-speak) that has to match as well.

This used to be a pain to fix, but currently (SQL Server 2000, SP3) there is a stored procedure that does the heavy lifting.

All of these instructions should be done as a database admin, with the restored database selected.

First, make sure that this is the problem. This will lists the orphaned users:

    EXEC sp_change_users_login 'Report'

If you already have a login id and password for this user, fix it by doing:

    EXEC sp_change_users_login 'Auto_Fix', 'user'

If you want to create a new login id and password for this user, fix it by doing:

    EXEC sp_change_users_login 'Auto_Fix', 'user', 'login', 'password'

Loving the new Batman films and went to see the most recent incarnation at the Glasgow Imax on Saturday, Film was outstanding, I would give it an IMDB rating of 7.8 which for those not in the know is very good.

If you’re wondering what IMDB (The Internet Movie Database) is you're missing out, if you consider yourself any kind of film fan you gotta get into this site I value its ratings on films more than any other site/magazine/newspaper with the possible exception of the Le "Metro"!

I digress, Dark Knight was tops although i felt the number of shots filmed using IMAX technology did not justify it being shown on that format and you would be as well going to a normal cinema or alternatively you buy the Blu-ray and see it in all its glory.

You can pre order from play.com here. 

Batman: The Dark Knight (w/ Play.com Exclusive Art Cards) (2 Discs) (Blu-ray) - £14.99 FREE Delivery!
RRP: £27.99
Save: £13.00 (46%)
Customer rating: 4.5 out of 5 stars ( 62 customer ratings )
Due for release on 08/12/2008 

If like me your are slightly (read worringly) obsessed with everything being in its place and have come across the rules function within outlook, you will love this little tip...

Is there a way to set up a rule so that all emails from a specific server (example ventil8.com) go into a specific folder? Well yes there is!

1. Begin creating the rule. Type the domain portion of the address in the Address field.  In Outlook 2003 and 2007, it's the From field at the bottom of the dialog; in   Outlook 2002, Outlook98/2000 Corporate, type the domain in the right pane. (The address dialog in Outlook 98/2000 in Internet mode doesn't support entering partial addresses.) 
2. Click Ok after entering the domain in the address field, then Cancel the Check Names dialog when it appears.
   

Run your rule and hey presto!

This game takes me back to my students days when we spent our student loan on brand new PS1, Wipeout and a surround sound system, and spent the best part of 48 hours playing it to death, brilliant!

The new High Def verison came out last week and is availble for only 11.99!! bargin, if you ask me and one of the better PS3 games out at the moment, only availble on the PS store but for all your "offline" game purchase i think play.com is the cheapest bar none, and you free delivery. Nuff said.

Click here for more info.

 

Ok here is the situation, one which many of you may have experienced.  I have a live SQL DB and my development SQL DB; I've got the nod from the client for a new site which will be essentially a re-skin of an existing site, including its DB.
So I have downloaded the latest version of it's backup file (lets call it databaseSkin1.BAK) from the live server and I'm going to do a restore onto my new SQL 2005 express, I’ve broken the steps required to complete the process.

1. Create a new Database with my development SQL Express DB, lets call it databaseSkin2
2. Right click my new database and select TASKS > RESTORE > Database
3. Specify from device and select the folder in which you placed you databaseSkin1.BAK file
   

This is where i ran into issues, SQL told me that the file was not accessible, which is very strange as it was reading it straight from the drive.  This initially led me to the following article http://support.microsoft.com/kb/827452 which i thought was a little heavy handed and to be honest i could not be bothered going through the whole process of downloading the fix and waiting for an email from Microsoft etc etc.

So i kept searching where i found this post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=169145&SiteID=1, now this did not work for me like it did for "wilsonjan" but it got me thinking that it must be permission based issue.  So in order to get this to work I had to find the databaseSkin1.BAK file on the hard drive right click and select SECURITY then add the Network service user and give that user full access rights to the databaseSkin1.BAK file. 

To satisfy my curiosity and to see how this process would behave in SQL 2000 i also attempted to restore this same databaseSkin1.BAK file to my SQL 2000 instance. In this scenario  I already had a database called databaseSkin1 on the sever and when i attempted to create a new DB called databaseSkin2 by restoring from the backup file databaseSkin1.BAK we will always get the error that the file already exists even if you have selected the "force restore over existing database". The only way to get to do this is to rename the following during the restore process, in the options tab:

• databaseSkin1_Data to databaseSkin2_Data
• databaseSkin1_Log to databaseSkin2_Log

By default these will be named as per the BAK file you are using.

Hope all of the above made sense?!

I've done all the research and opted for one and one for my hosting and i'm impressed.  I've used fasthosts and a few others and one and one offers the best bang for buck in my honest opinion.

I will try to do a pros and cons over the next few days.

 

I rarely buy books, I'm always given them as presents or someone will recommend them and follow that up with an offer to loan me a copy. Why is that?  Why is it that whenever you read a good book you want to spread the word, you want other people to have the same experience and emotions that the book gave you.

Who knows but here is my recommendation to you "I Know This Much Is True" by Wally Lamb, had me hooked a few years ago on a Greek island backpacking holiday (my best holiday to date) and i believe it made it onto Oprah's Book Club.

Best place to get it is Borders or get a loan, my copy is currently out and has been for about 5 years!!

 

I dont always watch Golf on TV but you can't beat the ryder cup even if it looks like were going to lose, been watching that and the Man U Chelsea game via ustream.tv, impressed with the quality.

 

 

Been trying to install this all night and keep having to make room on my C drive even though i'm installing it on my healthy H drive why on earth it still needs 1 GB on C i dont know..

Well i have finally done it,  i've gone and set myself up a wee blog...dont cha just love it!now i just need to say something interesting at regular intervals...and try to spell correctly! eek!!