No longer able to open up .rptproj

My visual studio .net application previously had not problem opening .rptroj
files, but now it tells me "Make sure the application for the project type
(.rptproj) is installed"
Also, when I try to create a new project, the "Business Intelligence"
project type is not listed. I have seen some suggestions on line about
removing msatinterop.dll from the PrivateAssemblies directory but this does
not change a thing for me.Try running VS from the command line with the /resetskippkgs switch. That
should do the trick. Your command would look something like:
C:\>cd C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE\
C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE>devenv
/resetskipkgs
This is assuming you have RS installed to the default directory. You would
obviously have to find where the devenv.exe file is in order to run the file.
"DBA72" wrote:
> My visual studio .net application previously had not problem opening .rptroj
> files, but now it tells me "Make sure the application for the project type
> (.rptproj) is installed"
> Also, when I try to create a new project, the "Business Intelligence"
> project type is not listed. I have seen some suggestions on line about
> removing msatinterop.dll from the PrivateAssemblies directory but this does
> not change a thing for me.|||Running devenv didn't work for me, but reinstalling MRS with the Report
Designer component checked did. Good Luck.
Bassist695 wrote:
> Try running VS from the command line with the /resetskippkgs switch.
That
> should do the trick. Your command would look something like:
> C:\>cd C:\Program Files\Microsoft Visual Studio .NET
2003\Common7\IDE\
> C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE>devenv
> /resetskipkgs
> This is assuming you have RS installed to the default directory. You
would
> obviously have to find where the devenv.exe file is in order to run
the file.
>
> "DBA72" wrote:
> > My visual studio .net application previously had not problem
opening .rptroj
> > files, but now it tells me "Make sure the application for the
project type
> > (.rptproj) is installed"
> >
> > Also, when I try to create a new project, the "Business
Intelligence"
> > project type is not listed. I have seen some suggestions on line
about
> > removing msatinterop.dll from the PrivateAssemblies directory but
this does
> > not change a thing for me.|||I solved this problem by reinstalling reporting services. I tried
running devenv.exe to no avail. On the default install for RS it
leaves the Report Designer unchecked. When you reinstall (or repair)
make sure this component is checked and it should solve the problem.
Bassist695 wrote:
> Try running VS from the command line with the /resetskippkgs switch.
That
> should do the trick. Your command would look something like:
> C:\>cd C:\Program Files\Microsoft Visual Studio .NET
2003\Common7\IDE\
> C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE>devenv
> /resetskipkgs
> This is assuming you have RS installed to the default directory. You
would
> obviously have to find where the devenv.exe file is in order to run
the file.
>
> "DBA72" wrote:
> > My visual studio .net application previously had not problem
opening .rptroj
> > files, but now it tells me "Make sure the application for the
project type
> > (.rptproj) is installed"
> >
> > Also, when I try to create a new project, the "Business
Intelligence"
> > project type is not listed. I have seen some suggestions on line
about
> > removing msatinterop.dll from the PrivateAssemblies directory but
this does
> > not change a thing for me.sql

Nixing a Transaction Log

Is it possible to nix a transaction log without backing it
up? My disk is not large enought to back it up and the
snapshot agent continually tells me that there is not
enough space (error 112) although I have 5GB Free on the
array.
Sql 2k
daveWe were just having this same issue - and did this.
With nobody in the DB - so you are sure that no log
activity is going on.
Not sure it's the safest thing to do...
In query analyzer do BACKUP LOG dbname WITH TRUNCATE_ONLY
Them back to Enterprise Manager - right click on DB - all
tasks - SHRINK FILES - click on the FILES cmd button -
choose the log file from the drop down and press OK /
then press CANCEL when you get back to the SHRINK FILES
dialog box.
This dropped the size of the log file to 1024 k
MS KB article give you different (but similar steps):
http://support.microsoft.com/default.aspx?scid=kb;en-
us;272318
>--Original Message--
>Is it possible to nix a transaction log without backing
it
>up? My disk is not large enought to back it up and the
>snapshot agent continually tells me that there is not
>enough space (error 112) although I have 5GB Free on the
>array.
>Sql 2k
>dave
>.
>|||Thanks! That totally helped out in the biggest way!!!
Dave
>--Original Message--
>We were just having this same issue - and did this.
>With nobody in the DB - so you are sure that no log
>activity is going on.
>Not sure it's the safest thing to do...
>In query analyzer do BACKUP LOG dbname WITH TRUNCATE_ONLY
>Them back to Enterprise Manager - right click on DB - all
>tasks - SHRINK FILES - click on the FILES cmd button -
>choose the log file from the drop down and press OK /
>then press CANCEL when you get back to the SHRINK FILES
>dialog box.
>This dropped the size of the log file to 1024 k
>MS KB article give you different (but similar steps):
>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;272318
>>--Original Message--
>>Is it possible to nix a transaction log without backing
>it
>>up? My disk is not large enought to back it up and the
>>snapshot agent continually tells me that there is not
>>enough space (error 112) although I have 5GB Free on the
>>array.
>>Sql 2k
>>dave
>>.
>.
>

Newbie:preparation to reindex SQL db

Hello,
A third-party vendor tells me a SQL db contains various errors and suggests
that I 'reindex' the db.
I see that I can go to SQL Query Analyzer, pick the db I need and run
DBCC DBREINDEX
Question is this, what's the implication of running this without specifying
a specific table ? Is that alright run this on the 'entire' database ?> Question is this, what's the implication of running this without
> specifying
> a specific table ? Is that alright run this on the 'entire' database ?
How large is the database? What is your tolerance for downtime?
I would make a backup of the database, restore it on another server, and
test out the reindex there. Not only will you get an idea of time/CPU/I/O
requirements, you will also be able to test how your application(s) will
work against it during the reindexing of the tables.
My guess is that in the long run you'll want to break up the operation into
smaller chunks (e.g. one or two tables at a time). But it's tough to say
without more information specific to *your* environment. I know what I
can't do here in mine. :-)|||Hi,
DBCC DBREINDEX will recreate the Index, But for identifying errors you need
to execute either DBCC CHECKDB or DBCC CHECKTABLE commands.
Once you identify the errors you need to execute DBCC CHECKDB with
REPAIR_REBUILD to clear the errors.
DBCC DBREINDEX can be used to remove the fragmentation in your table and
this command will lock your table. Due to this you can execute this command
only offline. So check your vendor whether to exeecute DBCC CHECKDB or
REINDEX.
Thanks
Hari
SQL Server MVP
"Magoo" <magoo-nospam@.hotmail.com> wrote in message
news:usGs49MUFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hello,
> A third-party vendor tells me a SQL db contains various errors and
suggests
> that I 'reindex' the db.
> I see that I can go to SQL Query Analyzer, pick the db I need and run
> DBCC DBREINDEX
> Question is this, what's the implication of running this without
specifying
> a specific table ? Is that alright run this on the 'entire' database ?
>|||What errors exactly did this vendor say you had in the database?
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:udIZZpRUFHA.2124@.TK2MSFTNGP14.phx.gbl...
> Hi,
> DBCC DBREINDEX will recreate the Index, But for identifying errors you
need
> to execute either DBCC CHECKDB or DBCC CHECKTABLE commands.
> Once you identify the errors you need to execute DBCC CHECKDB with
> REPAIR_REBUILD to clear the errors.
> DBCC DBREINDEX can be used to remove the fragmentation in your table and
> this command will lock your table. Due to this you can execute this
command
> only offline. So check your vendor whether to exeecute DBCC CHECKDB or
> REINDEX.
> Thanks
> Hari
> SQL Server MVP
> "Magoo" <magoo-nospam@.hotmail.com> wrote in message
> news:usGs49MUFHA.3280@.TK2MSFTNGP09.phx.gbl...
> suggests
> specifying
>

Newbie:preparation to reindex SQL db

Hello,
A third-party vendor tells me a SQL db contains various errors and suggests
that I 'reindex' the db.
I see that I can go to SQL Query Analyzer, pick the db I need and run
DBCC DBREINDEX
Question is this, what's the implication of running this without specifying
a specific table ? Is that alright run this on the 'entire' database ?> Question is this, what's the implication of running this without
> specifying
> a specific table ? Is that alright run this on the 'entire' database ?
How large is the database? What is your tolerance for downtime?
I would make a backup of the database, restore it on another server, and
test out the reindex there. Not only will you get an idea of time/CPU/I/O
requirements, you will also be able to test how your application(s) will
work against it during the reindexing of the tables.
My guess is that in the long run you'll want to break up the operation into
smaller chunks (e.g. one or two tables at a time). But it's tough to say
without more information specific to *your* environment. I know what I
can't do here in mine. :-)|||Hi,
DBCC DBREINDEX will recreate the Index, But for identifying errors you need
to execute either DBCC CHECKDB or DBCC CHECKTABLE commands.
Once you identify the errors you need to execute DBCC CHECKDB with
REPAIR_REBUILD to clear the errors.
DBCC DBREINDEX can be used to remove the fragmentation in your table and
this command will lock your table. Due to this you can execute this command
only offline. So check your vendor whether to exeecute DBCC CHECKDB or
REINDEX.
Thanks
Hari
SQL Server MVP
"Magoo" <magoo-nospam@.hotmail.com> wrote in message
news:usGs49MUFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hello,
> A third-party vendor tells me a SQL db contains various errors and
suggests
> that I 'reindex' the db.
> I see that I can go to SQL Query Analyzer, pick the db I need and run
> DBCC DBREINDEX
> Question is this, what's the implication of running this without
specifying
> a specific table ? Is that alright run this on the 'entire' database ?
>|||What errors exactly did this vendor say you had in the database?
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:udIZZpRUFHA.2124@.TK2MSFTNGP14.phx.gbl...
> Hi,
> DBCC DBREINDEX will recreate the Index, But for identifying errors you
need
> to execute either DBCC CHECKDB or DBCC CHECKTABLE commands.
> Once you identify the errors you need to execute DBCC CHECKDB with
> REPAIR_REBUILD to clear the errors.
> DBCC DBREINDEX can be used to remove the fragmentation in your table and
> this command will lock your table. Due to this you can execute this
command
> only offline. So check your vendor whether to exeecute DBCC CHECKDB or
> REINDEX.
> Thanks
> Hari
> SQL Server MVP
> "Magoo" <magoo-nospam@.hotmail.com> wrote in message
> news:usGs49MUFHA.3280@.TK2MSFTNGP09.phx.gbl...
> > Hello,
> >
> > A third-party vendor tells me a SQL db contains various errors and
> suggests
> > that I 'reindex' the db.
> >
> > I see that I can go to SQL Query Analyzer, pick the db I need and run
> > DBCC DBREINDEX
> >
> > Question is this, what's the implication of running this without
> specifying
> > a specific table ? Is that alright run this on the 'entire' database ?
> >
> >
>

Newbie:preparation to reindex SQL db

Hello,
A third-party vendor tells me a SQL db contains various errors and suggests
that I 'reindex' the db.
I see that I can go to SQL Query Analyzer, pick the db I need and run
DBCC DBREINDEX
Question is this, what's the implication of running this without specifying
a specific table ? Is that alright run this on the 'entire' database ?
> Question is this, what's the implication of running this without
> specifying
> a specific table ? Is that alright run this on the 'entire' database ?
How large is the database? What is your tolerance for downtime?
I would make a backup of the database, restore it on another server, and
test out the reindex there. Not only will you get an idea of time/CPU/I/O
requirements, you will also be able to test how your application(s) will
work against it during the reindexing of the tables.
My guess is that in the long run you'll want to break up the operation into
smaller chunks (e.g. one or two tables at a time). But it's tough to say
without more information specific to *your* environment. I know what I
can't do here in mine. :-)
|||Hi,
DBCC DBREINDEX will recreate the Index, But for identifying errors you need
to execute either DBCC CHECKDB or DBCC CHECKTABLE commands.
Once you identify the errors you need to execute DBCC CHECKDB with
REPAIR_REBUILD to clear the errors.
DBCC DBREINDEX can be used to remove the fragmentation in your table and
this command will lock your table. Due to this you can execute this command
only offline. So check your vendor whether to exeecute DBCC CHECKDB or
REINDEX.
Thanks
Hari
SQL Server MVP
"Magoo" <magoo-nospam@.hotmail.com> wrote in message
news:usGs49MUFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hello,
> A third-party vendor tells me a SQL db contains various errors and
suggests
> that I 'reindex' the db.
> I see that I can go to SQL Query Analyzer, pick the db I need and run
> DBCC DBREINDEX
> Question is this, what's the implication of running this without
specifying
> a specific table ? Is that alright run this on the 'entire' database ?
>
|||What errors exactly did this vendor say you had in the database?
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:udIZZpRUFHA.2124@.TK2MSFTNGP14.phx.gbl...
> Hi,
> DBCC DBREINDEX will recreate the Index, But for identifying errors you
need
> to execute either DBCC CHECKDB or DBCC CHECKTABLE commands.
> Once you identify the errors you need to execute DBCC CHECKDB with
> REPAIR_REBUILD to clear the errors.
> DBCC DBREINDEX can be used to remove the fragmentation in your table and
> this command will lock your table. Due to this you can execute this
command
> only offline. So check your vendor whether to exeecute DBCC CHECKDB or
> REINDEX.
> Thanks
> Hari
> SQL Server MVP
> "Magoo" <magoo-nospam@.hotmail.com> wrote in message
> news:usGs49MUFHA.3280@.TK2MSFTNGP09.phx.gbl...
> suggests
> specifying
>