A
AAaron123
I tried an SQL NG but maybe this NG is more relavent.
I look at the DB names in a User Instance and I see the system names and
two DBs are named like:
I:\MY DOCUMENTS\VISUAL STUDIO
2008\WEBSITES\TEST\APP_DATA\NEWSANDEVENTSDB.MDF
and one that is named simply:
PhotosDB
Everything is working but I wonder at the difference in the name patterns.
Can you explain why the names might by as they are?
I'm not sure how the two DBs were created.
There were three but I inadvertingly deleted PhotosDB.
And then recreated it. So I did name that one.
As to the names of the other two I know I read someplace (but can't remember
where) about SQL Express and such names.
So I think it's an SQL Express or maybe it's an ASP.Net thing.
Thanks
PS
In researching I found the following but don't know if ASP.Net is doing
something like that:
Attaching a database to a User Instance as you are doing here creates what
we call an Autonamed database unless you specify a specific name. Exactly
what the name is depends upon exacty how and where it is being attached. In
this case, SSEUtil give the database a name that is the same as the path to
the mdf file. Your test script must specify the name of the database it is
acting on, and because of autoname, your database is named something like
C:\foo\bar\test.mdf.
If you had done this:
Your script would have only had to specify something like
USE test
GO
SELECT * FROM Employees
GO
I look at the DB names in a User Instance and I see the system names and
two DBs are named like:
I:\MY DOCUMENTS\VISUAL STUDIO
2008\WEBSITES\TEST\APP_DATA\NEWSANDEVENTSDB.MDF
and one that is named simply:
PhotosDB
Everything is working but I wonder at the difference in the name patterns.
Can you explain why the names might by as they are?
I'm not sure how the two DBs were created.
There were three but I inadvertingly deleted PhotosDB.
And then recreated it. So I did name that one.
As to the names of the other two I know I read someplace (but can't remember
where) about SQL Express and such names.
So I think it's an SQL Express or maybe it's an ASP.Net thing.
Thanks
PS
In researching I found the following but don't know if ASP.Net is doing
something like that:
Attaching a database to a User Instance as you are doing here creates what
we call an Autonamed database unless you specify a specific name. Exactly
what the name is depends upon exacty how and where it is being attached. In
this case, SSEUtil give the database a name that is the same as the path to
the mdf file. Your test script must specify the name of the database it is
acting on, and because of autoname, your database is named something like
C:\foo\bar\test.mdf.
If you had done this:
Your script would have only had to specify something like
USE test
GO
SELECT * FROM Employees
GO