I/O error (bad page ID)

I/O error (bad page ID) detected during read of BUF
pointer = 0x147ab6c0, page ptr = 0xacda6000, pageid =
(0x1:0x3e552), dbid = 10, status = 0x801, file =
<directorypath of the .MDF>
Any ideas?anon,
It looks like you might have a corrupt database. Can you run DBCC
CHECKDB and DBCC NEWALLOC in the database. Please post any errors from
these commands.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
anonymous@.discussions.microsoft.com wrote:
> I/O error (bad page ID) detected during read of BUF
> pointer = 0x147ab6c0, page ptr = 0xacda6000, pageid =
> (0x1:0x3e552), dbid = 10, status = 0x801, file =
> <directorypath of the .MDF>
> Any ideas?

I/O error (bad page ID)

I/O error (bad page ID) detected during read of BUF
pointer = 0x147ab6c0, page ptr = 0xacda6000, pageid =
(0x1:0x3e552), dbid = 10, status = 0x801, file =
<directorypath of the .MDF>
Any ideas?
anon,
It looks like you might have a corrupt database. Can you run DBCC
CHECKDB and DBCC NEWALLOC in the database. Please post any errors from
these commands.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
anonymous@.discussions.microsoft.com wrote:
> I/O error (bad page ID) detected during read of BUF
> pointer = 0x147ab6c0, page ptr = 0xacda6000, pageid =
> (0x1:0x3e552), dbid = 10, status = 0x801, file =
> <directorypath of the .MDF>
> Any ideas?
sql

I/O error (bad page ID)

I/O error (bad page ID) detected during read of BUF
pointer = 0x147ab6c0, page ptr = 0xacda6000, pageid = (0x1:0x3e552), dbid = 10, status = 0x801, file = <directorypath of the .MDF>
Any ideas?anon,
It looks like you might have a corrupt database. Can you run DBCC
CHECKDB and DBCC NEWALLOC in the database. Please post any errors from
these commands.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
anonymous@.discussions.microsoft.com wrote:
> I/O error (bad page ID) detected during read of BUF
> pointer = 0x147ab6c0, page ptr = 0xacda6000, pageid => (0x1:0x3e552), dbid = 10, status = 0x801, file => <directorypath of the .MDF>
> Any ideas?

I need help with my query

Hi Y'all,

I want to get all database-names from my server, i do that like this:

select name, dbid from sysdatabases => from my master database

Now i want to add a "where"-clause to select only those databases that have the table "TASKS".

Can someone help me out?

THanks

Hi,

If you are trying to get the list of tables, database name etc. in your ASP.Net application then have a look at it.http://msdn2.microsoft.com/en-us/library/system.data.oledb.oledbconnection.getoledbschematable.aspx

Thanks and best regards,

|||

this doesn't seem to work:

SET @.sSql = 'select * from ' + @.databasenaam + '.dbo.sysobjects where name like '''tablesearchnaam''' '

if exists(EXEC sp_sqlexec @.sSql)

|||Have you tried this already?

SELECT*FROM sysobjectsWHERE [name]LIKE'%tasks%'

This can also be done without using a stored procedure...

IFEXISTS(SELECT*FROM sysobjectsWHERE [name]LIKE'%tasks%')
DO STUFF

|||

If you just want tables you might want to restrict the type to 'U'.

SELECT*FROM sysobjectsWHERE [name]LIKE'%tasks%' AND Type = 'U'