Bytes and Bites of Internet
Posts tagged Bug
Issue with Backup sets of Backup in SSMS 2012
Apr 19th
Just like many fellow early adopters, me too have installed shiny new SQL Server 2012 in my work machine. And I have been using it quite a while. Since it is “Powered by Visual Studio” now it has look and feel of VS 2010 too (for me main reason was included support of BIDS … or say SSDT ). As a go-to guy for SQL Server, I am responsible for maintaining all SQL Server instances .. and every now and then I have to play a role of DBA too.
Yesterday I ran into really strange issue. I have to restore a SQL Server 2008 R2 database to another machine with same edition. Since there were couple of devs around my desk to show off I fired up brand new SSMS 2012 (it feels really a bit nice when you have some toy to play with while others looking at you … just kidding). All I had to do was to restore database using GUI just to show them how they can do by them self. But with my surprise when I opened up restore screen for database and pointed it to my backup what I saw was really strange (add shocking and disappointing). In new SSMS 2012 you will not see list of all backup sets inside your backup !!! Instead of that you will have to use so called new feature “TIMELINE” by browsing my backups using some stupid date time picker !! And this is really confusing because now I have to guess which backup I have to use because this TIMELINE doesn’t tell me exactly what were the dates when I took backups
To explain this issue I have prepared process which can be used to reproduce this issue. Following steps will reproduce the issue,
And I have “4,294,967,295” messages in my inbox !!
Feb 27th
I have more then 4 billion messages in my inbox, and without doubt I will be record holder for “the most emailed a person ever” or “person with super giant mail box” or “person who does nothing but keeps getting (and reading) emails” …..and so on …..
Don’t believe me … here is the proof … a snapshot from my mail client
And say if each message is of minimal size, 1 KB then for all of these messages my local mail box will be of approximately 4TB in size !! (think of re-downloading all messages again if my PC dies ) .. Pretty cool right ??
Resolving … Agent XPs disabled issue in SQL Server 2005
Dec 27th
SQL Server sometimes behaves very strangely for no apparent reason. Few days back I was playing with our staging server and I had to stop SQL Server service for some testing purposes. When I started it back, I saw that SQL Server Agent was disabled and next to it a message showing that “Agent XPs disabled”
From my experience it generally means that SQL Server Agent service is not running. But looking at SQL Server Configuration Manager I found that service was just OK. But just to try, I restarted SQL Server Agent but I was still getting same message and disabled SQL Agent !!
After some googling I found that it is rather very common issue with SQL Server Agent !! Apparently sometimes for no reason, Agent XPs gets disabled in SQL Server environment. When I ran,
EXEC sp_configure 'Agent XPs'
Intellisense in SQL Server 2008 r2 management studio
Aug 15th
This quick post is about my recent experience with SSMS for SQL Server 2008 r2. Usually I use some other 3rd party tool for SQL Server Development because it is sort of more easier to use when we are developing (but that tool is not good at all when it comes to managing SQL Server).
If you are a developer like me who is required to work with application but mostly deals with database … and you happen to use SSMS for SQL Server 2008 R2 then you might already have noticed that you have … hmm.. sort of lost … intellisense in SSMS (or SQL Server Management Studio, a default tool for interaction with SQL Server) after installing Visual Studio 2010 SP1 updated. This is really weird issue. I / We generally when release an update for our application we make sure that for any reasons our other applications that are using that one application doesn’t lose some functionality. And I don’t understand how come guys at such a professional company like MSFT don’t understand this common app release / testing process ??
‘Delete ‘ with Alias in T-SQL
Jun 25th
Last week I was working on something where I was required to write a delete query against few records in table. Now a days I am kind of habituated to use alias for tables whenever I write any query (mostly because of tool I am we are using for SQL development, which don’t have intellisence if alias is not being used for table name !!) and in other case it was join between two tables was required to delete records. So as with other query, I wrote my simple delete query with alias … and found that when you use alias delete statement is a bit different !!! Below is how I reproduced same issue in my laptop. (Note: Query is using a test table I created using good ol’ AdventureWorks sample database)
-- Delete from table using Alias Delete from TableFoo TF where City='Renton' go
But parsing this query gave me following error
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ‘TF’.
Solving MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = ‘{8BDD006D-D5F0-4AAA-BA13-65995063EC44}’. Error code: 1608
Mar 9th
Today I got call from one of my friend for help in installing SQL Server 2008 R2. Apparently, he somehow cancelled the installation at very beginning of process for some reason and then every single attempt to install it again failed with really weird error. To resolve this problem, we removed registry entries leftover, removed any and every temp files and folders created by SQL Server installation but nothing helped. All the time we get this strange error,
MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = ‘{8BDD006D-D5F0-4AAA-BA13-65995063EC44}’. Error code: 1608
With little hope I fired up firefox and search google with this string. With little surprise, we were not the only ones who are getting this error. And there were numerous blogs and solutions about it. Though none seem to have explanation why we are getting this error but all seem to suggest one common solution.
All we needed to do is to reverse the GUID and simply search of it in registry. In our case it was D600DDB8 (just the first part), and we searched registry with that parameter and deleted all the entries we encountered (Ofcourse we took backup of registry before deleting anything as removing wrong entry could be fatal in Windows). I think we deleted about 2-3 entries and then restarted the installation.
Ajax Control Toolkit and IE 9 Runtime Error
Nov 29th
You guys may be thinking that what the hell is wrong with this guy. First he doesn’t write much and even if he write he always cries about errors he get while working on his things !!! Its always he , he and he … with error error and errors only … but fact is no matter how much I try to code well, I frequently get really really weird errors and being my log, I like to keep track of these errors in this blog.
Oki, so another error today. As you might know, I like to taste things before they release. Actually, I like that because it keeps me updated with new stuffs in technology of present time. So keeping that tradition alive, I had installed IE 9 Beta in my machine from few months now. Just today I was working / playing with my code as usual. actually it was an old program that I was rewriting to do some improvement in functionality. So, after making some changes I tried to run the program, but I got something like this as error Microsoft JScript runtime error: Invalid set operation on read-only property.
I tried to f9 the code and at one point it was showing some that it need some files from my AJAX Control toolkit (I was using many controls from AJAX Control toolkit). But I was not getting any idea what it is really missing. It was showing me error that we see when we are using component of AJAX Control Toolkit but not including Toolkit Script manager. But I have already included Toolkit Script manager into program, and that actually made me confused about error.