Could not open FCB for invalid file ID 20294 in database

Hi,
I am getting this error when I am trying to delete record
"Server: Msg 5180, Level 22, State 1, Line 1
Could not open FCB for invalid file ID 20294 in database 'SAS_Test'.
Connection Broken"
But when I use select command it works fine. I can ping the server, but some
how can't delete does not work!.
I check the SQL server log and it has "Could not open FCB for invalid file
ID 20294 in database, Error: 5180, Severity: 22, State: 1"
Any help would be appreciated.
Shan
Run DBCC CheckDB for that database to check physical corruption under file..
also refer to this link: -
http://support.microsoft.com/default...;en-us;Q276043
"Shan" wrote:

> Hi,
> I am getting this error when I am trying to delete record
> "Server: Msg 5180, Level 22, State 1, Line 1
> Could not open FCB for invalid file ID 20294 in database 'SAS_Test'.
> Connection Broken"
> But when I use select command it works fine. I can ping the server, but some
> how can't delete does not work!.
> I check the SQL server log and it has "Could not open FCB for invalid file
> ID 20294 in database, Error: 5180, Severity: 22, State: 1"
> Any help would be appreciated.
> --
> Shan

Could not open FCB for invalid file ID 20294 in database

Hi,
I am getting this error when I am trying to delete record
"Server: Msg 5180, Level 22, State 1, Line 1
Could not open FCB for invalid file ID 20294 in database 'SAS_Test'.
Connection Broken"
But when I use select command it works fine. I can ping the server, but some
how can't delete does not work!.
I check the SQL server log and it has "Could not open FCB for invalid file
ID 20294 in database, Error: 5180, Severity: 22, State: 1"
Any help would be appreciated.
--
ShanRun DBCC CheckDB for that database to check physical corruption under file..
also refer to this link: -
http://support.microsoft.com/defaul...b;en-us;Q276043
"Shan" wrote:

> Hi,
> I am getting this error when I am trying to delete record
> "Server: Msg 5180, Level 22, State 1, Line 1
> Could not open FCB for invalid file ID 20294 in database 'SAS_Test'.
> Connection Broken"
> But when I use select command it works fine. I can ping the server, but so
me
> how can't delete does not work!.
> I check the SQL server log and it has "Could not open FCB for invalid file
> ID 20294 in database, Error: 5180, Severity: 22, State: 1"
> Any help would be appreciated.
> --
> Shan

Could not open FCB for invalid file ID 20294 in database

Hi,
I am getting this error when I am trying to delete record
"Server: Msg 5180, Level 22, State 1, Line 1
Could not open FCB for invalid file ID 20294 in database 'SAS_Test'.
Connection Broken"
But when I use select command it works fine. I can ping the server, but some
how can't delete does not work!.
I check the SQL server log and it has "Could not open FCB for invalid file
ID 20294 in database, Error: 5180, Severity: 22, State: 1"
Any help would be appreciated.
--
ShanRun DBCC CheckDB for that database to check physical corruption under file..
also refer to this link: -
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q276043
"Shan" wrote:
> Hi,
> I am getting this error when I am trying to delete record
> "Server: Msg 5180, Level 22, State 1, Line 1
> Could not open FCB for invalid file ID 20294 in database 'SAS_Test'.
> Connection Broken"
> But when I use select command it works fine. I can ping the server, but some
> how can't delete does not work!.
> I check the SQL server log and it has "Could not open FCB for invalid file
> ID 20294 in database, Error: 5180, Severity: 22, State: 1"
> Any help would be appreciated.
> --
> Shan

Could not map ordinals

Server: Msg 7351, Level 16, State 2, Line 1
OLE DB provider 'SQLOLEDB' could not map ordinals for one
or more columns of object 'DBSCHEMA_COLUMNS'.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
IColumnsInfo::MapColumnIDs returned 0x40eda:
[COLUMN_NAME=IS_COMPUTED ORDINAL=-1]].
I have 5 SQL 2000, Enterprise Edition, SP3 servers running
Windows 2000 Advanced Server w/SP3.
I have set up linking between each of these servers using
the sa username/password 'be made using this security
context.' They all work but one, SQL2. I can access any
other server from SQL2 but from any other server cannot
access tables on SQL2. I get the message above.
I had this before on this same server, but since then have
formatted the system, made sure all the hardware is
working correctly, installed SQL Server not using the same
system databases, and the error is back.
Anyone have ideas for me to try? I have searched
support.microsoft.com, groups.google.com, yahoo.com,
sqlservercentral.com, sqlmag.com to no avail.
Thanks,
Michelle
Please reply to the newsgroup or email me at
daxemail-microsoft'at'yahoo'dot'comI ended up calling Microsoft PSS. I received wonderful
assistance from Chandra who discovered the instcat.sql
script in the service pack did not run correctly on my
system. We backed up the master database, ran the script,
and I now have access to the linked servers.
Thanks! Hope this helps someone in the future,
Michelle
>--Original Message--
>Server: Msg 7351, Level 16, State 2, Line 1
>OLE DB provider 'SQLOLEDB' could not map ordinals for one
>or more columns of object 'DBSCHEMA_COLUMNS'.
>OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
>IColumnsInfo::MapColumnIDs returned 0x40eda:
>[COLUMN_NAME=IS_COMPUTED ORDINAL=-1]].
>I have 5 SQL 2000, Enterprise Edition, SP3 servers
running
>Windows 2000 Advanced Server w/SP3.
>I have set up linking between each of these servers using
>the sa username/password 'be made using this security
>context.' They all work but one, SQL2. I can access any
>other server from SQL2 but from any other server cannot
>access tables on SQL2. I get the message above.
>I had this before on this same server, but since then
have
>formatted the system, made sure all the hardware is
>working correctly, installed SQL Server not using the
same
>system databases, and the error is back.
>Anyone have ideas for me to try? I have searched
>support.microsoft.com, groups.google.com, yahoo.com,
>sqlservercentral.com, sqlmag.com to no avail.
>Thanks,
>Michelle
>Please reply to the newsgroup or email me at
>daxemail-microsoft'at'yahoo'dot'com
>.
>

Could not find xp_trace_setqueryhistory

I'm trying to enable black-box reporting, but I must be doing something wrong:

> exec xp_trace_setqueryhistory

Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'xp_trace_setqueryhistory'.

Am I missing something obvious?

Thanks!

Hello,

The xp_trace xp's haven't been in mssql since 7.0. You need to use the sp_trace% procs.

Cheers,

Rob

|||Well, that explains why I couldn't find them. Thanks!

could not find table error

Using SS2000 SP4.
When I run DBCC SHOWCONTIG (ActionsNeeded) WITH TABLERESULTS, ALL_INDEXES I
get an error "Server: Msg 2501, Level 16, State 45, Line 1
Could not find a table or object named 'ActionsNeeded'. Check sysobjects."
All objects in the database are owned by "memsym". If I try "DBCC SHOWCONTIG
(memsym.ActionsNeeded) WITH TABLERESULTS, ALL_INDEXES" I get this error -
"Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '.'."
I have a script that checks index fragmentation and it uses the above
command. I get the same error on all tables in the database. Any idea why and
how to fix it?
The tables do exist and I can select from them.
Thanks,
--
Dan D.> All objects in the database are owned by "memsym". If I try "DBCC
> SHOWCONTIG
> (memsym.ActionsNeeded) WITH TABLERESULTS, ALL_INDEXES" I get this error -
> "Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '.'."
Try enclosing the object name in quotes:
DBCC SHOWCONTIG ('memsym.ActionsNeeded')
WITH TABLERESULTS, ALL_INDEXES
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:AEC3EE22-C7D7-4E81-A29D-36C5B698B241@.microsoft.com...
> Using SS2000 SP4.
> When I run DBCC SHOWCONTIG (ActionsNeeded) WITH TABLERESULTS, ALL_INDEXES
> I
> get an error "Server: Msg 2501, Level 16, State 45, Line 1
> Could not find a table or object named 'ActionsNeeded'. Check sysobjects."
> All objects in the database are owned by "memsym". If I try "DBCC
> SHOWCONTIG
> (memsym.ActionsNeeded) WITH TABLERESULTS, ALL_INDEXES" I get this error -
> "Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '.'."
> I have a script that checks index fragmentation and it uses the above
> command. I get the same error on all tables in the database. Any idea why
> and
> how to fix it?
> The tables do exist and I can select from them.
> Thanks,
> --
> Dan D.|||I guess I wasn't thinking this morning. That was too easy.
Thanks,
--
Dan D.
"Dan Guzman" wrote:
> > All objects in the database are owned by "memsym". If I try "DBCC
> > SHOWCONTIG
> > (memsym.ActionsNeeded) WITH TABLERESULTS, ALL_INDEXES" I get this error -
> > "Server: Msg 170, Level 15, State 1, Line 1
> > Line 1: Incorrect syntax near '.'."
> Try enclosing the object name in quotes:
> DBCC SHOWCONTIG ('memsym.ActionsNeeded')
> WITH TABLERESULTS, ALL_INDEXES
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:AEC3EE22-C7D7-4E81-A29D-36C5B698B241@.microsoft.com...
> > Using SS2000 SP4.
> >
> > When I run DBCC SHOWCONTIG (ActionsNeeded) WITH TABLERESULTS, ALL_INDEXES
> > I
> > get an error "Server: Msg 2501, Level 16, State 45, Line 1
> > Could not find a table or object named 'ActionsNeeded'. Check sysobjects."
> >
> > All objects in the database are owned by "memsym". If I try "DBCC
> > SHOWCONTIG
> > (memsym.ActionsNeeded) WITH TABLERESULTS, ALL_INDEXES" I get this error -
> > "Server: Msg 170, Level 15, State 1, Line 1
> > Line 1: Incorrect syntax near '.'."
> >
> > I have a script that checks index fragmentation and it uses the above
> > command. I get the same error on all tables in the database. Any idea why
> > and
> > how to fix it?
> > The tables do exist and I can select from them.
> >
> > Thanks,
> > --
> > Dan D.
>

Could not find stored procedure 'SP_DBOPTION'.

Hi All,
Command:
SP_DBOPTION 'ORDERDB', 'SELECT INTO', 'TRUE'
Error Message:
Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'SP_DBOPTION'.
I am getting the above message when I run the said
command. I tried to locate the resolution at several
places and no help
Thanks,
Mohammed Sarwar
Ocp Dba Oracle 9i, 8i, 8.0If you have a case-sensitive installation, you need to specify the
stored procedure name in lower case:
EXE sp_dboption 'ORDERDB', 'SELECT INTO', 'TRUE'
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Mohammed Sarwar" <MSarwar@.uBid.com> wrote in message
news:29fe001c391dd$1012bfd0$a601280a@.phx.gbl...
> Hi All,
> Command:
> SP_DBOPTION 'ORDERDB', 'SELECT INTO', 'TRUE'
> Error Message:
> Server: Msg 2812, Level 16, State 62, Line 1
> Could not find stored procedure 'SP_DBOPTION'.
> I am getting the above message when I run the said
> command. I tried to locate the resolution at several
> places and no help
> Thanks,
> Mohammed Sarwar
> Ocp Dba Oracle 9i, 8i, 8.0
>|||Dan,
Super! That worked.
Thanks,
Mohammed Sarwar
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Could not find database ID 102 ?

It happens to me that in very complex sql queries I get a message:
Server: Msg 913, Level 16, State 8, Line 1
Could not find database ID 102. Database may not be activated yet or may be
in transition.
The query then just doesn't run. What the hack does that mean?
Example:
The following one works:
select field1, ..., field4
from
(
select field1, ..., field4 from table1
union all
select field1, ..., field4 from table2
union all
select field1, ..., field4 from view3
)
group by field1...
but when I replace view3 with its sql then I get the mentioned error. It's
not the first time it's happened to me.
Regards,
Marcin
Hi
Looks like the one DB you are trying to access is not online.
Run
SELECT [name] FROM master.dbo.sysdatabases WHERE dbid = 102
and it will tell you which DB it is. Check the status of the DB in EM.
Regards
Mike
"pexiak" wrote:

> It happens to me that in very complex sql queries I get a message:
> Server: Msg 913, Level 16, State 8, Line 1
> Could not find database ID 102. Database may not be activated yet or may be
> in transition.
> The query then just doesn't run. What the hack does that mean?
> Example:
> The following one works:
> select field1, ..., field4
> from
> (
> select field1, ..., field4 from table1
> union all
> select field1, ..., field4 from table2
> union all
> select field1, ..., field4 from view3
> )
> group by field1...
> but when I replace view3 with its sql then I get the mentioned error. It's
> not the first time it's happened to me.
> Regards,
> Marcin
>
>
|||It does not return any records. It is impossible that that database is
offline, it is being used constantly and no problems appear.
Uytkownik "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> napisa w
wiadomoci news:7478A463-F2A6-4630-81BC-41E358917FB4@.microsoft.com...[vbcol=seagreen]
> Hi
> Looks like the one DB you are trying to access is not online.
> Run
> SELECT [name] FROM master.dbo.sysdatabases WHERE dbid = 102
> and it will tell you which DB it is. Check the status of the DB in EM.
> Regards
> Mike
> "pexiak" wrote:
be[vbcol=seagreen]
It's[vbcol=seagreen]
|||Can be timeout error... troubleshoot in that way
"pexiak" wrote:

> It does not return any records. It is impossible that that database is
> offline, it is being used constantly and no problems appear.
> U?ytkownik "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> napisa3 w
> wiadomo?ci news:7478A463-F2A6-4630-81BC-41E358917FB4@.microsoft.com...
> be
> It's
>
>
|||Hi,
Which service pack you are using? Looks like this a bug. Check the below KB
article.
http://support.microsoft.com/kb/834688
Thanks
Hari
SQL Server MVP
"pexiak" <mpeksa@.poczta.onet.pl> wrote in message
news:d2j4t6$a9g$1@.news.onet.pl...
> It happens to me that in very complex sql queries I get a message:
> Server: Msg 913, Level 16, State 8, Line 1
> Could not find database ID 102. Database may not be activated yet or may
> be
> in transition.
> The query then just doesn't run. What the hack does that mean?
> Example:
> The following one works:
> select field1, ..., field4
> from
> (
> select field1, ..., field4 from table1
> union all
> select field1, ..., field4 from table2
> union all
> select field1, ..., field4 from view3
> )
> group by field1...
> but when I replace view3 with its sql then I get the mentioned error. It's
> not the first time it's happened to me.
> Regards,
> Marcin
>
|||This happened to me once when I had UDF in a view with derived tables
when I took the code from the UDF and pasted it in the SQL it was fine
I guess it was something to do with the levels of nesting and joining with
derived tables
"pexiak" <mpeksa@.poczta.onet.pl> wrote in message
news:d2j4t6$a9g$1@.news.onet.pl...
> It happens to me that in very complex sql queries I get a message:
> Server: Msg 913, Level 16, State 8, Line 1
> Could not find database ID 102. Database may not be activated yet or may
> be
> in transition.
> The query then just doesn't run. What the hack does that mean?
> Example:
> The following one works:
> select field1, ..., field4
> from
> (
> select field1, ..., field4 from table1
> union all
> select field1, ..., field4 from table2
> union all
> select field1, ..., field4 from view3
> )
> group by field1...
> but when I replace view3 with its sql then I get the mentioned error. It's
> not the first time it's happened to me.
> Regards,
> Marcin
>

Could not find database ID 102 ?

It happens to me that in very complex sql queries I get a message:
Server: Msg 913, Level 16, State 8, Line 1
Could not find database ID 102. Database may not be activated yet or may be
in transition.
The query then just doesn't run. What the hack does that mean?
Example:
The following one works:
select field1, ..., field4
from
(
select field1, ..., field4 from table1
union all
select field1, ..., field4 from table2
union all
select field1, ..., field4 from view3
)
group by field1...
but when I replace view3 with its sql then I get the mentioned error. It's
not the first time it's happened to me.
Regards,
MarcinHi
Looks like the one DB you are trying to access is not online.
Run
SELECT [name] FROM master.dbo.sysdatabases WHERE dbid = 102
and it will tell you which DB it is. Check the status of the DB in EM.
Regards
Mike
"pexiak" wrote:

> It happens to me that in very complex sql queries I get a message:
> Server: Msg 913, Level 16, State 8, Line 1
> Could not find database ID 102. Database may not be activated yet or may b
e
> in transition.
> The query then just doesn't run. What the hack does that mean?
> Example:
> The following one works:
> select field1, ..., field4
> from
> (
> select field1, ..., field4 from table1
> union all
> select field1, ..., field4 from table2
> union all
> select field1, ..., field4 from view3
> )
> group by field1...
> but when I replace view3 with its sql then I get the mentioned error. It's
> not the first time it's happened to me.
> Regards,
> Marcin
>
>|||It does not return any records. It is impossible that that database is
offline, it is being used constantly and no problems appear.
Uytkownik "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> napisa w
wiadomoci news:7478A463-F2A6-4630-81BC-41E358917FB4@.microsoft.com...[vbcol=seagreen]
> Hi
> Looks like the one DB you are trying to access is not online.
> Run
> SELECT [name] FROM master.dbo.sysdatabases WHERE dbid = 102
> and it will tell you which DB it is. Check the status of the DB in EM.
> Regards
> Mike
> "pexiak" wrote:
>
be[vbcol=seagreen]
It's[vbcol=seagreen]|||Can be timeout error... troubleshoot in that way
"pexiak" wrote:

> It does not return any records. It is impossible that that database is
> offline, it is being used constantly and no problems appear.
> U?ytkownik "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> napisa3 w
> wiadomo?ci news:7478A463-F2A6-4630-81BC-41E358917FB4@.microsoft.com...
> be
> It's
>
>|||Hi,
Which service pack you are using? Looks like this a bug. Check the below KB
article.
http://support.microsoft.com/kb/834688
Thanks
Hari
SQL Server MVP
"pexiak" <mpeksa@.poczta.onet.pl> wrote in message
news:d2j4t6$a9g$1@.news.onet.pl...
> It happens to me that in very complex sql queries I get a message:
> Server: Msg 913, Level 16, State 8, Line 1
> Could not find database ID 102. Database may not be activated yet or may
> be
> in transition.
> The query then just doesn't run. What the hack does that mean?
> Example:
> The following one works:
> select field1, ..., field4
> from
> (
> select field1, ..., field4 from table1
> union all
> select field1, ..., field4 from table2
> union all
> select field1, ..., field4 from view3
> )
> group by field1...
> but when I replace view3 with its sql then I get the mentioned error. It's
> not the first time it's happened to me.
> Regards,
> Marcin
>|||This happened to me once when I had UDF in a view with derived tables
when I took the code from the UDF and pasted it in the SQL it was fine
I guess it was something to do with the levels of nesting and joining with
derived tables
"pexiak" <mpeksa@.poczta.onet.pl> wrote in message
news:d2j4t6$a9g$1@.news.onet.pl...
> It happens to me that in very complex sql queries I get a message:
> Server: Msg 913, Level 16, State 8, Line 1
> Could not find database ID 102. Database may not be activated yet or may
> be
> in transition.
> The query then just doesn't run. What the hack does that mean?
> Example:
> The following one works:
> select field1, ..., field4
> from
> (
> select field1, ..., field4 from table1
> union all
> select field1, ..., field4 from table2
> union all
> select field1, ..., field4 from view3
> )
> group by field1...
> but when I replace view3 with its sql then I get the mentioned error. It's
> not the first time it's happened to me.
> Regards,
> Marcin
>

Could not find database ID 102 ?

It happens to me that in very complex sql queries I get a message:
Server: Msg 913, Level 16, State 8, Line 1
Could not find database ID 102. Database may not be activated yet or may be
in transition.
The query then just doesn't run. What the hack does that mean?
Example:
The following one works:
select field1, ..., field4
from
(
select field1, ..., field4 from table1
union all
select field1, ..., field4 from table2
union all
select field1, ..., field4 from view3
)
group by field1...
but when I replace view3 with its sql then I get the mentioned error. It's
not the first time it's happened to me.
Regards,
MarcinHi
Looks like the one DB you are trying to access is not online.
Run
SELECT [name] FROM master.dbo.sysdatabases WHERE dbid = 102
and it will tell you which DB it is. Check the status of the DB in EM.
Regards
Mike
"pexiak" wrote:
> It happens to me that in very complex sql queries I get a message:
> Server: Msg 913, Level 16, State 8, Line 1
> Could not find database ID 102. Database may not be activated yet or may be
> in transition.
> The query then just doesn't run. What the hack does that mean?
> Example:
> The following one works:
> select field1, ..., field4
> from
> (
> select field1, ..., field4 from table1
> union all
> select field1, ..., field4 from table2
> union all
> select field1, ..., field4 from view3
> )
> group by field1...
> but when I replace view3 with its sql then I get the mentioned error. It's
> not the first time it's happened to me.
> Regards,
> Marcin
>
>|||It does not return any records. It is impossible that that database is
offline, it is being used constantly and no problems appear.
U¿ytkownik "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> napisa³ w
wiadomo¶ci news:7478A463-F2A6-4630-81BC-41E358917FB4@.microsoft.com...
> Hi
> Looks like the one DB you are trying to access is not online.
> Run
> SELECT [name] FROM master.dbo.sysdatabases WHERE dbid = 102
> and it will tell you which DB it is. Check the status of the DB in EM.
> Regards
> Mike
> "pexiak" wrote:
> > It happens to me that in very complex sql queries I get a message:
> >
> > Server: Msg 913, Level 16, State 8, Line 1
> > Could not find database ID 102. Database may not be activated yet or may
be
> > in transition.
> >
> > The query then just doesn't run. What the hack does that mean?
> >
> > Example:
> > The following one works:
> >
> > select field1, ..., field4
> > from
> > (
> > select field1, ..., field4 from table1
> > union all
> > select field1, ..., field4 from table2
> > union all
> > select field1, ..., field4 from view3
> > )
> > group by field1...
> >
> > but when I replace view3 with its sql then I get the mentioned error.
It's
> > not the first time it's happened to me.
> > Regards,
> > Marcin
> >
> >
> >|||Can be timeout error... troubleshoot in that way
"pexiak" wrote:
> It does not return any records. It is impossible that that database is
> offline, it is being used constantly and no problems appear.
> U¿ytkownik "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> napisa³ w
> wiadomo¶ci news:7478A463-F2A6-4630-81BC-41E358917FB4@.microsoft.com...
> > Hi
> >
> > Looks like the one DB you are trying to access is not online.
> >
> > Run
> > SELECT [name] FROM master.dbo.sysdatabases WHERE dbid = 102
> > and it will tell you which DB it is. Check the status of the DB in EM.
> >
> > Regards
> > Mike
> >
> > "pexiak" wrote:
> >
> > > It happens to me that in very complex sql queries I get a message:
> > >
> > > Server: Msg 913, Level 16, State 8, Line 1
> > > Could not find database ID 102. Database may not be activated yet or may
> be
> > > in transition.
> > >
> > > The query then just doesn't run. What the hack does that mean?
> > >
> > > Example:
> > > The following one works:
> > >
> > > select field1, ..., field4
> > > from
> > > (
> > > select field1, ..., field4 from table1
> > > union all
> > > select field1, ..., field4 from table2
> > > union all
> > > select field1, ..., field4 from view3
> > > )
> > > group by field1...
> > >
> > > but when I replace view3 with its sql then I get the mentioned error.
> It's
> > > not the first time it's happened to me.
> > > Regards,
> > > Marcin
> > >
> > >
> > >
>
>|||Hi,
Which service pack you are using? Looks like this a bug. Check the below KB
article.
http://support.microsoft.com/kb/834688
Thanks
Hari
SQL Server MVP
"pexiak" <mpeksa@.poczta.onet.pl> wrote in message
news:d2j4t6$a9g$1@.news.onet.pl...
> It happens to me that in very complex sql queries I get a message:
> Server: Msg 913, Level 16, State 8, Line 1
> Could not find database ID 102. Database may not be activated yet or may
> be
> in transition.
> The query then just doesn't run. What the hack does that mean?
> Example:
> The following one works:
> select field1, ..., field4
> from
> (
> select field1, ..., field4 from table1
> union all
> select field1, ..., field4 from table2
> union all
> select field1, ..., field4 from view3
> )
> group by field1...
> but when I replace view3 with its sql then I get the mentioned error. It's
> not the first time it's happened to me.
> Regards,
> Marcin
>|||This happened to me once when I had UDF in a view with derived tables
when I took the code from the UDF and pasted it in the SQL it was fine
I guess it was something to do with the levels of nesting and joining with
derived tables
"pexiak" <mpeksa@.poczta.onet.pl> wrote in message
news:d2j4t6$a9g$1@.news.onet.pl...
> It happens to me that in very complex sql queries I get a message:
> Server: Msg 913, Level 16, State 8, Line 1
> Could not find database ID 102. Database may not be activated yet or may
> be
> in transition.
> The query then just doesn't run. What the hack does that mean?
> Example:
> The following one works:
> select field1, ..., field4
> from
> (
> select field1, ..., field4 from table1
> union all
> select field1, ..., field4 from table2
> union all
> select field1, ..., field4 from view3
> )
> group by field1...
> but when I replace view3 with its sql then I get the mentioned error. It's
> not the first time it's happened to me.
> Regards,
> Marcin
>

Could not establish secure channel for SSL/TLS

We are getting the same error. We changed the asp timeout at the master property level, and we are now getting the same error. I have checked the RSWebApplication.config and it matches the server name.
I have gone through the other posts around this issue, but haven't been able to resolve the issue. I am at the point of reinstalling Reporting Services and setting up all of our reports again.
Any help would be appreciated!!!I found no solution ... and try to uninstall Report Services to make a new
installation. Also was not able to uninstall ... had to move to a new Server
:(
Tiago Andrade e Silva
"kbunch@.gapac.com" <kbunch@.gapac.com@.discussions.microsoft.com> wrote in
message news:1C5176BE-6741-4758-9B6D-FA583E84B26C@.microsoft.com...
> We are getting the same error. We changed the asp timeout at the master
property level, and we are now getting the same error. I have checked the
RSWebApplication.config and it matches the server name.
> I have gone through the other posts around this issue, but haven't been
able to resolve the issue. I am at the point of reinstalling Reporting
Services and setting up all of our reports again.
> Any help would be appreciated!!!
>|||SSL is not a requirement for Reporting services. Try setting
SecureConnectionLevel to 0 in RSReportsErver.config - there are more details
about it in the books online.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ray" <Ray@.discussions.microsoft.com> wrote in message
news:F9012D1C-5D5D-4348-84AA-3C88A88C8EAA@.microsoft.com...
> Tiago,
> Did you ever get a resolution or a workaround from MS on this issue? We
are having the same problem, and IIS on the report server is NOT configured
for SSL! Do you know if SSL is a requirement for Reporting Services?
> Thanks,
> Aisha
> "Tiago Andrade e Silva" wrote:
> > I found no solution ... and try to uninstall Report Services to make a
new
> > installation. Also was not able to uninstall ... had to move to a new
Server
> > :(
> >
> > Tiago Andrade e Silva
> > "kbunch@.gapac.com" <kbunch@.gapac.com@.discussions.microsoft.com> wrote in
> > message news:1C5176BE-6741-4758-9B6D-FA583E84B26C@.microsoft.com...
> > > We are getting the same error. We changed the asp timeout at the
master
> > property level, and we are now getting the same error. I have checked
the
> > RSWebApplication.config and it matches the server name.
> > >
> > > I have gone through the other posts around this issue, but haven't
been
> > able to resolve the issue. I am at the point of reinstalling Reporting
> > Services and setting up all of our reports again.
> > >
> > > Any help would be appreciated!!!
> > >
> >
> >
> >|||The error in the title of this post is "Could not establish secure channel
for SSL/TLS". You should never get this error if you are not using SSL, are
you saying you are getting it? What is the exact request that fails with
this error?
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ray" <Ray@.discussions.microsoft.com> wrote in message
news:10AC1BA4-4429-455E-B6A6-3EF528A8536D@.microsoft.com...
> Tudor,
> That has already been established per RSReportServer.config , <Add
Key="SecureConnectionLevel" Value="0"/>. The value is set to 0 and we are
NOT USING SSL.
> What books online are you talking about? Can you provide more details on
this? Seems like several others have the same issue, like Tiago, and he
never found a resolution and ended up moving Reporting Services to another
server? Is that the resolution? What if it starts happening on the new
server?
> Please provide more helpful information on this issue. Most of these
threads with this issue have been started since May and no resolution posted
thus far?
> Aisha
> "Tudor Trufinescu (MSFT)" wrote:
> > SSL is not a requirement for Reporting services. Try setting
> > SecureConnectionLevel to 0 in RSReportsErver.config - there are more
details
> > about it in the books online.
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "Ray" <Ray@.discussions.microsoft.com> wrote in message
> > news:F9012D1C-5D5D-4348-84AA-3C88A88C8EAA@.microsoft.com...
> > > Tiago,
> > >
> > > Did you ever get a resolution or a workaround from MS on this issue?
We
> > are having the same problem, and IIS on the report server is NOT
configured
> > for SSL! Do you know if SSL is a requirement for Reporting Services?
> > >
> > > Thanks,
> > > Aisha
> > >
> > > "Tiago Andrade e Silva" wrote:
> > >
> > > > I found no solution ... and try to uninstall Report Services to
make a
> > new
> > > > installation. Also was not able to uninstall ... had to move to a
new
> > Server
> > > > :(
> > > >
> > > > Tiago Andrade e Silva
> > > > "kbunch@.gapac.com" <kbunch@.gapac.com@.discussions.microsoft.com>
wrote in
> > > > message news:1C5176BE-6741-4758-9B6D-FA583E84B26C@.microsoft.com...
> > > > > We are getting the same error. We changed the asp timeout at the
> > master
> > > > property level, and we are now getting the same error. I have
checked
> > the
> > > > RSWebApplication.config and it matches the server name.
> > > > >
> > > > > I have gone through the other posts around this issue, but haven't
> > been
> > > > able to resolve the issue. I am at the point of reinstalling
Reporting
> > > > Services and setting up all of our reports again.
> > > > >
> > > > > Any help would be appreciated!!!
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||What is the URL in RSWebApplication.config ?
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ray" <Ray@.discussions.microsoft.com> wrote in message
news:78F9C232-00B0-4611-9048-7D40CD3D9399@.microsoft.com...
> Tudor,
> Here is a copy of the ReportServerWebApp__08_04_2004_08_56_18.log from
this morning when I tried accessing http://myservername/reports:
> <begin ReportServerWebApp log file>
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
8.00.743.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Central Daylight Time</TimeZone>
> <Path>D:\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerWebApp__08_04_2004_08_56_18.log</Path>
> <SystemName>myservername</SystemName>
> <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> <OSVersion>5.0.2195.0</OSVersion>
> </Header>
> aspnet_wp!ui!20c!8/4/2004-08:56:18:: e ERROR: The underlying connection
was closed: Could not establish secure channel for SSL/TLS.
> aspnet_wp!ui!20c!8/4/2004-08:56:18:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The underlying connection was closed: Could not
establish secure channel for SSL/TLS. -->
System.ComponentModel.Win32Exception: The function completed successfully,
but must be called again to complete the context
> -- End of inner exception stack trace --
> at System.Net.HttpWebRequest.CheckFinalStatus()
> at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult
asyncResult)
> at System.Net.HttpWebRequest.GetRequestStream()
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
> at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> at
Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> at
Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
> at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
> at
Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> aspnet_wp!ui!20c!8/4/2004-08:56:18:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)
> </end ReportServerWebApp log file>
> Here is the IIS log from this morning:
> <begin IIS log>
> #Software: Microsoft Internet Information Services 5.0
> #Version: 1.0
> #Date: 2004-08-04 13:56:18
> #Fields: date time s-port cs-method cs-uri-stem cs-uri-query sc-status
cs(User-Agent)
> 2004-08-04 13:56:18 80 GET /reports - 401
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)
> 2004-08-04 13:56:18 80 GET /reports/ - 302
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)
> 2004-08-04 13:56:18 80 GET /reports/Home.aspx - 302
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)
> 2004-08-04 13:56:18 80 POST /ReportServer/reportservice.asmx - 403 -
> 2004-08-04 13:56:18 80 POST /ReportServer/reportservice.asmx - 403 -
> 2004-08-04 13:56:18 80 GET /reports/Pages/Folder.aspx - 500
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)
> 2004-08-04 13:56:18 80 GET /Reports/js/ReportingServices.js - 304
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)
> 2004-08-04 13:56:18 80 GET /Reports/styles/ReportingServices.css - 304
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)
> 2004-08-04 13:56:18 80 GET /Reports/images/blank.gif - 304
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)
> 2004-08-04 13:56:18 80 GET /Reports/images/48error.jpg - 304
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CLR+1.1.4322)
> </end IIS log>
> Please let me know if you need any other information. I didn't see a
place to upload files, so that is why I am just putting the information in
here. Also, if you search this newsgroup for the "Could not establish
secure channel for SSL/TLS" error, you will find some other posts with users
with this same problem when the SecureConnectionLevel Value = 0.
> Thanks,
> Aisha
>
> "Tudor Trufinescu (MSFT)" wrote:
> > The error in the title of this post is "Could not establish secure
channel
> > for SSL/TLS". You should never get this error if you are not using SSL,
are
> > you saying you are getting it? What is the exact request that fails with
> > this error?
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Ray" <Ray@.discussions.microsoft.com> wrote in message
> > news:10AC1BA4-4429-455E-B6A6-3EF528A8536D@.microsoft.com...
> > > Tudor,
> > >
> > > That has already been established per RSReportServer.config , <Add
> > Key="SecureConnectionLevel" Value="0"/>. The value is set to 0 and we
are
> > NOT USING SSL.
> > >
> > > What books online are you talking about? Can you provide more details
on
> > this? Seems like several others have the same issue, like Tiago, and he
> > never found a resolution and ended up moving Reporting Services to
another
> > server? Is that the resolution? What if it starts happening on the new
> > server?
> > >
> > > Please provide more helpful information on this issue. Most of these
> > threads with this issue have been started since May and no resolution
posted
> > thus far?
> > >
> > > Aisha
> > >
> > > "Tudor Trufinescu (MSFT)" wrote:
> > >
> > > > SSL is not a requirement for Reporting services. Try setting
> > > > SecureConnectionLevel to 0 in RSReportsErver.config - there are more
> > details
> > > > about it in the books online.
> > > >
> > > > --
> > > > Tudor Trufinescu
> > > > Dev Lead
> > > > Sql Server Reporting Services
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > > "Ray" <Ray@.discussions.microsoft.com> wrote in message
> > > > news:F9012D1C-5D5D-4348-84AA-3C88A88C8EAA@.microsoft.com...
> > > > > Tiago,
> > > > >
> > > > > Did you ever get a resolution or a workaround from MS on this
issue?
> > We
> > > > are having the same problem, and IIS on the report server is NOT
> > configured
> > > > for SSL! Do you know if SSL is a requirement for Reporting
Services?
> > > > >
> > > > > Thanks,
> > > > > Aisha
> > > > >
> > > > > "Tiago Andrade e Silva" wrote:
> > > > >
> > > > > > I found no solution ... and try to uninstall Report Services to
> > make a
> > > > new
> > > > > > installation. Also was not able to uninstall ... had to move to
a
> > new
> > > > Server
> > > > > > :(
> > > > > >
> > > > > > Tiago Andrade e Silva
> > > > > > "kbunch@.gapac.com" <kbunch@.gapac.com@.discussions.microsoft.com>
> > wrote in
> > > > > > message
news:1C5176BE-6741-4758-9B6D-FA583E84B26C@.microsoft.com...
> > > > > > > We are getting the same error. We changed the asp timeout at
the
> > > > master
> > > > > > property level, and we are now getting the same error. I have
> > checked
> > > > the
> > > > > > RSWebApplication.config and it matches the server name.
> > > > > > >
> > > > > > > I have gone through the other posts around this issue, but
haven't
> > > > been
> > > > > > able to resolve the issue. I am at the point of reinstalling
> > Reporting
> > > > > > Services and setting up all of our reports again.
> > > > > > >
> > > > > > > Any help would be appreciated!!!
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

Could not continue scan with NOLOCK due to data movement. when delete a record

Error 601
Severity Level 12
Message Text
Could not continue scan with NOLOCK due to data movement.
My client always hit this error when he tried to delete a record from
table. The table contains about 1 million records. the table has a
unique index idx_1 on (col_a, col_b, col_c). non-unique index idx_2 on
(col_a),
non-unique index idx_3 on col_c. An update trigger on table also.
When he execute
delete from table_a where col_a = @.parm1 and col_c = @.parm3. he gets
the 601 error.
but if he execute
delete from table_a where col_a = @.parm1 and col_b = @.parm2. he can
delete this one record.
We execute dbcc checktable(table_a) and no error reported.
I read posts that saying it is because read-uncommitted or nolock
hint, but we do not has this options and we did not execute select
statement.
Any idea why this happens, we are afraid that the table is not healthy/
waiting to corruption. Is there anything we can do to narrow down
where the cause is and to provent it happen again?
and it is MS SQL 2000 with SP4
thanks in advance
-rockdaleDoes this KB article apply?
http://support.microsoft.com/kb/815008
Linchi
"rockdale" wrote:
> Error 601
> Severity Level 12
> Message Text
> Could not continue scan with NOLOCK due to data movement.
> My client always hit this error when he tried to delete a record from
> table. The table contains about 1 million records. the table has a
> unique index idx_1 on (col_a, col_b, col_c). non-unique index idx_2 on
> (col_a),
> non-unique index idx_3 on col_c. An update trigger on table also.
> When he execute
> delete from table_a where col_a = @.parm1 and col_c = @.parm3. he gets
> the 601 error.
> but if he execute
> delete from table_a where col_a = @.parm1 and col_b = @.parm2. he can
> delete this one record.
> We execute dbcc checktable(table_a) and no error reported.
> I read posts that saying it is because read-uncommitted or nolock
> hint, but we do not has this options and we did not execute select
> statement.
> Any idea why this happens, we are afraid that the table is not healthy/
> waiting to corruption. Is there anything we can do to narrow down
> where the cause is and to provent it happen again?
> and it is MS SQL 2000 with SP4
> thanks in advance
> -rockdale
>|||NOPE.
The database is SQL2K with SP4.
They did not execute any select statement, not mention Read Uncommited
option.
They execute the delete statement using one where condition and get
the error.
They execute the delete statement using another where condition and
no error occured.
I even execute the DBCC TRACEON (9134, -1) as the article you
mentioned, I still getting the same error. I can not restart the sql
server, it is a production server.
Thanks
On Oct 19, 11:46 am, Linchi Shea
<LinchiS...@.discussions.microsoft.com> wrote:
> Does this KB article apply?http://support.microsoft.com/kb/815008
> Linchi
>
> "rockdale" wrote:
> > Error 601
> > Severity Level 12
> > Message Text
> > Could not continue scan with NOLOCK due to data movement.
> > My client always hit this error when he tried to delete a record from
> > table. The table contains about 1 million records. the table has a
> > unique index idx_1 on (col_a, col_b, col_c). non-unique index idx_2 on
> > (col_a),
> > non-unique index idx_3 on col_c. An update trigger on table also.
> > When he execute
> > delete from table_a where col_a = @.parm1 and col_c = @.parm3. he gets
> > the 601 error.
> > but if he execute
> > delete from table_a where col_a = @.parm1 and col_b = @.parm2. he can
> > delete this one record.
> > We execute dbcc checktable(table_a) and no error reported.
> > I read posts that saying it is because read-uncommitted or nolock
> > hint, but we do not has this options and we did not execute select
> > statement.
> > Any idea why this happens, we are afraid that the table is not healthy/
> > waiting to corruption. Is there anything we can do to narrow down
> > where the cause is and to provent it happen again?
> > and it is MS SQL 2000 with SP4
> > thanks in advance
> > -rockdale- Hide quoted text -
> - Show quoted text -|||Look for a DELETE trigger on the table.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"rockdale" <rockdale.green@.gmail.com> wrote in message
news:1192807669.901836.228930@.i38g2000prf.googlegroups.com...
> Error 601
> Severity Level 12
> Message Text
> Could not continue scan with NOLOCK due to data movement.
> My client always hit this error when he tried to delete a record from
> table. The table contains about 1 million records. the table has a
> unique index idx_1 on (col_a, col_b, col_c). non-unique index idx_2 on
> (col_a),
> non-unique index idx_3 on col_c. An update trigger on table also.
> When he execute
> delete from table_a where col_a = @.parm1 and col_c = @.parm3. he gets
> the 601 error.
> but if he execute
> delete from table_a where col_a = @.parm1 and col_b = @.parm2. he can
> delete this one record.
> We execute dbcc checktable(table_a) and no error reported.
> I read posts that saying it is because read-uncommitted or nolock
> hint, but we do not has this options and we did not execute select
> statement.
> Any idea why this happens, we are afraid that the table is not healthy/
> waiting to corruption. Is there anything we can do to narrow down
> where the cause is and to provent it happen again?
> and it is MS SQL 2000 with SP4
> thanks in advance
> -rockdale
>|||They have a n update trigger in the table basically update the
lastedUpdateDateTime field. The Trigger is for Update only, so I do
not think delete will trigger this trigger.
On Oct 19, 1:30 pm, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> Look for a DELETE trigger on the table.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
> "rockdale" <rockdale.gr...@.gmail.com> wrote in message
> news:1192807669.901836.228930@.i38g2000prf.googlegroups.com...
>
> > Error 601
> > Severity Level 12
> > Message Text
> > Could not continue scan with NOLOCK due to data movement.
> > My client always hit this error when he tried to delete a record from
> > table. The table contains about 1 million records. the table has a
> > unique index idx_1 on (col_a, col_b, col_c). non-unique index idx_2 on
> > (col_a),
> > non-unique index idx_3 on col_c. An update trigger on table also.
> > When he execute
> > delete from table_a where col_a = @.parm1 and col_c = @.parm3. he gets
> > the 601 error.
> > but if he execute
> > delete from table_a where col_a = @.parm1 and col_b = @.parm2. he can
> > delete this one record.
> > We execute dbcc checktable(table_a) and no error reported.
> > I read posts that saying it is because read-uncommitted or nolock
> > hint, but we do not has this options and we did not execute select
> > statement.
> > Any idea why this happens, we are afraid that the table is not healthy/
> > waiting to corruption. Is there anything we can do to narrow down
> > where the cause is and to provent it happen again?
> > and it is MS SQL 2000 with SP4
> > thanks in advance
> > -rockdale- Hide quoted text -
> - Show quoted text -|||I just delete the trigger and I still getting the same error.
More Info on index:
They have a UNIQUE NONCLUSTERED Constraints on table_a
(col_a, col_b, col_c)
an INDEX on table_a
(col_c)
an INDEX on table_a
(col_a)
Might these indices problems?
thanks
On Oct 19, 1:30 pm, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> Look for a DELETE trigger on the table.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
> "rockdale" <rockdale.gr...@.gmail.com> wrote in message
> news:1192807669.901836.228930@.i38g2000prf.googlegroups.com...
>
> > Error 601
> > Severity Level 12
> > Message Text
> > Could not continue scan with NOLOCK due to data movement.
> > My client always hit this error when he tried to delete a record from
> > table. The table contains about 1 million records. the table has a
> > unique index idx_1 on (col_a, col_b, col_c). non-unique index idx_2 on
> > (col_a),
> > non-unique index idx_3 on col_c. An update trigger on table also.
> > When he execute
> > delete from table_a where col_a = @.parm1 and col_c = @.parm3. he gets
> > the 601 error.
> > but if he execute
> > delete from table_a where col_a = @.parm1 and col_b = @.parm2. he can
> > delete this one record.
> > We execute dbcc checktable(table_a) and no error reported.
> > I read posts that saying it is because read-uncommitted or nolock
> > hint, but we do not has this options and we did not execute select
> > statement.
> > Any idea why this happens, we are afraid that the table is not healthy/
> > waiting to corruption. Is there anything we can do to narrow down
> > where the cause is and to provent it happen again?
> > and it is MS SQL 2000 with SP4
> > thanks in advance
> > -rockdale- Hide quoted text -
> - Show quoted text -

Could not allocate space for object

There is a Primary Filegroup with 5 datafiles and 2 logfiles. I'm trying to
add more datafiles, but the error "Server: Msg 1105, Level 17, State 2, Line
1" shows up.
I tried to create a new filegroup but the error message is the same. There
is disk space. Could someone help me ? Thanks !
Pre-allocate storage. Expand the size of the file. Don't rely on auto-grow (as you have just
noticed).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:D7E3B5B7-4EEF-4926-B101-6C40E0EDF713@.microsoft.com...
> There is a Primary Filegroup with 5 datafiles and 2 logfiles. I'm trying to
> add more datafiles, but the error "Server: Msg 1105, Level 17, State 2, Line
> 1" shows up.
> I tried to create a new filegroup but the error message is the same. There
> is disk space. Could someone help me ? Thanks !
|||How can I pre-allocate storage. There is space on disk. I tried to create a
new data with 1Mb and no success.
"Tibor Karaszi" wrote:

> Pre-allocate storage. Expand the size of the file. Don't rely on auto-grow (as you have just
> noticed).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:D7E3B5B7-4EEF-4926-B101-6C40E0EDF713@.microsoft.com...
>
|||If you want to do in EM, right-click database, properties, data files, mark the mdf file and enter a
bigger size for the file. If you want to use TSQL directly, check out ALTER DATABASE... MODIFY FILE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:A840434E-5867-4718-A89A-042427BB34F6@.microsoft.com...[vbcol=seagreen]
> How can I pre-allocate storage. There is space on disk. I tried to create a
> new data with 1Mb and no success.
> "Tibor Karaszi" wrote:
|||ok, but I don't want increase the size I want add a new data file. The
problem is add a new data file or filegroup. I tried do it on EM and TSQL,
but no success.
"Tibor Karaszi" wrote:

> If you want to do in EM, right-click database, properties, data files, mark the mdf file and enter a
> bigger size for the file. If you want to use TSQL directly, check out ALTER DATABASE... MODIFY FILE.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:A840434E-5867-4718-A89A-042427BB34F6@.microsoft.com...
>
|||I see. Can you post the TSQL command you tried and the exact error message returned?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:C02C5DFA-32EA-4418-ACD1-361B7BDAF9B2@.microsoft.com...[vbcol=seagreen]
> ok, but I don't want increase the size I want add a new data file. The
> problem is add a new data file or filegroup. I tried do it on EM and TSQL,
> but no success.
> "Tibor Karaszi" wrote:
|||Hi !
the command:
ALTER DATABASE NetSys
ADD FILEGROUP SECOND
GO
ALTER DATABASE NetSys
ADD FILE
( NAME = NetSys10,
FILENAME = 'e:\Data\NETSYS10.NDF',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)
( NAME = NetSys08,
FILENAME = 'e:\Data\dbNETSYS08.NDF',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)
TO FILEGROUP SECOND
I tried today again and the command was successfull. thanks for you help.
"Tibor Karaszi" wrote:

> I see. Can you post the TSQL command you tried and the exact error message returned?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:C02C5DFA-32EA-4418-ACD1-361B7BDAF9B2@.microsoft.com...
>

Could not allocate space for object

There is a Primary Filegroup with 5 datafiles and 2 logfiles. I'm trying to
add more datafiles, but the error "Server: Msg 1105, Level 17, State 2, Line
1" shows up.
I tried to create a new filegroup but the error message is the same. There
is disk space. Could someone help me ? Thanks !Pre-allocate storage. Expand the size of the file. Don't rely on auto-grow (
as you have just
noticed).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:D7E3B5B7-4EEF-4926-B101-6C40E0EDF713@.microsoft.com...
> There is a Primary Filegroup with 5 datafiles and 2 logfiles. I'm trying t
o
> add more datafiles, but the error "Server: Msg 1105, Level 17, State 2, Li
ne
> 1" shows up.
> I tried to create a new filegroup but the error message is the same. There
> is disk space. Could someone help me ? Thanks !|||How can I pre-allocate storage. There is space on disk. I tried to create a
new data with 1Mb and no success.
"Tibor Karaszi" wrote:

> Pre-allocate storage. Expand the size of the file. Don't rely on auto-grow
(as you have just
> noticed).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:D7E3B5B7-4EEF-4926-B101-6C40E0EDF713@.microsoft.com...
>|||If you want to do in EM, right-click database, properties, data files, mark
the mdf file and enter a
bigger size for the file. If you want to use TSQL directly, check out ALTER
DATABASE... MODIFY FILE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:A840434E-5867-4718-A89A-042427BB34F6@.microsoft.com...[vbcol=seagreen]
> How can I pre-allocate storage. There is space on disk. I tried to create
a
> new data with 1Mb and no success.
> "Tibor Karaszi" wrote:
>|||ok, but I don't want increase the size I want add a new data file. The
problem is add a new data file or filegroup. I tried do it on EM and TSQL,
but no success.
"Tibor Karaszi" wrote:

> If you want to do in EM, right-click database, properties, data files, mar
k the mdf file and enter a
> bigger size for the file. If you want to use TSQL directly, check out ALTE
R DATABASE... MODIFY FILE.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:A840434E-5867-4718-A89A-042427BB34F6@.microsoft.com...
>|||I see. Can you post the TSQL command you tried and the exact error message r
eturned?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:C02C5DFA-32EA-4418-ACD1-361B7BDAF9B2@.microsoft.com...[vbcol=seagreen]
> ok, but I don't want increase the size I want add a new data file. The
> problem is add a new data file or filegroup. I tried do it on EM and TSQL,
> but no success.
> "Tibor Karaszi" wrote:
>|||Hi !
the command:
ALTER DATABASE NetSys
ADD FILEGROUP SECOND
GO
ALTER DATABASE NetSys
ADD FILE
( NAME = NetSys10,
FILENAME = 'e:\Data\NETSYS10.NDF',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)
( NAME = NetSys08,
FILENAME = 'e:\Data\dbNETSYS08.NDF',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)
TO FILEGROUP SECOND
I tried today again and the command was successfull. thanks for you help.
"Tibor Karaszi" wrote:

> I see. Can you post the TSQL command you tried and the exact error message
returned?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:C02C5DFA-32EA-4418-ACD1-361B7BDAF9B2@.microsoft.com...
>

Could not allocate space for object

There is a Primary Filegroup with 5 datafiles and 2 logfiles. I'm trying to
add more datafiles, but the error "Server: Msg 1105, Level 17, State 2, Line
1" shows up.
I tried to create a new filegroup but the error message is the same. There
is disk space. Could someone help me ? Thanks !Pre-allocate storage. Expand the size of the file. Don't rely on auto-grow (as you have just
noticed).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:D7E3B5B7-4EEF-4926-B101-6C40E0EDF713@.microsoft.com...
> There is a Primary Filegroup with 5 datafiles and 2 logfiles. I'm trying to
> add more datafiles, but the error "Server: Msg 1105, Level 17, State 2, Line
> 1" shows up.
> I tried to create a new filegroup but the error message is the same. There
> is disk space. Could someone help me ? Thanks !|||How can I pre-allocate storage. There is space on disk. I tried to create a
new data with 1Mb and no success.
"Tibor Karaszi" wrote:
> Pre-allocate storage. Expand the size of the file. Don't rely on auto-grow (as you have just
> noticed).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:D7E3B5B7-4EEF-4926-B101-6C40E0EDF713@.microsoft.com...
> > There is a Primary Filegroup with 5 datafiles and 2 logfiles. I'm trying to
> > add more datafiles, but the error "Server: Msg 1105, Level 17, State 2, Line
> > 1" shows up.
> > I tried to create a new filegroup but the error message is the same. There
> > is disk space. Could someone help me ? Thanks !
>|||If you want to do in EM, right-click database, properties, data files, mark the mdf file and enter a
bigger size for the file. If you want to use TSQL directly, check out ALTER DATABASE... MODIFY FILE.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:A840434E-5867-4718-A89A-042427BB34F6@.microsoft.com...
> How can I pre-allocate storage. There is space on disk. I tried to create a
> new data with 1Mb and no success.
> "Tibor Karaszi" wrote:
>> Pre-allocate storage. Expand the size of the file. Don't rely on auto-grow (as you have just
>> noticed).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Shima" <Shima@.discussions.microsoft.com> wrote in message
>> news:D7E3B5B7-4EEF-4926-B101-6C40E0EDF713@.microsoft.com...
>> > There is a Primary Filegroup with 5 datafiles and 2 logfiles. I'm trying to
>> > add more datafiles, but the error "Server: Msg 1105, Level 17, State 2, Line
>> > 1" shows up.
>> > I tried to create a new filegroup but the error message is the same. There
>> > is disk space. Could someone help me ? Thanks !
>>|||ok, but I don't want increase the size I want add a new data file. The
problem is add a new data file or filegroup. I tried do it on EM and TSQL,
but no success.
"Tibor Karaszi" wrote:
> If you want to do in EM, right-click database, properties, data files, mark the mdf file and enter a
> bigger size for the file. If you want to use TSQL directly, check out ALTER DATABASE... MODIFY FILE.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:A840434E-5867-4718-A89A-042427BB34F6@.microsoft.com...
> > How can I pre-allocate storage. There is space on disk. I tried to create a
> > new data with 1Mb and no success.
> >
> > "Tibor Karaszi" wrote:
> >
> >> Pre-allocate storage. Expand the size of the file. Don't rely on auto-grow (as you have just
> >> noticed).
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> >> news:D7E3B5B7-4EEF-4926-B101-6C40E0EDF713@.microsoft.com...
> >> > There is a Primary Filegroup with 5 datafiles and 2 logfiles. I'm trying to
> >> > add more datafiles, but the error "Server: Msg 1105, Level 17, State 2, Line
> >> > 1" shows up.
> >> > I tried to create a new filegroup but the error message is the same. There
> >> > is disk space. Could someone help me ? Thanks !
> >>
> >>
>|||I see. Can you post the TSQL command you tried and the exact error message returned?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:C02C5DFA-32EA-4418-ACD1-361B7BDAF9B2@.microsoft.com...
> ok, but I don't want increase the size I want add a new data file. The
> problem is add a new data file or filegroup. I tried do it on EM and TSQL,
> but no success.
> "Tibor Karaszi" wrote:
>> If you want to do in EM, right-click database, properties, data files, mark the mdf file and
>> enter a
>> bigger size for the file. If you want to use TSQL directly, check out ALTER DATABASE... MODIFY
>> FILE.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Shima" <Shima@.discussions.microsoft.com> wrote in message
>> news:A840434E-5867-4718-A89A-042427BB34F6@.microsoft.com...
>> > How can I pre-allocate storage. There is space on disk. I tried to create a
>> > new data with 1Mb and no success.
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> Pre-allocate storage. Expand the size of the file. Don't rely on auto-grow (as you have just
>> >> noticed).
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >> Blog: http://solidqualitylearning.com/blogs/tibor/
>> >>
>> >>
>> >> "Shima" <Shima@.discussions.microsoft.com> wrote in message
>> >> news:D7E3B5B7-4EEF-4926-B101-6C40E0EDF713@.microsoft.com...
>> >> > There is a Primary Filegroup with 5 datafiles and 2 logfiles. I'm trying to
>> >> > add more datafiles, but the error "Server: Msg 1105, Level 17, State 2, Line
>> >> > 1" shows up.
>> >> > I tried to create a new filegroup but the error message is the same. There
>> >> > is disk space. Could someone help me ? Thanks !
>> >>
>> >>
>>|||Hi !
the command:
ALTER DATABASE NetSys
ADD FILEGROUP SECOND
GO
ALTER DATABASE NetSys
ADD FILE
( NAME = NetSys10,
FILENAME = 'e:\Data\NETSYS10.NDF',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)
( NAME = NetSys08,
FILENAME = 'e:\Data\dbNETSYS08.NDF',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)
TO FILEGROUP SECOND
I tried today again and the command was successfull. thanks for you help.
"Tibor Karaszi" wrote:
> I see. Can you post the TSQL command you tried and the exact error message returned?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:C02C5DFA-32EA-4418-ACD1-361B7BDAF9B2@.microsoft.com...
> > ok, but I don't want increase the size I want add a new data file. The
> > problem is add a new data file or filegroup. I tried do it on EM and TSQL,
> > but no success.
> >
> > "Tibor Karaszi" wrote:
> >
> >> If you want to do in EM, right-click database, properties, data files, mark the mdf file and
> >> enter a
> >> bigger size for the file. If you want to use TSQL directly, check out ALTER DATABASE... MODIFY
> >> FILE.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> >> news:A840434E-5867-4718-A89A-042427BB34F6@.microsoft.com...
> >> > How can I pre-allocate storage. There is space on disk. I tried to create a
> >> > new data with 1Mb and no success.
> >> >
> >> > "Tibor Karaszi" wrote:
> >> >
> >> >> Pre-allocate storage. Expand the size of the file. Don't rely on auto-grow (as you have just
> >> >> noticed).
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >> >>
> >> >>
> >> >> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> >> >> news:D7E3B5B7-4EEF-4926-B101-6C40E0EDF713@.microsoft.com...
> >> >> > There is a Primary Filegroup with 5 datafiles and 2 logfiles. I'm trying to
> >> >> > add more datafiles, but the error "Server: Msg 1105, Level 17, State 2, Line
> >> >> > 1" shows up.
> >> >> > I tried to create a new filegroup but the error message is the same. There
> >> >> > is disk space. Could someone help me ? Thanks !
> >> >>
> >> >>
> >>
> >>
>

Could not allocate new page for database TEMPDB.

I tried to create a new table in VIEW to accomplish some urgent work and I have received the following message:

Server: Msg 1101, Level 17, State 10, Line 1
Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth.

It should be recognized that the MS SQL Server performance is slower than before. What files the TEMPDB contains, which need to be cleared from time to time, and how can I solve this above mentioned matter.
Thank you.Hi,

execute following statment;
use tempdb
go
sp_helpfile

If growth is set to 0 (Zero), your tempdb can't allocate more space. See books online to read how to change growth and how to allocate.

/Mada|||Thank you !!
I will try to use it and I will search for books online to have the solution.

Best regards.