May 23, 2004 at 10:37 am
Hello people!
I have a problem again with my SQL Server..
Please help me, i am a big noobie..
I get this when i try to open a file that includes a connection to a MS SQL Server database;
Attempt to locate entry in Sysdatabases for database 'Test' by name failed - no entry found under that name. Make sure that name is entered properly.
Atra
atrinho.tk
May 24, 2004 at 12:05 am
Hi,
I find i get that error when i try to restore a database and network connectivity or power is cut to the server.(unfortunate but true, where i work).
I have found restarting the server it self (restarting ther SQL server services) helps to remove it and then i can restore it or remove it..I think there is a stored proc you can use to programmatically remove it/add it..Perhaps some one else here knows it..i will have a look for it soon..
Good luck !
------------------------------
Life is far too important to be taken seriously
May 24, 2004 at 1:08 am
did you drop and restore the db 'test' ?
If yes, check the user's default db.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 25, 2004 at 6:58 am
The sysdatabases table in the master database contains one row for each database you create. Use sp_helpdb to report information about databases. The syntax for this command is:
“sp_helpdb” if you want information about all databases, and if you want information for a specific database
“sp_helpdb @dbname” Where @dbname is the database name for which you want to get information. You must have permissions to access @dbname in order to execute sp_helpdb and also the guest user account must exist in the database.
Regards
May 25, 2004 at 7:02 am
okay, thank you very muche verybody, i will try it when i get home from school!
/atrinho
Atra
atrinho.tk
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply