4.0 Creating a Simple Table in SQL Server 2005 Express

[ahsan4646]

thanks



[woofwoofbone]

Can i create a database for my records and keep them on this database?

I think this may be useful for me because i have a bunch of old records and like to record my titles and other data so i dont have to go in the crates.

Would you recommend another database? 2010?

I think this will be extra work but might be worth it.

[Firchild]

@woofwoofbone I'd use Access

[zingzongzingerling]

Great video. Is there a way of making the primary key like an autonumber so you don't have to keep entering the ID? (Like you can in Access) cheers

[Firchild]

@zingzongzingerling Erm, not sure, I stopped using SQL Server, as I found it twitchy and moved on to MySQL. Sorry!

[tatamisoftware]

Excellent video. Thank you!

[2oPTiK09]

If anyone can help, every time I try to create a click on OK to create the table i get an error message that says:

"An exception occurred while executing an Transact-SQL statement or batch (microsoft.Sqlserver.express.c­onnectioninfo)

Create database permission denied in database 'master' (microsoft sql server.error:262)

Please help me. =]

[punxz18]

Thank you!!

[shenlazarus]

You have SQL Server Express, but you use a tool to access the database. Is SQL Server Management Studio Express? Is it included with SQL Server Express?

Thanks

[Firchild]

Ah, I understand! Yes I'm using Management Studio 2005 Express

[Firchild]

and the net framework version 2

[shenlazarus]

Which tool do you use?