First, apologies if this is the wrong forum for this post - if so please
gently redirect me to the correct place to post.
I have taken over as the DBA/developer on a ProjectServer instance. In my
database there are some groups of talbes that I don't think should be their.
I can't link them to anything in MSPS and they are probably from some
tutorial. The three sets begin with DS_, OBJ_, and UNV_.
The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
As best as I can tell - reviewing MSPS documentation - these have nothing to
do with ProjectServer. They look like they might have been involved in some
sort of Use Case modeling tool or something.
Is anybody familiar with these tables? Am I free to delete them?
Thanks
Bob,
Looks like Business Objects to me. All ProjectServer tables are prefixed
with MSP_.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Bob wrote:
> First, apologies if this is the wrong forum for this post - if so please
> gently redirect me to the correct place to post.
> I have taken over as the DBA/developer on a ProjectServer instance. In my
> database there are some groups of talbes that I don't think should be their.
> I can't link them to anything in MSPS and they are probably from some
> tutorial. The three sets begin with DS_, OBJ_, and UNV_.
> The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
> The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
> The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
> As best as I can tell - reviewing MSPS documentation - these have nothing to
> do with ProjectServer. They look like they might have been involved in some
> sort of Use Case modeling tool or something.
> Is anybody familiar with these tables? Am I free to delete them?
> Thanks
>
2012年3月22日星期四
Anybody recognize these tables?
First, apologies if this is the wrong forum for this post - if so please
gently redirect me to the correct place to post.
I have taken over as the DBA/developer on a ProjectServer instance. In my
database there are some groups of talbes that I don't think should be their.
I can't link them to anything in MSPS and they are probably from some
tutorial. The three sets begin with DS_, OBJ_, and UNV_.
The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
As best as I can tell - reviewing MSPS documentation - these have nothing to
do with ProjectServer. They look like they might have been involved in some
sort of Use Case modeling tool or something.
Is anybody familiar with these tables? Am I free to delete them?
ThanksBob,
Looks like Business Objects to me. All ProjectServer tables are prefixed
with MSP_.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Bob wrote:
> First, apologies if this is the wrong forum for this post - if so please
> gently redirect me to the correct place to post.
> I have taken over as the DBA/developer on a ProjectServer instance. In my
> database there are some groups of talbes that I don't think should be their.
> I can't link them to anything in MSPS and they are probably from some
> tutorial. The three sets begin with DS_, OBJ_, and UNV_.
> The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
> The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
> The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
> As best as I can tell - reviewing MSPS documentation - these have nothing to
> do with ProjectServer. They look like they might have been involved in some
> sort of Use Case modeling tool or something.
> Is anybody familiar with these tables? Am I free to delete them?
> Thanks
>sql
gently redirect me to the correct place to post.
I have taken over as the DBA/developer on a ProjectServer instance. In my
database there are some groups of talbes that I don't think should be their.
I can't link them to anything in MSPS and they are probably from some
tutorial. The three sets begin with DS_, OBJ_, and UNV_.
The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
As best as I can tell - reviewing MSPS documentation - these have nothing to
do with ProjectServer. They look like they might have been involved in some
sort of Use Case modeling tool or something.
Is anybody familiar with these tables? Am I free to delete them?
ThanksBob,
Looks like Business Objects to me. All ProjectServer tables are prefixed
with MSP_.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Bob wrote:
> First, apologies if this is the wrong forum for this post - if so please
> gently redirect me to the correct place to post.
> I have taken over as the DBA/developer on a ProjectServer instance. In my
> database there are some groups of talbes that I don't think should be their.
> I can't link them to anything in MSPS and they are probably from some
> tutorial. The three sets begin with DS_, OBJ_, and UNV_.
> The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
> The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
> The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
> As best as I can tell - reviewing MSPS documentation - these have nothing to
> do with ProjectServer. They look like they might have been involved in some
> sort of Use Case modeling tool or something.
> Is anybody familiar with these tables? Am I free to delete them?
> Thanks
>sql
Anybody recognize these tables?
First, apologies if this is the wrong forum for this post - if so please
gently redirect me to the correct place to post.
I have taken over as the DBA/developer on a ProjectServer instance. In my
database there are some groups of talbes that I don't think should be their.
I can't link them to anything in MSPS and they are probably from some
tutorial. The three sets begin with DS_, OBJ_, and UNV_.
The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
As best as I can tell - reviewing MSPS documentation - these have nothing to
do with ProjectServer. They look like they might have been involved in some
sort of Use Case modeling tool or something.
Is anybody familiar with these tables? Am I free to delete them?
ThanksBob,
Looks like Business Objects to me. All ProjectServer tables are prefixed
with MSP_.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Bob wrote:
> First, apologies if this is the wrong forum for this post - if so please
> gently redirect me to the correct place to post.
> I have taken over as the DBA/developer on a ProjectServer instance. In my
> database there are some groups of talbes that I don't think should be thei
r.
> I can't link them to anything in MSPS and they are probably from some
> tutorial. The three sets begin with DS_, OBJ_, and UNV_.
> The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
> The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
> The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
> As best as I can tell - reviewing MSPS documentation - these have nothing
to
> do with ProjectServer. They look like they might have been involved in so
me
> sort of Use Case modeling tool or something.
> Is anybody familiar with these tables? Am I free to delete them?
> Thanks
>
gently redirect me to the correct place to post.
I have taken over as the DBA/developer on a ProjectServer instance. In my
database there are some groups of talbes that I don't think should be their.
I can't link them to anything in MSPS and they are probably from some
tutorial. The three sets begin with DS_, OBJ_, and UNV_.
The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
As best as I can tell - reviewing MSPS documentation - these have nothing to
do with ProjectServer. They look like they might have been involved in some
sort of Use Case modeling tool or something.
Is anybody familiar with these tables? Am I free to delete them?
ThanksBob,
Looks like Business Objects to me. All ProjectServer tables are prefixed
with MSP_.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Bob wrote:
> First, apologies if this is the wrong forum for this post - if so please
> gently redirect me to the correct place to post.
> I have taken over as the DBA/developer on a ProjectServer instance. In my
> database there are some groups of talbes that I don't think should be thei
r.
> I can't link them to anything in MSPS and they are probably from some
> tutorial. The three sets begin with DS_, OBJ_, and UNV_.
> The DS_ tables are DS_PENDING_JOBS and DS_USER_LIST
> The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL
> The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ
> As best as I can tell - reviewing MSPS documentation - these have nothing
to
> do with ProjectServer. They look like they might have been involved in so
me
> sort of Use Case modeling tool or something.
> Is anybody familiar with these tables? Am I free to delete them?
> Thanks
>
Anybody knows the syntax? Thanks
declare @.lastmonth char(7)
select comment from tbldescription
where themonth = code.getlastmonth() <-- syntax wrong
getlastmonth() is a function returning last month in form like '2006.02'
Anybody knows the right syntax, please email me back. Thanks!It is not completely clear what are you trying to get.
1. If you want to use you custom code function, then
just use general sql pane (command type=text) and as you data source use:
="select comment from tbldescription where themonth ='"+code.getlastmonth()
+"'"
2. use just a plain sql query (command type=table direct)
select comment from tbldescription where YEAR(yourdatetime_field) =YEAR(GETDATE()) and MONTH(yourdatetime_field) = MONTH (GETDATE()) -1
Hope it helps
Oleg Yevteyev,
San Diego, CA
It is OK to contact me with a contracting opportunity.
"myfirstname"001atgmaildotcom.
Replace "myfirstname" with Oleg.
--
"Henry Chen" <HenryChen@.discussions.microsoft.com> wrote in message
news:5A98BD40-5FB4-4383-B307-4D38D7507690@.microsoft.com...
> declare @.lastmonth char(7)
> select comment from tbldescription
> where themonth = code.getlastmonth() <-- syntax wrong
>
> getlastmonth() is a function returning last month in form like '2006.02'
> Anybody knows the right syntax, please email me back. Thanks!
>
>|||I am creating a data connection and the three line codes are in the dataset
panel, then I click on refresh tab, it generated an error, why? that is my
question.
"Henry Chen" wrote:
> declare @.lastmonth char(7)
> select comment from tbldescription
> where themonth = code.getlastmonth() <-- syntax wrong
>
> getlastmonth() is a function returning last month in form like '2006.02'
> Anybody knows the right syntax, please email me back. Thanks!
>
>|||Hi,
"Why?" That's because SQL server doesn't understand what you are trying to
write and which is not in the SQL SERVER scope. This is used inside the
report.(code.getlastmonth()) Instead use sqlserver commands to get the last
month in your format. Can take it from the last post.
Amarnath
"Henry Chen" wrote:
> I am creating a data connection and the three line codes are in the dataset
> panel, then I click on refresh tab, it generated an error, why? that is my
> question.
> "Henry Chen" wrote:
> > declare @.lastmonth char(7)
> >
> > select comment from tbldescription
> > where themonth = code.getlastmonth() <-- syntax wrong
> >
> >
> > getlastmonth() is a function returning last month in form like '2006.02'
> >
> > Anybody knows the right syntax, please email me back. Thanks!
> >
> >
> >|||the correct answer is
="select comment from tbldescription where themonth = '" +
code.getlastmonth() + "'"
in ONE LINE.
so you are right.
Thanks!
"Henry Chen" wrote:
> declare @.lastmonth char(7)
> select comment from tbldescription
> where themonth = code.getlastmonth() <-- syntax wrong
>
> getlastmonth() is a function returning last month in form like '2006.02'
> Anybody knows the right syntax, please email me back. Thanks!
>
>sql
select comment from tbldescription
where themonth = code.getlastmonth() <-- syntax wrong
getlastmonth() is a function returning last month in form like '2006.02'
Anybody knows the right syntax, please email me back. Thanks!It is not completely clear what are you trying to get.
1. If you want to use you custom code function, then
just use general sql pane (command type=text) and as you data source use:
="select comment from tbldescription where themonth ='"+code.getlastmonth()
+"'"
2. use just a plain sql query (command type=table direct)
select comment from tbldescription where YEAR(yourdatetime_field) =YEAR(GETDATE()) and MONTH(yourdatetime_field) = MONTH (GETDATE()) -1
Hope it helps
Oleg Yevteyev,
San Diego, CA
It is OK to contact me with a contracting opportunity.
"myfirstname"001atgmaildotcom.
Replace "myfirstname" with Oleg.
--
"Henry Chen" <HenryChen@.discussions.microsoft.com> wrote in message
news:5A98BD40-5FB4-4383-B307-4D38D7507690@.microsoft.com...
> declare @.lastmonth char(7)
> select comment from tbldescription
> where themonth = code.getlastmonth() <-- syntax wrong
>
> getlastmonth() is a function returning last month in form like '2006.02'
> Anybody knows the right syntax, please email me back. Thanks!
>
>|||I am creating a data connection and the three line codes are in the dataset
panel, then I click on refresh tab, it generated an error, why? that is my
question.
"Henry Chen" wrote:
> declare @.lastmonth char(7)
> select comment from tbldescription
> where themonth = code.getlastmonth() <-- syntax wrong
>
> getlastmonth() is a function returning last month in form like '2006.02'
> Anybody knows the right syntax, please email me back. Thanks!
>
>|||Hi,
"Why?" That's because SQL server doesn't understand what you are trying to
write and which is not in the SQL SERVER scope. This is used inside the
report.(code.getlastmonth()) Instead use sqlserver commands to get the last
month in your format. Can take it from the last post.
Amarnath
"Henry Chen" wrote:
> I am creating a data connection and the three line codes are in the dataset
> panel, then I click on refresh tab, it generated an error, why? that is my
> question.
> "Henry Chen" wrote:
> > declare @.lastmonth char(7)
> >
> > select comment from tbldescription
> > where themonth = code.getlastmonth() <-- syntax wrong
> >
> >
> > getlastmonth() is a function returning last month in form like '2006.02'
> >
> > Anybody knows the right syntax, please email me back. Thanks!
> >
> >
> >|||the correct answer is
="select comment from tbldescription where themonth = '" +
code.getlastmonth() + "'"
in ONE LINE.
so you are right.
Thanks!
"Henry Chen" wrote:
> declare @.lastmonth char(7)
> select comment from tbldescription
> where themonth = code.getlastmonth() <-- syntax wrong
>
> getlastmonth() is a function returning last month in form like '2006.02'
> Anybody knows the right syntax, please email me back. Thanks!
>
>sql
2012年3月20日星期二
Any way to repair the damage backup file?
Maybe post to wrong group, I am sorry.
If my backup file has error so that the restore is failed, is there any way
to repair the damage backup file?
(The restore procedure of 2005 report there is an error on page 65535:-1)
Thx.
To the best of my knowledge, there's no repair option for a backup. But in 2005, you have the
CONTINUE_AFTER_ERROR option for the RESTORE command. Of could, you will then have a database win
some corruption which you need to handle.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Frank Lee" <Reply@.to.newsgroup> wrote in message news:%23VMMehtDGHA.644@.TK2MSFTNGP09.phx.gbl...
> Maybe post to wrong group, I am sorry.
> If my backup file has error so that the restore is failed, is there any way to repair the damage
> backup file?
> (The restore procedure of 2005 report there is an error on page 65535:-1)
> Thx.
>
|||I see. Thanks. Good news for me.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
??:eWH4mgwDGHA.2924@.tk2msftngp13.phx.gbl...
> To the best of my knowledge, there's no repair option for a backup. But in
> 2005, you have the CONTINUE_AFTER_ERROR option for the RESTORE command. Of
> could, you will then have a database win some corruption which you need to
> handle.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Frank Lee" <Reply@.to.newsgroup> wrote in message
> news:%23VMMehtDGHA.644@.TK2MSFTNGP09.phx.gbl...
>
If my backup file has error so that the restore is failed, is there any way
to repair the damage backup file?
(The restore procedure of 2005 report there is an error on page 65535:-1)
Thx.
To the best of my knowledge, there's no repair option for a backup. But in 2005, you have the
CONTINUE_AFTER_ERROR option for the RESTORE command. Of could, you will then have a database win
some corruption which you need to handle.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Frank Lee" <Reply@.to.newsgroup> wrote in message news:%23VMMehtDGHA.644@.TK2MSFTNGP09.phx.gbl...
> Maybe post to wrong group, I am sorry.
> If my backup file has error so that the restore is failed, is there any way to repair the damage
> backup file?
> (The restore procedure of 2005 report there is an error on page 65535:-1)
> Thx.
>
|||I see. Thanks. Good news for me.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
??:eWH4mgwDGHA.2924@.tk2msftngp13.phx.gbl...
> To the best of my knowledge, there's no repair option for a backup. But in
> 2005, you have the CONTINUE_AFTER_ERROR option for the RESTORE command. Of
> could, you will then have a database win some corruption which you need to
> handle.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Frank Lee" <Reply@.to.newsgroup> wrote in message
> news:%23VMMehtDGHA.644@.TK2MSFTNGP09.phx.gbl...
>
Any way to repair the damage backup file?
Maybe post to wrong group, I am sorry.
If my backup file has error so that the restore is failed, is there any way
to repair the damage backup file?
(The restore procedure of 2005 report there is an error on page 65535:-1)
Thx.To the best of my knowledge, there's no repair option for a backup. But in 2005, you have the
CONTINUE_AFTER_ERROR option for the RESTORE command. Of could, you will then have a database win
some corruption which you need to handle.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Frank Lee" <Reply@.to.newsgroup> wrote in message news:%23VMMehtDGHA.644@.TK2MSFTNGP09.phx.gbl...
> Maybe post to wrong group, I am sorry.
> If my backup file has error so that the restore is failed, is there any way to repair the damage
> backup file?
> (The restore procedure of 2005 report there is an error on page 65535:-1)
> Thx.
>|||I see. Thanks. Good news for me.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
'?:eWH4mgwDGHA.2924@.tk2msftngp13.phx.gbl...
> To the best of my knowledge, there's no repair option for a backup. But in
> 2005, you have the CONTINUE_AFTER_ERROR option for the RESTORE command. Of
> could, you will then have a database win some corruption which you need to
> handle.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Frank Lee" <Reply@.to.newsgroup> wrote in message
> news:%23VMMehtDGHA.644@.TK2MSFTNGP09.phx.gbl...
>> Maybe post to wrong group, I am sorry.
>> If my backup file has error so that the restore is failed, is there any
>> way to repair the damage backup file?
>> (The restore procedure of 2005 report there is an error on page 65535:-1)
>> Thx.
>
If my backup file has error so that the restore is failed, is there any way
to repair the damage backup file?
(The restore procedure of 2005 report there is an error on page 65535:-1)
Thx.To the best of my knowledge, there's no repair option for a backup. But in 2005, you have the
CONTINUE_AFTER_ERROR option for the RESTORE command. Of could, you will then have a database win
some corruption which you need to handle.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Frank Lee" <Reply@.to.newsgroup> wrote in message news:%23VMMehtDGHA.644@.TK2MSFTNGP09.phx.gbl...
> Maybe post to wrong group, I am sorry.
> If my backup file has error so that the restore is failed, is there any way to repair the damage
> backup file?
> (The restore procedure of 2005 report there is an error on page 65535:-1)
> Thx.
>|||I see. Thanks. Good news for me.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
'?:eWH4mgwDGHA.2924@.tk2msftngp13.phx.gbl...
> To the best of my knowledge, there's no repair option for a backup. But in
> 2005, you have the CONTINUE_AFTER_ERROR option for the RESTORE command. Of
> could, you will then have a database win some corruption which you need to
> handle.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Frank Lee" <Reply@.to.newsgroup> wrote in message
> news:%23VMMehtDGHA.644@.TK2MSFTNGP09.phx.gbl...
>> Maybe post to wrong group, I am sorry.
>> If my backup file has error so that the restore is failed, is there any
>> way to repair the damage backup file?
>> (The restore procedure of 2005 report there is an error on page 65535:-1)
>> Thx.
>
Any way to repair the damage backup file?
Maybe post to wrong group, I am sorry.
If my backup file has error so that the restore is failed, is there any way
to repair the damage backup file?
(The restore procedure of 2005 report there is an error on page 65535:-1)
Thx.To the best of my knowledge, there's no repair option for a backup. But in 2
005, you have the
CONTINUE_AFTER_ERROR option for the RESTORE command. Of could, you will then
have a database win
some corruption which you need to handle.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Frank Lee" <Reply@.to.newsgroup> wrote in message news:%23VMMehtDGHA.644@.TK2MSFTNGP09.phx.gb
l...
> Maybe post to wrong group, I am sorry.
> If my backup file has error so that the restore is failed, is there any wa
y to repair the damage
> backup file?
> (The restore procedure of 2005 report there is an error on page 65535:-1)
> Thx.
>|||I see. Thanks. Good news for me.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
'?:eWH4mgwDGHA.2924@.tk2msftngp13.phx.gbl...
> To the best of my knowledge, there's no repair option for a backup. But in
> 2005, you have the CONTINUE_AFTER_ERROR option for the RESTORE command. Of
> could, you will then have a database win some corruption which you need to
> handle.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Frank Lee" <Reply@.to.newsgroup> wrote in message
> news:%23VMMehtDGHA.644@.TK2MSFTNGP09.phx.gbl...
>sql
If my backup file has error so that the restore is failed, is there any way
to repair the damage backup file?
(The restore procedure of 2005 report there is an error on page 65535:-1)
Thx.To the best of my knowledge, there's no repair option for a backup. But in 2
005, you have the
CONTINUE_AFTER_ERROR option for the RESTORE command. Of could, you will then
have a database win
some corruption which you need to handle.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Frank Lee" <Reply@.to.newsgroup> wrote in message news:%23VMMehtDGHA.644@.TK2MSFTNGP09.phx.gb
l...
> Maybe post to wrong group, I am sorry.
> If my backup file has error so that the restore is failed, is there any wa
y to repair the damage
> backup file?
> (The restore procedure of 2005 report there is an error on page 65535:-1)
> Thx.
>|||I see. Thanks. Good news for me.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
'?:eWH4mgwDGHA.2924@.tk2msftngp13.phx.gbl...
> To the best of my knowledge, there's no repair option for a backup. But in
> 2005, you have the CONTINUE_AFTER_ERROR option for the RESTORE command. Of
> could, you will then have a database win some corruption which you need to
> handle.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Frank Lee" <Reply@.to.newsgroup> wrote in message
> news:%23VMMehtDGHA.644@.TK2MSFTNGP09.phx.gbl...
>sql
2012年3月8日星期四
Any response?
Am I in the wrong newsgroup? I thought I read that there should be some
response from Microsoft within one working day?
The question below was posted over a week ago....
Hi
I have SQL2000 dev edition installed and am trying to install a new named
instance of MSDE2000A (to replicate what users will be doing).
However when I run Setup I get "The system administrator has set policies to
prevent this installation." But I am the system administrator!
Setup ini files is as follows:
[Options]
INSTANCENAME="System5"
TARGETDIR="C:\Program Files\Silvertree Engineering\IceSpy System5\"
DATADIR="C:\Program Files\Silvertree Engineering\IceSpy System5\Data\"
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
and I am adding an SAPWD to the command line.
I have the same problem with trying to re-install MS-Office 2003 on a
client's PC. I also logged-in as the admin. I tried editing the registry by
deleting all MS-Office-related entries; somehow, the system still detects
that a previous version had been installed (the program folders were deleted,
including those in "docs & settings).
If you get e decent answer to this problem, please forward to me.
Thanx!
"quilkin" wrote:
> Am I in the wrong newsgroup? I thought I read that there should be some
> response from Microsoft within one working day?
> The question below was posted over a week ago....
> Hi
> I have SQL2000 dev edition installed and am trying to install a new named
> instance of MSDE2000A (to replicate what users will be doing).
> However when I run Setup I get "The system administrator has set policies to
> prevent this installation." But I am the system administrator!
> Setup ini files is as follows:
> [Options]
> INSTANCENAME="System5"
> TARGETDIR="C:\Program Files\Silvertree Engineering\IceSpy System5\"
> DATADIR="C:\Program Files\Silvertree Engineering\IceSpy System5\Data\"
> DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> and I am adding an SAPWD to the command line.
>
|||Microsoft may monitor these newsgroups but there is no guarantee that
someone from MS will respond.
Have you checked to see if there has been any changes the security settings
of your system?
Jim
"quilkin" <quilkin@.discussions.microsoft.com> wrote in message
news:BCEA697C-6EFB-4C68-89C0-D86D2B240254@.microsoft.com...
> Am I in the wrong newsgroup? I thought I read that there should be some
> response from Microsoft within one working day?
> The question below was posted over a week ago....
> Hi
> I have SQL2000 dev edition installed and am trying to install a new named
> instance of MSDE2000A (to replicate what users will be doing).
> However when I run Setup I get "The system administrator has set policies
> to
> prevent this installation." But I am the system administrator!
> Setup ini files is as follows:
> [Options]
> INSTANCENAME="System5"
> TARGETDIR="C:\Program Files\Silvertree Engineering\IceSpy System5\"
> DATADIR="C:\Program Files\Silvertree Engineering\IceSpy System5\Data\"
> DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> and I am adding an SAPWD to the command line.
>
response from Microsoft within one working day?
The question below was posted over a week ago....
Hi
I have SQL2000 dev edition installed and am trying to install a new named
instance of MSDE2000A (to replicate what users will be doing).
However when I run Setup I get "The system administrator has set policies to
prevent this installation." But I am the system administrator!
Setup ini files is as follows:
[Options]
INSTANCENAME="System5"
TARGETDIR="C:\Program Files\Silvertree Engineering\IceSpy System5\"
DATADIR="C:\Program Files\Silvertree Engineering\IceSpy System5\Data\"
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
and I am adding an SAPWD to the command line.
I have the same problem with trying to re-install MS-Office 2003 on a
client's PC. I also logged-in as the admin. I tried editing the registry by
deleting all MS-Office-related entries; somehow, the system still detects
that a previous version had been installed (the program folders were deleted,
including those in "docs & settings).
If you get e decent answer to this problem, please forward to me.
Thanx!
"quilkin" wrote:
> Am I in the wrong newsgroup? I thought I read that there should be some
> response from Microsoft within one working day?
> The question below was posted over a week ago....
> Hi
> I have SQL2000 dev edition installed and am trying to install a new named
> instance of MSDE2000A (to replicate what users will be doing).
> However when I run Setup I get "The system administrator has set policies to
> prevent this installation." But I am the system administrator!
> Setup ini files is as follows:
> [Options]
> INSTANCENAME="System5"
> TARGETDIR="C:\Program Files\Silvertree Engineering\IceSpy System5\"
> DATADIR="C:\Program Files\Silvertree Engineering\IceSpy System5\Data\"
> DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> and I am adding an SAPWD to the command line.
>
|||Microsoft may monitor these newsgroups but there is no guarantee that
someone from MS will respond.
Have you checked to see if there has been any changes the security settings
of your system?
Jim
"quilkin" <quilkin@.discussions.microsoft.com> wrote in message
news:BCEA697C-6EFB-4C68-89C0-D86D2B240254@.microsoft.com...
> Am I in the wrong newsgroup? I thought I read that there should be some
> response from Microsoft within one working day?
> The question below was posted over a week ago....
> Hi
> I have SQL2000 dev edition installed and am trying to install a new named
> instance of MSDE2000A (to replicate what users will be doing).
> However when I run Setup I get "The system administrator has set policies
> to
> prevent this installation." But I am the system administrator!
> Setup ini files is as follows:
> [Options]
> INSTANCENAME="System5"
> TARGETDIR="C:\Program Files\Silvertree Engineering\IceSpy System5\"
> DATADIR="C:\Program Files\Silvertree Engineering\IceSpy System5\Data\"
> DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> and I am adding an SAPWD to the command line.
>
2012年2月25日星期六
any one know whats wrong with it
[CODE]
Private Sub pulllikehell()
Dim cn As SqlCeConnection
Dim rda As SqlCeRemoteDataAccess = Nothing
Dim sqlEngine As SqlCeEngine
Try
' Create database if it doesn't already exist
If (Not File.Exists("\My Documents\ORDER.sdf")) Then
sqlEngine = New SqlCeEngine
sqlEngine.LocalConnectionString = "Data Source=\My Documents\ORDER.sdf;"
sqlEngine.CreateDatabase()
sqlEngine.Dispose()
Else
' Open the connection to the database
cn = New SqlCeConnection("Data Source=\My Documents" & _
"\ORDER.sdf:")
cn.Open()
Dim cmd As SqlCeCommand = cn.CreateCommand()
' Drop the FieldMemos table
cmd.CommandText = "DROP TABLE STAFF"
cmd.ExecuteNonQuery()
' Close the connection
End If
' Instantiate the RDA Object
rda = New SqlCeRemoteDataAccess
' Connection String to the SQL Server.
Dim remoteConnectString As String = "Provider=SQLOLEDB;" & _
"Data Source=KANGALERT/SQLEXPRESS;" & _
"Initial Catalog=ORDER;"
rda.InternetLogin = ""
rda.InternetPassword = ""
rda.InternetUrl = "http://kangalert/server/sqlcesa30.dll"
rda.LocalConnectionString = "Data Source=\My Documents\" & _
"ORDER.sdf;"
rda.Pull("STAFF", "Select * from STAFF", remoteConnectString, _
RdaTrackOption.TrackingOnWithIndexes)
MsgBox("ok")
Catch sqlex As SqlCeException
Dim sqlError As SqlCeError
For Each sqlError In sqlex.Errors
MessageBox.Show(sqlError.Message)
Next
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
rda.Dispose()
End Try
End Sub
[/CODE]
computer server name is kangalert
and got 2 sqlservice run in my pc, SQLEXPRESS and MSSQLSERVER
DATABASE NAME IS ORDER with a TABLE call STAFF
when come to this statement
rda.LocalConnectionString = "Data Source=\My Documents\ORDER.sdf"
ERROR MESSAGE: A request to send data to the computer running IIS has failed. For more information, see HRESULT.
when come to this statement
rda.Pull("STAFF", "Select * from STAFF", remoteConnectString, _
RdaTrackOption.TrackingOnWithIndexes)
ERROR MESSAGE :A required property is not specified. [ Property name = SubscriberConnectionString ]
HOPEFULLY ANYONE CAN HELP ME SOLVE IT. THANKS IN ADVANCE
its a similar problem on the other thread... have you debugged your codes? if u already did, can you be more specific on the location of the problem
...|||ERROR: A request to send data to the computer running IIS has failed
This occurs when the Client Agent box (Emulator or Device) does not have the network connectivity with IIS Box. Make sure you have the connectivity. Try browsing the above sqlcesa30.dll URL in your emulator/device IE, to ensure the connectivity.
ERROR: A required property is not specified. [ Property name = SubscriberConnectionString ]
I really do not understand how you have got this error.
Let us know the results after resolving the first error.
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
订阅：
博文 (Atom)