Actually we need to set up databases for our clients in which, the db name should be the clients name.

So instead of creating a new db everytime and changing the...

How can i give view permission?

Thanks all...

I managed to do with the same. I have logged in as emptestuser

Now for emptest db, in Security-logins I have the emptestuser created under this database.

And the same emptestuser...

Thanks all....

My database name is Serv and I have 150 tables and 200 procedures...

How would i give it in this query...

Can u please make me clear

Yes I tried...but that is not working. I'm getting the same error

GMBAR,BARBIL,ODISHA REGION

GMBBS,BHUBANESWAR,ODISHA REGION

GMBEL,BELLARY,SOUTH REGION

GMBHU,BHUJ,GUJARAT

GMKND,KANDLA(SEZ),GUJARAT (SPECIAL ECONOMIC ZONE)

GMHYD,HYDERABAD,SOUTH REGION

GMKOD,KODURU,SOUTH REGION

GMKOL,KOLKATA,EAST REGION

GMMGG,MANDIGOBINDGARAH,NORTH REGION

This is my branch data which is a .csv...

Thanks for ur reply

but i wanted to import using bcp instead of bulk insert...

The date which i give as '10-Aug-2010' is converted and stored in the table as '2010-08-10'

but i want the date to be stored as '10/08/2010'

I tried with your it...

I need to convert dt_of_birth [varchar] (15) which is in the format DD-Mon-YYYY to DD/MM/YYYY

So how do i give this in the stored procedure?

Thanks a lot...

I got it right..

Here in this procedure i have a problem with date formats. In my data the format is DD-MM-YYYY (13-Aug-1951)

I should declare in my temp table...

Thanks a lot Igor....

And here in the script the values are hardcoded.

How can i fetch the values from temp table and then so the splitting?