Showing posts with label website. Show all posts
Showing posts with label website. Show all posts

Wednesday, March 28, 2012

New to MS-SQL

Where is a good website to help me get started using MS-SQL Server?

I have it all set up and just need to read some tutorials on importing
already exsisting tables in Access and Excel.

I am also looking for tutorials on linking the SQL to an Intranet
within the local network for internal employee access.

Thanks in advance,

LynnLynn

There are lots of very good SQL Server sites on the net. The problem
you will find is that most of the content assumes a certain level of
Knowledge of SQL Server, which you might not have yet. Having said that
quite a few of them do have entry level articles which may help you.
Some of the sites I use include.

http://www.sql-server-performance.com/
http://www.sqlteam.com/
http://www.bitpipe.com/rlist/term/S...l?src=google_ct
http://www.1sqlstreet.com/vb/default.asp?lngWId=5
http://www.sqlservercentral.com/
http://www.dbazine.com/

Hope these help

regards

John

LLively2 wrote:
> Where is a good website to help me get started using MS-SQL Server?
> I have it all set up and just need to read some tutorials on importing
> already exsisting tables in Access and Excel.
> I am also looking for tutorials on linking the SQL to an Intranet
> within the local network for internal employee access.
> Thanks in advance,
> Lynn

Monday, February 20, 2012

New database from backup

I am going to build a new website and I have all the data in a sql-backup file - and I have a new installation of SQL Server - how do I install it? I try to use Restore database from SQL Server Manager, but I just get the errors (I think because of that I do not have the database in the server).

I am totally beginner with SQL Server - so coudl anyone help me?

What errors are you getting, exactly?

If you want to restore the database on a second machine (instead of the one where the backup was made), you probably need to modify the path where the files will be stored. On the restore database dialog, go to the second tab and check the file names. (This is in SQL 2000 Enterprise Manager, the dialog may look different on the 2005 version).|||Thanks.
You made my day.