help exporting data to Oracle

hi,
i'm trying to export data from Sql Server to Oracle, when i try i get
a message saying that the values in a column are too large, in sql
server the column is of type ntext length 16, in Oracle its long, is
there something i can do? if i need to change Oracle's long to
something else, what should i make it blob?
Thanks.I am not an Oracle guy, but the name 'long' sounds like a numeric datatype,
not textual. I think BLOB will be more appropriate for large text data.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"soni29" <soni29@.hotmail.com> wrote in message
news:cad7a075.0402181427.31bcffc4@.posting.google.com...
hi,
i'm trying to export data from Sql Server to Oracle, when i try i get
a message saying that the values in a column are too large, in sql
server the column is of type ntext length 16, in Oracle its long, is
there something i can do? if i need to change Oracle's long to
something else, what should i make it blob?
Thanks.

help exporting data to Oracle

hi,
i'm trying to export data from Sql Server to Oracle, when i try i get
a message saying that the values in a column are too large, in sql
server the column is of type ntext length 16, in Oracle its long, is
there something i can do? if i need to change Oracle's long to
something else, what should i make it blob?
Thanks.I am not an Oracle guy, but the name 'long' sounds like a numeric datatype,
not textual. I think BLOB will be more appropriate for large text data.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"soni29" <soni29@.hotmail.com> wrote in message
news:cad7a075.0402181427.31bcffc4@.posting.google.com...
hi,
i'm trying to export data from Sql Server to Oracle, when i try i get
a message saying that the values in a column are too large, in sql
server the column is of type ntext length 16, in Oracle its long, is
there something i can do? if i need to change Oracle's long to
something else, what should i make it blob?
Thanks.sql

Help applying SP2 Beta

Help!!!
After applying SP2 beta to my Test Server I get the following message when
launching the Report Manager:
"The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'Unknown'. The expected
version is 'C.0.6.54'. To continue, update the version of the report server
database and verify access rights. (rsInvalidReportServerDatabase)"
Get Online Help URL:
http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
I tried following the Get Online Help link instructions without success.
I even uninstalled Report Server and re-installed my SP1 version!
Do I need to drop the Report Server Databases before re-installing?
I have back-up of the orignal tables
I need to acces some reports that I had created in the test environment.
--
Application Engineer / DBA
UCLA SOMMake sure that all of your SPs are in the dbo namespace.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcial" <no_spam@.antispammer.com> wrote in message
news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> Help!!!
> After applying SP2 beta to my Test Server I get the following message when
> launching the Report Manager:
> "The version of the report server database is either in a format that is
> not
> valid, or it cannot be read. The found version is 'Unknown'. The expected
> version is 'C.0.6.54'. To continue, update the version of the report
> server
> database and verify access rights. (rsInvalidReportServerDatabase)"
> Get Online Help URL:
> http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> I tried following the Get Online Help link instructions without success.
> I even uninstalled Report Server and re-installed my SP1 version!
> Do I need to drop the Report Server Databases before re-installing?
> I have back-up of the orignal tables
> I need to acces some reports that I had created in the test environment.
> --
> Application Engineer / DBA
> UCLA SOM|||Thanks Daniel, could you be a bit morer specific on how to ensure SPs in dbo
namespace!
"Daniel Reib [MSFT]" wrote:
> Make sure that all of your SPs are in the dbo namespace.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Marcial" <no_spam@.antispammer.com> wrote in message
> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> > Help!!!
> >
> > After applying SP2 beta to my Test Server I get the following message when
> > launching the Report Manager:
> >
> > "The version of the report server database is either in a format that is
> > not
> > valid, or it cannot be read. The found version is 'Unknown'. The expected
> > version is 'C.0.6.54'. To continue, update the version of the report
> > server
> > database and verify access rights. (rsInvalidReportServerDatabase)"
> >
> > Get Online Help URL:
> >
> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >
> > I tried following the Get Online Help link instructions without success.
> >
> > I even uninstalled Report Server and re-installed my SP1 version!
> > Do I need to drop the Report Server Databases before re-installing?
> >
> > I have back-up of the orignal tables
> >
> > I need to acces some reports that I had created in the test environment.
> >
> > --
> > Application Engineer / DBA
> > UCLA SOM
>
>|||If you go to enterprise manager, find the reportserver database and look at
it's SPs. Who is the owner of the SPs?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcial" <no_spam@.antispammer.com> wrote in message
news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
> Thanks Daniel, could you be a bit morer specific on how to ensure SPs in
> dbo
> namespace!
> "Daniel Reib [MSFT]" wrote:
>> Make sure that all of your SPs are in the dbo namespace.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Marcial" <no_spam@.antispammer.com> wrote in message
>> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
>> > Help!!!
>> >
>> > After applying SP2 beta to my Test Server I get the following message
>> > when
>> > launching the Report Manager:
>> >
>> > "The version of the report server database is either in a format that
>> > is
>> > not
>> > valid, or it cannot be read. The found version is 'Unknown'. The
>> > expected
>> > version is 'C.0.6.54'. To continue, update the version of the report
>> > server
>> > database and verify access rights. (rsInvalidReportServerDatabase)"
>> >
>> > Get Online Help URL:
>> >
>> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
>> >
>> > I tried following the Get Online Help link instructions without
>> > success.
>> >
>> > I even uninstalled Report Server and re-installed my SP1 version!
>> > Do I need to drop the Report Server Databases before re-installing?
>> >
>> > I have back-up of the orignal tables
>> >
>> > I need to acces some reports that I had created in the test
>> > environment.
>> >
>> > --
>> > Application Engineer / DBA
>> > UCLA SOM
>>|||Ok... I have verified that the dbo is the owner or the Stored Procedures in
both the
ReportServer and ReportServerTembDB. There is also an RSExecute Role which
currently contains no users.
could this be the cause of the error?
I also need to metion that I had installed SQL SERVER SP4 beta.
Could this be cause problems with Reporting Services'
"Daniel Reib [MSFT]" wrote:
> If you go to enterprise manager, find the reportserver database and look at
> it's SPs. Who is the owner of the SPs?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Marcial" <no_spam@.antispammer.com> wrote in message
> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
> > Thanks Daniel, could you be a bit morer specific on how to ensure SPs in
> > dbo
> > namespace!
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Make sure that all of your SPs are in the dbo namespace.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> >> > Help!!!
> >> >
> >> > After applying SP2 beta to my Test Server I get the following message
> >> > when
> >> > launching the Report Manager:
> >> >
> >> > "The version of the report server database is either in a format that
> >> > is
> >> > not
> >> > valid, or it cannot be read. The found version is 'Unknown'. The
> >> > expected
> >> > version is 'C.0.6.54'. To continue, update the version of the report
> >> > server
> >> > database and verify access rights. (rsInvalidReportServerDatabase)"
> >> >
> >> > Get Online Help URL:
> >> >
> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >> >
> >> > I tried following the Get Online Help link instructions without
> >> > success.
> >> >
> >> > I even uninstalled Report Server and re-installed my SP1 version!
> >> > Do I need to drop the Report Server Databases before re-installing?
> >> >
> >> > I have back-up of the orignal tables
> >> >
> >> > I need to acces some reports that I had created in the test
> >> > environment.
> >> >
> >> > --
> >> > Application Engineer / DBA
> >> > UCLA SOM
> >>
> >>
> >>
>
>|||Do you know what user you use to connect to the database server? You may
want to run rsconfig.exe to set the user to a specific user. You would then
need to manually add that user to each RSExecRole. There are four roles, on
in each of the following DB:
ReportServer
ReportServerTempDB
Master
Msdb
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcial" <no_spam@.antispammer.com> wrote in message
news:BC3682DA-89F6-41F4-9B29-98E63EC203D1@.microsoft.com...
> Ok... I have verified that the dbo is the owner or the Stored Procedures
> in
> both the
> ReportServer and ReportServerTembDB. There is also an RSExecute Role which
> currently contains no users.
> could this be the cause of the error?
> I also need to metion that I had installed SQL SERVER SP4 beta.
> Could this be cause problems with Reporting Services'
> "Daniel Reib [MSFT]" wrote:
>> If you go to enterprise manager, find the reportserver database and look
>> at
>> it's SPs. Who is the owner of the SPs?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Marcial" <no_spam@.antispammer.com> wrote in message
>> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
>> > Thanks Daniel, could you be a bit morer specific on how to ensure SPs
>> > in
>> > dbo
>> > namespace!
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> Make sure that all of your SPs are in the dbo namespace.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Marcial" <no_spam@.antispammer.com> wrote in message
>> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
>> >> > Help!!!
>> >> >
>> >> > After applying SP2 beta to my Test Server I get the following
>> >> > message
>> >> > when
>> >> > launching the Report Manager:
>> >> >
>> >> > "The version of the report server database is either in a format
>> >> > that
>> >> > is
>> >> > not
>> >> > valid, or it cannot be read. The found version is 'Unknown'. The
>> >> > expected
>> >> > version is 'C.0.6.54'. To continue, update the version of the report
>> >> > server
>> >> > database and verify access rights. (rsInvalidReportServerDatabase)"
>> >> >
>> >> > Get Online Help URL:
>> >> >
>> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
>> >> >
>> >> > I tried following the Get Online Help link instructions without
>> >> > success.
>> >> >
>> >> > I even uninstalled Report Server and re-installed my SP1 version!
>> >> > Do I need to drop the Report Server Databases before re-installing?
>> >> >
>> >> > I have back-up of the orignal tables
>> >> >
>> >> > I need to acces some reports that I had created in the test
>> >> > environment.
>> >> >
>> >> > --
>> >> > Application Engineer / DBA
>> >> > UCLA SOM
>> >>
>> >>
>> >>
>>|||May I jump in here? I am having a similar problem, but my error originally
differed slightly.
Instead of "found version 'Unknown'", mine reported "found version
'T.0.6.51'. Cause apparently
due to me using RSCONFIG to try to change the credentials used to connect to
the RS SQL
Server databases. Commands I issued:
rsconfig -c -s KCBSGP12 -d ReportServer2000 -a sql -u RSAdmin -p xxxxxx
rsconfig -c -s KCBSGP12 -d ReportServer2000TempDB -a sql -u RSAdmin -p xxxxxx
RSAdmin was a created as user in ReportServer2000 and ReportServer2000TempDB
with same
permissions as the original account (an AD account versus SQL account, in
case that's important).
Restarted ReportServer service and got the error. Then realized from this
thread I had missed
MASTER and MSDB databases, so added RSAdmin user to those as well, then
issued "rsconfig"
commands as above for those two databases. NOW, the "found version" is
"Unknown", just
as Marcial is getting.
Hoping very much you can help! Thank you.
"Daniel Reib [MSFT]" wrote:
> Do you know what user you use to connect to the database server? You may
> want to run rsconfig.exe to set the user to a specific user. You would then
> need to manually add that user to each RSExecRole. There are four roles, on
> in each of the following DB:
> ReportServer
> ReportServerTempDB
> Master
> Msdb
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Marcial" <no_spam@.antispammer.com> wrote in message
> news:BC3682DA-89F6-41F4-9B29-98E63EC203D1@.microsoft.com...
> > Ok... I have verified that the dbo is the owner or the Stored Procedures
> > in
> > both the
> > ReportServer and ReportServerTembDB. There is also an RSExecute Role which
> > currently contains no users.
> > could this be the cause of the error?
> >
> > I also need to metion that I had installed SQL SERVER SP4 beta.
> > Could this be cause problems with Reporting Services'
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> If you go to enterprise manager, find the reportserver database and look
> >> at
> >> it's SPs. Who is the owner of the SPs?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
> >> > Thanks Daniel, could you be a bit morer specific on how to ensure SPs
> >> > in
> >> > dbo
> >> > namespace!
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> Make sure that all of your SPs are in the dbo namespace.
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> >> >> > Help!!!
> >> >> >
> >> >> > After applying SP2 beta to my Test Server I get the following
> >> >> > message
> >> >> > when
> >> >> > launching the Report Manager:
> >> >> >
> >> >> > "The version of the report server database is either in a format
> >> >> > that
> >> >> > is
> >> >> > not
> >> >> > valid, or it cannot be read. The found version is 'Unknown'. The
> >> >> > expected
> >> >> > version is 'C.0.6.54'. To continue, update the version of the report
> >> >> > server
> >> >> > database and verify access rights. (rsInvalidReportServerDatabase)"
> >> >> >
> >> >> > Get Online Help URL:
> >> >> >
> >> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >> >> >
> >> >> > I tried following the Get Online Help link instructions without
> >> >> > success.
> >> >> >
> >> >> > I even uninstalled Report Server and re-installed my SP1 version!
> >> >> > Do I need to drop the Report Server Databases before re-installing?
> >> >> >
> >> >> > I have back-up of the orignal tables
> >> >> >
> >> >> > I need to acces some reports that I had created in the test
> >> >> > environment.
> >> >> >
> >> >> > --
> >> >> > Application Engineer / DBA
> >> >> > UCLA SOM
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||You only want to issue rsconfig for the report server database, not for the
temp or any other. RSConfig.exe does NOT update the RSExecRole that is
present in the 4 databases that you mention, you must do this manually.
So, rerun rsconfig.exe, pointing it to ReportServer2000. Then manually add
RSAdmin to the rsexecrole in the 4 databases mentioned below.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"J Noble" <JNoble@.discussions.microsoft.com> wrote in message
news:FB973338-95DA-477D-ADB1-4CD33FF84582@.microsoft.com...
> May I jump in here? I am having a similar problem, but my error
> originally
> differed slightly.
> Instead of "found version 'Unknown'", mine reported "found version
> 'T.0.6.51'. Cause apparently
> due to me using RSCONFIG to try to change the credentials used to connect
> to
> the RS SQL
> Server databases. Commands I issued:
> rsconfig -c -s KCBSGP12 -d ReportServer2000 -a sql -u RSAdmin -p xxxxxx
> rsconfig -c -s KCBSGP12 -d ReportServer2000TempDB -a sql -u RSAdmin -p
> xxxxxx
> RSAdmin was a created as user in ReportServer2000 and
> ReportServer2000TempDB
> with same
> permissions as the original account (an AD account versus SQL account, in
> case that's important).
> Restarted ReportServer service and got the error. Then realized from this
> thread I had missed
> MASTER and MSDB databases, so added RSAdmin user to those as well, then
> issued "rsconfig"
> commands as above for those two databases. NOW, the "found version" is
> "Unknown", just
> as Marcial is getting.
> Hoping very much you can help! Thank you.
>
> "Daniel Reib [MSFT]" wrote:
>> Do you know what user you use to connect to the database server? You may
>> want to run rsconfig.exe to set the user to a specific user. You would
>> then
>> need to manually add that user to each RSExecRole. There are four roles,
>> on
>> in each of the following DB:
>> ReportServer
>> ReportServerTempDB
>> Master
>> Msdb
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Marcial" <no_spam@.antispammer.com> wrote in message
>> news:BC3682DA-89F6-41F4-9B29-98E63EC203D1@.microsoft.com...
>> > Ok... I have verified that the dbo is the owner or the Stored
>> > Procedures
>> > in
>> > both the
>> > ReportServer and ReportServerTembDB. There is also an RSExecute Role
>> > which
>> > currently contains no users.
>> > could this be the cause of the error?
>> >
>> > I also need to metion that I had installed SQL SERVER SP4 beta.
>> > Could this be cause problems with Reporting Services'
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> If you go to enterprise manager, find the reportserver database and
>> >> look
>> >> at
>> >> it's SPs. Who is the owner of the SPs?
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Marcial" <no_spam@.antispammer.com> wrote in message
>> >> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
>> >> > Thanks Daniel, could you be a bit morer specific on how to ensure
>> >> > SPs
>> >> > in
>> >> > dbo
>> >> > namespace!
>> >> >
>> >> > "Daniel Reib [MSFT]" wrote:
>> >> >
>> >> >> Make sure that all of your SPs are in the dbo namespace.
>> >> >>
>> >> >> --
>> >> >> -Daniel
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "Marcial" <no_spam@.antispammer.com> wrote in message
>> >> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
>> >> >> > Help!!!
>> >> >> >
>> >> >> > After applying SP2 beta to my Test Server I get the following
>> >> >> > message
>> >> >> > when
>> >> >> > launching the Report Manager:
>> >> >> >
>> >> >> > "The version of the report server database is either in a format
>> >> >> > that
>> >> >> > is
>> >> >> > not
>> >> >> > valid, or it cannot be read. The found version is 'Unknown'. The
>> >> >> > expected
>> >> >> > version is 'C.0.6.54'. To continue, update the version of the
>> >> >> > report
>> >> >> > server
>> >> >> > database and verify access rights.
>> >> >> > (rsInvalidReportServerDatabase)"
>> >> >> >
>> >> >> > Get Online Help URL:
>> >> >> >
>> >> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
>> >> >> >
>> >> >> > I tried following the Get Online Help link instructions without
>> >> >> > success.
>> >> >> >
>> >> >> > I even uninstalled Report Server and re-installed my SP1 version!
>> >> >> > Do I need to drop the Report Server Databases before
>> >> >> > re-installing?
>> >> >> >
>> >> >> > I have back-up of the orignal tables
>> >> >> >
>> >> >> > I need to acces some reports that I had created in the test
>> >> >> > environment.
>> >> >> >
>> >> >> > --
>> >> >> > Application Engineer / DBA
>> >> >> > UCLA SOM
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Fantastic. Thanks very much.
Bad assumption on my part to initially run RSConfig against both db's. I see
some logic in the reported versions now, though. 'C' being the main db,
'T' being the Temp db, and 'Unknown' referring to Master and Msdb.
"Daniel Reib [MSFT]" wrote:
> You only want to issue rsconfig for the report server database, not for the
> temp or any other. RSConfig.exe does NOT update the RSExecRole that is
> present in the 4 databases that you mention, you must do this manually.
> So, rerun rsconfig.exe, pointing it to ReportServer2000. Then manually add
> RSAdmin to the rsexecrole in the 4 databases mentioned below.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "J Noble" <JNoble@.discussions.microsoft.com> wrote in message
> news:FB973338-95DA-477D-ADB1-4CD33FF84582@.microsoft.com...
> > May I jump in here? I am having a similar problem, but my error
> > originally
> > differed slightly.
> > Instead of "found version 'Unknown'", mine reported "found version
> > 'T.0.6.51'. Cause apparently
> > due to me using RSCONFIG to try to change the credentials used to connect
> > to
> > the RS SQL
> > Server databases. Commands I issued:
> > rsconfig -c -s KCBSGP12 -d ReportServer2000 -a sql -u RSAdmin -p xxxxxx
> > rsconfig -c -s KCBSGP12 -d ReportServer2000TempDB -a sql -u RSAdmin -p
> > xxxxxx
> > RSAdmin was a created as user in ReportServer2000 and
> > ReportServer2000TempDB
> > with same
> > permissions as the original account (an AD account versus SQL account, in
> > case that's important).
> > Restarted ReportServer service and got the error. Then realized from this
> > thread I had missed
> > MASTER and MSDB databases, so added RSAdmin user to those as well, then
> > issued "rsconfig"
> > commands as above for those two databases. NOW, the "found version" is
> > "Unknown", just
> > as Marcial is getting.
> >
> > Hoping very much you can help! Thank you.
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Do you know what user you use to connect to the database server? You may
> >> want to run rsconfig.exe to set the user to a specific user. You would
> >> then
> >> need to manually add that user to each RSExecRole. There are four roles,
> >> on
> >> in each of the following DB:
> >>
> >> ReportServer
> >> ReportServerTempDB
> >> Master
> >> Msdb
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> news:BC3682DA-89F6-41F4-9B29-98E63EC203D1@.microsoft.com...
> >> > Ok... I have verified that the dbo is the owner or the Stored
> >> > Procedures
> >> > in
> >> > both the
> >> > ReportServer and ReportServerTembDB. There is also an RSExecute Role
> >> > which
> >> > currently contains no users.
> >> > could this be the cause of the error?
> >> >
> >> > I also need to metion that I had installed SQL SERVER SP4 beta.
> >> > Could this be cause problems with Reporting Services'
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> If you go to enterprise manager, find the reportserver database and
> >> >> look
> >> >> at
> >> >> it's SPs. Who is the owner of the SPs?
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> >> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
> >> >> > Thanks Daniel, could you be a bit morer specific on how to ensure
> >> >> > SPs
> >> >> > in
> >> >> > dbo
> >> >> > namespace!
> >> >> >
> >> >> > "Daniel Reib [MSFT]" wrote:
> >> >> >
> >> >> >> Make sure that all of your SPs are in the dbo namespace.
> >> >> >>
> >> >> >> --
> >> >> >> -Daniel
> >> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> >> rights.
> >> >> >>
> >> >> >>
> >> >> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> >> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> >> >> >> > Help!!!
> >> >> >> >
> >> >> >> > After applying SP2 beta to my Test Server I get the following
> >> >> >> > message
> >> >> >> > when
> >> >> >> > launching the Report Manager:
> >> >> >> >
> >> >> >> > "The version of the report server database is either in a format
> >> >> >> > that
> >> >> >> > is
> >> >> >> > not
> >> >> >> > valid, or it cannot be read. The found version is 'Unknown'. The
> >> >> >> > expected
> >> >> >> > version is 'C.0.6.54'. To continue, update the version of the
> >> >> >> > report
> >> >> >> > server
> >> >> >> > database and verify access rights.
> >> >> >> > (rsInvalidReportServerDatabase)"
> >> >> >> >
> >> >> >> > Get Online Help URL:
> >> >> >> >
> >> >> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >> >> >> >
> >> >> >> > I tried following the Get Online Help link instructions without
> >> >> >> > success.
> >> >> >> >
> >> >> >> > I even uninstalled Report Server and re-installed my SP1 version!
> >> >> >> > Do I need to drop the Report Server Databases before
> >> >> >> > re-installing?
> >> >> >> >
> >> >> >> > I have back-up of the orignal tables
> >> >> >> >
> >> >> >> > I need to acces some reports that I had created in the test
> >> >> >> > environment.
> >> >> >> >
> >> >> >> > --
> >> >> >> > Application Engineer / DBA
> >> >> >> > UCLA SOM
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>sql

Help : Table Corrupt

Can not truncate or drop a table.
DBCC CHECKTABLE on the table returns the following message:
"Table Corrupt: IAM page (1:25040) (object ID 38016033,
index ID 0) is out of the range of this database."
Our version is Microsoft SQL Server 7.00 - 7.00.623
Can this corrupt other tables?
Thanks.Here are the general recommendations for handling a suspect or corrupt
database:
0. Ensure you have a backup strategy that you can use to recover from
hardware failures (including corruption). I recommend performing both
database and log backup in most situations.
1. If you can run DBCC CHECKDB against the database: Search Books Online and
KB for the error numbers that CHECKDB gives you. There might be specific
info for that type of error.
2. Find out why this happened. Check eventlog, do HW diagnostics etc.;
search Books Online and KB for those errors. You don't want this to happen
again! If the database is suspect, the file might have been in use by for
instance an anti-virus program and restarting SQL Server might be all that
is needed - but you still want to read logs etc to find out what happened.
3. If there is a hardware problem, ensure the faulty hardware is replaced.
4. Backup the log. This assumes that log backup schedule is in place, of
course. If the database is suspect, then the NO_TRUNCATE option for the
RESTORE command must be used. Also, you might want to do a file backup of
the mdf and ldf files, for extra safety.
5. Restore is the best thing to do now. If you managed to backup log as per
step 4, then you will most probably have zero dataloss. You should restore
the latest clean database backup and the subsequent log backups including
the one taken in above step.
If the database isn't suspect, then DBCC with a REPAIR option might be a
secondary option but this will often result in loss of data. Additional
solutions, depending on the errors, may be to manually rebuild non-clustered
indexes, manually drop and reload a table if the data is static, and so on.
If the database is suspect, a secondary option can be to try to "un-suspect"
the database using sp_resetstatus. Read about it (books online, KB, google
etc). It might help but if the database is too damaged, it might just pop
back to suspect again. There's also something called "emergency mode" which
is a "panic" status you can set in order to try to get data out of a damaged
database. I think the name of that option speaks for itself. Again search
the net for info.
If you feel uncertain with above steps, I recommend letting MS hand-hold you
through the steps appropriate for your particular situation.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"xeiger" <xeiger@.yahoo.es> wrote in message
news:baf601c3ecce$8df61a40$a001280a@.phx.gbl...
> Can not truncate or drop a table.
> DBCC CHECKTABLE on the table returns the following message:
> "Table Corrupt: IAM page (1:25040) (object ID 38016033,
> index ID 0) is out of the range of this database."
> Our version is Microsoft SQL Server 7.00 - 7.00.623
> Can this corrupt other tables?
> Thanks.

Help : Table Corrupt

Can not truncate or drop a table.
DBCC CHECKTABLE on the table returns the following message:
"Table Corrupt: IAM page (1:25040) (object ID 38016033,
index ID 0) is out of the range of this database."
Our version is Microsoft SQL Server 7.00 - 7.00.623
Can this corrupt other tables?
Thanks.Here are the general recommendations for handling a suspect or corrupt
database:
0. Ensure you have a backup strategy that you can use to recover from
hardware failures (including corruption). I recommend performing both
database and log backup in most situations.
1. If you can run DBCC CHECKDB against the database: Search Books Online and
KB for the error numbers that CHECKDB gives you. There might be specific
info for that type of error.
2. Find out why this happened. Check eventlog, do HW diagnostics etc.;
search Books Online and KB for those errors. You don't want this to happen
again! If the database is suspect, the file might have been in use by for
instance an anti-virus program and restarting SQL Server might be all that
is needed - but you still want to read logs etc to find out what happened.
3. If there is a hardware problem, ensure the faulty hardware is replaced.
4. Backup the log. This assumes that log backup schedule is in place, of
course. If the database is suspect, then the NO_TRUNCATE option for the
RESTORE command must be used. Also, you might want to do a file backup of
the mdf and ldf files, for extra safety.
5. Restore is the best thing to do now. If you managed to backup log as per
step 4, then you will most probably have zero dataloss. You should restore
the latest clean database backup and the subsequent log backups including
the one taken in above step.
If the database isn't suspect, then DBCC with a REPAIR option might be a
secondary option but this will often result in loss of data. Additional
solutions, depending on the errors, may be to manually rebuild non-clustered
indexes, manually drop and reload a table if the data is static, and so on.
If the database is suspect, a secondary option can be to try to "un-suspect"
the database using sp_resetstatus. Read about it (books online, KB, google
etc). It might help but if the database is too damaged, it might just pop
back to suspect again. There's also something called "emergency mode" which
is a "panic" status you can set in order to try to get data out of a damaged
database. I think the name of that option speaks for itself. Again search
the net for info.
If you feel uncertain with above steps, I recommend letting MS hand-hold you
through the steps appropriate for your particular situation.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"xeiger" <xeiger@.yahoo.es> wrote in message
news:baf601c3ecce$8df61a40$a001280a@.phx.gbl...
> Can not truncate or drop a table.
> DBCC CHECKTABLE on the table returns the following message:
> "Table Corrupt: IAM page (1:25040) (object ID 38016033,
> index ID 0) is out of the range of this database."
> Our version is Microsoft SQL Server 7.00 - 7.00.623
> Can this corrupt other tables?
> Thanks.

help , please ,problems with sql 2005 expresse

Hi , people , i'm new here and i'm just starting with sql 2005 server , and i have a problem: when i will install sql , a message show up , tell me that i don't have the service pack to install sql , then the message shows a link:http://go.microsoft.com/fwlink/?LinkId=50380 , but this link doesn't exist! What to do? I already have Windows installer 3.0 , but not service pack 2. Could this be the problem?

and thanks in advanced

Yes, the minimum required service pack level for Windows XP is Service Pack 2.|||

I have the same problem installing on SBS Server 2003. I have installed the SP2 for Windows Installer, and all other updates have been done. Any further ideas?

|||For Win2K3 SBS you'll need to install SP1. There is no SP2 for SBS.|||yes get the service pak. it also comes with the installer.|||Having installed all the required SP's as well as the latest windows installer, SQL 2005 installed OK. Tnx to all who replied|||Well, having all the patches and SP1 installed on SBS 2003, I still cannot install Sql Server Express 2005. I see the same question has been asked all over, but no-one seems to have an answer. If a simply question like this cannot be answered on a MS owned forum, why on earth should anyone consider buying the full product? This is annoying to put it mildly....

help , please ,problems with sql 2005 expresse

Hi , people , i'm new here and i'm just starting with sql 2005 server , and i have a problem: when i will install sql , a message show up , tell me that i don't have the service pack to install sql , then the message shows a link:http://go.microsoft.com/fwlink/?LinkId=50380 , but this link doesn't exist! What to do? I already have Windows installer 3.0 , but not service pack 2. Could this be the problem?

and thanks in advanced

Yes, the minimum required service pack level for Windows XP is Service Pack 2.|||

I have the same problem installing on SBS Server 2003. I have installed the SP2 for Windows Installer, and all other updates have been done. Any further ideas?

|||For Win2K3 SBS you'll need to install SP1. There is no SP2 for SBS.|||yes get the service pak. it also comes with the installer.|||Having installed all the required SP's as well as the latest windows installer, SQL 2005 installed OK. Tnx to all who replied|||Well, having all the patches and SP1 installed on SBS 2003, I still cannot install Sql Server Express 2005. I see the same question has been asked all over, but no-one seems to have an answer. If a simply question like this cannot be answered on a MS owned forum, why on earth should anyone consider buying the full product? This is annoying to put it mildly....

help , please ,problems with sql 2005 expresse

Hi , people , i'm new here and i'm just starting with sql 2005 server , and i have a problem: when i will install sql , a message show up , tell me that i don't have the service pack to install sql , then the message shows a link:http://go.microsoft.com/fwlink/?LinkId=50380 , but this link doesn't exist! What to do? I already have Windows installer 3.0 , but not service pack 2. Could this be the problem?

and thanks in advanced

Yes, the minimum required service pack level for Windows XP is Service Pack 2.|||

I have the same problem installing on SBS Server 2003. I have installed the SP2 for Windows Installer, and all other updates have been done. Any further ideas?

|||For Win2K3 SBS you'll need to install SP1. There is no SP2 for SBS.|||yes get the service pak. it also comes with the installer.|||Having installed all the required SP's as well as the latest windows installer, SQL 2005 installed OK. Tnx to all who replied|||Well, having all the patches and SP1 installed on SBS 2003, I still cannot install Sql Server Express 2005. I see the same question has been asked all over, but no-one seems to have an answer. If a simply question like this cannot be answered on a MS owned forum, why on earth should anyone consider buying the full product? This is annoying to put it mildly....

HELP With THIS MESSAGE

This is what we are getting on the server but I cannot seem to find anything anywhere and i am not real strong in SQL...I am a server guy that is tasked with finding the issue!

Scott H
Weasel101

Event Type: Error
Event Source: MSSQLServer
Event Category: Server
Event ID: 17052
Date: 3/12/2002
Time: 2:45:06 PM
User: ********** (Changed for privacy...sorry)
Computer: MYCOMPUTER (Changed for privacy...sorry)
Description:
Error: 823, Severity: 24, State: 1
I/O error (bad page ID) detected during read of BUF pointer = 0x1431e6c0, page ptr = 0x498f6000, pageid = (0x1:0x403), dbid = 4, status = 0x801, file = f:\MSSQL7\DATA\msdbdata.mdf.
Data:
0000: 37 03 00 00 18 00 00 00 7......
0008: 08 00 00 00 4e 00 54 00 ...N.T.
0010: 30 00 30 00 33 00 32 00 0.0.3.2.
0018: 4b 00 00 00 05 00 00 00 K......
0020: 6d 00 73 00 64 00 62 00 m.s.d.b.
0028: 00 00 ..Do you know if this happened during a restore ?|||There looks to be a Technet article on this problem:

BUG: Error Message 823 or Retail Assert Encountered During Restore of SQL Server Log Backup (Q281809) (http://support.microsoft.com/default.aspx?scid=kb;EN-US;q281809)|||CAUSE
SQL Server may allow the log to be backed up when non-logged operations have taken place.

WORKAROUND
To workaround this problem either:

Avoid the use of non-logged operations.

-or-

Ensure that any process performing non-logged operations complete and secure a complete database backup

Help - Recovering SQL 2000 Database

Friends,
The SQL server 2000 was running fine until all of a Sudden I got this
message,
SQL Server is aborting. Fatal exception c0000005 caught.
The Service would not start, and I need help in Recovering it.
Any help is greatly Appreciated.
--
SantoshCan you check the SQL Server error log and post the error messages here? You
will find the log in MSSQL\Log folder under the installation path.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
> Friends,
> The SQL server 2000 was running fine until all of a Sudden I got this
> message,
> SQL Server is aborting. Fatal exception c0000005 caught.
> The Service would not start, and I need help in Recovering it.
> Any help is greatly Appreciated.
> --
> Santosh
>|||Hi Vyas,
Sorry for the late reply,
The error log just says the below and halts at the last step.
2004-09-13 17:09:54.39 spid11 Starting up database 'jennifertest'.
2004-09-13 17:10:02.75 spid3 Recovery complete.
2004-09-13 17:10:02.75 spid3 SQL global counter collection task is
created.
Do you want any other file like SQLDump?
TIA
--
Santosh
Can you check the SQL Server error log and post the error messages here? You
will find the log in MSSQL\Log folder under the installation path.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
> Friends,
> The SQL server 2000 was running fine until all of a Sudden I got this
> message,
> SQL Server is aborting. Fatal exception c0000005 caught.
> The Service would not start, and I need help in Recovering it.
> Any help is greatly Appreciated.
> --
> Santosh
>

HELP - Error Message when running DBCC Showcontig with TableResults

Has anyone encountered the following error message when
running DBCC Showcontig with tableresults?
[Microsoft][ODBC SQL Server Driver]Unknown token received
from SQL Server
I am doing a dynamic DBCC on every table in my DB to
perform some analysis of indexes, however when I run the
full DB, I get this error. I printed the table.index for
each index prior to running the dbcc and when I take the
table and index and run independantly in ISQL, it executes
fine, but gives me a message about:
'DBCC execution completed. If DBCC printed error messages,
contact your system administrator.'
Which is not viable since it is a text string and not the
parameters of the TABLERESULTS table.
Anyone have a workaround or know what I can do to fix this?I'd start checking the database using CHECKDB. If that comes out clean, I'd say you've hit a bug
(check KB, be current and if that doesn't help open case with MS PSS).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Chris" <chris@.da-krewe.com> wrote in message news:066a01c391af$9183bca0$a101280a@.phx.gbl...
> Has anyone encountered the following error message when
> running DBCC Showcontig with tableresults?
> [Microsoft][ODBC SQL Server Driver]Unknown token received
> from SQL Server
> I am doing a dynamic DBCC on every table in my DB to
> perform some analysis of indexes, however when I run the
> full DB, I get this error. I printed the table.index for
> each index prior to running the dbcc and when I take the
> table and index and run independantly in ISQL, it executes
> fine, but gives me a message about:
> 'DBCC execution completed. If DBCC printed error messages,
> contact your system administrator.'
> Which is not viable since it is a text string and not the
> parameters of the TABLERESULTS table.
> Anyone have a workaround or know what I can do to fix this?

help

how can i get the result .....A B
JOHN N
OHN HN
HN OHN
N JOHN
where JOHN is an employee in emp table...
Message posted via http://www.droptable.com
The example below uses a derived table containing numbers up to the maximum
size for the FirstName column. You might consider creating a general
purpose permanent table if this is the sort of thing you do often.
SELECT
SUBSTRING(FirstName, Position, LEN(FirstName) - Position + 1) AS A,
RIGHT(FirstName, Position) AS B
FROM dbo.emp
CROSS JOIN (
SELECT 1 AS Position
UNION ALL SELECT 2
UNION ALL SELECT 3
UNION ALL SELECT 4
UNION ALL SELECT 5
UNION ALL SELECT 6
UNION ALL SELECT 7
UNION ALL SELECT 8
UNION ALL SELECT 9
UNION ALL SELECT 10 AS Position) AS Positions
WHERE
FirstName = 'JOHN' AND
Position <= LEN(FirstName)
Hope this helps.
Dan Guzman
SQL Server MVP
"Nishu via droptable.com" <u30587@.uwe> wrote in message
news:6d33e7a43e7ba@.uwe...
> how can i get the result .....A B
> JOHN N
> OHN HN
> HN OHN
> N JOHN
>
>
> where JOHN is an employee in emp table...
> --
> Message posted via http://www.droptable.com
>
|||This assumes a table of integers named Numbers with values that at
least cover the range from 1 to the maximum length of the name.
SELECT RIGHT(E.employee, LEN(E.employee) - N.Nbr + 1),
RIGHT(E.employee, N.Nbr)
FROM Emp as E
JOIN Numbers as N
ON N.Nbr between 1 and LEN(E.employee)
Roy Harvey
Beacon Falls, CT
On Fri, 02 Feb 2007 12:18:38 GMT, "Nishu via droptable.com"
<u30587@.uwe> wrote:

>how can i get the result .....A B
> JOHN N
> OHN HN
> HN OHN
> N JOHN
>
>
>where JOHN is an employee in emp table...
|||thanx roy,it worked well..
Roy Harvey wrote:[vbcol=seagreen]
>This assumes a table of integers named Numbers with values that at
>least cover the range from 1 to the maximum length of the name.
>SELECT RIGHT(E.employee, LEN(E.employee) - N.Nbr + 1),
> RIGHT(E.employee, N.Nbr)
> FROM Emp as E
> JOIN Numbers as N
> ON N.Nbr between 1 and LEN(E.employee)
>Roy Harvey
>Beacon Falls, CT
>[quoted text clipped - 3 lines]
Message posted via http://www.droptable.com
|||thnx dan
Dan Guzman wrote:[vbcol=seagreen]
>The example below uses a derived table containing numbers up to the maximum
>size for the FirstName column. You might consider creating a general
>purpose permanent table if this is the sort of thing you do often.
>SELECT
> SUBSTRING(FirstName, Position, LEN(FirstName) - Position + 1) AS A,
> RIGHT(FirstName, Position) AS B
>FROM dbo.emp
>CROSS JOIN (
> SELECT 1 AS Position
> UNION ALL SELECT 2
> UNION ALL SELECT 3
> UNION ALL SELECT 4
> UNION ALL SELECT 5
> UNION ALL SELECT 6
> UNION ALL SELECT 7
> UNION ALL SELECT 8
> UNION ALL SELECT 9
> UNION ALL SELECT 10 AS Position) AS Positions
>WHERE
> FirstName = 'JOHN' AND
> Position <= LEN(FirstName)
>[quoted text clipped - 3 lines]
Message posted via http://www.droptable.com

HELP

Error Message "unable to load sql server odbc driver resource DLL.The
Application cannot continute"
Please help me !
You might try reinstalling MDAC
http://msdn.microsoft.com/data/downl.../default.aspx. The latest
version is 2.8.
Hope this helps.
Dan Guzman
SQL Server MVP
"??H" <lemel@.hungnet.idv.tw> wrote in message
news:eryrMLU$EHA.2700@.TK2MSFTNGP14.phx.gbl...
> Error Message "unable to load sql server odbc driver resource DLL.The
> Application cannot continute"
> Please help me !
>

HELP

Error Message "unable to load sql server odbc driver resource DLL.The
Application cannot continute"
Please help me !You might try reinstalling MDAC
http://msdn.microsoft.com/data/down...s/default.aspx. The latest
version is 2.8.
Hope this helps.
Dan Guzman
SQL Server MVP
"??H" <lemel@.hungnet.idv.tw> wrote in message
news:eryrMLU$EHA.2700@.TK2MSFTNGP14.phx.gbl...
> Error Message "unable to load sql server odbc driver resource DLL.The
> Application cannot continute"
> Please help me !
>

help

how can i get the result .....A B
JOHN N
OHN HN
HN OHN
N JOHN
where JOHN is an employee in emp table...
Message posted via http://www.droptable.comThe example below uses a derived table containing numbers up to the maximum
size for the FirstName column. You might consider creating a general
purpose permanent table if this is the sort of thing you do often.
SELECT
SUBSTRING(FirstName, Position, LEN(FirstName) - Position + 1) AS A,
RIGHT(FirstName, Position) AS B
FROM dbo.emp
CROSS JOIN (
SELECT 1 AS Position
UNION ALL SELECT 2
UNION ALL SELECT 3
UNION ALL SELECT 4
UNION ALL SELECT 5
UNION ALL SELECT 6
UNION ALL SELECT 7
UNION ALL SELECT 8
UNION ALL SELECT 9
UNION ALL SELECT 10 AS Position) AS Positions
WHERE
FirstName = 'JOHN' AND
Position <= LEN(FirstName)
Hope this helps.
Dan Guzman
SQL Server MVP
"Nishu via droptable.com" <u30587@.uwe> wrote in message
news:6d33e7a43e7ba@.uwe...
> how can i get the result .....A B
> JOHN N
> OHN HN
> HN OHN
> N JOHN
>
>
> where JOHN is an employee in emp table...
> --
> Message posted via http://www.droptable.com
>|||This assumes a table of integers named Numbers with values that at
least cover the range from 1 to the maximum length of the name.
SELECT RIGHT(E.employee, LEN(E.employee) - N.Nbr + 1),
RIGHT(E.employee, N.Nbr)
FROM Emp as E
JOIN Numbers as N
ON N.Nbr between 1 and LEN(E.employee)
Roy Harvey
Beacon Falls, CT
On Fri, 02 Feb 2007 12:18:38 GMT, "Nishu via droptable.com"
<u30587@.uwe> wrote:

>how can i get the result .....A B
> JOHN N
> OHN HN
> HN OHN
> N JOHN
>
>
>where JOHN is an employee in emp table...|||thanx roy,it worked well..
Roy Harvey wrote:[vbcol=seagreen]
>This assumes a table of integers named Numbers with values that at
>least cover the range from 1 to the maximum length of the name.
>SELECT RIGHT(E.employee, LEN(E.employee) - N.Nbr + 1),
> RIGHT(E.employee, N.Nbr)
> FROM Emp as E
> JOIN Numbers as N
> ON N.Nbr between 1 and LEN(E.employee)
>Roy Harvey
>Beacon Falls, CT
>
>[quoted text clipped - 3 lines]
Message posted via http://www.droptable.com|||thnx dan
Dan Guzman wrote:[vbcol=seagreen]
>The example below uses a derived table containing numbers up to the maximum
>size for the FirstName column. You might consider creating a general
>purpose permanent table if this is the sort of thing you do often.
>SELECT
> SUBSTRING(FirstName, Position, LEN(FirstName) - Position + 1) AS A,
> RIGHT(FirstName, Position) AS B
>FROM dbo.emp
>CROSS JOIN (
> SELECT 1 AS Position
> UNION ALL SELECT 2
> UNION ALL SELECT 3
> UNION ALL SELECT 4
> UNION ALL SELECT 5
> UNION ALL SELECT 6
> UNION ALL SELECT 7
> UNION ALL SELECT 8
> UNION ALL SELECT 9
> UNION ALL SELECT 10 AS Position) AS Positions
>WHERE
> FirstName = 'JOHN' AND
> Position <= LEN(FirstName)
>
>[quoted text clipped - 3 lines]
Message posted via http://www.droptable.com

help

I keep getting this message. It is not something I can reacreate b/c it seems to do it randomly. can anyone tell me what causes this.

There is a file sharing violation. A different process might be using the file. [ my documents/APISMobile.sdf ]

Is this a SQL CE or a SQL Mobile database? SQL CE can only have a single connection opened. I have seen this error when another application on your device (most notably, Pocket Query Analyzer) is running in the background and has the database open (and you are trying to access the database from your mobile app as well).

On device, go to Start-->Settings-->System-->Memory and click the RUnning Programs tab to see what apps are running on device.

To close Pocket Query Analyzer, be sure not to click the circled X in the top right corner (this only minimizes the app), but rather use File-->Exit on the menu to close the Query Anlyzer app.

Darren

|||I have noticed that active sync is running and I think that was the problem b/c I had the db in the file to sync. What you told me made me think about it, thanks.

HELP

Error Message "unable to load sql server odbc driver resource DLL.The
Application cannot continute"
Please help me !You might try reinstalling MDAC
http://msdn.microsoft.com/data/downloads/updates/default.aspx. The latest
version is 2.8.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"¶Ë¤ß¤H" <lemel@.hungnet.idv.tw> wrote in message
news:eryrMLU$EHA.2700@.TK2MSFTNGP14.phx.gbl...
> Error Message "unable to load sql server odbc driver resource DLL.The
> Application cannot continute"
> Please help me !
>

help

how can i get the result .....A B
JOHN N
OHN HN
HN OHN
N JOHN
where JOHN is an employee in emp table...
--
Message posted via http://www.sqlmonster.comThe example below uses a derived table containing numbers up to the maximum
size for the FirstName column. You might consider creating a general
purpose permanent table if this is the sort of thing you do often.
SELECT
SUBSTRING(FirstName, Position, LEN(FirstName) - Position + 1) AS A,
RIGHT(FirstName, Position) AS B
FROM dbo.emp
CROSS JOIN (
SELECT 1 AS Position
UNION ALL SELECT 2
UNION ALL SELECT 3
UNION ALL SELECT 4
UNION ALL SELECT 5
UNION ALL SELECT 6
UNION ALL SELECT 7
UNION ALL SELECT 8
UNION ALL SELECT 9
UNION ALL SELECT 10 AS Position) AS Positions
WHERE
FirstName = 'JOHN' AND
Position <= LEN(FirstName)
Hope this helps.
Dan Guzman
SQL Server MVP
"Nishu via SQLMonster.com" <u30587@.uwe> wrote in message
news:6d33e7a43e7ba@.uwe...
> how can i get the result .....A B
> JOHN N
> OHN HN
> HN OHN
> N JOHN
>
>
> where JOHN is an employee in emp table...
> --
> Message posted via http://www.sqlmonster.com
>|||This assumes a table of integers named Numbers with values that at
least cover the range from 1 to the maximum length of the name.
SELECT RIGHT(E.employee, LEN(E.employee) - N.Nbr + 1),
RIGHT(E.employee, N.Nbr)
FROM Emp as E
JOIN Numbers as N
ON N.Nbr between 1 and LEN(E.employee)
Roy Harvey
Beacon Falls, CT
On Fri, 02 Feb 2007 12:18:38 GMT, "Nishu via SQLMonster.com"
<u30587@.uwe> wrote:
>how can i get the result .....A B
> JOHN N
> OHN HN
> HN OHN
> N JOHN
>
>
>where JOHN is an employee in emp table...|||thanx roy,it worked well..:)
Roy Harvey wrote:
>This assumes a table of integers named Numbers with values that at
>least cover the range from 1 to the maximum length of the name.
>SELECT RIGHT(E.employee, LEN(E.employee) - N.Nbr + 1),
> RIGHT(E.employee, N.Nbr)
> FROM Emp as E
> JOIN Numbers as N
> ON N.Nbr between 1 and LEN(E.employee)
>Roy Harvey
>Beacon Falls, CT
>>how can i get the result .....A B
>> JOHN N
>[quoted text clipped - 3 lines]
>>where JOHN is an employee in emp table...
--
Message posted via http://www.sqlmonster.com|||thnx dan:)
Dan Guzman wrote:
>The example below uses a derived table containing numbers up to the maximum
>size for the FirstName column. You might consider creating a general
>purpose permanent table if this is the sort of thing you do often.
>SELECT
> SUBSTRING(FirstName, Position, LEN(FirstName) - Position + 1) AS A,
> RIGHT(FirstName, Position) AS B
>FROM dbo.emp
>CROSS JOIN (
> SELECT 1 AS Position
> UNION ALL SELECT 2
> UNION ALL SELECT 3
> UNION ALL SELECT 4
> UNION ALL SELECT 5
> UNION ALL SELECT 6
> UNION ALL SELECT 7
> UNION ALL SELECT 8
> UNION ALL SELECT 9
> UNION ALL SELECT 10 AS Position) AS Positions
>WHERE
> FirstName = 'JOHN' AND
> Position <= LEN(FirstName)
>> how can i get the result .....A B
>> JOHN N
>[quoted text clipped - 3 lines]
>> where JOHN is an employee in emp table...
--
Message posted via http://www.sqlmonster.com