Tag Archives: Tip

View is not showing newly added column in table

Hi all,
This is for the people who still use “Select * From Table” in their SQL Views. I don’t know what is the reason that you are using this way to create your views, but you could be the victim of this scenario (see… what title says).

Let me show you how you can solve this issue… in-case you come across one.

When this happens??
You make changes in table which is the source of your view. Changes like modifying existing column definition, adding new columns or removing existing columns from table could cause this issue.

Where can I see this issue??
Check the meta-data of your table and view for comparison. (Tip: You can either use traditional method using SYS.OBJECTS joins SYS.COLUMNS or you can check using INFORMATION_SCHEMA.COLUMNS)

What is the solution?
There are different ways to circumvent this issue.

Read the rest of this entry »


Tags: , , , , ,

SSRS Report is asking for Username and Password while executing

Hi all,
I want to bring to your focus a very minor detail which could eat-up your time when it happens.

This is the case when your SSRS report is deployed on ReportServer and you are accessing thru any application or interface e.g. SharePoint. Your SSRS report is using Integrated Security and hence no need to provide Username and Password if you have access to the Report. And everything works fine up to this point.

After some days, if you notice that your SSRS Report is not working as expected and it has started asking for Username and Password while executing it. What could be the reason?

Read the rest of this entry »


Tags: , , , , , , ,

GodMode in Windows 7

Hi All,

If you have a Windows 7, then you can enable so-called “GodMode” to get access to most of the controls of operating system & other components.

You simply have to create a folder name with following words.
(Please exclude ” – double quotes while naming it). Ta-Da.

The folder icon will change to control panel icon and you will see the big list of items where you can easily search many controlling options just grouping by “Application” in details view. You can also collapse or expand all groups by right-click & selecting appropriate options.

Though it seems like a one-place-control-center for operating system components, but there are few options which you may not find in the list. Please check the control panel for more details.

Read the rest of this entry »

1 Comment

Posted by on February 21, 2012 in General, New Features


Tags: , ,