Ok we r talking too much abt the drawer

this is exactly my scenario,

each product(in this case verticals(Package,hotel,Cars)) had different attributes so this should be treated as different...

Normalization defines a set of methods to break down tables to their constituent parts until each table represents one and only one "thing", and its columns serve to fully describe...

I think 2 nd approach is not good...it is not a normalized structure

For eg: Consider a table having different drawers we can arrange the file related to verticals in their...

thank you very much this is exactly i wanted

i am facing the same issue, i want to give user to read the procedure but there is lock(picture) on the stored procedure. I had given the user read and...

thanks Brandie

As i mention i am planning to design a DB for B2C Travel project.So before starting developing i wanted to know the various design issues.

As you mention there will...

thanks for the reply

that means Even if i use different filegroups there is no improvement in DB performance if I don't use different physical disk drive right.

Is there any...

the server is in SQL Server and Window Authentication Mode Since the DB is accesed by NT AUTHORITY\SYSTEM which is in built login...to check the connection i used Window authentication...

thanks Lowell for the hint ...Linked server

Finally solved that problem by dropping the Database trigger which report the changes made in the 2008 DB to the 2005 DB ..which...

created the LOGIN 'test' through this process

1.under instance clicked the SECURITY tab

2.LOGINS ---New Logins --> open the pop up Window---> Give the Login name test and password test(SQL...

thnks for the reply

obviously i created the login first and then created the user

Still this error is coming

thanks Sharath this is exactly i wanted.

Thanks for the reply, i think i should go with seperate DB. I have one static DB which contain millions of data which don't changes fequently. In terms of DB...

How to configure this

thanks for the reply..the connection string is same