Database name keeps on Disapearing from SQL SMS
-
I'm fed up of my Ms SQL databases keeps on Disapearing from SMS ,and then keeps on coming back ..it is really frustrating ,is there any other database similar to ms sql which does not have any problem like this?
Well thats a new one, I have never heard this complaint about SSMS before, I suspect it is your environment rather than SSMS.
Never underestimate the power of human stupidity RAH
-
Well thats a new one, I have never heard this complaint about SSMS before, I suspect it is your environment rather than SSMS.
Never underestimate the power of human stupidity RAH
-
I'm fed up of my Ms SQL databases keeps on Disapearing from SMS ,and then keeps on coming back ..it is really frustrating ,is there any other database similar to ms sql which does not have any problem like this?
chdboy wrote:
I'm fed up of my Ms SQL databases keeps on Disapearing from SMS [..],is there any other database similar to ms sql which does not have any problem like this?
The IDE and the Database server are two distinctly different applications. What is dissapearing exactly? The alias as defined in SMS, the database (how? is it simply not visisble in the IDE, or is the actual physical file gone?) MSAccess doesn't have this problem, but that's hardly a good replacement for Sql Server. Switching db-server will have more impact than simply a different IDE. FWIW, you can always download and use another IDE if you dislike SMS.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
I'm fed up of my Ms SQL databases keeps on Disapearing from SMS ,and then keeps on coming back ..it is really frustrating ,is there any other database similar to ms sql which does not have any problem like this?
Are you using a SQL Express User Instance[^] (
AttachDBFilenamein your connection string)? These databases will automatically be closed and removed after a period of inactivity, which is why you can't see them in SQL Server Management Studio.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
