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
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:
( name =
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
from my understand it shows a list of all the tables
if i had create a new...
Separate names with a comma.