sql record counts: sql2000

Showing posts with label sql2000. Show all posts

Sunday, March 25, 2012

difference between 'Backup' and DB maint. plan backup?

hi.
ive not setup any backups under 'Management' -> 'Backup' on my SQL2000 box.
instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
is setting up a backup using a maintenance plan the same as setting up a
full backup under the 'Backup' tab?
thanks.Hi,
Backup tab is just creating the Logical Backup device. What you are doing is
exacltly the right procedure to take Full database
and Transaction log backup.
Looks like you are performing backup only for non system database backup,
But i recomend you to do the backup for all the system
databases as well. This will help you in the eve of crash.
Thanks
Hari
SQL Server MVP
"mb" <mb@.discussions.microsoft.com> wrote in message
news:C67C8B52-07C6-40D0-A722-2BCE97582372@.microsoft.com...
> hi.
> ive not setup any backups under 'Management' -> 'Backup' on my SQL2000
> box.
> instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
> under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
> is setting up a backup using a maintenance plan the same as setting up a
> full backup under the 'Backup' tab?
> thanks.|||hmm, yes, but i dont believe i have the option of 'remove inactive entries
from transaction log' when creating transaction logs from the maintenance
plans. true?
"Hari Prasad" wrote:
> Hi,
> Backup tab is just creating the Logical Backup device. What you are doing is
> exacltly the right procedure to take Full database
> and Transaction log backup.
> Looks like you are performing backup only for non system database backup,
> But i recomend you to do the backup for all the system
> databases as well. This will help you in the eve of crash.
> Thanks
> Hari
> SQL Server MVP
>
>
> "mb" <mb@.discussions.microsoft.com> wrote in message
> news:C67C8B52-07C6-40D0-A722-2BCE97582372@.microsoft.com...
> > hi.
> >
> > ive not setup any backups under 'Management' -> 'Backup' on my SQL2000
> > box.
> > instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
> > under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
> >
> > is setting up a backup using a maintenance plan the same as setting up a
> > full backup under the 'Backup' tab?
> >
> > thanks.
>
>|||Btw, I've written an article about this:
http://www.karaszi.com/SQLServer/info_restore_no_truncate.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mb" <mb@.discussions.microsoft.com> wrote in message
news:5E78EC73-4EBA-4DAD-836E-3EBAD9D3BFA8@.microsoft.com...
> hmm, yes, but i dont believe i have the option of 'remove inactive entries
> from transaction log' when creating transaction logs from the maintenance
> plans. true?
> "Hari Prasad" wrote:
>> Hi,
>> Backup tab is just creating the Logical Backup device. What you are doing is
>> exacltly the right procedure to take Full database
>> and Transaction log backup.
>> Looks like you are performing backup only for non system database backup,
>> But i recomend you to do the backup for all the system
>> databases as well. This will help you in the eve of crash.
>> Thanks
>> Hari
>> SQL Server MVP
>>
>>
>> "mb" <mb@.discussions.microsoft.com> wrote in message
>> news:C67C8B52-07C6-40D0-A722-2BCE97582372@.microsoft.com...
>> > hi.
>> >
>> > ive not setup any backups under 'Management' -> 'Backup' on my SQL2000
>> > box.
>> > instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
>> > under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
>> >
>> > is setting up a backup using a maintenance plan the same as setting up a
>> > full backup under the 'Backup' tab?
>> >
>> > thanks.
>>|||Maint plan will not add the NO_TRUNCATE option for the backup log command. This option is what
empties the log and when you uncheck in the backup dialog, this option is added. Terrible GUI design
in the backup dialog (not maint wiz) IMO, and this option has a very special purpose and is only
used for disaster scenarios.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mb" <mb@.discussions.microsoft.com> wrote in message
news:5E78EC73-4EBA-4DAD-836E-3EBAD9D3BFA8@.microsoft.com...
> hmm, yes, but i dont believe i have the option of 'remove inactive entries
> from transaction log' when creating transaction logs from the maintenance
> plans. true?
> "Hari Prasad" wrote:
>> Hi,
>> Backup tab is just creating the Logical Backup device. What you are doing is
>> exacltly the right procedure to take Full database
>> and Transaction log backup.
>> Looks like you are performing backup only for non system database backup,
>> But i recomend you to do the backup for all the system
>> databases as well. This will help you in the eve of crash.
>> Thanks
>> Hari
>> SQL Server MVP
>>
>>
>> "mb" <mb@.discussions.microsoft.com> wrote in message
>> news:C67C8B52-07C6-40D0-A722-2BCE97582372@.microsoft.com...
>> > hi.
>> >
>> > ive not setup any backups under 'Management' -> 'Backup' on my SQL2000
>> > box.
>> > instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
>> > under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
>> >
>> > is setting up a backup using a maintenance plan the same as setting up a
>> > full backup under the 'Backup' tab?
>> >
>> > thanks.
>>

difference between 'Backup' and DB maint. plan backup?

Wednesday, March 21, 2012

Diff Backups - Urgent pls help

I have a full Backup and a diff backup on a SQL 7 database
I have restored the full backup with NORECOVERY option sucessfully in a SQL
2000 server
When i try to restore the diff backups its gives me a error
Server: Msg 3136, Level 16, State 1, Line 1
Cannot apply the backup on device 'Z:\MS SQL
SERVER\Backup\AVAWEB\AVAWEB_DIFF_20050111_203101.b ak' to database 'AVAWEB'.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
-- Here is the command i am running
RESTORE DATABASE AVAWEB
FROM DISK = 'Z:\MS SQL SERVER\Backup\AVAWEB\AVAWEB_DIFF_20050111_203101.b ak'
WITH FILE=1, NORECOVERY,
MOVE 'AvaWeb_Data' to 'Z:\MS SQL SERVER\data\avaweb_data.mdf',
MOVE 'AvaWeb_Log' to 'Z:\MS SQL SERVER\log\avaweb_log.ldf'
Are you certain that you didn't perform a database backup between that db backup and the diff backup
you are trying to restore. I'd check in the backup history tables in msdb just to be certain.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:F22E8045-3B2D-429C-BB59-754079897F49@.microsoft.com...
>I have a full Backup and a diff backup on a SQL 7 database
> I have restored the full backup with NORECOVERY option sucessfully in a SQL
> 2000 server
> When i try to restore the diff backups its gives me a error
> Server: Msg 3136, Level 16, State 1, Line 1
> Cannot apply the backup on device 'Z:\MS SQL
> SERVER\Backup\AVAWEB\AVAWEB_DIFF_20050111_203101.b ak' to database 'AVAWEB'.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> -- Here is the command i am running
> RESTORE DATABASE AVAWEB
> FROM DISK = 'Z:\MS SQL SERVER\Backup\AVAWEB\AVAWEB_DIFF_20050111_203101.b ak'
> WITH FILE=1, NORECOVERY,
> MOVE 'AvaWeb_Data' to 'Z:\MS SQL SERVER\data\avaweb_data.mdf',
> MOVE 'AvaWeb_Log' to 'Z:\MS SQL SERVER\log\avaweb_log.ldf'
>
sql

Diff Backups - Urgent pls help

I have a full Backup and a diff backup on a SQL 7 database
I have restored the full backup with NORECOVERY option sucessfully in a SQL
2000 server
When i try to restore the diff backups its gives me a error
Server: Msg 3136, Level 16, State 1, Line 1
Cannot apply the backup on device 'Z:\MS SQL
SERVER\Backup\AVAWEB\AVAWEB_DIFF_2005011
1_203101.bak' to database 'AVAWEB'.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
-- Here is the command i am running
RESTORE DATABASE AVAWEB
FROM DISK = 'Z:\MS SQL SERVER\Backup\AVAWEB\AVAWEB_DIFF_2005011
1_203101.bak'
WITH FILE=1, NORECOVERY,
MOVE 'AvaWeb_Data' to 'Z:\MS SQL SERVER\data\avaweb_data.mdf',
MOVE 'AvaWeb_Log' to 'Z:\MS SQL SERVER\log\avaweb_log.ldf'Are you certain that you didn't perform a database backup between that db ba
ckup and the diff backup
you are trying to restore. I'd check in the backup history tables in msdb ju
st to be certain.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:F22E8045-3B2D-429C-BB59-754079897F49@.microsoft.com...
>I have a full Backup and a diff backup on a SQL 7 database
> I have restored the full backup with NORECOVERY option sucessfully in a SQ
L
> 2000 server
> When i try to restore the diff backups its gives me a error
> Server: Msg 3136, Level 16, State 1, Line 1
> Cannot apply the backup on device 'Z:\MS SQL
> SERVER\Backup\AVAWEB\AVAWEB_DIFF_2005011
1_203101.bak' to database 'AVAWEB'
.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> -- Here is the command i am running
> RESTORE DATABASE AVAWEB
> FROM DISK = 'Z:\MS SQL SERVER\Backup\AVAWEB\AVAWEB_DIFF_2005011
1_203101.ba
k'
> WITH FILE=1, NORECOVERY,
> MOVE 'AvaWeb_Data' to 'Z:\MS SQL SERVER\data\avaweb_data.mdf',
> MOVE 'AvaWeb_Log' to 'Z:\MS SQL SERVER\log\avaweb_log.ldf'
>

Diff b/w executing as Stored Procedure and Script

Hi All,
I have a peculiar problem with SQL2000. When i execute a Stored procedure in Demo & Production i get different outputs. But i copied the business logistics from the Sp and executed as a script in both the servers. Now Both the records are same.

I WANT TO KNOW " WHETHER THERE IS ANY DIFFERENCE IN EXECUTION METHODOLOGY BETWEEN STORED PROCEDURE AND QUERY".

NOTE: My stored procedure has 14 executable scripts. Upto 10 scripts no date comparisons were made. But at the 11th script the records differ.

I DOUBT WHETHER THERE WILL BE ANY DATE RELATED ISSUE WHEN EXECUTING AS STORED PROCEDURE AND SCRIPT

Hi,

There is no date related issue for a stored procedure to execute as for as I know. the diffrence between the stored proceudre and the script is the execution plan and the compiling time. remember some time in stored procedure might return the cached data. If possible try to start and stop the DB and then try to execute in both they day.

Might be some thing wrong in the quries in SP and the script which youa re running.

Take a look.

Mohan

|||

Hi Mohan,

Thanks for your reply. There is no chance for error in the script. How i say this bcoz " When i am running the script and the queries in the demo server i get the same result. So only i am very sure about that. Anyway you have given me a new Information. I shall take the necessary steps.

The DIFFERENCE occurs only in PRODUCTION server.

Monday, March 19, 2012

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia Pupo
I think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>
|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll[vbcol=seagreen]
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows
>

Diagrams Problem

HI
i have installed VisualStudio Sp6 after this installation when open my Sql
2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
don't work.
I reinstalled Sql Sp3 but don't work.
Can help me?
Tia PupoI think I got the same problem!
I even reinstalled and reattached the full developer edition of SQL 2K.
Some diagrams show up as blank white page, often results in a crash when
trying to close diagram. Some shows boxes with table names in a very large
font and without field details or relation lines and symbols.
I did install VS SP6 a few weeks back but didn't make a connection between
the two until now.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||I tried one of the suggestions I found, and it worked I replaced mdt2df.dll
with an older version.
The version I use is 2.0.0.8958.
/Per Salmi
"Pupo" <123Star@.libero.it> skrev i meddelandet
news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
> HI
> i have installed VisualStudio Sp6 after this installation when open my Sql
> 2000 server Sp3 i can't visualize Diagrams. Any operation on this windows
> don't work.
> I reinstalled Sql Sp3 but don't work.
> Can help me?
> Tia Pupo
>|||Thanks i replace this dll and now work fine.
"Per Salmi" <per.salmi@.nospam.nospam> wrote in message
news:Obj4KZjdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> I tried one of the suggestions I found, and it worked I replaced
mdt2df.dll
> with an older version.
> The version I use is 2.0.0.8958.
> /Per Salmi
> "Pupo" <123Star@.libero.it> skrev i meddelandet
> news:%23qyM2hgdEHA.1152@.TK2MSFTNGP09.phx.gbl...
Sql[vbcol=seagreen]
windows[vbcol=seagreen]
>

Sunday, March 11, 2012

Diagrams manipulation

Hello, working on SQL2000.
I want to know if the diagrams can be exported to a format that can be
later imported to another database.
I also want to know if importing a diagram to a database, changes the
indexes, FK, etc or has nothing to do with it.
Thanks in advanceYou can certainly move the diagrams to another server
HOW TO: Move a Database Diagram
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Guillermo Casta?o A" <guillermoc74@.hotmail.com> wrote in message
news:9350d78d.0401070611.ce11d86@.posting.google.com...
> Hello, working on SQL2000.
> I want to know if the diagrams can be exported to a format that can be
> later imported to another database.
> I also want to know if importing a diagram to a database, changes the
> indexes, FK, etc or has nothing to do with it.
> Thanks in advance

diagraming databases

Are diagrams passive? What really holds the relationships between the
tables? I have to look at a legacy database in SQL2000 and the diagram does
not seem to match the behavor of the tables.
Diagrams do work if there is a relation established on the tables.
Just check if Primary Key - Foreign Key combination is correctly defined
regards
Chandra
"Rich" wrote:

> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram does
> not seem to match the behavor of the tables.
|||> Are diagrams passive?
Sort of. Possibly that EM tries to "synchronize" a diagram when you open it and you have performed
modifications in the database structure.

> What really holds the relationships between the
> tables?
Defined FOREIGN KEY constraints used in commands such as ALTER TABLE tblref ADD CONSTRAINT col
REFERENCES tblreferenced(col).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:6D4302AE-1F21-41A0-9125-AF8D6085F276@.microsoft.com...
> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram does
> not seem to match the behavor of the tables.

diagraming databases

Are diagrams passive? What really holds the relationships between the
tables? I have to look at a legacy database in SQL2000 and the diagram does
not seem to match the behavor of the tables.Diagrams do work if there is a relation established on the tables.
Just check if Primary Key - Foreign Key combination is correctly defined
regards
Chandra
"Rich" wrote:

> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram do
es
> not seem to match the behavor of the tables.|||> Are diagrams passive?
Sort of. Possibly that EM tries to "synchronize" a diagram when you open it
and you have performed
modifications in the database structure.

> What really holds the relationships between the
> tables?
Defined FOREIGN KEY constraints used in commands such as ALTER TABLE tblref
ADD CONSTRAINT col
REFERENCES tblreferenced(col).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:6D4302AE-1F21-41A0-9125-AF8D6085F276@.microsoft.com...
> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram do
es
> not seem to match the behavor of the tables.

diagraming databases

Are diagrams passive? What really holds the relationships between the
tables? I have to look at a legacy database in SQL2000 and the diagram does
not seem to match the behavor of the tables.Diagrams do work if there is a relation established on the tables.
Just check if Primary Key - Foreign Key combination is correctly defined
regards
Chandra
"Rich" wrote:
> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram does
> not seem to match the behavor of the tables.|||> Are diagrams passive?
Sort of. Possibly that EM tries to "synchronize" a diagram when you open it and you have performed
modifications in the database structure.
> What really holds the relationships between the
> tables?
Defined FOREIGN KEY constraints used in commands such as ALTER TABLE tblref ADD CONSTRAINT col
REFERENCES tblreferenced(col).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:6D4302AE-1F21-41A0-9125-AF8D6085F276@.microsoft.com...
> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram does
> not seem to match the behavor of the tables.

Wednesday, March 7, 2012

development and implementation procedures....

Hello everyone,

I am looking for some help.

I am responsible for five SQL2000 database servers. One is production, two for development, one for testing and one for development and testing of a sub-product. We also use Source safe. Although sometimes, depending on the activity going on on each of the servers, the roles of development and testing servers get interchanged.

The problem I face as a DBA is to co-ordinate with all the developers and the people testing the applications and databases. Stored procedures, triggers and schema changes are not consistent across the same database on different servers. Multiple copies of databases get created on the same server. This happens primarily because, once development has been completed, the database is moved to the testing servers. As the testing progresses and issues are resolved, the scripts are changed, etc. As there are many developers and people testing, it is just impossible to keep track of who is doing what and where the latest source code is. And especially creates a problem during implementation. Some of you may relate to this problem.

I am new in this position and would like to put a process in place where things are better organized.

If some amongst you would like to share your thoughts and experiences or what you have done at your place of work to make your life easier, I would highly appreciate it. Also, you could direct me to places where I can get some information on this subject.

Thanks in advance and apologies for this rather lengthy question.I would say make sure you are the only admin or dbcreator on the testing server (and naturally the production server).

Once you are assured of your Oz-like powers, declare that the testing server is going to be made in the image of the production server. Ideally this should happen when no one is actually testing anything.

Once you have done this, demand of the programmers that they submit scripts for their changes. These will normally consist of a few alter or create table statements, and alter/create procedure statements. It is very rare to see a large number of tables being dropped with short shrift in the course of an internal development project.

The testing server databases can be replaced by copies of the production server at any time (in some places quarterly, but more usually by request before testing a major update). Datebases are never moved from testing to production.

Only after the testing is complete, and you are assured the upgrade can be done with no errors on production, then you can run those same scripts you ran on testing before on production.

Any old-hand programmers will probably take some offense at losing privileges on testing or production, but the benefits should outweigh the complaints. Hope this helps.

Saturday, February 25, 2012

Developing for 2000 and 2005

Hi,
What are our options for developing for 2000 and 2005 "at the same time" /
on one computer.
I upgraded my local sql2000 to sql2005 and installed Visual Studio 2005 side
by side with Visual Studio 2003. Now Visual Studio 2003 cannot open Sql2000
report server projects anymore and 2005 "complains" about upgrading the
report projects. For several customers we still need to develop Sql2000
reports while other customers request Sql2005 reports.
Please advise,
ErikYou need to keep the source for the RS 2000 reports separate from the RS
2005 reports. RS 2005 will still run 2000 reports. 2000 will not run 2005
reports. 2005 Report Designer converts 2000 reports when you try to modify
them in 2005.
I took a 2000 report (I have both report designers on my machine) and I
deployed it to RS 2005.
Although 2005 is supposed to run 2000 reports I have noticed some minor
problems. For instance, if I do this:
= "Myparam1 = " & Parameters!Myparam1.Label
It doesn't like the use of label. However, if I convert the report by
bringing it into the 2005 designer, convert, redeploy the error goes away.
My suggestion is to have two report servers. One for 2000 and one for 2005.
Having both designers on one machine is not a problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Erik Tamminga" <agnimmate@.muimetca.ln_revese_the_previous> wrote in message
news:eEZs$fB7FHA.3660@.TK2MSFTNGP09.phx.gbl...
> Hi,
> What are our options for developing for 2000 and 2005 "at the same time" /
> on one computer.
> I upgraded my local sql2000 to sql2005 and installed Visual Studio 2005
> side by side with Visual Studio 2003. Now Visual Studio 2003 cannot open
> Sql2000 report server projects anymore and 2005 "complains" about
> upgrading the report projects. For several customers we still need to
> develop Sql2000 reports while other customers request Sql2005 reports.
> Please advise,
> Erik
>|||Plausible.
The upgrade of Sql2000 to Sql2005 (developer editions) on my own machine
removed Sql 2000 Report Designed and installed Sql 2005 Report Designed. I
now reinstalled the Sql 2000 Report Designed (which I didn't think was
possible).
Thanks.
Erik
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eQND1pE7FHA.268@.TK2MSFTNGP10.phx.gbl...
> You need to keep the source for the RS 2000 reports separate from the RS
> 2005 reports. RS 2005 will still run 2000 reports. 2000 will not run 2005
> reports. 2005 Report Designer converts 2000 reports when you try to modify
> them in 2005.
> I took a 2000 report (I have both report designers on my machine) and I
> deployed it to RS 2005.
> Although 2005 is supposed to run 2000 reports I have noticed some minor
> problems. For instance, if I do this:
> = "Myparam1 = " & Parameters!Myparam1.Label
> It doesn't like the use of label. However, if I convert the report by
> bringing it into the 2005 designer, convert, redeploy the error goes away.
> My suggestion is to have two report servers. One for 2000 and one for
> 2005. Having both designers on one machine is not a problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Erik Tamminga" <agnimmate@.muimetca.ln_revese_the_previous> wrote in
> message news:eEZs$fB7FHA.3660@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> What are our options for developing for 2000 and 2005 "at the same time"
>> / on one computer.
>> I upgraded my local sql2000 to sql2005 and installed Visual Studio 2005
>> side by side with Visual Studio 2003. Now Visual Studio 2003 cannot open
>> Sql2000 report server projects anymore and 2005 "complains" about
>> upgrading the report projects. For several customers we still need to
>> develop Sql2000 reports while other customers request Sql2005 reports.
>> Please advise,
>> Erik
>

Friday, February 17, 2012

Develop in VS2005 and deployment to SQL 2000

I find I can use VS2005 to develop reports of Reporting Service and the
datasource of reports is from SQL2000.
Can I develop these report to SQL2000 after I developed?If you get Reporting Services, you will get Report Designer as a template in
VS.NET. Check how to obtain RS at
http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>I find I can use VS2005 to develop reports of Reporting Service and the
>datasource of reports is from SQL2000.
> Can I develop these report to SQL2000 after I developed?
>|||Thanks,
I have licence of SQL Server Standard, there is no problem about licence.
My problem is technique issue.
If the report is desgined in VS2005, then I deployment it to Sql2000, will
it be OK?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> ¼¶¼g©ó¶l¥ó·s»D:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
> If you get Reporting Services, you will get Report Designer as a template
> in VS.NET. Check how to obtain RS at
> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I find I can use VS2005 to develop reports of Reporting Service and the
>>datasource of reports is from SQL2000.
>> Can I develop these report to SQL2000 after I developed?
>>
>|||Hi
No. The file format has changed and AFAIK, you can not tell it at design
time what version you are building for.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:un%23yFqKzFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Thanks,
> I have licence of SQL Server Standard, there is no problem about licence.
> My problem is technique issue.
> If the report is desgined in VS2005, then I deployment it to Sql2000, will
> it be OK?
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si>
> ¼¶¼g©ó¶l¥ó·s»D:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>> If you get Reporting Services, you will get Report Designer as a template
>> in VS.NET. Check how to obtain RS at
>> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
>> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I find I can use VS2005 to develop reports of Reporting Service and the
>>datasource of reports is from SQL2000.
>> Can I develop these report to SQL2000 after I developed?
>>
>>
>|||Hi,
I have read your question a couple of times and am unsure if you are
referring to the server-based Reporting Services or the new report
controls which are included in Visual Studio 2005.
If you want to use server-based Reporting Services then I believe
Mike's answer is correct, since the RDL format has changed between
RS2000 and RS2005.
If you want to use the new report controls, which don't depend on
server-based Reporting Services, I think you are likely to be ok. I
should mention that it's a scenario I haven't tested personally.
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 16:21:50 +0800, "ad" <flying@.wfes.tcc.edu.tw>
wrote:
>Thanks,
>I have licence of SQL Server Standard, there is no problem about licence.
>My problem is technique issue.
>If the report is desgined in VS2005, then I deployment it to Sql2000, will
>it be OK?
>
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> ¼¶¼g©ó¶l¥ó·s»D:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>> If you get Reporting Services, you will get Report Designer as a template
>> in VS.NET. Check how to obtain RS at
>> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
>> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I find I can use VS2005 to develop reports of Reporting Service and the
>>datasource of reports is from SQL2000.
>> Can I develop these report to SQL2000 after I developed?
>>
>>
>

Sunday, March 25, 2012

difference between 'Backup' and DB maint. plan backup?

difference between 'Backup' and DB maint. plan backup?

difference between 'Backup' and DB maint. plan backup?

Wednesday, March 21, 2012

Diff Backups - Urgent pls help

Diff Backups - Urgent pls help

Diff b/w executing as Stored Procedure and Script

Monday, March 19, 2012

Diagrams Problem

Diagrams Problem

Diagrams Problem

Diagrams Problem

Sunday, March 11, 2012

Diagrams manipulation

diagraming databases

diagraming databases

diagraming databases

Wednesday, March 7, 2012

development and implementation procedures....

Saturday, February 25, 2012

Developing for 2000 and 2005

Friday, February 17, 2012

Develop in VS2005 and deployment to SQL 2000

Develop in VS2005 and deployment to SQL 2000

Develop in VS2005 and deployment to SQL 2000

sql record counts

Blog Archive

About Me