Error in Transfer SQL Server Objects

Hi ,

i am copying objects from one DB to other usign Transfer SQL Server Objects Task. i am getting this error

[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=-1073548784 description=Executing the query "DROP TABLE [dbo].[testCopy] " failed with the following error: "Cannot drop the table 'dbo.testCopy', because it does not exist or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".

it is true that object doesnt exist on the destination. but i want it to see if the object is there then drop otherwise just copy the object there,

Regards,

Haroon

This should not happen post SQL 2005 SP1, can you confirm your version?sql

Error in Enterprise Manager

In Enterprise Manager, when I expand the objects and click on the database
object for my live system I get the following error message:
Title bar: "Internet Explorer Script Error"
An error has occurred in the script on this page.
Line: 307
Char: 2
Error: Unspecified error.
Code: 0
URL:
res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Too ls\Binn\Resources\1033\sqlmmc.rll/Tabs.html
Do you want to continue running scripts on this page?
Yes/NO.
Whether I press Yes or No the right pane say the database is undefined.
All other database work fine and the system seems to be running fine.
Any Ideas?
Dan
Is this in the taskpad view? If so, it happens to me a lot. A
workaround is to change the View to Large icons, Small icons, or
something besides taskpad. Then close EM, then open it back, and you
can then change the view back to taskpad. Not exactly sure why it
happens.
DG wrote:
> In Enterprise Manager, when I expand the objects and click on the database
> object for my live system I get the following error message:
> Title bar: "Internet Explorer Script Error"
> An error has occurred in the script on this page.
> Line: 307
> Char: 2
> Error: Unspecified error.
> Code: 0
> URL:
> res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Too ls\Binn\Resources\1033\sqlmmc.rll/Tabs.html
> Do you want to continue running scripts on this page?
> Yes/NO.
> Whether I press Yes or No the right pane say the database is undefined.
> All other database work fine and the system seems to be running fine.
> Any Ideas?
> Dan
|||That did not work. I don't know what taskpad view is, but I changed view to
small icons then exited EM. Then re-opened EM and change back to Large
Icons, then open all objects and clickd on the database and got the same
error.
Dan
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1124455114.091345.312340@.f14g2000cwb.googlegr oups.com...
> Is this in the taskpad view? If so, it happens to me a lot. A
> workaround is to change the View to Large icons, Small icons, or
> something besides taskpad. Then close EM, then open it back, and you
> can then change the view back to taskpad. Not exactly sure why it
> happens.
>
> DG wrote:
>
|||I see the taskpad now...duh.
That worked the second time.
Thanks, Dan
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1124455114.091345.312340@.f14g2000cwb.googlegr oups.com...
> Is this in the taskpad view? If so, it happens to me a lot. A
> workaround is to change the View to Large icons, Small icons, or
> something besides taskpad. Then close EM, then open it back, and you
> can then change the view back to taskpad. Not exactly sure why it
> happens.
>
> DG wrote:
>
|||Sorry that didn't work for you - I searched briefly and got several
other responses similar to mine... here's one...
http://www.sqlnewsgroups.net/group/m...topic4742.aspx
If this doesn't work, then I'm not sure....

Error in Enterprise Manager

In Enterprise Manager, when I expand the objects and click on the database
object for my live system I get the following error message:
Title bar: "Internet Explorer Script Error"
An error has occurred in the script on this page.
Line: 307
Char: 2
Error: Unspecified error.
Code: 0
URL:
res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html
Do you want to continue running scripts on this page?
Yes/NO.
Whether I press Yes or No the right pane say the database is undefined.
All other database work fine and the system seems to be running fine.
Any Ideas?
DanIs this in the taskpad view? If so, it happens to me a lot. A
workaround is to change the View to Large icons, Small icons, or
something besides taskpad. Then close EM, then open it back, and you
can then change the view back to taskpad. Not exactly sure why it
happens.
DG wrote:
> In Enterprise Manager, when I expand the objects and click on the database
> object for my live system I get the following error message:
> Title bar: "Internet Explorer Script Error"
> An error has occurred in the script on this page.
> Line: 307
> Char: 2
> Error: Unspecified error.
> Code: 0
> URL:
> res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html
> Do you want to continue running scripts on this page?
> Yes/NO.
> Whether I press Yes or No the right pane say the database is undefined.
> All other database work fine and the system seems to be running fine.
> Any Ideas?
> Dan|||That did not work. I don't know what taskpad view is, but I changed view to
small icons then exited EM. Then re-opened EM and change back to Large
Icons, then open all objects and clickd on the database and got the same
error.
Dan
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1124455114.091345.312340@.f14g2000cwb.googlegroups.com...
> Is this in the taskpad view? If so, it happens to me a lot. A
> workaround is to change the View to Large icons, Small icons, or
> something besides taskpad. Then close EM, then open it back, and you
> can then change the view back to taskpad. Not exactly sure why it
> happens.
>
> DG wrote:
>> In Enterprise Manager, when I expand the objects and click on the
>> database
>> object for my live system I get the following error message:
>> Title bar: "Internet Explorer Script Error"
>> An error has occurred in the script on this page.
>> Line: 307
>> Char: 2
>> Error: Unspecified error.
>> Code: 0
>> URL:
>> res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html
>> Do you want to continue running scripts on this page?
>> Yes/NO.
>> Whether I press Yes or No the right pane say the database is undefined.
>> All other database work fine and the system seems to be running fine.
>> Any Ideas?
>> Dan
>|||I see the taskpad now...duh.
That worked the second time.
Thanks, Dan
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1124455114.091345.312340@.f14g2000cwb.googlegroups.com...
> Is this in the taskpad view? If so, it happens to me a lot. A
> workaround is to change the View to Large icons, Small icons, or
> something besides taskpad. Then close EM, then open it back, and you
> can then change the view back to taskpad. Not exactly sure why it
> happens.
>
> DG wrote:
>> In Enterprise Manager, when I expand the objects and click on the
>> database
>> object for my live system I get the following error message:
>> Title bar: "Internet Explorer Script Error"
>> An error has occurred in the script on this page.
>> Line: 307
>> Char: 2
>> Error: Unspecified error.
>> Code: 0
>> URL:
>> res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html
>> Do you want to continue running scripts on this page?
>> Yes/NO.
>> Whether I press Yes or No the right pane say the database is undefined.
>> All other database work fine and the system seems to be running fine.
>> Any Ideas?
>> Dan
>|||Sorry that didn't work for you - I searched briefly and got several
other responses similar to mine... here's one...
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic4742.aspx
If this doesn't work, then I'm not sure....

Error in Enterprise Manager

In Enterprise Manager, when I expand the objects and click on the database
object for my live system I get the following error message:
Title bar: "Internet Explorer Script Error"
An error has occurred in the script on this page.
Line: 307
Char: 2
Error: Unspecified error.
Code: 0
URL:
res:// C:\Program%20Files\Microsoft%20SQL%20Ser
ver\80\Tools\Binn\Resources\10
33\sqlmmc.rll/Tabs.html
Do you want to continue running scripts on this page?
Yes/NO.
Whether I press Yes or No the right pane say the database is undefined.
All other database work fine and the system seems to be running fine.
Any Ideas?
DanIs this in the taskpad view? If so, it happens to me a lot. A
workaround is to change the View to Large icons, Small icons, or
something besides taskpad. Then close EM, then open it back, and you
can then change the view back to taskpad. Not exactly sure why it
happens.
DG wrote:
> In Enterprise Manager, when I expand the objects and click on the database
> object for my live system I get the following error message:
> Title bar: "Internet Explorer Script Error"
> An error has occurred in the script on this page.
> Line: 307
> Char: 2
> Error: Unspecified error.
> Code: 0
> URL:
> res:// C:\Program%20Files\Microsoft%20SQL%20Ser
ver\80\Tools\Binn\Resources\
1033\sqlmmc.rll/Tabs.html
> Do you want to continue running scripts on this page?
> Yes/NO.
> Whether I press Yes or No the right pane say the database is undefined.
> All other database work fine and the system seems to be running fine.
> Any Ideas?
> Dan|||That did not work. I don't know what taskpad view is, but I changed view to
small icons then exited EM. Then re-opened EM and change back to Large
Icons, then open all objects and clickd on the database and got the same
error.
Dan
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1124455114.091345.312340@.f14g2000cwb.googlegroups.com...
> Is this in the taskpad view? If so, it happens to me a lot. A
> workaround is to change the View to Large icons, Small icons, or
> something besides taskpad. Then close EM, then open it back, and you
> can then change the view back to taskpad. Not exactly sure why it
> happens.
>
> DG wrote:
>|||I see the taskpad now...duh.
That worked the second time.
Thanks, Dan
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1124455114.091345.312340@.f14g2000cwb.googlegroups.com...
> Is this in the taskpad view? If so, it happens to me a lot. A
> workaround is to change the View to Large icons, Small icons, or
> something besides taskpad. Then close EM, then open it back, and you
> can then change the view back to taskpad. Not exactly sure why it
> happens.
>
> DG wrote:
>|||Sorry that didn't work for you - I searched briefly and got several
other responses similar to mine... here's one...
http://www.sqlnewsgroups.net/group/...42.asp
x
If this doesn't work, then I'm not sure....

Error in creating DB diagram

Hi all,

When ever i tried to creat a diagram for the database i have i got this error:

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

the version of the database i am working in was backed up from another machine

what is the problem and how can i solve it?

Thanks in advance

hi,

using SQL Server Management Studio Express, select the database node you have problems with.. access it's properties and, in the "Files" tab, set a valid login as the database owner... please verify the database is in "compatibility level 2005" 2005 too (Oprions tab)..

regards

|||

Hi,

I choosed "sa" as the database owner snd it works

Thanks alot

Error Icons displayed on parent objects with no or different children

I recently had to restore a database from backup and the restored
database had a different set of publications than the one I overwrote.
Since then, in EM, on the Replication Monitor object, Publishers, and
Servername objects as well as on the Agents and Snapshot Agents
objects, I see the little red X denoting an error. I have done
everything i can think of and more, following much advice given on this
group. I even turned replication off, deleted all publications, used
hilary cotter's script to clean up all the miscellaneous replication
tables/settings, etc. and restarted the server.
Everything seems to be working fine, but I would like to try to clean
up these "errors". Does anyone have any suggestions?
I am running SqlServer 8.00.2039 SP4 Standard Edition on Windows Server
2003 SP1
You will have to manually remove the replication jobs in msdb. Sometimes you
will get transitory error messages in EM, run sp_MSload_replication_status
to clear them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"troy" <troyblakely@.gmail.com> wrote in message
news:1125073355.972990.114690@.g47g2000cwa.googlegr oups.com...
> I recently had to restore a database from backup and the restored
> database had a different set of publications than the one I overwrote.
> Since then, in EM, on the Replication Monitor object, Publishers, and
> Servername objects as well as on the Agents and Snapshot Agents
> objects, I see the little red X denoting an error. I have done
> everything i can think of and more, following much advice given on this
> group. I even turned replication off, deleted all publications, used
> hilary cotter's script to clean up all the miscellaneous replication
> tables/settings, etc. and restarted the server.
> Everything seems to be working fine, but I would like to try to clean
> up these "errors". Does anyone have any suggestions?
> I am running SqlServer 8.00.2039 SP4 Standard Edition on Windows Server
> 2003 SP1
>