Showing posts with label cant. Show all posts
Showing posts with label cant. Show all posts

Friday, March 30, 2012

ID Column has backed down !

hi
honestly, i can't understand
why the pointer has backed down...
in design view, i see the value 147.720
while the last id-key is 147.772
what happens ?
thanks
atte, Hernn
You need to post your DDL so we can better understand the question. Are you
working with the identity property or is this a home-grown id?
--Brian
(Please reply to the newsgroups only.)
"bajopalabra" <bajopalabra@.hotmail.com> wrote in message
news:essjRIIuFHA.204@.TK2MSFTNGP10.phx.gbl...
> hi
> honestly, i can't understand
> why the pointer has backed down...
> in design view, i see the value 147.720
> while the last id-key is 147.772
> what happens ?
> thanks
> --
> atte, Hernn
>

I'd changed the server name, sql server can't start

hi, I have changed the host name of windows 2K server , then sql server 2000
can not start now, how can I restore the config? I don't want to reinstall
the sql server, thanks.Hi Tigershome,
To solve this, register your server again. Enter Enterprise Manager,
right-click on your SQL Server Group, then select New SQL Server
Registration... Follow the wizard and when it asks you for the server, type
the name of your new Windows 2K server. Continue and finish the wizard, and
your SQL Server will be up and running. If not, please post again.
Jerome Smith
"tigershome" <tigershome@.etang.com> wrote in message
news:OlLC7FZqDHA.2488@.TK2MSFTNGP12.phx.gbl...
> hi, I have changed the host name of windows 2K server , then sql server
2000
> can not start now, how can I restore the config? I don't want to reinstall
> the sql server, thanks.
>
>

Monday, March 26, 2012

I/O error (bad page id)

We can't get the database restored. It won't reattach
(sp_attach_db) and it won't restore from a backup file.
So we have the Mdf and Ldf files and a backup file but
since we detached, we can't seem to get the data on-line
again to do anything.
Any attempts to repair the database with CHECKDB results
in consistency errors. The database can be backed up but
not restored from a recent database backup. We tried to
recreate the database by using Copy Database Wizard and
DTS both with no success because of an I/O error. Trying
to query tables sometimes worked and other times didn't.
Finally, the database was detached and ended any attempts
to re-attach thus far.
Server: Msg 7995, Level 16, State 1, Line 1
Database 'woodsch0304' consistency errors in sysobjects,
sysindexes, syscolumns, or systypes prevent further
CHECKDB processing.
Not giving up yet...
If the database has any value to you, it is time to open a call to MS PSS. I
think the cost is still $249.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob Pearson" <anonymous@.discussions.microsoft.com> wrote in message
news:120d01c4263f$ffce93e0$a501280a@.phx.gbl...
> We can't get the database restored. It won't reattach
> (sp_attach_db) and it won't restore from a backup file.
> So we have the Mdf and Ldf files and a backup file but
> since we detached, we can't seem to get the data on-line
> again to do anything.
> Any attempts to repair the database with CHECKDB results
> in consistency errors. The database can be backed up but
> not restored from a recent database backup. We tried to
> recreate the database by using Copy Database Wizard and
> DTS both with no success because of an I/O error. Trying
> to query tables sometimes worked and other times didn't.
> Finally, the database was detached and ended any attempts
> to re-attach thus far.
> Server: Msg 7995, Level 16, State 1, Line 1
> Database 'woodsch0304' consistency errors in sysobjects,
> sysindexes, syscolumns, or systypes prevent further
> CHECKDB processing.
>
> Not giving up yet...
>
|||You've lost a page in one of the critical (for CHECKDB and database use)
system tables so you're in danger of losing your database. I concur with
Wayne's suggestion - PSS is your best bet.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:eGoGOWkJEHA.624@.TK2MSFTNGP11.phx.gbl...
> If the database has any value to you, it is time to open a call to MS PSS.
I
> think the cost is still $249.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Bob Pearson" <anonymous@.discussions.microsoft.com> wrote in message
> news:120d01c4263f$ffce93e0$a501280a@.phx.gbl...
>

Monday, March 19, 2012

I wanna change my Enterprise Manager Font SQL 2000!

Greetings!!
I would like to change my EM font to something (IMO) that is easier on
the eye. However I can't seem to achieve this simple task. I try
Tools..Font.. in EM however nothing works! I have looked at other
messages and have come across the regfont.exe however I have a hunch
that is a SQL 6.5 program.
Please, anyone out there, put me out of my font-related misery!!!
Yours,
qh
quackhandle1975@.yahoo.co.uk wrote:
> Greetings!!
> I would like to change my EM font to something (IMO) that is easier on
> the eye. However I can't seem to achieve this simple task. I try
> Tools..Font.. in EM however nothing works! I have looked at other
> messages and have come across the regfont.exe however I have a hunch
> that is a SQL 6.5 program.
>
> Please, anyone out there, put me out of my font-related misery!!!
> Yours,
> qh
>
Hi
I don't know if you can change it in EM, but if you switch to SQL Server
Management Studio (SQL 2005), you can change the font as you like.
Regards
Steen
|||I actually solved this...
Right click on the desktop (not in any app) select Appearance and
change the icon text font!
Hey presto, the font in Enterprise Mangler is changed!!!
I deserve a medal for this...
;o)
qh

I understand Why can't BCP ..

Hello..
I use command BCP rceiving the following error :
(SQLState = S1000, Native Error = 0
Error = [Microsoft][ODBC SQL Server Driver]ODBCBCP/Driver
version mismatch)What is your bcp command line? Are you bcp'ing out or in? What version of
SQL are you trying to connect to.
It is hard to tell where your version error is coming from. I used a 2000
bcp client to export/import from a SQL 6.5 database and a SQL 6.5 client to
export/import from a SQL 2000 database.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Hydren" <hydrenyear@.pop.co.th> wrote in message
news:249c01c3e0d0$7371e7d0$a401280a@.phx.gbl...
quote:

> Hello..
> I use command BCP rceiving the following error :
> (SQLState = S1000, Native Error = 0
> Error = [Microsoft][ODBC SQL Server Driver]ODBCBCP/Driver
> version mismatch)
>

Monday, March 12, 2012

I really need help with this one.

I really need help with this, I am sure it cant be too hard, I have
just been looking at it too long.
I have part numbers and vendor numbers and I would like a query to show
a distinct part number and vendor derived from the vendor that has
delivered the most of that part.
The reason I have more than one vendor for each part, is that incoming
from a warranty repair from the same vendor can appear as seperate from
the mass production delivery. for instance
This is an example of my data:
PART Vendor QTY Delivered
-- -- --
12345-1 125a 20
12345-1 5456c 35
12345-1 25a 5
12345-1 72v 10000 <-Max delivered for Part/Vend
12345-1 89c 12
99998-7 51 100000 <-Max delivered for part/Vend
99998-7 52 8
99998-7 53 5
I would then like the data to appear as below:
PART Vendor QTY Delivered
-- -- --
12345-1 72v 10000
99998-7 51 100000
It would then only display the part and vendor where the Qty is
highest. I also only ever see one instance of any part number, though a
vendor number can appear each time the vendor delivers the most of that
part.
Thanks in advance for any help you can give me.
PhilSELECT *
FROM Deliveries as D
WHERE QtyDelivered =
(select max(QtyDelivered) from Deliveries as M
where D.Part = M.Part)
One point this does not address is when two vendors both have the same
QtyDelivered for a part. As written, it will show two rows for the
part.
Roy Harvey
Beacon Falls, CT
On 2 May 2006 10:47:26 -0700, "philipbennett25" <pbennett@.xyratex.com>
wrote:

>I really need help with this, I am sure it cant be too hard, I have
>just been looking at it too long.
>I have part numbers and vendor numbers and I would like a query to show
>a distinct part number and vendor derived from the vendor that has
>delivered the most of that part.
>The reason I have more than one vendor for each part, is that incoming
>from a warranty repair from the same vendor can appear as seperate from
>the mass production delivery. for instance
>
>This is an example of my data:
> PART Vendor QTY Delivered
>-- -- --
>12345-1 125a 20
>12345-1 5456c 35
>12345-1 25a 5
>12345-1 72v 10000 <-Max delivered for Part/Vend
>12345-1 89c 12
>99998-7 51 100000 <-Max delivered for part/Vend
>99998-7 52 8
>99998-7 53 5
>
>I would then like the data to appear as below:
> PART Vendor QTY Delivered
>-- -- --
>12345-1 72v 10000
>99998-7 51 100000
>
>It would then only display the part and vendor where the Qty is
>highest. I also only ever see one instance of any part number, though a
>vendor number can appear each time the vendor delivers the most of that
>part.
>Thanks in advance for any help you can give me.
>Phil

Sunday, February 19, 2012

I need help about two server configuration

Hello I have one sql server 2000 and one MSDE , I need a database replicated
in two servers, but I can't modify table structures.
I need to make data modifications in SQL Server and in MSDE, what type of
replication can I use ?
Thank you .
Guillermo
Guillermo,
there are several choices, depending on your setup:
If you are expecting conflicts then the (out of the box) choice is between
queued updating and merge replication. Queued updating won't work if you are
replicating BLOBs but it is generally much faster than merge, especially as
you only have one subscriber.
If the data is completely partitioned, you could use bidirectional
transactional replication (not out of the box though).
If there is continual connectivity (unlikely as you are using MSDE as the
subscriber) then immediate updating subscribers could be relevant.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Thank you Paul, but I can not use Merge because that type of replication
make changes in my table structures.
And transactional replication from sql server to MSDE is ok but what can I
do for MSDE to Sql Server?
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> escribi en el mensaje
news:%23ynvRF95GHA.3592@.TK2MSFTNGP05.phx.gbl...
> Guillermo,
> there are several choices, depending on your setup:
> If you are expecting conflicts then the (out of the box) choice is between
> queued updating and merge replication. Queued updating won't work if you
are
> replicating BLOBs but it is generally much faster than merge, especially
as
> you only have one subscriber.
> If the data is completely partitioned, you could use bidirectional
> transactional replication (not out of the box though).
> If there is continual connectivity (unlikely as you are using MSDE as the
> subscriber) then immediate updating subscribers could be relevant.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
|||Guillermo,
if you go down the transactional route, you'll still have schema changes for
updating subscribers. You're quite right that bidirectional transactional
replication isn't an option as you have MSDE and hence can't publish from
it. So, for merge or transactional you'll have another column added. If you
want a solution that doesn't alter the schema at all, then for your
requirements you could consider Redgate DataCompare which just uses Primary
Keys as identifiers. BTW, what is the problem with the schema being altered
to add the extra column?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||"what is the problem with the schema being altered to add the extra
column?"
I fear that it causes errors in my applications
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> escribi en el mensaje
news:uFjTFnF6GHA.1256@.TK2MSFTNGP04.phx.gbl...
> Guillermo,
> if you go down the transactional route, you'll still have schema changes
for
> updating subscribers. You're quite right that bidirectional transactional
> replication isn't an option as you have MSDE and hence can't publish from
> it. So, for merge or transactional you'll have another column added. If
you
> want a solution that doesn't alter the schema at all, then for your
> requirements you could consider Redgate DataCompare which just uses
Primary
> Keys as identifiers. BTW, what is the problem with the schema being
altered
> to add the extra column?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||I would only think so if these applications use "select * from ...", which
is pretty unusual. In other cases you'll be OK.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .