This is a multi-part message in MIME format.
--=_NextPart_000_00A3_01C79966.58D0C7A0
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable
Hi,
I have two sql server. One is sql 2000, and another is sql 2005
On sql 2000 I try to add linked to sql 2005.
(like this)
exec sp_addlinkedserver @.server =3D N'ZAGREB_NEW',
@.srvproduct =3D N' ',
@.provider =3D N'SQLNCLI',
@.datasrc =3D N'',
@.catalog =3D N'komitenti',
@.provstr =3D N'SERVER=3DZAGREB_NEW;uid=3Dradovan;pwd=3DDELTA555'
GO
I try
SELECT top 1 adresa from zagreb_new.komitenti.dbo.komitenti
and have followig error:
OLE DB error trace [Non-interface error: Column 'MB' (compile-time = ordinal 4) of object '"komitenti"."dbo"."komitenti"' was reported to = have changed. The exact nature of the change is unknown].
Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'SQLNCLI' supplied inconsistent metadata for a column. = Metadata information was changed at execution time.
When I try:
SELECT * FROM OPENQUERY(ZAGREB_NEW, 'SELECT TOP 1 * FROM = komitenti.dbo.komitenti')
I got result.
How can I exec stored procedure on linked server, because
exec Zagreb_new.database.dbo.Mystored doesn't work
error is:
Msg 7212, Level 17, State 1, Line 1
Could not execute procedure 'spG_ProvjeriMB' on remote server = 'zagreb_new'.
--=_NextPart_000_00A3_01C79966.58D0C7A0
Content-Type: text/html;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,
I have two sql server. One is sql 2000, = and another is sql 2005
On sql 2000 I try to add linked to sql 2005.
(like this)
exec sp_addlinkedserver @.server =3D N'ZAGREB_NEW',
@.srvproduct =3D N' ',
@.provider =3D N'SQLNCLI',
@.datasrc =3D N'',
@.catalog =3D N'komitenti',
@.provstr =3D N'SERVER=3DZAGREB_NEW;uid=3Dradovan;pwd=3DDELTA555'
GO
I try
SELECT top 1 adresa from zagreb_new.komitenti.dbo.komitenti
and have followig error:
OLE DB error trace [Non-interface error: = Column 'MB' (compile-time ordinal 4) of object '"komitenti"."dbo"."komitenti"' was = reported to have changed. The exact nature of the change is unknown].
Msg 7356, Level 16, State 1, Line = 1
OLE DB provider 'SQLNCLI' supplied = inconsistent metadata for a column. Metadata information was changed at execution time.
When I try:
SELECT * FROM OPENQUERY(ZAGREB_NEW, = 'SELECT TOP 1 * FROM komitenti.dbo.komitenti')
I got result.
How can I exec stored procedure on linked = server, because
exec Zagreb_new.database.dbo.Mystored = doesn't work
error is:
Msg 7212, Level 17, State 1, Line 1
Could not execute procedure 'spG_ProvjeriMB' on remote = server 'zagreb_new'.
--=_NextPart_000_00A3_01C79966.58D0C7A0--Hi
"Radovan DobriÄ?" wrote:
> Hi,
> I have two sql server. One is sql 2000, and another is sql 2005
> On sql 2000 I try to add linked to sql 2005.
> (like this)
> exec sp_addlinkedserver @.server = N'ZAGREB_NEW',
> @.srvproduct = N' ',
> @.provider = N'SQLNCLI',
> @.datasrc = N'',
> @.catalog = N'komitenti',
> @.provstr = N'SERVER=ZAGREB_NEW;uid=radovan;pwd=DELTA555'
> GO
>
> I try
> SELECT top 1 adresa from zagreb_new.komitenti.dbo.komitenti
> and have followig error:
>
> OLE DB error trace [Non-interface error: Column 'MB' (compile-time ordinal 4) of object '"komitenti"."dbo"."komitenti"' was reported to have changed. The exact nature of the change is unknown].
> Msg 7356, Level 16, State 1, Line 1
> OLE DB provider 'SQLNCLI' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
>
> When I try:
> SELECT * FROM OPENQUERY(ZAGREB_NEW, 'SELECT TOP 1 * FROM komitenti.dbo.komitenti')
> I got result.
>
> How can I exec stored procedure on linked server, because
> exec Zagreb_new.database.dbo.Mystored doesn't work
> error is:
>
> Msg 7212, Level 17, State 1, Line 1
> Could not execute procedure 'spG_ProvjeriMB' on remote server 'zagreb_new'
The only thing I have found about this is that "it could be fixed in SP2"
which versions are the servers running? Is the client one of the servers?
Is a login defined for the linked server? See
http://msdn2.microsoft.com/en-us/library/ms189811.aspx or are you using the
default mapping, in which case will the login have permissions on the remote
server? Your error message when running the remote procedure would indicate
that they don't have permissions to run this.
John|||Hi,
I have sp2 on server (I try it on another server with sp2 in another firm
and have exactly same result).
I try it with sql server account (and did mapping on that account). That
account have admin privil.
radovan
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:BE5DF476-CF21-4F8C-8634-D4461EA9132F@.microsoft.com...
> Hi
> "Radovan Dobriæ" wrote:
>> Hi,
>> I have two sql server. One is sql 2000, and another is sql 2005
>> On sql 2000 I try to add linked to sql 2005.
>> (like this)
>> exec sp_addlinkedserver @.server = N'ZAGREB_NEW',
>> @.srvproduct = N' ',
>> @.provider = N'SQLNCLI',
>> @.datasrc = N'',
>> @.catalog = N'komitenti',
>> @.provstr = N'SERVER=ZAGREB_NEW;uid=radovan;pwd=DELTA555'
>> GO
>>
>> I try
>> SELECT top 1 adresa from zagreb_new.komitenti.dbo.komitenti
>> and have followig error:
>>
>> OLE DB error trace [Non-interface error: Column 'MB' (compile-time
>> ordinal 4) of object '"komitenti"."dbo"."komitenti"' was reported to have
>> changed. The exact nature of the change is unknown].
>> Msg 7356, Level 16, State 1, Line 1
>> OLE DB provider 'SQLNCLI' supplied inconsistent metadata for a column.
>> Metadata information was changed at execution time.
>>
>> When I try:
>> SELECT * FROM OPENQUERY(ZAGREB_NEW, 'SELECT TOP 1 * FROM
>> komitenti.dbo.komitenti')
>> I got result.
>>
>> How can I exec stored procedure on linked server, because
>> exec Zagreb_new.database.dbo.Mystored doesn't work
>> error is:
>>
>> Msg 7212, Level 17, State 1, Line 1
>> Could not execute procedure 'spG_ProvjeriMB' on remote server
>> 'zagreb_new'
> The only thing I have found about this is that "it could be fixed in SP2"
> which versions are the servers running? Is the client one of the servers?
> Is a login defined for the linked server? See
> http://msdn2.microsoft.com/en-us/library/ms189811.aspx or are you using
> the
> default mapping, in which case will the login have permissions on the
> remote
> server? Your error message when running the remote procedure would
> indicate
> that they don't have permissions to run this.
> John
>|||Hi
Have you tried creating the linked server as
EXEC sp_addlinkedserver @.server = 'ZAGREB_NEW',
@.srvproduct = N'',
@.provider = N'SQLNCLI',
@.datasrc = N'ZAGREB_NEW'
or
EXEC sp_addlinkedserver 'ZAGREB_NEW', N'SQL Server'
John
"Radovan Dobriæ" wrote:
> Hi,
> I have sp2 on server (I try it on another server with sp2 in another firm
> and have exactly same result).
> I try it with sql server account (and did mapping on that account). That
> account have admin privil.
> radovan
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:BE5DF476-CF21-4F8C-8634-D4461EA9132F@.microsoft.com...
> > Hi
> >
> > "Radovan Dobriæ" wrote:
> >
> >> Hi,
> >> I have two sql server. One is sql 2000, and another is sql 2005
> >>
> >> On sql 2000 I try to add linked to sql 2005.
> >>
> >> (like this)
> >> exec sp_addlinkedserver @.server = N'ZAGREB_NEW',
> >>
> >> @.srvproduct = N' ',
> >>
> >> @.provider = N'SQLNCLI',
> >>
> >> @.datasrc = N'',
> >>
> >> @.catalog = N'komitenti',
> >>
> >> @.provstr = N'SERVER=ZAGREB_NEW;uid=radovan;pwd=DELTA555'
> >>
> >> GO
> >>
> >>
> >>
> >> I try
> >>
> >> SELECT top 1 adresa from zagreb_new.komitenti.dbo.komitenti
> >>
> >> and have followig error:
> >>
> >>
> >>
> >> OLE DB error trace [Non-interface error: Column 'MB' (compile-time
> >> ordinal 4) of object '"komitenti"."dbo"."komitenti"' was reported to have
> >> changed. The exact nature of the change is unknown].
> >>
> >> Msg 7356, Level 16, State 1, Line 1
> >>
> >> OLE DB provider 'SQLNCLI' supplied inconsistent metadata for a column.
> >> Metadata information was changed at execution time.
> >>
> >>
> >>
> >> When I try:
> >>
> >> SELECT * FROM OPENQUERY(ZAGREB_NEW, 'SELECT TOP 1 * FROM
> >> komitenti.dbo.komitenti')
> >>
> >> I got result.
> >>
> >>
> >>
> >> How can I exec stored procedure on linked server, because
> >>
> >> exec Zagreb_new.database.dbo.Mystored doesn't work
> >>
> >> error is:
> >>
> >>
> >>
> >> Msg 7212, Level 17, State 1, Line 1
> >>
> >> Could not execute procedure 'spG_ProvjeriMB' on remote server
> >> 'zagreb_new'
> >
> > The only thing I have found about this is that "it could be fixed in SP2"
> > which versions are the servers running? Is the client one of the servers?
> >
> > Is a login defined for the linked server? See
> > http://msdn2.microsoft.com/en-us/library/ms189811.aspx or are you using
> > the
> > default mapping, in which case will the login have permissions on the
> > remote
> > server? Your error message when running the remote procedure would
> > indicate
> > that they don't have permissions to run this.
> >
> > John
> >
> >
>
>|||That was my first try.
Linked server works fine with
SELECT * FROM OPENQUERY(ZAGREB_NEW, 'SELECT TOP 1 * FROM
komitenti.dbo.komitenti')
but not with
SELECT TOP 1 * FROM zagreb_new.komitenti.dbo.komitenti'
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:03897BB2-0508-4F7C-A923-090DB6AE439B@.microsoft.com...
> Hi
> Have you tried creating the linked server as
> EXEC sp_addlinkedserver @.server = 'ZAGREB_NEW',
> @.srvproduct = N'',
> @.provider = N'SQLNCLI',
> @.datasrc = N'ZAGREB_NEW'
> or
> EXEC sp_addlinkedserver 'ZAGREB_NEW', N'SQL Server'
>
> John
> "Radovan Dobria" wrote:
>> Hi,
>> I have sp2 on server (I try it on another server with sp2 in another firm
>> and have exactly same result).
>> I try it with sql server account (and did mapping on that account). That
>> account have admin privil.
>> radovan
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:BE5DF476-CF21-4F8C-8634-D4461EA9132F@.microsoft.com...
>> > Hi
>> >
>> > "Radovan Dobria" wrote:
>> >
>> >> Hi,
>> >> I have two sql server. One is sql 2000, and another is sql 2005
>> >>
>> >> On sql 2000 I try to add linked to sql 2005.
>> >>
>> >> (like this)
>> >> exec sp_addlinkedserver @.server = N'ZAGREB_NEW',
>> >>
>> >> @.srvproduct = N' ',
>> >>
>> >> @.provider = N'SQLNCLI',
>> >>
>> >> @.datasrc = N'',
>> >>
>> >> @.catalog = N'komitenti',
>> >>
>> >> @.provstr = N'SERVER=ZAGREB_NEW;uid=radovan;pwd=DELTA555'
>> >>
>> >> GO
>> >>
>> >>
>> >>
>> >> I try
>> >>
>> >> SELECT top 1 adresa from zagreb_new.komitenti.dbo.komitenti
>> >>
>> >> and have followig error:
>> >>
>> >>
>> >>
>> >> OLE DB error trace [Non-interface error: Column 'MB' (compile-time
>> >> ordinal 4) of object '"komitenti"."dbo"."komitenti"' was reported to
>> >> have
>> >> changed. The exact nature of the change is unknown].
>> >>
>> >> Msg 7356, Level 16, State 1, Line 1
>> >>
>> >> OLE DB provider 'SQLNCLI' supplied inconsistent metadata for a column.
>> >> Metadata information was changed at execution time.
>> >>
>> >>
>> >>
>> >> When I try:
>> >>
>> >> SELECT * FROM OPENQUERY(ZAGREB_NEW, 'SELECT TOP 1 * FROM
>> >> komitenti.dbo.komitenti')
>> >>
>> >> I got result.
>> >>
>> >>
>> >>
>> >> How can I exec stored procedure on linked server, because
>> >>
>> >> exec Zagreb_new.database.dbo.Mystored doesn't work
>> >>
>> >> error is:
>> >>
>> >>
>> >>
>> >> Msg 7212, Level 17, State 1, Line 1
>> >>
>> >> Could not execute procedure 'spG_ProvjeriMB' on remote server
>> >> 'zagreb_new'
>> >
>> > The only thing I have found about this is that "it could be fixed in
>> > SP2"
>> > which versions are the servers running? Is the client one of the
>> > servers?
>> >
>> > Is a login defined for the linked server? See
>> > http://msdn2.microsoft.com/en-us/library/ms189811.aspx or are you using
>> > the
>> > default mapping, in which case will the login have permissions on the
>> > remote
>> > server? Your error message when running the remote procedure would
>> > indicate
>> > that they don't have permissions to run this.
>> >
>> > John
>> >
>> >
>>|||Hi
On May 23, 3:40 pm, "Radovan Dobri=E6" <rado...@.servis24.hr> wrote:
> That was my first try.
> Linked server works fine with
> SELECT * FROM OPENQUERY(ZAGREB_NEW, 'SELECT TOP 1 * FROM
> komitenti.dbo.komitenti')
> but not with
> SELECT TOP 1 * FROM zagreb_new.komitenti.dbo.komitenti'
>
The error you are getting would indicate that the user context that
each one is running under is different in each case.
Try mapping the local login to a different remote login using
sp_addlinkedsrvlogin
e=2Eg.
EXEC sp_addlinkedsrvlogin 'Accounts', 'false', 'Domain\Mary', 'MaryP',
'd89q3w4u'
and/or make sure that you can connect as the same user on the remote
system and execute the procedure.
John
Showing posts with label message. Show all posts
Showing posts with label message. Show all posts
Wednesday, March 28, 2012
Problem with Jobs
Hello all,
I am having a problem with the sql
DB on the company that I work for.
I got message under job history
on Enterprise manager is :
"The job failed.The Job was invoked by Schedule 15 (Replication
agent schedule.).The last step to run
was step 1 (Run agent.)"
and in the event log is:
Event ID: 208
Source: SQLAgent$(company DB)
"sql server Schedule (company DB)
status:Failed"
Please advice.
Thanks in advance
Kind regards
This relates to replication issues, which can be quite complex depending on what you're trying to do. You should review your replication scheme to ensure that all the data is going where it should. If the replication isn't happening, your files will grow on the distributor until it runs out of room.
If you're new to replication, check here:
http://msdn2.microsoft.com/en-us/library/ms151198.aspx
Monday, March 26, 2012
problem with installshield
I don't know what I did, but I keep getting the message that I can't install a program or even uninstall one. I think I deleted part of my installsheild. I have tried to find out where and how to repair it, but I haven't so far. Please help!!!!! Rita
I guess your reason for asking here is that you're trying to install an older version of SQL Server?
InstallShield isn't a Microsoft product. If it's broken somehow, you should start by getting it fixed. Here's a link that should help:
http://www.macrovision.com/products/flexnet_installshield/index.shtml
Paul
|||Puts the Patriot Actors right in the Windows Control Panel . . .
from Corel.com support site search (one supposes it will soon disappear -- this dreadful thing is unaccountably included in WordPerfect):
"If you wish to remove the InstallShield Update Manager from your workstation, you will need to download and install the Update Manager uninstaller from the following location: http://consumer.installshield.com/kb.asp?id=Q111006 ."
|||I have been trying to install a PC Studio for a mobile phone and receive error message "empty temporary folder, check internet connection then try to run Setup again"
I found a fix in Article ID 311203 recommending deleting the InstallShield File in C:\Program Files\Common Files\Install Shield folder but article says this only applies to Windows 98, 95 and Millennium. Can I use with Windows XP?
problem with installshield
I don't know what I did, but I keep getting the message that I can't install a program or even uninstall one. I think I deleted part of my installsheild. I have tried to find out where and how to repair it, but I haven't so far. Please help!!!!! Rita
I guess your reason for asking here is that you're trying to install an older version of SQL Server?
InstallShield isn't a Microsoft product. If it's broken somehow, you should start by getting it fixed. Here's a link that should help:
http://www.macrovision.com/products/flexnet_installshield/index.shtml
Paul
|||Puts the Patriot Actors right in the Windows Control Panel . . .
from Corel.com support site search (one supposes it will soon disappear -- this dreadful thing is unaccountably included in WordPerfect):
"If you wish to remove the InstallShield Update Manager from your workstation, you will need to download and install the Update Manager uninstaller from the following location: http://consumer.installshield.com/kb.asp?id=Q111006 ."
|||I have been trying to install a PC Studio for a mobile phone and receive error message "empty temporary folder, check internet connection then try to run Setup again"
I found a fix in Article ID 311203 recommending deleting the InstallShield File in C:\Program Files\Common Files\Install Shield folder but article says this only applies to Windows 98, 95 and Millennium. Can I use with Windows XP?
problem with installshield
I don't know what I did, but I keep getting the message that I can't install a program or even uninstall one. I think I deleted part of my installsheild. I have tried to find out where and how to repair it, but I haven't so far. Please help!!!!! Rita
Puts the Patriot Actors right in the Windows Control Panel . . .
from Corel.com support site search (one supposes it will soon disappear -- this dreadful thing is unaccountably included in WordPerfect):
"If you wish to remove the InstallShield Update Manager from your workstation, you will need to download and install the Update Manager uninstaller from the following location: http://consumer.installshield.com/kb.asp?id=Q111006 ."
|||I have been trying to install a PC Studio for a mobile phone and receive error message "empty temporary folder, check internet connection then try to run Setup again"
I found a fix in Article ID 311203 recommending deleting the InstallShield File in C:\Program Files\Common Files\Install Shield folder but article says this only applies to Windows 98, 95 and Millennium. Can I use with Windows XP?
|||I guess your reason for asking here is that you're trying to install an older version of SQL Server?
InstallShield isn't a Microsoft product. If it's broken somehow, you should start by getting it fixed. Here's a link that should help:
http://www.macrovision.com/products/flexnet_installshield/index.shtml
Paul
Problem with installing SQL Server
Hi All,
I'm running into a problem when trying to install SQL Server onto my laptop that is running Windows XP. The error message that is displayed is:
"An error occurred while creating one or more registry entries. Please see
C:\Windows\sqlstp.log for details. The problem could be caused by a low
registry quota condition."
Does anyone know how to solve this?? Any help would be appreciated.
Thanks,
Pete
Seems to be a complex issue, may need sqlstp.log for trouble-shooting. For a quick check, please take a look at this link, which also mentioned an issue of installing SQL on WinXp:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=182716&SiteId=1
|||Typically this type of error (which isn't SQL Server specific) can/will happen if the account you are using can't access the registry to write/update new entries... or if there aren't enough empty 'slots' available.Were you running/installing this as admin? (or were you trying to throw this instance on to a DC, etc?)
Try this link as well:
http://www.mcse.ms/archive82-2004-12-1281012.html
problem with install, but can't uninstall
There is a problem with my SQL server desktop installation. The message says
corrupt or did not install properly & that I shoud uninstall & try again. The
problem is that there is no place to uninstall that i can find. What should I
do? I am using win xp pro sp2 and was trying to install it with business
contact manager. It is not listed in the add/remove programs. I can uninstall
Business contact manager, but not the sql desktop engine.
hi,
webweaver6 wrote:
> There is a problem with my SQL server desktop installation. The
> message says corrupt or did not install properly & that I shoud
> uninstall & try again. The problem is that there is no place to
> uninstall that i can find. What should I do? I am using win xp pro
> sp2 and was trying to install it with business contact manager. It is
> not listed in the add/remove programs. I can uninstall Business
> contact manager, but not the sql desktop engine.
to manually uninstall MSDE you can have a look at
http://support.microsoft.com/default...;EN-US;Q290991 ..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||That seemed to have worked. The uninstall error message is gone. I have
reinstalled businss contact manager and now within outlook get the error
message of "mapi was unable to load the information service dccmsp.dll" so
this is not yet working. What else can I do?
Thanks.
"Andrea Montanari" wrote:
> hi,
> webweaver6 wrote:
> to manually uninstall MSDE you can have a look at
> http://support.microsoft.com/default...;EN-US;Q290991 ..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi,
webweaver6 wrote:
> That seemed to have worked. The uninstall error message is gone. I
> have reinstalled businss contact manager and now within outlook get
> the error message of "mapi was unable to load the information service
> dccmsp.dll" so this is not yet working. What else can I do?
mapi error, not SQL error... unfortunately I can not help here :D:D:D
try Outlook ng or the solutions (if any) listed in
http://groups.google.it/groups?hl=it...22&sa=N&tab=wg
thank you
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
corrupt or did not install properly & that I shoud uninstall & try again. The
problem is that there is no place to uninstall that i can find. What should I
do? I am using win xp pro sp2 and was trying to install it with business
contact manager. It is not listed in the add/remove programs. I can uninstall
Business contact manager, but not the sql desktop engine.
hi,
webweaver6 wrote:
> There is a problem with my SQL server desktop installation. The
> message says corrupt or did not install properly & that I shoud
> uninstall & try again. The problem is that there is no place to
> uninstall that i can find. What should I do? I am using win xp pro
> sp2 and was trying to install it with business contact manager. It is
> not listed in the add/remove programs. I can uninstall Business
> contact manager, but not the sql desktop engine.
to manually uninstall MSDE you can have a look at
http://support.microsoft.com/default...;EN-US;Q290991 ..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||That seemed to have worked. The uninstall error message is gone. I have
reinstalled businss contact manager and now within outlook get the error
message of "mapi was unable to load the information service dccmsp.dll" so
this is not yet working. What else can I do?
Thanks.
"Andrea Montanari" wrote:
> hi,
> webweaver6 wrote:
> to manually uninstall MSDE you can have a look at
> http://support.microsoft.com/default...;EN-US;Q290991 ..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi,
webweaver6 wrote:
> That seemed to have worked. The uninstall error message is gone. I
> have reinstalled businss contact manager and now within outlook get
> the error message of "mapi was unable to load the information service
> dccmsp.dll" so this is not yet working. What else can I do?
mapi error, not SQL error... unfortunately I can not help here :D:D:D
try Outlook ng or the solutions (if any) listed in
http://groups.google.it/groups?hl=it...22&sa=N&tab=wg
thank you
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Friday, March 23, 2012
Problem with Index Tuning Wizard
When running the Index Tuning Wizard (ITW) on our SQL Server we got a
error message : 'Could not complete cursor operation because the table
schema changed after the cursor was declared'
The ITW was used only to advice new indexes. I know that it creates
hypothetical indexes in the sysindexes table, but what are the changes
in the user-tables ?
How do you use the ITW without interfering with the real
schema-definitions ?
thanks,
RobbertHi,
Before using the ITW, you should get a load of the queries
you are running. You can capture the events in profiler
and then use that load file for the ITW to use.
hth
DeeJay
>--Original Message--
>When running the Index Tuning Wizard (ITW) on our SQL
Server we got a
>error message : 'Could not complete cursor operation
because the table
>schema changed after the cursor was declared'
>The ITW was used only to advice new indexes. I know that
it creates
>hypothetical indexes in the sysindexes table, but what
are the changes
>in the user-tables ?
>How do you use the ITW without interfering with the real
>schema-definitions ?
>thanks,
>Robbert
>.
>|||My theory on this is while you were running the ITW
someone in your tream made a change to the structure a
table, which caused it to get an error.
I have run ITW a number of times using our Production
Database, with no problems.
Peter
"We are all worms. But I believe that I am a glow-worm."
Winston Churchill
>--Original Message--
>When running the Index Tuning Wizard (ITW) on our SQL
Server we got a
>error message : 'Could not complete cursor operation
because the table
>schema changed after the cursor was declared'
>The ITW was used only to advice new indexes. I know that
it creates
>hypothetical indexes in the sysindexes table, but what
are the changes
>in the user-tables ?
>How do you use the ITW without interfering with the real
>schema-definitions ?
>thanks,
>Robbert
>.
>
error message : 'Could not complete cursor operation because the table
schema changed after the cursor was declared'
The ITW was used only to advice new indexes. I know that it creates
hypothetical indexes in the sysindexes table, but what are the changes
in the user-tables ?
How do you use the ITW without interfering with the real
schema-definitions ?
thanks,
RobbertHi,
Before using the ITW, you should get a load of the queries
you are running. You can capture the events in profiler
and then use that load file for the ITW to use.
hth
DeeJay
>--Original Message--
>When running the Index Tuning Wizard (ITW) on our SQL
Server we got a
>error message : 'Could not complete cursor operation
because the table
>schema changed after the cursor was declared'
>The ITW was used only to advice new indexes. I know that
it creates
>hypothetical indexes in the sysindexes table, but what
are the changes
>in the user-tables ?
>How do you use the ITW without interfering with the real
>schema-definitions ?
>thanks,
>Robbert
>.
>|||My theory on this is while you were running the ITW
someone in your tream made a change to the structure a
table, which caused it to get an error.
I have run ITW a number of times using our Production
Database, with no problems.
Peter
"We are all worms. But I believe that I am a glow-worm."
Winston Churchill
>--Original Message--
>When running the Index Tuning Wizard (ITW) on our SQL
Server we got a
>error message : 'Could not complete cursor operation
because the table
>schema changed after the cursor was declared'
>The ITW was used only to advice new indexes. I know that
it creates
>hypothetical indexes in the sysindexes table, but what
are the changes
>in the user-tables ?
>How do you use the ITW without interfering with the real
>schema-definitions ?
>thanks,
>Robbert
>.
>
problem with index and duplicates
Hi
I'm trying to change structure of table 'TB_KONTAKT' to add a fiew fields -
but during that I get the following error message:
'TB_KONTAKT' table
- Unable to create index 'PK__TB_KONTAKT__04AFB25B'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE
INDEX terminated because a duplicate key was found for index ID 1. Most
significant primary key is '1190914'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint.
See previous errors.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
terminated.
That index is already build and I'm rather scared of destroying it.
How can I fix the problem?
Best Regards
Darek T.Dariusz Tomon wrote:
> Hi
> I'm trying to change structure of table 'TB_KONTAKT' to add a fiew fields -
> but during that I get the following error message:
> 'TB_KONTAKT' table
> - Unable to create index 'PK__TB_KONTAKT__04AFB25B'.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE
> INDEX terminated because a duplicate key was found for index ID 1. Most
> significant primary key is '1190914'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint.
> See previous errors.
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated.
> That index is already build and I'm rather scared of destroying it.
> How can I fix the problem?
> Best Regards
> Darek T.
>
It looks like you're attempting to define a primary key on your table.
Primary keys must be unique, and the field(s) that you're keying on have
some duplicate values.|||Dariusz Tomon,
Are you using Enterprise Manager to apply this change (add new columns)?
AMB
"Dariusz Tomon" wrote:
> Hi
> I'm trying to change structure of table 'TB_KONTAKT' to add a fiew fields -
> but during that I get the following error message:
> 'TB_KONTAKT' table
> - Unable to create index 'PK__TB_KONTAKT__04AFB25B'.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE
> INDEX terminated because a duplicate key was found for index ID 1. Most
> significant primary key is '1190914'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint.
> See previous errors.
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated.
> That index is already build and I'm rather scared of destroying it.
> How can I fix the problem?
> Best Regards
> Darek T.
>
>
I'm trying to change structure of table 'TB_KONTAKT' to add a fiew fields -
but during that I get the following error message:
'TB_KONTAKT' table
- Unable to create index 'PK__TB_KONTAKT__04AFB25B'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE
INDEX terminated because a duplicate key was found for index ID 1. Most
significant primary key is '1190914'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint.
See previous errors.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
terminated.
That index is already build and I'm rather scared of destroying it.
How can I fix the problem?
Best Regards
Darek T.Dariusz Tomon wrote:
> Hi
> I'm trying to change structure of table 'TB_KONTAKT' to add a fiew fields -
> but during that I get the following error message:
> 'TB_KONTAKT' table
> - Unable to create index 'PK__TB_KONTAKT__04AFB25B'.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE
> INDEX terminated because a duplicate key was found for index ID 1. Most
> significant primary key is '1190914'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint.
> See previous errors.
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated.
> That index is already build and I'm rather scared of destroying it.
> How can I fix the problem?
> Best Regards
> Darek T.
>
It looks like you're attempting to define a primary key on your table.
Primary keys must be unique, and the field(s) that you're keying on have
some duplicate values.|||Dariusz Tomon,
Are you using Enterprise Manager to apply this change (add new columns)?
AMB
"Dariusz Tomon" wrote:
> Hi
> I'm trying to change structure of table 'TB_KONTAKT' to add a fiew fields -
> but during that I get the following error message:
> 'TB_KONTAKT' table
> - Unable to create index 'PK__TB_KONTAKT__04AFB25B'.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE
> INDEX terminated because a duplicate key was found for index ID 1. Most
> significant primary key is '1190914'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint.
> See previous errors.
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated.
> That index is already build and I'm rather scared of destroying it.
> How can I fix the problem?
> Best Regards
> Darek T.
>
>
Wednesday, March 21, 2012
Problem with ID 17981
Hello,
I′m trying to do an update through a system but this message display a problem that I didn′t get to identify exactly the problem to looking for a solution.
"Table error: Object ID 17981, index ID 1, page (0:871674153). Test (offset + len < PAGESIZE) failed. Slot 10, offset 0x1a8 is i
Error while undoing logged operation in database "
Could anyone help me please?
Thanks,
Maurício
Try checking the table with "dbcc checktable" and the db with "dbcc checkdb".
AMB
Problem with GROUP BY/COMPUTE : error message 8120
Hi,
I have this query ( it is Ok with Sybase SQLServer)
select 'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
,'Anne'=datepart(yy,DPSTVOI),'Priode'=
CPST,'Nombre'=count(NVOI)
from HREH3M
group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
compute sum(count(NVOI)) by CPST,NVOI,datepart(yy,DPSTVOI)
I want to migrate it under MS SQLServer 2000, but I have this error message
:
Serveur : Msg 8120, Niveau 16, tat 1, Ligne 1
Column 'HREH3M.DPSTVOI' is invalid in the select list because it is not
contained in either an aggregate function or the GROUP BY clause.
If I delete the last line, the query is Ok :
select 'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
,'Anne'=datepart(yy,DPSTVOI),'Priode'=
CPST,'Nombre'=count(NVOI)
from HREH3M
group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
The problem is with COMPUTE claude, but I can't understand why.
please help me to solve this.
thanks in advance
regards
LaurentWhat kind of error or warning appears when you drop that line? Apparently
syntax for COMPUTE is fine.
"Laurent CLAUDEL" wrote:
> Hi,
> I have this query ( it is Ok with Sybase SQLServer)
> select 'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
> ,'Année'=datepart(yy,DPSTVOI),'Période
'=CPST,'Nombre'=count(NVOI)
> from HREH3M
> group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
> order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
> compute sum(count(NVOI)) by CPST,NVOI,datepart(yy,DPSTVOI)
>
> I want to migrate it under MS SQLServer 2000, but I have this error messag
e
> :
> Serveur : Msg 8120, Niveau 16, état 1, Ligne 1
> Column 'HREH3M.DPSTVOI' is invalid in the select list because it is not
> contained in either an aggregate function or the GROUP BY clause.
> If I delete the last line, the query is Ok :
> select 'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
> ,'Année'=datepart(yy,DPSTVOI),'Période
'=CPST,'Nombre'=count(NVOI)
> from HREH3M
> group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
> order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
> The problem is with COMPUTE claude, but I can't understand why.
> please help me to solve this.
> thanks in advance
> regards
> Laurent
>
>|||if I drop the last line (COMPUTE), there is no more error.
"Enric" <Enric@.discussions.microsoft.com> a crit dans le message de news:
B27D7A22-9880-4A31-9335-D0C77C2DED83@.microsoft.com...
> What kind of error or warning appears when you drop that line? Apparently
> syntax for COMPUTE is fine.
> "Laurent CLAUDEL" wrote:
>|||But I want a sum by Year, so i have to keep the COMPUTE clause
"Laurent CLAUDEL" <laurent.claudel@.steria.com> a crit dans le message de
news: OhOqg8Y1FHA.1108@.TK2MSFTNGP14.phx.gbl...
> if I drop the last line (COMPUTE), there is no more error.
> "Enric" <Enric@.discussions.microsoft.com> a crit dans le message de news:
> B27D7A22-9880-4A31-9335-D0C77C2DED83@.microsoft.com...
>|||I suggest you don't use COMPUTE / COMPUTE BY unless it's essential to
maintain Sybase compatibility. COMPUTE is legacy stuff that was
deprecated long ago. Take a look at CUBE / ROLLUP in Books Online -
it's a much more powerful feature.
David Portas
SQL Server MVP
--sql
I have this query ( it is Ok with Sybase SQLServer)
select 'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
,'Anne'=datepart(yy,DPSTVOI),'Priode'=
CPST,'Nombre'=count(NVOI)
from HREH3M
group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
compute sum(count(NVOI)) by CPST,NVOI,datepart(yy,DPSTVOI)
I want to migrate it under MS SQLServer 2000, but I have this error message
:
Serveur : Msg 8120, Niveau 16, tat 1, Ligne 1
Column 'HREH3M.DPSTVOI' is invalid in the select list because it is not
contained in either an aggregate function or the GROUP BY clause.
If I delete the last line, the query is Ok :
select 'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
,'Anne'=datepart(yy,DPSTVOI),'Priode'=
CPST,'Nombre'=count(NVOI)
from HREH3M
group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
The problem is with COMPUTE claude, but I can't understand why.
please help me to solve this.
thanks in advance
regards
LaurentWhat kind of error or warning appears when you drop that line? Apparently
syntax for COMPUTE is fine.
"Laurent CLAUDEL" wrote:
> Hi,
> I have this query ( it is Ok with Sybase SQLServer)
> select 'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
> ,'Année'=datepart(yy,DPSTVOI),'Période
'=CPST,'Nombre'=count(NVOI)
> from HREH3M
> group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
> order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
> compute sum(count(NVOI)) by CPST,NVOI,datepart(yy,DPSTVOI)
>
> I want to migrate it under MS SQLServer 2000, but I have this error messag
e
> :
> Serveur : Msg 8120, Niveau 16, état 1, Ligne 1
> Column 'HREH3M.DPSTVOI' is invalid in the select list because it is not
> contained in either an aggregate function or the GROUP BY clause.
> If I delete the last line, the query is Ok :
> select 'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
> ,'Année'=datepart(yy,DPSTVOI),'Période
'=CPST,'Nombre'=count(NVOI)
> from HREH3M
> group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
> order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(
mm,DPSTVOI)
> The problem is with COMPUTE claude, but I can't understand why.
> please help me to solve this.
> thanks in advance
> regards
> Laurent
>
>|||if I drop the last line (COMPUTE), there is no more error.
"Enric" <Enric@.discussions.microsoft.com> a crit dans le message de news:
B27D7A22-9880-4A31-9335-D0C77C2DED83@.microsoft.com...
> What kind of error or warning appears when you drop that line? Apparently
> syntax for COMPUTE is fine.
> "Laurent CLAUDEL" wrote:
>|||But I want a sum by Year, so i have to keep the COMPUTE clause
"Laurent CLAUDEL" <laurent.claudel@.steria.com> a crit dans le message de
news: OhOqg8Y1FHA.1108@.TK2MSFTNGP14.phx.gbl...
> if I drop the last line (COMPUTE), there is no more error.
> "Enric" <Enric@.discussions.microsoft.com> a crit dans le message de news:
> B27D7A22-9880-4A31-9335-D0C77C2DED83@.microsoft.com...
>|||I suggest you don't use COMPUTE / COMPUTE BY unless it's essential to
maintain Sybase compatibility. COMPUTE is legacy stuff that was
deprecated long ago. Take a look at CUBE / ROLLUP in Books Online -
it's a much more powerful feature.
David Portas
SQL Server MVP
--sql
Tuesday, March 20, 2012
Problem with function
Hello,
I am unable to resolve an error message for following user defined function.
Scope of this function:
This functions generates a unique identifier no from a table and returns it to caller.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION SystemNoShiva1
( -- Add the parameters for the function here
)
RETURNS int
AS
begin
DECLARE @.st2 numeric(18,0)
DECLARE @.sys01 numeric(18,0)
declare sys cursor for Select Max(SystemNo) From TISSystemMst1
open sys
Fetch sys into @.sys01
begin
--DECLARE @.st2 numeric(18,0)
if (@.@.fetch_status = 0)
-- IF @.@.ROWCOUNT <> 0
close sys
Deallocate sys
select @.sys01 = @.sys01 + 1
--update TISSystemMst1 set systemno = (@.sys01)
insert into TISSystemMst1 values(@.sys01)
select @.st2 = @.sys01
end
RETURN @.st2
end
Messeg I receive is
Msg 128, Level 15, State 1, Line 17
The name "sys" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
How can I clear above error message?
Nilkanth Desai
Hi,
A typical cursor fetch as follows, however looking at the script, why are you using a cursor, if we are simply selecting the topmost (Max) value and incrementing it?
If you are simply incrementing the topmost value why not use something like
CREATE FUNCTION SystemNoShiva1
( -- Add the parameters for the function here
)
RETURNS int
declare @.st2 int
set @.st2 = (Select Max(SystemNo)+1 From TISSystemMst1)
insert into TISSystemMst1 values (@.st2)
return @.st2
Go
--Cursor Option As Follows--
declare @.sys01 int
Declare sys Cursor For
Select Max(SystemNo) From TISSystemMst1
Open sys
fetch next from sys
into @.sys01
WHILE @.@.fetch_status=0
begin
set @.sys01 = (@.sys01+1)
insert into TISSystemMst1 values(@.sys01)
fetch next from sys
into @.sys01
end
close sys
deallocate sys
return @.sys01
Hope this helps
|||Hello GDR,
Thx for u r prompt reply. I tried both samples but receive error as under.
Sample 1
While creating this function I receive message "Incorrect syntext near the keyword declare"
In Sample 2
In this code sample I receive same error message as I was receiving in my previous (main) message.
Nilkanth Desai
|||My humble appologies, the 'AS' is missing, I wrote the script on the forum page, not on a SQL interface thus parsing was not an option,
CREATE FUNCTION SystemNoShiva1
RETURNS int
AS
begin
declare @.st2 int
set @.st2 = (Select Max(SystemNo)+1 From TISSystemMst1)
insert into TISSystemMst1 values (@.st2)
return @.st2
End
Problem with Full-text searching
I am getting this error message from SQL Server when attempting any full-text
catalog operation:
Error 7619: Execution of a full-text operation failed. The parameter is
incorrect.
The service appears to be installed and running on Windows 2003 Server and
the error appears to be coming from stored procedures like
sp_fulltext_database. What do I need to check next to resolve this problem?
can you create your catalog or fulltext indexes through the wizard?
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
"Andrew" <wanhelp@.elca.org> wrote in message
news:F9513F7D-D058-4AEB-BC18-321BB05896A7@.microsoft.com...
>I am getting this error message from SQL Server when attempting any
>full-text
> catalog operation:
> Error 7619: Execution of a full-text operation failed. The parameter is
> incorrect.
> The service appears to be installed and running on Windows 2003 Server and
> the error appears to be coming from stored procedures like
> sp_fulltext_database. What do I need to check next to resolve this
> problem?
>
|||"Hilary Cotter" wrote:
> can you create your catalog or fulltext indexes through the wizard?
No. The wizard terminates after this error message appears.
|||This appears to be windows 2000. Can do any operations through tsql, such as
creating a table.
Can you try this for me
create database fulltextest
GO
use fulltextest
GO
sp_fulltext_database 'enable'
GO
create table fulltext
(pk int not null identity constraint pk primary key,
charcol char (20))
GO
sp_fulltext_catalog 'test','create'
GO
sp_fulltext_table 'fulltext', 'create', 'test','pk'
GO
sp_fulltext_column 'fulltext','charcol','add'
GO
sp_fulltext_table 'fulltext','start_full'
GO
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
"Andrew" <wanhelp@.elca.org> wrote in message
news:281B3353-53E0-48CF-85B4-559B3688217F@.microsoft.com...
> "Hilary Cotter" wrote:
>
> No. The wizard terminates after this error message appears.
>
|||"Hilary Cotter" wrote:
> This appears to be windows 2000. Can do any operations through tsql, such as
> creating a table.
> Can you try this for me
> create database fulltextest
The first step that broke was the one with sp_fulltext_database 'enable'. I
worked it out with a Microsoft support engineer, though.
catalog operation:
Error 7619: Execution of a full-text operation failed. The parameter is
incorrect.
The service appears to be installed and running on Windows 2003 Server and
the error appears to be coming from stored procedures like
sp_fulltext_database. What do I need to check next to resolve this problem?
can you create your catalog or fulltext indexes through the wizard?
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
"Andrew" <wanhelp@.elca.org> wrote in message
news:F9513F7D-D058-4AEB-BC18-321BB05896A7@.microsoft.com...
>I am getting this error message from SQL Server when attempting any
>full-text
> catalog operation:
> Error 7619: Execution of a full-text operation failed. The parameter is
> incorrect.
> The service appears to be installed and running on Windows 2003 Server and
> the error appears to be coming from stored procedures like
> sp_fulltext_database. What do I need to check next to resolve this
> problem?
>
|||"Hilary Cotter" wrote:
> can you create your catalog or fulltext indexes through the wizard?
No. The wizard terminates after this error message appears.
|||This appears to be windows 2000. Can do any operations through tsql, such as
creating a table.
Can you try this for me
create database fulltextest
GO
use fulltextest
GO
sp_fulltext_database 'enable'
GO
create table fulltext
(pk int not null identity constraint pk primary key,
charcol char (20))
GO
sp_fulltext_catalog 'test','create'
GO
sp_fulltext_table 'fulltext', 'create', 'test','pk'
GO
sp_fulltext_column 'fulltext','charcol','add'
GO
sp_fulltext_table 'fulltext','start_full'
GO
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
"Andrew" <wanhelp@.elca.org> wrote in message
news:281B3353-53E0-48CF-85B4-559B3688217F@.microsoft.com...
> "Hilary Cotter" wrote:
>
> No. The wizard terminates after this error message appears.
>
|||"Hilary Cotter" wrote:
> This appears to be windows 2000. Can do any operations through tsql, such as
> creating a table.
> Can you try this for me
> create database fulltextest
The first step that broke was the one with sp_fulltext_database 'enable'. I
worked it out with a Microsoft support engineer, though.
problem with foreign keys
Hiya, I'm having a prob I'd really appreciate any help. I get the message 'ORA-02273: this unique/primary key is referenced by some foreign keys' every time i try these foreign keys. I read another post on something similar but still need some help.
For example I have 2 tables:
CREATE TABLE EQUIPMENT
(serialno varchar2(7) not null,
equip varchar2(30),
primary key (serialno) );
CREATE TABLE ROOMBOOKING
(bookingdate date not null,
sess char(1) not null,
roomno number(3) not null,
misc varchar2(30),
primary key (bookingdate, sess, roomno) ); <<SO COMPOSITE KEY HERE
Now I need to make foreign keys in another table to some of these columns but I keep getting there error. For example I've got a table called EQUIPMENTBOOKING that contains
sess, bookingdate, roomno, serialno
but I cant get the keys working.
ALTER TABLE EQUIPMENTBOOKING
add constraint fkey_room
foreign key (bookingdate, roomno, sess) references roombooking (bookingdate, roomno, sess) ;
tried one at a time
ALTER TABLE EQUIPMENTBOOKING
add constraint fkey_room
foreign key (bookingdate) references roombooking (bookingdate) ;
still get the error. And still havent put in the other table one yet, its roombooking thats causing the problem. Can one help?
thanks alottry specifying the FK columns in the same order as the PK columns
in fact you should be able simply to reference the table, and it will figure out the PK
ALTER TABLE EQUIPMENTBOOKING
add constraint fkey_room
foreign key (bookingdate, sess, roomno) references roombooking|||Aaah, thanks a lot. That fixed it up. Working now, thankyou.
For example I have 2 tables:
CREATE TABLE EQUIPMENT
(serialno varchar2(7) not null,
equip varchar2(30),
primary key (serialno) );
CREATE TABLE ROOMBOOKING
(bookingdate date not null,
sess char(1) not null,
roomno number(3) not null,
misc varchar2(30),
primary key (bookingdate, sess, roomno) ); <<SO COMPOSITE KEY HERE
Now I need to make foreign keys in another table to some of these columns but I keep getting there error. For example I've got a table called EQUIPMENTBOOKING that contains
sess, bookingdate, roomno, serialno
but I cant get the keys working.
ALTER TABLE EQUIPMENTBOOKING
add constraint fkey_room
foreign key (bookingdate, roomno, sess) references roombooking (bookingdate, roomno, sess) ;
tried one at a time
ALTER TABLE EQUIPMENTBOOKING
add constraint fkey_room
foreign key (bookingdate) references roombooking (bookingdate) ;
still get the error. And still havent put in the other table one yet, its roombooking thats causing the problem. Can one help?
thanks alottry specifying the FK columns in the same order as the PK columns
in fact you should be able simply to reference the table, and it will figure out the PK
ALTER TABLE EQUIPMENTBOOKING
add constraint fkey_room
foreign key (bookingdate, sess, roomno) references roombooking|||Aaah, thanks a lot. That fixed it up. Working now, thankyou.
Monday, March 12, 2012
Problem with executing a SQL Server DTS Package from ASP
Could someone help. I am new at writing scripts to execute a DTS package using ASP. After I run my scripts, I get the following error message :
Step [DTSStep_DTSDataPumpTask_1] failed
Task "Import FITA Calendar"
Package [Import Fita Calendar] failed
Here is what my scripts look like :
<%
Const DTSSQLStgFlag_Default = 0
Const DTSStepExecResult_Failure = 1
Dim oPkg, oStep, sMessage, bStatus
Set oPkg = Server.CreateObject("DTS.Package")
oPkg.LoadFromSQLServer "myserver","sa","$12eww",DTSSQLStgFlag_Default,"","","","Import FITA calendar"
oPkg.Execute()
bStatus = True
For Each oStep In oPkg.Steps
sMessage = sMessage & "<p> Step [" & oStep.Name & "] "
If oStep.ExecutionResult = DTSStepExecResult_Failure Then
sMessage = sMessage & " failed<br>"
bStatus = False
Else
sMessage = sMessage & " succeeded<br>"
End If
sMessage = sMessage & "Task """ & oPkg.Tasks (oStep.TaskName).Description & """</p>"
Next
If bStatus Then
sMessage = sMessage & "<p>Package [" & oPkg.Name & "] succeeded</p>"
Else
sMessage = sMessage & "<p>Package [" & oPkg.Name & "] failed</p>"
End If
Response.Write sMessage
Response.Write "<p>Done</p>"
%>because I do that alot. And you can exec DTS inside SP. So you can place this inside your sp and just exec from asp. Hope that helps.
example
exec master..xp_cmdshell 'dtsrun /Ssql1 /NPublish /E'
This will execute the DTSRun command line utility with the parameters
/S = SQL Server Host Name
/N = DTS Package Name
You can either use /E for "trusted connection" or /U/P to supply username and passwords
Step [DTSStep_DTSDataPumpTask_1] failed
Task "Import FITA Calendar"
Package [Import Fita Calendar] failed
Here is what my scripts look like :
<%
Const DTSSQLStgFlag_Default = 0
Const DTSStepExecResult_Failure = 1
Dim oPkg, oStep, sMessage, bStatus
Set oPkg = Server.CreateObject("DTS.Package")
oPkg.LoadFromSQLServer "myserver","sa","$12eww",DTSSQLStgFlag_Default,"","","","Import FITA calendar"
oPkg.Execute()
bStatus = True
For Each oStep In oPkg.Steps
sMessage = sMessage & "<p> Step [" & oStep.Name & "] "
If oStep.ExecutionResult = DTSStepExecResult_Failure Then
sMessage = sMessage & " failed<br>"
bStatus = False
Else
sMessage = sMessage & " succeeded<br>"
End If
sMessage = sMessage & "Task """ & oPkg.Tasks (oStep.TaskName).Description & """</p>"
Next
If bStatus Then
sMessage = sMessage & "<p>Package [" & oPkg.Name & "] succeeded</p>"
Else
sMessage = sMessage & "<p>Package [" & oPkg.Name & "] failed</p>"
End If
Response.Write sMessage
Response.Write "<p>Done</p>"
%>because I do that alot. And you can exec DTS inside SP. So you can place this inside your sp and just exec from asp. Hope that helps.
example
exec master..xp_cmdshell 'dtsrun /Ssql1 /NPublish /E'
This will execute the DTSRun command line utility with the parameters
/S = SQL Server Host Name
/N = DTS Package Name
You can either use /E for "trusted connection" or /U/P to supply username and passwords
Saturday, February 25, 2012
problem with DB after upgrade to 2005
Hi all.
I just ran my first test upgrade from 2000 to 2005 on a system with
several db's. All of them but one seem to be fine. I get a message
that says the following when I try to expand the table list:
Value cannot be null parameter name: context (object explorer)
the details of the message are here:
===================================
Value cannot be null.
Parameter name: context (ObjectExplorer)
--
Program Location:
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext..ctor(SqlOlapConnectionInfoBase
connection, String name, String context, INodeInformation parent)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
nodes, INodeInformation source, INavigableItem sourceItem, String
urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
nodes, INodeInformation source, INavigableItem sourceItem,
IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonContextFilterNavigableItemBuilder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryView.get_Items()
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage.CopyItems(ISummaryView
summaryView)
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage..ctor(ISummaryView
summaryView, List`1 columnDescriptors)
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.PopulateView()
Like i said, this is the only db out of 4 user db's that is having
this problem.
any suggestions on where to start?
MeredithHi Meredith
"mryan" wrote:
> Hi all.
> I just ran my first test upgrade from 2000 to 2005 on a system with
> several db's. All of them but one seem to be fine. I get a message
> that says the following when I try to expand the table list:
> Value cannot be null parameter name: context (object explorer)
> the details of the message are here:
> ===================================> Value cannot be null.
> Parameter name: context (ObjectExplorer)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext..ctor(SqlOlapConnectionInfoBase
> connection, String name, String context, INodeInformation parent)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
> nodes, INodeInformation source, INavigableItem sourceItem, String
> urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
> nodes, INodeInformation source, INavigableItem sourceItem,
> IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonContextFilterNavigableItemBuilder.Build(INodeInformation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryView.get_Items()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage.CopyItems(ISummaryView
> summaryView)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage..ctor(ISummaryView
> summaryView, List`1 columnDescriptors)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.PopulateView()
>
> Like i said, this is the only db out of 4 user db's that is having
> this problem.
> any suggestions on where to start?
>
> Meredith
>
There doesn't seem to be much on this error!
http://groups.google.com/groups/search?hl=en&lr=&q=%22Parameter+name%3A+context+%28ObjectExplorer%29%22
Does this error occur for all databases (including master/tempdb or new
ones), if so it is most likely an issue with the installation or tools.
If specific databases, then can you restore a SQL 2000 backup onto the SQL
2005 server and see if it still occurs?
Check the compatibility mode of the original database and the upgraded one.
John|||I know there seems to be nothing really out there on this error. It
is only happening on one db on the server, so I find it unlikely as
well that it is an install issue - even stranger, I can expand the
views list, and other objects in that DB just fine. The compatibility
modes are the same (80). My next step is to do a restore, but I am
trying to exhaust all other options since it is a 500gig db, and the
restore is going to take 10+ hrs.
Meredith
> There doesn't seem to be much on this error!
> http://groups.google.com/groups/search?hl=en&lr=&q=%22Parameter+name%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded one.
> John- Hide quoted text -
> - Show quoted text -|||There really isn't much out there on this. The error is only
happening on the table list of a single user db. The compatibility
mode is the same (80), and it is happening on several different
installs of SSMS. A restore is my last hope since it is a 500gig db
and the restore will take 10+ hrs.
Meredith
> > Meredith
> There doesn't seem to be much on this error!
> http://groups.google.com/groups/search?hl=en&lr=&q=%22Parameter+name%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded one.
> John- Hide quoted text -
> - Show quoted text -|||On May 16, 2:26 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Meredith
>
>
> "mryan" wrote:
> > Hi all.
> > I just ran my first test upgrade from 2000 to 2005 on a system with
> > several db's. All of them but one seem to be fine. I get a message
> > that says the following when I try to expand the table list:
> > Value cannot be null parameter name: context (object explorer)
> > the details of the message are here:
> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> > Value cannot be null.
> > Parameter name: context (ObjectExplorer)
> > --
> > Program Location:
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeCont=ext.=AD.ctor(SqlOlapConnectionInfoBase
> > connection, String name, String context, INodeInformation parent)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Navigabl=eIte=ADmBuilder.BuildDynamicItemWithQuery(IList
> > nodes, INodeInformation source, INavigableItem sourceItem, String
> > urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Navigabl=eIte=ADmBuilder.BuildDynamicItem(IList
> > nodes, INodeInformation source, INavigableItem sourceItem,
> > IFilterProvider filter)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Navigabl=eIte=ADmBuilder.Build(INodeInformation
> > source, INavigableItem sourceItem, IFilterProvider filter)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonConte=xtFi=ADlterNavigableItemBuilder.Build(INodeInformation
> > source, INavigableItem sourceItem, IFilterProvider filter)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Navigabl=eIte=ADm.GetChildren()
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryV=iew.=ADget_Items()
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVi=rtua=ADlStorage.CopyItems(ISummaryView
> > summaryView)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVi=rtua=ADlStorage..ctor(ISummaryView
> > summaryView, List`1 columnDescriptors)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneL=istV=ADiewer.PopulateView()
> > Like i said, this is the only db out of 4 user db's that is having
> > this problem.
> > any suggestions on where to start?
> > Meredith
> There doesn't seem to be much on this error!
> http://groups.google.com/groups/search?hl=3Den&lr=3D&q=3D%22Parameter+nam=
e%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded on=e=2E
> John- Hide quoted text -
> - Show quoted text -
I figured it out! The problem seems to be that there are two tables
in the DB not owned by dbo. When you query information_schema.tables
the table_schema value for both is NULL. Of course I can't modify
ownership or drop either table, so I am going to have to restore a new
copy of the db, with the ownership of those tables fixed.
Meredith|||Hi Meredith
"mryan" wrote:
> I figured it out! The problem seems to be that there are two tables
> in the DB not owned by dbo. When you query information_schema.tables
> the table_schema value for both is NULL. Of course I can't modify
> ownership or drop either table, so I am going to have to restore a new
> copy of the db, with the ownership of those tables fixed.
> Meredith
>
Does the user who owned the object exist in the restored system and is that
user associated to a login?
John
I just ran my first test upgrade from 2000 to 2005 on a system with
several db's. All of them but one seem to be fine. I get a message
that says the following when I try to expand the table list:
Value cannot be null parameter name: context (object explorer)
the details of the message are here:
===================================
Value cannot be null.
Parameter name: context (ObjectExplorer)
--
Program Location:
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext..ctor(SqlOlapConnectionInfoBase
connection, String name, String context, INodeInformation parent)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
nodes, INodeInformation source, INavigableItem sourceItem, String
urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
nodes, INodeInformation source, INavigableItem sourceItem,
IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonContextFilterNavigableItemBuilder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryView.get_Items()
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage.CopyItems(ISummaryView
summaryView)
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage..ctor(ISummaryView
summaryView, List`1 columnDescriptors)
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.PopulateView()
Like i said, this is the only db out of 4 user db's that is having
this problem.
any suggestions on where to start?
MeredithHi Meredith
"mryan" wrote:
> Hi all.
> I just ran my first test upgrade from 2000 to 2005 on a system with
> several db's. All of them but one seem to be fine. I get a message
> that says the following when I try to expand the table list:
> Value cannot be null parameter name: context (object explorer)
> the details of the message are here:
> ===================================> Value cannot be null.
> Parameter name: context (ObjectExplorer)
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeContext..ctor(SqlOlapConnectionInfoBase
> connection, String name, String context, INodeInformation parent)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
> nodes, INodeInformation source, INavigableItem sourceItem, String
> urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
> nodes, INodeInformation source, INavigableItem sourceItem,
> IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonContextFilterNavigableItemBuilder.Build(INodeInformation
> source, INavigableItem sourceItem, IFilterProvider filter)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryView.get_Items()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage.CopyItems(ISummaryView
> summaryView)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage..ctor(ISummaryView
> summaryView, List`1 columnDescriptors)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.PopulateView()
>
> Like i said, this is the only db out of 4 user db's that is having
> this problem.
> any suggestions on where to start?
>
> Meredith
>
There doesn't seem to be much on this error!
http://groups.google.com/groups/search?hl=en&lr=&q=%22Parameter+name%3A+context+%28ObjectExplorer%29%22
Does this error occur for all databases (including master/tempdb or new
ones), if so it is most likely an issue with the installation or tools.
If specific databases, then can you restore a SQL 2000 backup onto the SQL
2005 server and see if it still occurs?
Check the compatibility mode of the original database and the upgraded one.
John|||I know there seems to be nothing really out there on this error. It
is only happening on one db on the server, so I find it unlikely as
well that it is an install issue - even stranger, I can expand the
views list, and other objects in that DB just fine. The compatibility
modes are the same (80). My next step is to do a restore, but I am
trying to exhaust all other options since it is a 500gig db, and the
restore is going to take 10+ hrs.
Meredith
> There doesn't seem to be much on this error!
> http://groups.google.com/groups/search?hl=en&lr=&q=%22Parameter+name%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded one.
> John- Hide quoted text -
> - Show quoted text -|||There really isn't much out there on this. The error is only
happening on the table list of a single user db. The compatibility
mode is the same (80), and it is happening on several different
installs of SSMS. A restore is my last hope since it is a 500gig db
and the restore will take 10+ hrs.
Meredith
> > Meredith
> There doesn't seem to be much on this error!
> http://groups.google.com/groups/search?hl=en&lr=&q=%22Parameter+name%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded one.
> John- Hide quoted text -
> - Show quoted text -|||On May 16, 2:26 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Meredith
>
>
> "mryan" wrote:
> > Hi all.
> > I just ran my first test upgrade from 2000 to 2005 on a system with
> > several db's. All of them but one seem to be fine. I get a message
> > that says the following when I try to expand the table list:
> > Value cannot be null parameter name: context (object explorer)
> > the details of the message are here:
> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> > Value cannot be null.
> > Parameter name: context (ObjectExplorer)
> > --
> > Program Location:
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodeCont=ext.=AD.ctor(SqlOlapConnectionInfoBase
> > connection, String name, String context, INodeInformation parent)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Navigabl=eIte=ADmBuilder.BuildDynamicItemWithQuery(IList
> > nodes, INodeInformation source, INavigableItem sourceItem, String
> > urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Navigabl=eIte=ADmBuilder.BuildDynamicItem(IList
> > nodes, INodeInformation source, INavigableItem sourceItem,
> > IFilterProvider filter)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Navigabl=eIte=ADmBuilder.Build(INodeInformation
> > source, INavigableItem sourceItem, IFilterProvider filter)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonConte=xtFi=ADlterNavigableItemBuilder.Build(INodeInformation
> > source, INavigableItem sourceItem, IFilterProvider filter)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Navigabl=eIte=ADm.GetChildren()
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryV=iew.=ADget_Items()
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVi=rtua=ADlStorage.CopyItems(ISummaryView
> > summaryView)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVi=rtua=ADlStorage..ctor(ISummaryView
> > summaryView, List`1 columnDescriptors)
> > at
> > Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneL=istV=ADiewer.PopulateView()
> > Like i said, this is the only db out of 4 user db's that is having
> > this problem.
> > any suggestions on where to start?
> > Meredith
> There doesn't seem to be much on this error!
> http://groups.google.com/groups/search?hl=3Den&lr=3D&q=3D%22Parameter+nam=
e%...
> Does this error occur for all databases (including master/tempdb or new
> ones), if so it is most likely an issue with the installation or tools.
> If specific databases, then can you restore a SQL 2000 backup onto the SQL
> 2005 server and see if it still occurs?
> Check the compatibility mode of the original database and the upgraded on=e=2E
> John- Hide quoted text -
> - Show quoted text -
I figured it out! The problem seems to be that there are two tables
in the DB not owned by dbo. When you query information_schema.tables
the table_schema value for both is NULL. Of course I can't modify
ownership or drop either table, so I am going to have to restore a new
copy of the db, with the ownership of those tables fixed.
Meredith|||Hi Meredith
"mryan" wrote:
> I figured it out! The problem seems to be that there are two tables
> in the DB not owned by dbo. When you query information_schema.tables
> the table_schema value for both is NULL. Of course I can't modify
> ownership or drop either table, so I am going to have to restore a new
> copy of the db, with the ownership of those tables fixed.
> Meredith
>
Does the user who owned the object exist in the restored system and is that
user associated to a login?
John
Subscribe to:
Posts (Atom)