hay everybody,
i am using crystal report version 7.the no. of records in it is 4000.when i take the report it will close automatically.do anyone of u know the maximum capacity of crystal reprt.please help me.It is much higher than 4000. I run reports with 100000+ records every day. Make sure you have enough system RAM for yoyr reports. What are your system requirements?|||and how are you calling that report thru Frond End?
Showing posts with label version. Show all posts
Showing posts with label version. Show all posts
Monday, March 19, 2012
Monday, February 13, 2012
Attaching Database 'AdventureWorks'
Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
Steve
IT Developer
You have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:290AD911-24FA-419B-8A26-636CC009B189@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
Steve
IT Developer
You have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:290AD911-24FA-419B-8A26-636CC009B189@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>
Attaching Database 'AdventureWorks'
Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
Steve
IT Developer
You have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F507C579-89CA-40F4-BC9A-F0233C2B7F08@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
Steve
IT Developer
You have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F507C579-89CA-40F4-BC9A-F0233C2B7F08@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>
Attaching Database 'AdventureWorks'
Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
--
Steve
IT DeveloperYou have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F507C579-89CA-40F4-BC9A-F0233C2B7F08@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
--
Steve
IT DeveloperYou have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F507C579-89CA-40F4-BC9A-F0233C2B7F08@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>
Attaching Database 'AdventureWorks'
Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following erro
r.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
--
Steve
IT DeveloperYou have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F507C579-89CA-40F4-BC9A-F0233C2B7F08@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following erro
r.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
--
Steve
IT DeveloperYou have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F507C579-89CA-40F4-BC9A-F0233C2B7F08@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>
Attaching an SQL .MDF file to an MSDE Instance
I have installed an instance of MSDE. I have a full version of SQLServer2000 and have created all of the procs, etc. and have detached the .mdf file from the full version of SQLServer2000. How do I attach the tables, procs, etc in the MDF file to the MSDE instance?Hi,
Login to SQL Server using OSQL and use sp_attch_db store procedure to attach
the database.
Thanks
Hari
MCDBA
"Tom Buchanan" <thomasfbuchanan@.hotmail.com> wrote in message
news:46FB74F5-46C5-4379-A640-C0F71124D135@.microsoft.com...
> I have installed an instance of MSDE. I have a full version of
SQLServer2000 and have created all of the procs, etc. and have detached the
.mdf file from the full version of SQLServer2000. How do I attach the
tables, procs, etc in the MDF file to the MSDE instance?
Login to SQL Server using OSQL and use sp_attch_db store procedure to attach
the database.
Thanks
Hari
MCDBA
"Tom Buchanan" <thomasfbuchanan@.hotmail.com> wrote in message
news:46FB74F5-46C5-4379-A640-C0F71124D135@.microsoft.com...
> I have installed an instance of MSDE. I have a full version of
SQLServer2000 and have created all of the procs, etc. and have detached the
.mdf file from the full version of SQLServer2000. How do I attach the
tables, procs, etc in the MDF file to the MSDE instance?
Subscribe to:
Posts (Atom)