Im just learning how to backup and recover Can you tell me where i went wrong?
for the first link is there one for sql 2005 instead? the first one is 2000
thanks satya, would you be able to show me an example in how to work it out?
hi i am also hoping to learn also how to insert constraints, set primary keys, foreign keys and references Would you be able to show me?
can you show me?
how would i create that?
I created a small database with the initial size of 2mb, i then altered it to 5mb I then use the stored procedure sp_helpdb to check the sizes of the...
can you show me an example of how to set the constraints in a table. please?
i created a table: Alter database db Add filegroup music Create table song ( song_id Int Not Null identity(1,1), album_id int Not Null,...
Thank you Satya! [:D]
thanks but i also like to know how to do the other method. thanks
the code was used: Alter database modify file ( name = filename = size = 5MB )
can you tell me more about the information_schema.tables view. Thanks
yes i have but i still dont really understand the reason for the increase.
how would i set the constraints on those. Thank you very much
I created a new database but initially the size of the database is 2mb but i altered it so that it increase the size to 5mb but when i used the...
hi i am trying to learn the purpose of this information_schema.tables view from my understand it shows a list of all the tables if i had create a new...
Separate names with a comma.