-
MsSQL Server
Hi.
Maybe someone here can help me. I'm running a MsSQL server on my computer. Everytime I restart the computer the tables I create and users I add disapear, but the database I create remains. I'm creating tables with Enterpise Manager. After I add columns I click on save specify the name and click ok.
Any idea what's going on?
Thx.
-
What OS are you using this on? What type of authentication are you using to log into Sql Server? What account are you using to create tables? Same account you used to create the database?
I have never run across this problem but it sounds like a permissions problem of some type.
-
Lets see I tried on XP Pro, 2000 Pro. When Creating tables with Enterprise manager it doesn't ask for the password.
Ok. Just for the heck of it yesterday I ran the database creation wizard and for that DB it did save the tables. Will try the same thing on my laptop see what will happen.
Before I just right clicked on the instance of a server and selected New database.
-
Well, that would explain quite a bit. Tables can only be created inside existing databases. And, depending on the version of Sql Server you are using, it may not be possible to install it correctly on a non-server OS. SQL Server 2000 Enterprise Edition and Standard Edition will only install on server OS's.