The problem is that if you restore a sql server database on a different computer than the backup was created, you can have the problem that the usernames and permissions are somewhat lost.
Each username has an associated SID. So even though you might have a user named ‘Bill’ and the restore database might have a user named ‘Bill’, they will have different SIDs and so the permissions will not be applied to the correct user.
To fix this problem you can follow the following steps:
1) run this TSQL:
2) This will produce a table showing you Users that having issues.
3) run the following TSQL:
sp_change_users_login 'update_one', 'UserNameFromStep2Table','NameOfUserToUse'
In many cases the 2nd and 3rd parameters will be the same string.
More about this SP can be found here: http://doc.ddart.net/mssql/sql70/sp_ca-cz_4.htm
Slashdot recently posted a question from a user asking what the best free anti virus options are.
The response can be seen here:
I am getting a little sick of this.
Starting with a few days ago I started getting a lot of these errors. Mostly in IE, but also in VS.Net.
Looking at the details of the error I see it is coming from mytilus.dll, which is a DLL used by VirusScan 8. I have patch 11, which I guess is up to date. I will be keeping an eye on it.
Recently Microsoft lost a patent judgement, which resulted in them pushing down an “update” to IE that forces you to click on any embedded object to “activate” it.
Embedded objects can be flash movies, video clips, audio, etc.
This is really bad for sites that use flash. Things like navigation and rollovers don’t work until you first click on them.
This article talks about the work around, and how you can incorporate this into your ASP.NET projects.
This article is pretty interesting, as it discusses 5 xhtml elements that most people don’t know about or use.
Surrey Kent Orkney
C# C++ Java ASP.NET PHP
2) label (click the “Full Name”)
Full Name Gender: Male Female
CommentsCP is a good place to publish XHTML related articles.
www.google.com can search
Personal InformationFull Name Gender: Male Female
4) col/colgroup (notice the control over col widths)
5) Acronym (mouse over xhtml)
CP is a good place to publish XHTML related articles.
These are not widely known but very useful.
Almost all of my friends have IPods, but I have held off.
There are a number of reasons why:
1) ITunes: It sucks. I hate it. My current MP3 player simply allows you to drag and drop the files you want onto your MP3 player. No syncing, no problems.
2) User interface. I know a lot of people think the wheel is really cool, but I think it overly involves the user. Tell me what is wrong with up/down buttons before you redesign the interface to use a wheel.
3) Batteries. As noted at http://www.ipodsdirtysecret.com/. The battery in an IPod can not be removed, and some say they start to fail after 18 months.
Well I came across a site called http://www.idont.com/, which went live today (before today it had some anti-ipod message up there).
Turns out it is a site for the new SanDisk MP3 player.
The e200 (really catchy name… not) looks pretty cool, and might be worth me looking into more: http://www.anythingbutipod.com/archives/2006/03/sandisk-sansa-e200-series-review.php
This weekend I went to see a band called Secret Machines, or The Secret Machines. They seem to split the naming thing about 50/50 between using the “The” and not using it.
Anyway, they were playing a show at midnight at the Metro, which was kinda cool. There was no opening band, so we got in around midnight and they came on around 12:20 or so. I hate waiting hours for a band to come on stage, so that was as big plus.
It was crowded in there, but not too croweded. When I saw 311 in the same place it was insane. They couldn’t have packed more people in there if they wanted to.
Secret Machines played most of the songs I know: they only have 3 CDs. And, they did this cool thing at the end of the show they setup their guitar in some kind of loop and left it on stage with the strobe lights and fog machines going full blast as they exited the stage. The loop continued for another 20 seconds or so before snapping off and the lights for the venue came on. Pretty cool!
Microsoft has released LINQ CTP.
While it is not expected that this will become fully released until the next version of Visual Studio (2008?) it is not something bad to look at now.
This article from MSDN talks about custom databinding, but specifically it talks about the issues raised when you are trying to databind a custom collection to a datagridview.
Using a List<T> will work, but when all is said and done you lose some nice features such as sorting.
There are not many good examples of how to do stuff like this. So the article below was all the more helpful when I was building a somewhat complex report.