Monthly Archives: July 2010

Changing SQL Database Schema to DBO

Dear All

When we create any table / Stored Procedure / Views or any object in SQL Server default that object gets schema name of that database

 

e.g.

Database Name :-abcd

DB owner user :- xyz

DB schema :- xyz

 

A database schema is a collection of meta-data that describes the relations in a database. A schema can be simply described as the “layout” of a database or the blueprint that outlines the way data is organized into tables. Schema are normally described using Structured Query Language as a series of CREATE statements that may be used to replicate the schema in a new database.

When we are creating a new Stored procedure e.g.

Create proc sample as

Begin

TSQL Statements

End

After this statement the procedure will be seen as

Xyz.sample where xyz is the schema name of that database.

 

Here the issue is that while executing the stored procedure it will throw error as the default schema is not dbo, to change the database schema
from xyz to dbo we need to do following steps.

 

Open SQL Server Management Studio à Expand Security à right click on User , select Properties à click on User Mapping

 

If you observe on the right top corner it is showing the database schema “Guest” and to access the objects created by this user afterwards the default schema should be DBO and to do it so click on right corner button in the default schema column ( here beside guest ) , it will open following screen

Click on browse button and select DBO from the list

And click on OK button .

After this any object created by the user xyz will be accessed with dbo schema J

 

 

Thanks

 

Prashant Deshpande

 

 

Advertisements

Leave a comment

Filed under Uncategorized

content uploading settings in Web.config

Dear All

There was issue of content uploading on one of our web portal and I got call for it, so I checked Event viewer which shown the following error .

 

 

To resolve the uploading issue this event has given clue to add runtime tag in web.config so added following line in web.config

 

<httpRuntime executionTimeout=”300″ maxRequestLength=”51200″/> ( 51200 is the kB size)

and then tried to re-upload the content and it has successfully got uploaded.

 

Thanks

 

Prashant Deshpande

 

 

Leave a comment

Filed under Uncategorized

IIS 7.5 redirection.config Issue

Dear All,

On one of server ( VM ) follwoing error occured and website was not working on it.

and after providing credintials it was not accepting , due to which IIS was not responding.so to trubleshoot the issue I used following steps .

  1. Tried to restart the application pool using following command


    C:\Windows\System32\inetsrv\appcmd.exe start apppool fyjc

    which has given following error

ERROR ( message:The WAS service is not available – try starting the service first. )”

  1. Come to know that WAS service is not working so tried to start Windows Process Activation Service through Services.msc but it didin’t get started
  2. so tried following command


    C:\Windows\System32\inetsrv\appcmd.exe wp

    To get the list of running Worker process which has taken me near the solution , it has given following error

     

    ” Exception Details: System.UnauthorizedAccessException: Filename:
    redirection.config
    Error: Cannot read configuration file due to insufficient permissions “

     

  3. Opened the file redirection.config from c:\windows\system32\inetsrv and after reading the contents of the file came to know that it is using settings from other server so deleted the below line from file

    <configurationRedirection enabled=”true”path=”\\10.10.10.60\Centralconfig$userName=”configuser1″ password=”[enc:IISRsaProvider:57686f6120447564652c2049495320526f636b73:enc]” />

  4. Saved the file redirection.config.
    The contents of redirection.config file should be as below 

    <configuration>

    <configSections>
        <section name=”configurationRedirection” />
    </configSections>

    <configProtectedData>
        <providers>
            <add name=”IISRsaProvider” type=”” description=”Uses RsaCryptoServiceProvider to encrypt and decrypt” keyContainerName=”iisConfigurationKey” cspProviderName=”” useMachineContainer=”true” useOAEP=”false” />
        </providers>
    </configProtectedData>

    <configurationRedirection />

</configuration>

      1   Tried to restart IIS
      2    Then browsed the site
      3    It Worked J
    

Found the cause of the error :- This error has occured because once we have tried for shared configuration in IIS 7.5 , which is recommaneded by Microsoft for WebFarn environment , but after testing we have removed the shared configuration from server mean while the image of server is replicated accross some of the web servers due to which the error occured.

Thanks

 

Prashant Deshpande

Leave a comment

Filed under Uncategorized

Google Offers Typing Tool for Indian Languages

Dear All

I found a nice article which I would like to share with you.

Transliteration is an interesting technology that helps people compose documents, emails or even chat in Indian languages (including Arabic) using the English (Roman) keyboard.

Google has long offered Indic transliteration tools in products like Gmail, Blogger, Orkut, etc. and then there are BookMarklets that you may use to type text in Indian languages on any non-Google website. The only downside is that you need a live internet connection for transliteration to work in real-time.


Well, not anymore because Google has just released a free transliteration utility for Windows that can work offline as well.

Called Google Transliteration IME, you may install this tool on any XP/Vista or Windows 7 computer to write text in most Indian languages including Hindi, Tamil, Bengali, Farsi (Persian), Greek, Gujarati, Kannada, Malayalam, Marathi, Nepali, Punjabi, Telugu and Urdu. The tool also works with the Arabic language.

Other than offline access, the other advantage offered by this Google Transliteration tool is that it has its own “memory.” For example, if the spelling of an Indic word has multiple versions, the tool will automatically remember the spelling you selected before and will offer it as a first choice the next time you type the same combination of Roman characters.

To enable the Google Keyboard, you need to go to Control Panel -> Regional and Language Options -> Keyboard and Languages and change the keyboard to “Google Input” (see screenshot).


Once you have changed the input keyboard to Google, open any Windows application (say notepad) and start typing a word just the way it sounds in your language using English letters. You may also use the onscreen virtual keyboard to type complex words that cannot be formed using the Roman keyboard.

You use the F12 keyboard shortcut to switch between English and the Indic language without having to turn off the Google IME tool.

 

Thanks

Prashant Deshpande


 

2 Comments

Filed under Uncategorized

SQL server Schema Permissions

 

Dear All

While using one Application following error was getting thrown in Event log and application was not giving the proper results in browser.

” Message Error Message :The SELECT permission was denied on the object ‘xobject’, database ‘xxxxx’, schema ‘dbo’.”

By looking error any one guess that some issue with user permissions , but it was not like that schema is different and users are different in SQL server.

So done following steps to overcome the issue

Use xxxx ( database name )

grant select on dbo. xobject to public ( xobject is the name of table / view)

 
 

 

Thanks

Prashant Deshpande

 

 

 

 

Leave a comment

Filed under Uncategorized