Windows 2000 Server SP4 + SQL Server 2000 Enterprise Editon SP3,RAID5.
the windows event log give the following error information:
I/O error 2(The system cannot find the file specified) detected during write at offset 0x0000010c6c4000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\GJSZBANK_Data.MDF'.
I have searched microsoft knowledge base and got this article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;828339
but don't understand some contents in the topic:
For example, if you encounter the following error message in the SQL Server Errorlog file, SQL Server encountered operating system error 2 when it uses a Windows API call to write to the tempdb primary database file:
Error: 823, Severity: 24, State: 4
I/O error 2(The system cannot find the file specified.) detected during write at offset 0x00000000284000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf'
Because SQL Server has already successfully opened the file and did not receive an Invalid Handle error, the error is likely being raised in a lower-level kernel software component, such as the file system or a device driver. This problem does not indicate a problem in SQL Server, and it must be investigated as an issue with the file system or a device driver that is associated with the file.
Does that mean this is not a SQL Server error?
Does that mean something wrong with my operating system? or something wrong with my hard disk?Are there any errors in the SQL errorlog? Or is it only in the NT Event log?
Showing posts with label editon. Show all posts
Showing posts with label editon. Show all posts
Friday, February 24, 2012
Saturday, February 11, 2012
@@version, add database to a named instance?
Hi,
I have a sql 2000 personal editon(default server) and developer edition
(named) installed on a machine (windowsXP).
1) if I do 'select @.@.version' in query, I always get 'personal edition'
version information back. How can I get the version nformation of developer
edition?
2)How do I use Enterprise Manager to create a database with developer editon
server instance?
THANKS!
It tells you the version of the server you are connecting to. If you want
the version of developer edition you need to connect to it first.
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:977874AC-FC88-4DB2-9AA2-76095F35BABF@.microsoft.com...
> Hi,
> I have a sql 2000 personal editon(default server) and developer edition
> (named) installed on a machine (windowsXP).
> 1) if I do 'select @.@.version' in query, I always get 'personal edition'
> version information back. How can I get the version nformation of
> developer
> edition?
> 2)How do I use Enterprise Manager to create a database with developer
> editon
> server instance?
> THANKS!
|||"ME",
I couldn't find a way to 'connect' to the server instance of developer
edition in the sql enterprise maganer. Hope you can help me on this. Thanks
!!
"ME" wrote:
> It tells you the version of the server you are connecting to. If you want
> the version of developer edition you need to connect to it first.
>
> "bangwo" <bangwo@.discussions.microsoft.com> wrote in message
> news:977874AC-FC88-4DB2-9AA2-76095F35BABF@.microsoft.com...
>
>
|||well, if you open Server Network Utility you should see the instance name of
your SQL Edition server. Use that instance name to connect ...
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:AB497B9C-D604-4F46-B65C-F898D5D99359@.microsoft.com...[vbcol=seagreen]
> "ME",
> I couldn't find a way to 'connect' to the server instance of developer
> edition in the sql enterprise maganer. Hope you can help me on this.
> Thanks
> !!
> "ME" wrote:
|||Hello,
Go to the SQL Server log of the SQL Server Developer edition installation
(C:\program files\Microsoft SQL Server\Logs\ folder).
In the error log the name of the SQL Server installation will be shown. You
could use that information to either register to Enterprise manager or
connect to Query Analyzer. After that you could execute SELECT @.@.Version.
Thanks
hari
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:AB497B9C-D604-4F46-B65C-F898D5D99359@.microsoft.com...[vbcol=seagreen]
> "ME",
> I couldn't find a way to 'connect' to the server instance of developer
> edition in the sql enterprise maganer. Hope you can help me on this.
> Thanks
> !!
> "ME" wrote:
I have a sql 2000 personal editon(default server) and developer edition
(named) installed on a machine (windowsXP).
1) if I do 'select @.@.version' in query, I always get 'personal edition'
version information back. How can I get the version nformation of developer
edition?
2)How do I use Enterprise Manager to create a database with developer editon
server instance?
THANKS!
It tells you the version of the server you are connecting to. If you want
the version of developer edition you need to connect to it first.
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:977874AC-FC88-4DB2-9AA2-76095F35BABF@.microsoft.com...
> Hi,
> I have a sql 2000 personal editon(default server) and developer edition
> (named) installed on a machine (windowsXP).
> 1) if I do 'select @.@.version' in query, I always get 'personal edition'
> version information back. How can I get the version nformation of
> developer
> edition?
> 2)How do I use Enterprise Manager to create a database with developer
> editon
> server instance?
> THANKS!
|||"ME",
I couldn't find a way to 'connect' to the server instance of developer
edition in the sql enterprise maganer. Hope you can help me on this. Thanks
!!
"ME" wrote:
> It tells you the version of the server you are connecting to. If you want
> the version of developer edition you need to connect to it first.
>
> "bangwo" <bangwo@.discussions.microsoft.com> wrote in message
> news:977874AC-FC88-4DB2-9AA2-76095F35BABF@.microsoft.com...
>
>
|||well, if you open Server Network Utility you should see the instance name of
your SQL Edition server. Use that instance name to connect ...
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:AB497B9C-D604-4F46-B65C-F898D5D99359@.microsoft.com...[vbcol=seagreen]
> "ME",
> I couldn't find a way to 'connect' to the server instance of developer
> edition in the sql enterprise maganer. Hope you can help me on this.
> Thanks
> !!
> "ME" wrote:
|||Hello,
Go to the SQL Server log of the SQL Server Developer edition installation
(C:\program files\Microsoft SQL Server\Logs\ folder).
In the error log the name of the SQL Server installation will be shown. You
could use that information to either register to Enterprise manager or
connect to Query Analyzer. After that you could execute SELECT @.@.Version.
Thanks
hari
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:AB497B9C-D604-4F46-B65C-F898D5D99359@.microsoft.com...[vbcol=seagreen]
> "ME",
> I couldn't find a way to 'connect' to the server instance of developer
> edition in the sql enterprise maganer. Hope you can help me on this.
> Thanks
> !!
> "ME" wrote:
@@version, add database to a named instance?
Hi,
I have a sql 2000 personal editon(default server) and developer edition
(named) installed on a machine (windowsXP).
1) if I do 'select @.@.version' in query, I always get 'personal edition'
version information back. How can I get the version nformation of developer
edition?
2)How do I use Enterprise Manager to create a database with developer editon
server instance?
THANKS!It tells you the version of the server you are connecting to. If you want
the version of developer edition you need to connect to it first.
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:977874AC-FC88-4DB2-9AA2-76095F35BABF@.microsoft.com...
> Hi,
> I have a sql 2000 personal editon(default server) and developer edition
> (named) installed on a machine (windowsXP).
> 1) if I do 'select @.@.version' in query, I always get 'personal edition'
> version information back. How can I get the version nformation of
> developer
> edition?
> 2)How do I use Enterprise Manager to create a database with developer
> editon
> server instance?
> THANKS!|||"ME",
I couldn't find a way to 'connect' to the server instance of developer
edition in the sql enterprise maganer. Hope you can help me on this. Thanks
!!
"ME" wrote:
> It tells you the version of the server you are connecting to. If you want
> the version of developer edition you need to connect to it first.
>
> "bangwo" <bangwo@.discussions.microsoft.com> wrote in message
> news:977874AC-FC88-4DB2-9AA2-76095F35BABF@.microsoft.com...
>
>|||well, if you open Server Network Utility you should see the instance name of
your SQL Edition server. Use that instance name to connect ...
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:AB497B9C-D604-4F46-B65C-F898D5D99359@.microsoft.com...[vbcol=seagreen]
> "ME",
> I couldn't find a way to 'connect' to the server instance of developer
> edition in the sql enterprise maganer. Hope you can help me on this.
> Thanks
> !!
> "ME" wrote:
>|||Hello,
Go to the SQL Server log of the SQL Server Developer edition installation
(C:\program files\Microsoft SQL Server\Logs\ folder).
In the error log the name of the SQL Server installation will be shown. You
could use that information to either register to Enterprise manager or
connect to Query Analyzer. After that you could execute SELECT @.@.Version.
Thanks
hari
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:AB497B9C-D604-4F46-B65C-F898D5D99359@.microsoft.com...[vbcol=seagreen]
> "ME",
> I couldn't find a way to 'connect' to the server instance of developer
> edition in the sql enterprise maganer. Hope you can help me on this.
> Thanks
> !!
> "ME" wrote:
>
I have a sql 2000 personal editon(default server) and developer edition
(named) installed on a machine (windowsXP).
1) if I do 'select @.@.version' in query, I always get 'personal edition'
version information back. How can I get the version nformation of developer
edition?
2)How do I use Enterprise Manager to create a database with developer editon
server instance?
THANKS!It tells you the version of the server you are connecting to. If you want
the version of developer edition you need to connect to it first.
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:977874AC-FC88-4DB2-9AA2-76095F35BABF@.microsoft.com...
> Hi,
> I have a sql 2000 personal editon(default server) and developer edition
> (named) installed on a machine (windowsXP).
> 1) if I do 'select @.@.version' in query, I always get 'personal edition'
> version information back. How can I get the version nformation of
> developer
> edition?
> 2)How do I use Enterprise Manager to create a database with developer
> editon
> server instance?
> THANKS!|||"ME",
I couldn't find a way to 'connect' to the server instance of developer
edition in the sql enterprise maganer. Hope you can help me on this. Thanks
!!
"ME" wrote:
> It tells you the version of the server you are connecting to. If you want
> the version of developer edition you need to connect to it first.
>
> "bangwo" <bangwo@.discussions.microsoft.com> wrote in message
> news:977874AC-FC88-4DB2-9AA2-76095F35BABF@.microsoft.com...
>
>|||well, if you open Server Network Utility you should see the instance name of
your SQL Edition server. Use that instance name to connect ...
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:AB497B9C-D604-4F46-B65C-F898D5D99359@.microsoft.com...[vbcol=seagreen]
> "ME",
> I couldn't find a way to 'connect' to the server instance of developer
> edition in the sql enterprise maganer. Hope you can help me on this.
> Thanks
> !!
> "ME" wrote:
>|||Hello,
Go to the SQL Server log of the SQL Server Developer edition installation
(C:\program files\Microsoft SQL Server\Logs\ folder).
In the error log the name of the SQL Server installation will be shown. You
could use that information to either register to Enterprise manager or
connect to Query Analyzer. After that you could execute SELECT @.@.Version.
Thanks
hari
"bangwo" <bangwo@.discussions.microsoft.com> wrote in message
news:AB497B9C-D604-4F46-B65C-F898D5D99359@.microsoft.com...[vbcol=seagreen]
> "ME",
> I couldn't find a way to 'connect' to the server instance of developer
> edition in the sql enterprise maganer. Hope you can help me on this.
> Thanks
> !!
> "ME" wrote:
>
Subscribe to:
Posts (Atom)