Sunday, February 12, 2012

Can not specify file name for new database in sql 2005

Hi,
We installed Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23
2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Standard
Edition on Windows NT 5.2 (Build 3790: Service Pack 2). In management
studio, when I created a new database, I was able to change logical name,
initial size, path, etc., but the problem is with the File Name field. I
could not enter file name for either data or log. I clicked in it, the
background color changed to light blue with no cursor.
Anybody know why?
Thanks in advance,
BingNever mind. Looks like the File Name field doesn't expect any user input.
It defaults to whatever that's entered in the Database Name field. But in
sql 2000, database name doesn't have to be the same with the physical
database disk file name. Wonder why 2005 handles that differently?
Bing
"bing" wrote:

> Hi,
> We installed Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23
> 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Standard
> Edition on Windows NT 5.2 (Build 3790: Service Pack 2). In management
> studio, when I created a new database, I was able to change logical name,
> initial size, path, etc., but the problem is with the File Name field. I
> could not enter file name for either data or log. I clicked in it, the
> background color changed to light blue with no cursor.
> Anybody know why?
> Thanks in advance,
> Bing

No comments:

Post a Comment