I have some jobs that when I want to delete or disable it I get bellow error
Msg:
"Error 14274 : cannot add, update, or delete a job that originated from an
MSX server"
what it means? how can I delete this job?
Thanks
TarvirdiIf memory servers, go into the MSDB.dbo.SysJobs table and update the
originating_server column to be that of the name the job currently resides
on. You should then be able to do whatever you want.
"Tarvirdi" wrote:
> I have some jobs that when I want to delete or disable it I get bellow err
or
> Msg:
> "Error 14274 : cannot add, update, or delete a job that originated from an
> MSX server"
> what it means? how can I delete this job?
> Thanks
> Tarvirdi
>
>
Showing posts with label delete. Show all posts
Showing posts with label delete. Show all posts
Monday, March 26, 2012
how disable MSX server generated job
I have some jobs that when I want to delete or disable it I get bellow error
Msg:
"Error 14274 : cannot add, update, or delete a job that originated from an
MSX server"
what it means? how can I delete this job?
Thanks
TarvirdiIf memory servers, go into the MSDB.dbo.SysJobs table and update the
originating_server column to be that of the name the job currently resides
on. You should then be able to do whatever you want.
"Tarvirdi" wrote:
> I have some jobs that when I want to delete or disable it I get bellow error
> Msg:
> "Error 14274 : cannot add, update, or delete a job that originated from an
> MSX server"
> what it means? how can I delete this job?
> Thanks
> Tarvirdi
>
>
Msg:
"Error 14274 : cannot add, update, or delete a job that originated from an
MSX server"
what it means? how can I delete this job?
Thanks
TarvirdiIf memory servers, go into the MSDB.dbo.SysJobs table and update the
originating_server column to be that of the name the job currently resides
on. You should then be able to do whatever you want.
"Tarvirdi" wrote:
> I have some jobs that when I want to delete or disable it I get bellow error
> Msg:
> "Error 14274 : cannot add, update, or delete a job that originated from an
> MSX server"
> what it means? how can I delete this job?
> Thanks
> Tarvirdi
>
>
How delete or rename file in storedprocedure
I want to rename or delete a file in my storedprocedure.
how?
TarvirdiYou can use xp_cmdshell, assuming you understand the permission implications
.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tarvirdi" <m_tarvirdi@.isc.iranet.net> wrote in message
news:ObmPN62YGHA.2208@.TK2MSFTNGP03.phx.gbl...
>I want to rename or delete a file in my storedprocedure.
> how?
> Tarvirdi
>|||U should have permission to execute xp_cmdshell.
U should have configured sql server to enable services for xp_cmdshell.
u can configure xp_cmdshell from sp_configure option.
HTH
from
Doller
how?
TarvirdiYou can use xp_cmdshell, assuming you understand the permission implications
.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tarvirdi" <m_tarvirdi@.isc.iranet.net> wrote in message
news:ObmPN62YGHA.2208@.TK2MSFTNGP03.phx.gbl...
>I want to rename or delete a file in my storedprocedure.
> how?
> Tarvirdi
>|||U should have permission to execute xp_cmdshell.
U should have configured sql server to enable services for xp_cmdshell.
u can configure xp_cmdshell from sp_configure option.
HTH
from
Doller
How delete or rename file in storedprocedure
I want to rename or delete a file in my storedprocedure.
how?
TarvirdiYou can use xp_cmdshell, assuming you understand the permission implications.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tarvirdi" <m_tarvirdi@.isc.iranet.net> wrote in message
news:ObmPN62YGHA.2208@.TK2MSFTNGP03.phx.gbl...
>I want to rename or delete a file in my storedprocedure.
> how?
> Tarvirdi
>|||U should have permission to execute xp_cmdshell.
U should have configured sql server to enable services for xp_cmdshell.
u can configure xp_cmdshell from sp_configure option.
HTH
from
Dollersql
how?
TarvirdiYou can use xp_cmdshell, assuming you understand the permission implications.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tarvirdi" <m_tarvirdi@.isc.iranet.net> wrote in message
news:ObmPN62YGHA.2208@.TK2MSFTNGP03.phx.gbl...
>I want to rename or delete a file in my storedprocedure.
> how?
> Tarvirdi
>|||U should have permission to execute xp_cmdshell.
U should have configured sql server to enable services for xp_cmdshell.
u can configure xp_cmdshell from sp_configure option.
HTH
from
Dollersql
how delete Log Shipping?
Hi,
I have Production database that needs to copied over to Developement
envirnoment where our developers can debug the issues we have in production.
I decided to go with log shipping and scheduled it to copy log every night to
Developemnt from Production.It worked fine...but the database was on
developement(seondry server)in read-only mode which when I tried to remove
gave me an error "database is in warm standby mode, alter database option
fails"
How do I do that developer would have full access (Not in Read-Only)to that
database on secondry server.
I tried to delete the log shipping (with the fear if the changes made to
seondry appear in primary database) and delete the log shipping from
maitenance plan but still not able to bring the database on secondry out of
read0only mode.
Thanks
ShanRESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
restore any further transaction log backups after this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> Hi,
> I have Production database that needs to copied over to Developement
> envirnoment where our developers can debug the issues we have in production.
> I decided to go with log shipping and scheduled it to copy log every night to
> Developemnt from Production.It worked fine...but the database was on
> developement(seondry server)in read-only mode which when I tried to remove
> gave me an error "database is in warm standby mode, alter database option
> fails"
> How do I do that developer would have full access (Not in Read-Only)to that
> database on secondry server.
> I tried to delete the log shipping (with the fear if the changes made to
> seondry appear in primary database) and delete the log shipping from
> maitenance plan but still not able to bring the database on secondry out of
> read0only mode.
> Thanks
> Shan|||Thanks for your reply, It worked. Then what kind of approach I should be
adapting when I have to backup database from one server to another server on
regular bases provided that databases on secondry server available to user
for all activities(Not Read-Only). Through the wizard the only two options I
see is "No Recovery" and "Standby".
Thanks
Shan
"Tibor Karaszi" wrote:
> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
> restore any further transaction log backups after this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Shan" <Shan@.discussions.microsoft.com> wrote in message
> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> > Hi,
> >
> > I have Production database that needs to copied over to Developement
> > envirnoment where our developers can debug the issues we have in production.
> > I decided to go with log shipping and scheduled it to copy log every night to
> > Developemnt from Production.It worked fine...but the database was on
> > developement(seondry server)in read-only mode which when I tried to remove
> > gave me an error "database is in warm standby mode, alter database option
> > fails"
> >
> > How do I do that developer would have full access (Not in Read-Only)to that
> > database on secondry server.
> >
> > I tried to delete the log shipping (with the fear if the changes made to
> > seondry appear in primary database) and delete the log shipping from
> > maitenance plan but still not able to bring the database on secondry out of
> > read0only mode.
> >
> > Thanks
> >
> > Shan
>
>|||'That is not possible using backup and restore (which is what log shipping is using). How would you
expect to restore a backup based on a prior backup if you have done modifications in the database
since you restored that prior backup? You might want to look at replication instead. I suggest you
read:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:60664FEF-29FD-4F97-AEC9-F3AA4654586B@.microsoft.com...
> Thanks for your reply, It worked. Then what kind of approach I should be
> adapting when I have to backup database from one server to another server on
> regular bases provided that databases on secondry server available to user
> for all activities(Not Read-Only). Through the wizard the only two options I
> see is "No Recovery" and "Standby".
> Thanks
> Shan
> "Tibor Karaszi" wrote:
>> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
>> restore any further transaction log backups after this.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Shan" <Shan@.discussions.microsoft.com> wrote in message
>> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
>> > Hi,
>> >
>> > I have Production database that needs to copied over to Developement
>> > envirnoment where our developers can debug the issues we have in production.
>> > I decided to go with log shipping and scheduled it to copy log every night to
>> > Developemnt from Production.It worked fine...but the database was on
>> > developement(seondry server)in read-only mode which when I tried to remove
>> > gave me an error "database is in warm standby mode, alter database option
>> > fails"
>> >
>> > How do I do that developer would have full access (Not in Read-Only)to that
>> > database on secondry server.
>> >
>> > I tried to delete the log shipping (with the fear if the changes made to
>> > seondry appear in primary database) and delete the log shipping from
>> > maitenance plan but still not able to bring the database on secondry out of
>> > read0only mode.
>> >
>> > Thanks
>> >
>> > Shan
>>
I have Production database that needs to copied over to Developement
envirnoment where our developers can debug the issues we have in production.
I decided to go with log shipping and scheduled it to copy log every night to
Developemnt from Production.It worked fine...but the database was on
developement(seondry server)in read-only mode which when I tried to remove
gave me an error "database is in warm standby mode, alter database option
fails"
How do I do that developer would have full access (Not in Read-Only)to that
database on secondry server.
I tried to delete the log shipping (with the fear if the changes made to
seondry appear in primary database) and delete the log shipping from
maitenance plan but still not able to bring the database on secondry out of
read0only mode.
Thanks
ShanRESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
restore any further transaction log backups after this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> Hi,
> I have Production database that needs to copied over to Developement
> envirnoment where our developers can debug the issues we have in production.
> I decided to go with log shipping and scheduled it to copy log every night to
> Developemnt from Production.It worked fine...but the database was on
> developement(seondry server)in read-only mode which when I tried to remove
> gave me an error "database is in warm standby mode, alter database option
> fails"
> How do I do that developer would have full access (Not in Read-Only)to that
> database on secondry server.
> I tried to delete the log shipping (with the fear if the changes made to
> seondry appear in primary database) and delete the log shipping from
> maitenance plan but still not able to bring the database on secondry out of
> read0only mode.
> Thanks
> Shan|||Thanks for your reply, It worked. Then what kind of approach I should be
adapting when I have to backup database from one server to another server on
regular bases provided that databases on secondry server available to user
for all activities(Not Read-Only). Through the wizard the only two options I
see is "No Recovery" and "Standby".
Thanks
Shan
"Tibor Karaszi" wrote:
> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
> restore any further transaction log backups after this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Shan" <Shan@.discussions.microsoft.com> wrote in message
> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> > Hi,
> >
> > I have Production database that needs to copied over to Developement
> > envirnoment where our developers can debug the issues we have in production.
> > I decided to go with log shipping and scheduled it to copy log every night to
> > Developemnt from Production.It worked fine...but the database was on
> > developement(seondry server)in read-only mode which when I tried to remove
> > gave me an error "database is in warm standby mode, alter database option
> > fails"
> >
> > How do I do that developer would have full access (Not in Read-Only)to that
> > database on secondry server.
> >
> > I tried to delete the log shipping (with the fear if the changes made to
> > seondry appear in primary database) and delete the log shipping from
> > maitenance plan but still not able to bring the database on secondry out of
> > read0only mode.
> >
> > Thanks
> >
> > Shan
>
>|||'That is not possible using backup and restore (which is what log shipping is using). How would you
expect to restore a backup based on a prior backup if you have done modifications in the database
since you restored that prior backup? You might want to look at replication instead. I suggest you
read:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:60664FEF-29FD-4F97-AEC9-F3AA4654586B@.microsoft.com...
> Thanks for your reply, It worked. Then what kind of approach I should be
> adapting when I have to backup database from one server to another server on
> regular bases provided that databases on secondry server available to user
> for all activities(Not Read-Only). Through the wizard the only two options I
> see is "No Recovery" and "Standby".
> Thanks
> Shan
> "Tibor Karaszi" wrote:
>> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
>> restore any further transaction log backups after this.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Shan" <Shan@.discussions.microsoft.com> wrote in message
>> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
>> > Hi,
>> >
>> > I have Production database that needs to copied over to Developement
>> > envirnoment where our developers can debug the issues we have in production.
>> > I decided to go with log shipping and scheduled it to copy log every night to
>> > Developemnt from Production.It worked fine...but the database was on
>> > developement(seondry server)in read-only mode which when I tried to remove
>> > gave me an error "database is in warm standby mode, alter database option
>> > fails"
>> >
>> > How do I do that developer would have full access (Not in Read-Only)to that
>> > database on secondry server.
>> >
>> > I tried to delete the log shipping (with the fear if the changes made to
>> > seondry appear in primary database) and delete the log shipping from
>> > maitenance plan but still not able to bring the database on secondry out of
>> > read0only mode.
>> >
>> > Thanks
>> >
>> > Shan
>>
how delete Log Shipping?
Hi,
I have Production database that needs to copied over to Developement
envirnoment where our developers can debug the issues we have in production.
I decided to go with log shipping and scheduled it to copy log every night t
o
Developemnt from Production.It worked fine...but the database was on
developement(seondry server)in read-only mode which when I tried to remove
gave me an error "database is in warm standby mode, alter database option
fails"
How do I do that developer would have full access (Not in Read-Only)to that
database on secondry server.
I tried to delete the log shipping (with the fear if the changes made to
seondry appear in primary database) and delete the log shipping from
maitenance plan but still not able to bring the database on secondry out of
read0only mode.
Thanks
ShanRESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But y
ou won't be able to
restore any further transaction log backups after this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> Hi,
> I have Production database that needs to copied over to Developement
> envirnoment where our developers can debug the issues we have in productio
n.
> I decided to go with log shipping and scheduled it to copy log every night
to
> Developemnt from Production.It worked fine...but the database was on
> developement(seondry server)in read-only mode which when I tried to remove
> gave me an error "database is in warm standby mode, alter database option
> fails"
> How do I do that developer would have full access (Not in Read-Only)to tha
t
> database on secondry server.
> I tried to delete the log shipping (with the fear if the changes made to
> seondry appear in primary database) and delete the log shipping from
> maitenance plan but still not able to bring the database on secondry out o
f
> read0only mode.
> Thanks
> Shan|||Thanks for your reply, It worked. Then what kind of approach I should be
adapting when I have to backup database from one server to another server on
regular bases provided that databases on secondry server available to user
for all activities(Not Read-Only). Through the wizard the only two options I
see is "No Recovery" and "Standby".
Thanks
Shan
"Tibor Karaszi" wrote:
> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But
you won't be able to
> restore any further transaction log backups after this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Shan" <Shan@.discussions.microsoft.com> wrote in message
> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
>
>|||'That is not possible using backup and restore (which is what log shipping i
s using). How would you
expect to restore a backup based on a prior backup if you have done modifica
tions in the database
since you restored that prior backup? You might want to look at replication
instead. I suggest you
read:
http://www.microsoft.com/technet/pr...oy/sqlhalp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:60664FEF-29FD-4F97-AEC9-F3AA4654586B@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply, It worked. Then what kind of approach I should be
> adapting when I have to backup database from one server to another server
on
> regular bases provided that databases on secondry server available to user
> for all activities(Not Read-Only). Through the wizard the only two options
I
> see is "No Recovery" and "Standby".
> Thanks
> Shan
> "Tibor Karaszi" wrote:
>
I have Production database that needs to copied over to Developement
envirnoment where our developers can debug the issues we have in production.
I decided to go with log shipping and scheduled it to copy log every night t
o
Developemnt from Production.It worked fine...but the database was on
developement(seondry server)in read-only mode which when I tried to remove
gave me an error "database is in warm standby mode, alter database option
fails"
How do I do that developer would have full access (Not in Read-Only)to that
database on secondry server.
I tried to delete the log shipping (with the fear if the changes made to
seondry appear in primary database) and delete the log shipping from
maitenance plan but still not able to bring the database on secondry out of
read0only mode.
Thanks
ShanRESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But y
ou won't be able to
restore any further transaction log backups after this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> Hi,
> I have Production database that needs to copied over to Developement
> envirnoment where our developers can debug the issues we have in productio
n.
> I decided to go with log shipping and scheduled it to copy log every night
to
> Developemnt from Production.It worked fine...but the database was on
> developement(seondry server)in read-only mode which when I tried to remove
> gave me an error "database is in warm standby mode, alter database option
> fails"
> How do I do that developer would have full access (Not in Read-Only)to tha
t
> database on secondry server.
> I tried to delete the log shipping (with the fear if the changes made to
> seondry appear in primary database) and delete the log shipping from
> maitenance plan but still not able to bring the database on secondry out o
f
> read0only mode.
> Thanks
> Shan|||Thanks for your reply, It worked. Then what kind of approach I should be
adapting when I have to backup database from one server to another server on
regular bases provided that databases on secondry server available to user
for all activities(Not Read-Only). Through the wizard the only two options I
see is "No Recovery" and "Standby".
Thanks
Shan
"Tibor Karaszi" wrote:
> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But
you won't be able to
> restore any further transaction log backups after this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Shan" <Shan@.discussions.microsoft.com> wrote in message
> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
>
>|||'That is not possible using backup and restore (which is what log shipping i
s using). How would you
expect to restore a backup based on a prior backup if you have done modifica
tions in the database
since you restored that prior backup? You might want to look at replication
instead. I suggest you
read:
http://www.microsoft.com/technet/pr...oy/sqlhalp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:60664FEF-29FD-4F97-AEC9-F3AA4654586B@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply, It worked. Then what kind of approach I should be
> adapting when I have to backup database from one server to another server
on
> regular bases provided that databases on secondry server available to user
> for all activities(Not Read-Only). Through the wizard the only two options
I
> see is "No Recovery" and "Standby".
> Thanks
> Shan
> "Tibor Karaszi" wrote:
>
how delete Log Shipping?
Hi,
I have Production database that needs to copied over to Developement
envirnoment where our developers can debug the issues we have in production.
I decided to go with log shipping and scheduled it to copy log every night to
Developemnt from Production.It worked fine...but the database was on
developement(seondry server)in read-only mode which when I tried to remove
gave me an error "database is in warm standby mode, alter database option
fails"
How do I do that developer would have full access (Not in Read-Only)to that
database on secondry server.
I tried to delete the log shipping (with the fear if the changes made to
seondry appear in primary database) and delete the log shipping from
maitenance plan but still not able to bring the database on secondry out of
read0only mode.
Thanks
Shan
RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
restore any further transaction log backups after this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> Hi,
> I have Production database that needs to copied over to Developement
> envirnoment where our developers can debug the issues we have in production.
> I decided to go with log shipping and scheduled it to copy log every night to
> Developemnt from Production.It worked fine...but the database was on
> developement(seondry server)in read-only mode which when I tried to remove
> gave me an error "database is in warm standby mode, alter database option
> fails"
> How do I do that developer would have full access (Not in Read-Only)to that
> database on secondry server.
> I tried to delete the log shipping (with the fear if the changes made to
> seondry appear in primary database) and delete the log shipping from
> maitenance plan but still not able to bring the database on secondry out of
> read0only mode.
> Thanks
> Shan
|||Thanks for your reply, It worked. Then what kind of approach I should be
adapting when I have to backup database from one server to another server on
regular bases provided that databases on secondry server available to user
for all activities(Not Read-Only). Through the wizard the only two options I
see is "No Recovery" and "Standby".
Thanks
Shan
"Tibor Karaszi" wrote:
> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
> restore any further transaction log backups after this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Shan" <Shan@.discussions.microsoft.com> wrote in message
> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
>
>
|||'That is not possible using backup and restore (which is what log shipping is using). How would you
expect to restore a backup based on a prior backup if you have done modifications in the database
since you restored that prior backup? You might want to look at replication instead. I suggest you
read:
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:60664FEF-29FD-4F97-AEC9-F3AA4654586B@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply, It worked. Then what kind of approach I should be
> adapting when I have to backup database from one server to another server on
> regular bases provided that databases on secondry server available to user
> for all activities(Not Read-Only). Through the wizard the only two options I
> see is "No Recovery" and "Standby".
> Thanks
> Shan
> "Tibor Karaszi" wrote:
I have Production database that needs to copied over to Developement
envirnoment where our developers can debug the issues we have in production.
I decided to go with log shipping and scheduled it to copy log every night to
Developemnt from Production.It worked fine...but the database was on
developement(seondry server)in read-only mode which when I tried to remove
gave me an error "database is in warm standby mode, alter database option
fails"
How do I do that developer would have full access (Not in Read-Only)to that
database on secondry server.
I tried to delete the log shipping (with the fear if the changes made to
seondry appear in primary database) and delete the log shipping from
maitenance plan but still not able to bring the database on secondry out of
read0only mode.
Thanks
Shan
RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
restore any further transaction log backups after this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> Hi,
> I have Production database that needs to copied over to Developement
> envirnoment where our developers can debug the issues we have in production.
> I decided to go with log shipping and scheduled it to copy log every night to
> Developemnt from Production.It worked fine...but the database was on
> developement(seondry server)in read-only mode which when I tried to remove
> gave me an error "database is in warm standby mode, alter database option
> fails"
> How do I do that developer would have full access (Not in Read-Only)to that
> database on secondry server.
> I tried to delete the log shipping (with the fear if the changes made to
> seondry appear in primary database) and delete the log shipping from
> maitenance plan but still not able to bring the database on secondry out of
> read0only mode.
> Thanks
> Shan
|||Thanks for your reply, It worked. Then what kind of approach I should be
adapting when I have to backup database from one server to another server on
regular bases provided that databases on secondry server available to user
for all activities(Not Read-Only). Through the wizard the only two options I
see is "No Recovery" and "Standby".
Thanks
Shan
"Tibor Karaszi" wrote:
> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
> restore any further transaction log backups after this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Shan" <Shan@.discussions.microsoft.com> wrote in message
> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
>
>
|||'That is not possible using backup and restore (which is what log shipping is using). How would you
expect to restore a backup based on a prior backup if you have done modifications in the database
since you restored that prior backup? You might want to look at replication instead. I suggest you
read:
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:60664FEF-29FD-4F97-AEC9-F3AA4654586B@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply, It worked. Then what kind of approach I should be
> adapting when I have to backup database from one server to another server on
> regular bases provided that databases on secondry server available to user
> for all activities(Not Read-Only). Through the wizard the only two options I
> see is "No Recovery" and "Standby".
> Thanks
> Shan
> "Tibor Karaszi" wrote:
How delete BIDS "Recent Projects" projects?
When I open BIDS it displays a list of "Recent Projects". How can I edit (or delete) items from this list? (Over time the list has acquired a lot of junk\test projects that I no longer need).
TIA,
Barkingdog
It's a set of keys in the registry.
To delete the 'Recent Projects' list the key is:
HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0\ProjectMRUList
To delete 'Recent Files' list, the key is:
HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0\FileMRUList
Where, of course, 8.0 corresponds to your version of Visual Studio.
How delete a log file
I have unfortunately create a second log file for a database.
So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
I would delete DataLog2.ldf, but it's now the active log file, and the
operation can't terminate.
Thanks
Try DBCC SHRINKFILE with the EMPTYFILE option.
Hope this helps.
Dan Guzman
SQL Server MVP
"Jean-Paul" <Jean-Paul@.discussions.microsoft.com> wrote in message
news:56283E5B-FB80-46DA-8DEE-D446F940F43C@.microsoft.com...
> I have unfortunately create a second log file for a database.
> So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
> I would delete DataLog2.ldf, but it's now the active log file, and the
> operation can't terminate.
> Thanks
|||Hi Jean-Paul,
Can you try detaching the database, delete the log file and then attach
the database? There are packages available within sqlserver "sp_detach_db"
and
"sp_attach_single_file_db".? Take a backup to be safe before making this
structural change.
Thanks,
Chandan Dutta
"Jean-Paul" wrote:
> I have unfortunately create a second log file for a database.
> So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
> I would delete DataLog2.ldf, but it's now the active log file, and the
> operation can't terminate.
> Thanks
|||Hi Chandan,
sp_attach_single_file_db command might fail if you have multiple LDF files.
As well it is risky to do this command on a production server.
Jean_paul,
You could follow the Dan Guzmans option, I can detail you the steps to
remove 1 LDF file :-
Insted of detaching the database you can empty the second LDF and Remove the
file.
How to check the number of LDF files used by a database:-
sp_helpdb <dbname>
If you have 2 LDF files ,to remove a file , you must first have the data
moved off of the file onto the other members in the data set.
To do this, use the EMPTY FILE parameter in DBCC SHRINKFILE command. This
will empty the file and mark it as unavailable.
See the commands to remove a ldf :-
backup log <dbname> to disk='c:\backup\dbname.trn'
go
use <dbname>
go
dbcc shrinkfile('logical_log_filename_to_delete','empty file')
go
alter database <dbname> remove file 'logical_log_file_name_to_delete'
Thanks
Hari
MCDBA
"Chandan Dutta" <ChandanDutta@.discussions.microsoft.com> wrote in message
news:25EC1FE9-F2AB-4AD4-BE70-48D06165A384@.microsoft.com...
> Hi Jean-Paul,
> Can you try detaching the database, delete the log file and then
attach[vbcol=seagreen]
> the database? There are packages available within sqlserver "sp_detach_db"
> and
> "sp_attach_single_file_db".? Take a backup to be safe before making this
> structural change.
> Thanks,
> Chandan Dutta
>
> "Jean-Paul" wrote:
sql
So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
I would delete DataLog2.ldf, but it's now the active log file, and the
operation can't terminate.
Thanks
Try DBCC SHRINKFILE with the EMPTYFILE option.
Hope this helps.
Dan Guzman
SQL Server MVP
"Jean-Paul" <Jean-Paul@.discussions.microsoft.com> wrote in message
news:56283E5B-FB80-46DA-8DEE-D446F940F43C@.microsoft.com...
> I have unfortunately create a second log file for a database.
> So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
> I would delete DataLog2.ldf, but it's now the active log file, and the
> operation can't terminate.
> Thanks
|||Hi Jean-Paul,
Can you try detaching the database, delete the log file and then attach
the database? There are packages available within sqlserver "sp_detach_db"
and
"sp_attach_single_file_db".? Take a backup to be safe before making this
structural change.
Thanks,
Chandan Dutta
"Jean-Paul" wrote:
> I have unfortunately create a second log file for a database.
> So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
> I would delete DataLog2.ldf, but it's now the active log file, and the
> operation can't terminate.
> Thanks
|||Hi Chandan,
sp_attach_single_file_db command might fail if you have multiple LDF files.
As well it is risky to do this command on a production server.
Jean_paul,
You could follow the Dan Guzmans option, I can detail you the steps to
remove 1 LDF file :-
Insted of detaching the database you can empty the second LDF and Remove the
file.
How to check the number of LDF files used by a database:-
sp_helpdb <dbname>
If you have 2 LDF files ,to remove a file , you must first have the data
moved off of the file onto the other members in the data set.
To do this, use the EMPTY FILE parameter in DBCC SHRINKFILE command. This
will empty the file and mark it as unavailable.
See the commands to remove a ldf :-
backup log <dbname> to disk='c:\backup\dbname.trn'
go
use <dbname>
go
dbcc shrinkfile('logical_log_filename_to_delete','empty file')
go
alter database <dbname> remove file 'logical_log_file_name_to_delete'
Thanks
Hari
MCDBA
"Chandan Dutta" <ChandanDutta@.discussions.microsoft.com> wrote in message
news:25EC1FE9-F2AB-4AD4-BE70-48D06165A384@.microsoft.com...
> Hi Jean-Paul,
> Can you try detaching the database, delete the log file and then
attach[vbcol=seagreen]
> the database? There are packages available within sqlserver "sp_detach_db"
> and
> "sp_attach_single_file_db".? Take a backup to be safe before making this
> structural change.
> Thanks,
> Chandan Dutta
>
> "Jean-Paul" wrote:
sql
How delete a log file
I have unfortunately create a second log file for a database.
So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
I would delete DataLog2.ldf, but it's now the active log file, and the
operation can't terminate.
ThanksTry DBCC SHRINKFILE with the EMPTYFILE option.
Hope this helps.
Dan Guzman
SQL Server MVP
"Jean-Paul" <Jean-Paul@.discussions.microsoft.com> wrote in message
news:56283E5B-FB80-46DA-8DEE-D446F940F43C@.microsoft.com...
> I have unfortunately create a second log file for a database.
> So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
> I would delete DataLog2.ldf, but it's now the active log file, and the
> operation can't terminate.
> Thanks|||Hi Jean-Paul,
Can you try detaching the database, delete the log file and then attach
the database? There are packages available within sqlserver "sp_detach_db"
and
"sp_attach_single_file_db".? Take a backup to be safe before making this
structural change.
Thanks,
Chandan Dutta
"Jean-Paul" wrote:
> I have unfortunately create a second log file for a database.
> So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
> I would delete DataLog2.ldf, but it's now the active log file, and the
> operation can't terminate.
> Thanks|||Hi Chandan,
sp_attach_single_file_db command might fail if you have multiple LDF files.
As well it is risky to do this command on a production server.
Jean_paul,
You could follow the Dan Guzmans option, I can detail you the steps to
remove 1 LDF file :-
Insted of detaching the database you can empty the second LDF and Remove the
file.
How to check the number of LDF files used by a database:-
sp_helpdb <dbname>
If you have 2 LDF files ,to remove a file , you must first have the data
moved off of the file onto the other members in the data set.
To do this, use the EMPTY FILE parameter in DBCC SHRINKFILE command. This
will empty the file and mark it as unavailable.
See the commands to remove a ldf :-
backup log <dbname> to disk='c:\backup\dbname.trn'
go
use <dbname>
go
dbcc shrinkfile('logical_log_filename_to_dele
te','emptyfile')
go
alter database <dbname> remove file 'logical_log_file_name_to_delete'
Thanks
Hari
MCDBA
"Chandan Dutta" <ChandanDutta@.discussions.microsoft.com> wrote in message
news:25EC1FE9-F2AB-4AD4-BE70-48D06165A384@.microsoft.com...
> Hi Jean-Paul,
> Can you try detaching the database, delete the log file and then
attach[vbcol=seagreen]
> the database? There are packages available within sqlserver "sp_detach_db"
> and
> "sp_attach_single_file_db".? Take a backup to be safe before making this
> structural change.
> Thanks,
> Chandan Dutta
>
> "Jean-Paul" wrote:
>
So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
I would delete DataLog2.ldf, but it's now the active log file, and the
operation can't terminate.
ThanksTry DBCC SHRINKFILE with the EMPTYFILE option.
Hope this helps.
Dan Guzman
SQL Server MVP
"Jean-Paul" <Jean-Paul@.discussions.microsoft.com> wrote in message
news:56283E5B-FB80-46DA-8DEE-D446F940F43C@.microsoft.com...
> I have unfortunately create a second log file for a database.
> So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
> I would delete DataLog2.ldf, but it's now the active log file, and the
> operation can't terminate.
> Thanks|||Hi Jean-Paul,
Can you try detaching the database, delete the log file and then attach
the database? There are packages available within sqlserver "sp_detach_db"
and
"sp_attach_single_file_db".? Take a backup to be safe before making this
structural change.
Thanks,
Chandan Dutta
"Jean-Paul" wrote:
> I have unfortunately create a second log file for a database.
> So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
> I would delete DataLog2.ldf, but it's now the active log file, and the
> operation can't terminate.
> Thanks|||Hi Chandan,
sp_attach_single_file_db command might fail if you have multiple LDF files.
As well it is risky to do this command on a production server.
Jean_paul,
You could follow the Dan Guzmans option, I can detail you the steps to
remove 1 LDF file :-
Insted of detaching the database you can empty the second LDF and Remove the
file.
How to check the number of LDF files used by a database:-
sp_helpdb <dbname>
If you have 2 LDF files ,to remove a file , you must first have the data
moved off of the file onto the other members in the data set.
To do this, use the EMPTY FILE parameter in DBCC SHRINKFILE command. This
will empty the file and mark it as unavailable.
See the commands to remove a ldf :-
backup log <dbname> to disk='c:\backup\dbname.trn'
go
use <dbname>
go
dbcc shrinkfile('logical_log_filename_to_dele
te','emptyfile')
go
alter database <dbname> remove file 'logical_log_file_name_to_delete'
Thanks
Hari
MCDBA
"Chandan Dutta" <ChandanDutta@.discussions.microsoft.com> wrote in message
news:25EC1FE9-F2AB-4AD4-BE70-48D06165A384@.microsoft.com...
> Hi Jean-Paul,
> Can you try detaching the database, delete the log file and then
attach[vbcol=seagreen]
> the database? There are packages available within sqlserver "sp_detach_db"
> and
> "sp_attach_single_file_db".? Take a backup to be safe before making this
> structural change.
> Thanks,
> Chandan Dutta
>
> "Jean-Paul" wrote:
>
How delete a log file
I have unfortunately create a second log file for a database.
So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
I would delete DataLog2.ldf, but it's now the active log file, and the
operation can't terminate.
ThanksTry DBCC SHRINKFILE with the EMPTYFILE option.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Jean-Paul" <Jean-Paul@.discussions.microsoft.com> wrote in message
news:56283E5B-FB80-46DA-8DEE-D446F940F43C@.microsoft.com...
> I have unfortunately create a second log file for a database.
> So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
> I would delete DataLog2.ldf, but it's now the active log file, and the
> operation can't terminate.
> Thanks|||Hi Chandan,
sp_attach_single_file_db command might fail if you have multiple LDF files.
As well it is risky to do this command on a production server.
Jean_paul,
You could follow the Dan Guzmans option, I can detail you the steps to
remove 1 LDF file :-
Insted of detaching the database you can empty the second LDF and Remove the
file.
How to check the number of LDF files used by a database:-
sp_helpdb <dbname>
If you have 2 LDF files ,to remove a file , you must first have the data
moved off of the file onto the other members in the data set.
To do this, use the EMPTY FILE parameter in DBCC SHRINKFILE command. This
will empty the file and mark it as unavailable.
See the commands to remove a ldf :-
backup log <dbname> to disk='c:\backup\dbname.trn'
go
use <dbname>
go
dbcc shrinkfile('logical_log_filename_to_delete','emptyfile')
go
alter database <dbname> remove file 'logical_log_file_name_to_delete'
--
Thanks
Hari
MCDBA
"Chandan Dutta" <ChandanDutta@.discussions.microsoft.com> wrote in message
news:25EC1FE9-F2AB-4AD4-BE70-48D06165A384@.microsoft.com...
> Hi Jean-Paul,
> Can you try detaching the database, delete the log file and then
attach
> the database? There are packages available within sqlserver "sp_detach_db"
> and
> "sp_attach_single_file_db".? Take a backup to be safe before making this
> structural change.
> Thanks,
> Chandan Dutta
>
> "Jean-Paul" wrote:
> > I have unfortunately create a second log file for a database.
> > So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
> > I would delete DataLog2.ldf, but it's now the active log file, and the
> > operation can't terminate.
> >
> > Thanks
So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
I would delete DataLog2.ldf, but it's now the active log file, and the
operation can't terminate.
ThanksTry DBCC SHRINKFILE with the EMPTYFILE option.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Jean-Paul" <Jean-Paul@.discussions.microsoft.com> wrote in message
news:56283E5B-FB80-46DA-8DEE-D446F940F43C@.microsoft.com...
> I have unfortunately create a second log file for a database.
> So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
> I would delete DataLog2.ldf, but it's now the active log file, and the
> operation can't terminate.
> Thanks|||Hi Chandan,
sp_attach_single_file_db command might fail if you have multiple LDF files.
As well it is risky to do this command on a production server.
Jean_paul,
You could follow the Dan Guzmans option, I can detail you the steps to
remove 1 LDF file :-
Insted of detaching the database you can empty the second LDF and Remove the
file.
How to check the number of LDF files used by a database:-
sp_helpdb <dbname>
If you have 2 LDF files ,to remove a file , you must first have the data
moved off of the file onto the other members in the data set.
To do this, use the EMPTY FILE parameter in DBCC SHRINKFILE command. This
will empty the file and mark it as unavailable.
See the commands to remove a ldf :-
backup log <dbname> to disk='c:\backup\dbname.trn'
go
use <dbname>
go
dbcc shrinkfile('logical_log_filename_to_delete','emptyfile')
go
alter database <dbname> remove file 'logical_log_file_name_to_delete'
--
Thanks
Hari
MCDBA
"Chandan Dutta" <ChandanDutta@.discussions.microsoft.com> wrote in message
news:25EC1FE9-F2AB-4AD4-BE70-48D06165A384@.microsoft.com...
> Hi Jean-Paul,
> Can you try detaching the database, delete the log file and then
attach
> the database? There are packages available within sqlserver "sp_detach_db"
> and
> "sp_attach_single_file_db".? Take a backup to be safe before making this
> structural change.
> Thanks,
> Chandan Dutta
>
> "Jean-Paul" wrote:
> > I have unfortunately create a second log file for a database.
> > So i have now 1 DataFile.mdf, 1 DataLog1.ldf and 1 DataLog2.ldf
> > I would delete DataLog2.ldf, but it's now the active log file, and the
> > operation can't terminate.
> >
> > Thanks
Sunday, February 19, 2012
How can I totally remove a connection in a DTS
Hi, when I remove a connection by clicking rigth button delete, this is
removed in the graphic enviroment, but the connection is still in the
DTS when I select the option Disconnected Edit and expand the
connection node.
Could somebody give me a tip to solve this, because is not good to see
10 connections in the disconnected edit window, if the DTS use only 1.
Thanks
Gus
Drag a new connection onto the designer. Select the old
connection you want to delete in the Existing connection
drop down. Click OK to save this connection. Then delete
this connection you just created. It will delete the old
connection reference with it.
You can get these orphaned connections when you rename
an existing connection.
-Sue
On 20 Sep 2006 13:55:51 -0700, "Gus" <gzaffa@.gmail.com>
wrote:
>Hi, when I remove a connection by clicking rigth button delete, this is
>removed in the graphic enviroment, but the connection is still in the
>DTS when I select the option Disconnected Edit and expand the
>connection node.
>Could somebody give me a tip to solve this, because is not good to see
>10 connections in the disconnected edit window, if the DTS use only 1.
>Thanks
>Gus
|||Sue, Thank you very much it works great ! ! !
Gustavo Zaffaroni
Sue Hoegemeier wrote:[vbcol=seagreen]
> Drag a new connection onto the designer. Select the old
> connection you want to delete in the Existing connection
> drop down. Click OK to save this connection. Then delete
> this connection you just created. It will delete the old
> connection reference with it.
> You can get these orphaned connections when you rename
> an existing connection.
> -Sue
> On 20 Sep 2006 13:55:51 -0700, "Gus" <gzaffa@.gmail.com>
> wrote:
removed in the graphic enviroment, but the connection is still in the
DTS when I select the option Disconnected Edit and expand the
connection node.
Could somebody give me a tip to solve this, because is not good to see
10 connections in the disconnected edit window, if the DTS use only 1.
Thanks
Gus
Drag a new connection onto the designer. Select the old
connection you want to delete in the Existing connection
drop down. Click OK to save this connection. Then delete
this connection you just created. It will delete the old
connection reference with it.
You can get these orphaned connections when you rename
an existing connection.
-Sue
On 20 Sep 2006 13:55:51 -0700, "Gus" <gzaffa@.gmail.com>
wrote:
>Hi, when I remove a connection by clicking rigth button delete, this is
>removed in the graphic enviroment, but the connection is still in the
>DTS when I select the option Disconnected Edit and expand the
>connection node.
>Could somebody give me a tip to solve this, because is not good to see
>10 connections in the disconnected edit window, if the DTS use only 1.
>Thanks
>Gus
|||Sue, Thank you very much it works great ! ! !
Gustavo Zaffaroni
Sue Hoegemeier wrote:[vbcol=seagreen]
> Drag a new connection onto the designer. Select the old
> connection you want to delete in the Existing connection
> drop down. Click OK to save this connection. Then delete
> this connection you just created. It will delete the old
> connection reference with it.
> You can get these orphaned connections when you rename
> an existing connection.
> -Sue
> On 20 Sep 2006 13:55:51 -0700, "Gus" <gzaffa@.gmail.com>
> wrote:
How can I totally remove a connection in a DTS
Hi, when I remove a connection by clicking rigth button delete, this is
removed in the graphic enviroment, but the connection is still in the
DTS when I select the option Disconnected Edit and expand the
connection node.
Could somebody give me a tip to solve this, because is not good to see
10 connections in the disconnected edit window, if the DTS use only 1.
Thanks
GusDrag a new connection onto the designer. Select the old
connection you want to delete in the Existing connection
drop down. Click OK to save this connection. Then delete
this connection you just created. It will delete the old
connection reference with it.
You can get these orphaned connections when you rename
an existing connection.
-Sue
On 20 Sep 2006 13:55:51 -0700, "Gus" <gzaffa@.gmail.com>
wrote:
>Hi, when I remove a connection by clicking rigth button delete, this is
>removed in the graphic enviroment, but the connection is still in the
>DTS when I select the option Disconnected Edit and expand the
>connection node.
>Could somebody give me a tip to solve this, because is not good to see
>10 connections in the disconnected edit window, if the DTS use only 1.
>Thanks
>Gus|||Sue, Thank you very much it works great ! ! !
Gustavo Zaffaroni
Sue Hoegemeier wrote:[vbcol=seagreen]
> Drag a new connection onto the designer. Select the old
> connection you want to delete in the Existing connection
> drop down. Click OK to save this connection. Then delete
> this connection you just created. It will delete the old
> connection reference with it.
> You can get these orphaned connections when you rename
> an existing connection.
> -Sue
> On 20 Sep 2006 13:55:51 -0700, "Gus" <gzaffa@.gmail.com>
> wrote:
>
removed in the graphic enviroment, but the connection is still in the
DTS when I select the option Disconnected Edit and expand the
connection node.
Could somebody give me a tip to solve this, because is not good to see
10 connections in the disconnected edit window, if the DTS use only 1.
Thanks
GusDrag a new connection onto the designer. Select the old
connection you want to delete in the Existing connection
drop down. Click OK to save this connection. Then delete
this connection you just created. It will delete the old
connection reference with it.
You can get these orphaned connections when you rename
an existing connection.
-Sue
On 20 Sep 2006 13:55:51 -0700, "Gus" <gzaffa@.gmail.com>
wrote:
>Hi, when I remove a connection by clicking rigth button delete, this is
>removed in the graphic enviroment, but the connection is still in the
>DTS when I select the option Disconnected Edit and expand the
>connection node.
>Could somebody give me a tip to solve this, because is not good to see
>10 connections in the disconnected edit window, if the DTS use only 1.
>Thanks
>Gus|||Sue, Thank you very much it works great ! ! !
Gustavo Zaffaroni
Sue Hoegemeier wrote:[vbcol=seagreen]
> Drag a new connection onto the designer. Select the old
> connection you want to delete in the Existing connection
> drop down. Click OK to save this connection. Then delete
> this connection you just created. It will delete the old
> connection reference with it.
> You can get these orphaned connections when you rename
> an existing connection.
> -Sue
> On 20 Sep 2006 13:55:51 -0700, "Gus" <gzaffa@.gmail.com>
> wrote:
>
How can I totally remove a connection in a DTS
Hi, when I remove a connection by clicking rigth button delete, this is
removed in the graphic enviroment, but the connection is still in the
DTS when I select the option Disconnected Edit and expand the
connection node.
Could somebody give me a tip to solve this, because is not good to see
10 connections in the disconnected edit window, if the DTS use only 1.
Thanks
GusDrag a new connection onto the designer. Select the old
connection you want to delete in the Existing connection
drop down. Click OK to save this connection. Then delete
this connection you just created. It will delete the old
connection reference with it.
You can get these orphaned connections when you rename
an existing connection.
-Sue
On 20 Sep 2006 13:55:51 -0700, "Gus" <gzaffa@.gmail.com>
wrote:
>Hi, when I remove a connection by clicking rigth button delete, this is
>removed in the graphic enviroment, but the connection is still in the
>DTS when I select the option Disconnected Edit and expand the
>connection node.
>Could somebody give me a tip to solve this, because is not good to see
>10 connections in the disconnected edit window, if the DTS use only 1.
>Thanks
>Gus|||Sue, Thank you very much it works great ! ! !
Gustavo Zaffaroni
Sue Hoegemeier wrote:
> Drag a new connection onto the designer. Select the old
> connection you want to delete in the Existing connection
> drop down. Click OK to save this connection. Then delete
> this connection you just created. It will delete the old
> connection reference with it.
> You can get these orphaned connections when you rename
> an existing connection.
> -Sue
> On 20 Sep 2006 13:55:51 -0700, "Gus" <gzaffa@.gmail.com>
> wrote:
> >Hi, when I remove a connection by clicking rigth button delete, this is
> >removed in the graphic enviroment, but the connection is still in the
> >DTS when I select the option Disconnected Edit and expand the
> >connection node.
> >
> >Could somebody give me a tip to solve this, because is not good to see
> >10 connections in the disconnected edit window, if the DTS use only 1.
> >
> >Thanks
> >Gus
removed in the graphic enviroment, but the connection is still in the
DTS when I select the option Disconnected Edit and expand the
connection node.
Could somebody give me a tip to solve this, because is not good to see
10 connections in the disconnected edit window, if the DTS use only 1.
Thanks
GusDrag a new connection onto the designer. Select the old
connection you want to delete in the Existing connection
drop down. Click OK to save this connection. Then delete
this connection you just created. It will delete the old
connection reference with it.
You can get these orphaned connections when you rename
an existing connection.
-Sue
On 20 Sep 2006 13:55:51 -0700, "Gus" <gzaffa@.gmail.com>
wrote:
>Hi, when I remove a connection by clicking rigth button delete, this is
>removed in the graphic enviroment, but the connection is still in the
>DTS when I select the option Disconnected Edit and expand the
>connection node.
>Could somebody give me a tip to solve this, because is not good to see
>10 connections in the disconnected edit window, if the DTS use only 1.
>Thanks
>Gus|||Sue, Thank you very much it works great ! ! !
Gustavo Zaffaroni
Sue Hoegemeier wrote:
> Drag a new connection onto the designer. Select the old
> connection you want to delete in the Existing connection
> drop down. Click OK to save this connection. Then delete
> this connection you just created. It will delete the old
> connection reference with it.
> You can get these orphaned connections when you rename
> an existing connection.
> -Sue
> On 20 Sep 2006 13:55:51 -0700, "Gus" <gzaffa@.gmail.com>
> wrote:
> >Hi, when I remove a connection by clicking rigth button delete, this is
> >removed in the graphic enviroment, but the connection is still in the
> >DTS when I select the option Disconnected Edit and expand the
> >connection node.
> >
> >Could somebody give me a tip to solve this, because is not good to see
> >10 connections in the disconnected edit window, if the DTS use only 1.
> >
> >Thanks
> >Gus
Subscribe to:
Comments (Atom)