Help with corrupt mdf file

I really hope someone out there can help me with this one... My company
recently acquired another company that was using SQL Server 7. The machine
that the database was housed on began to have hard drive issues. We were
able to extract the mdf and ldf files before the hard drives crashed
completely. When attempting to load these files into a SQL Server 2k
database, we hit a wall. SQL Server 2k refuses to attach the mdf file,
saying that the file is not an mdf file. We also received a similar error
in Query Analyzer, using both sp_attach_db and sp_attach_single_file_db;
this error claimed that the file name might be incorrect.
After this failure, we created a new database, stopped the services, and
switched the mdf files with the new databases. This brought the database up
in suspect mode. We were then able to switch it to suspect/emergency mode.
From here, we attempted a dbcc checkdb, which errored out with an version
error. We also attempted to import the data from the new emergency db into
a newer clean db. This failed with a login error, even though we were
logged in under sa.
I realize that we will probably not be able to retrieve all of the records
from the corrupt file, but does anyone know a way to access any of the data?
Any ideas or suggestions are welcome.
P.S. all of the servers that we manage are backed up daily... just trying
to fix another company's error
Thanks,
JoeOne of the things you might try to do is to attach it to a SQL 7 server..
Then the upgrade will not have to occur...
--
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
"Joe" <joe@.nospam.com> wrote in message
news:uFAJlKCwDHA.1888@.TK2MSFTNGP10.phx.gbl...
> I really hope someone out there can help me with this one... My company
> recently acquired another company that was using SQL Server 7. The
machine
> that the database was housed on began to have hard drive issues. We were
> able to extract the mdf and ldf files before the hard drives crashed
> completely. When attempting to load these files into a SQL Server 2k
> database, we hit a wall. SQL Server 2k refuses to attach the mdf file,
> saying that the file is not an mdf file. We also received a similar error
> in Query Analyzer, using both sp_attach_db and sp_attach_single_file_db;
> this error claimed that the file name might be incorrect.
> After this failure, we created a new database, stopped the services, and
> switched the mdf files with the new databases. This brought the database
up
> in suspect mode. We were then able to switch it to suspect/emergency
mode.
> From here, we attempted a dbcc checkdb, which errored out with an version
> error. We also attempted to import the data from the new emergency db
into
> a newer clean db. This failed with a login error, even though we were
> logged in under sa.
> I realize that we will probably not be able to retrieve all of the records
> from the corrupt file, but does anyone know a way to access any of the
data?
> Any ideas or suggestions are welcome.
>
> P.S. all of the servers that we manage are backed up daily... just
trying
> to fix another company's error
> Thanks,
> Joe
>|||Wayne,
I think your system clock or time zone is a bit off..., not sure if you have
noticed.
--
- Anith
( Please reply to newsgroups only )|||thanks... my region was wrong... sorry.
--
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
"Joe" <joe@.nospam.com> wrote in message
news:uFAJlKCwDHA.1888@.TK2MSFTNGP10.phx.gbl...
> I really hope someone out there can help me with this one... My company
> recently acquired another company that was using SQL Server 7. The
machine
> that the database was housed on began to have hard drive issues. We were
> able to extract the mdf and ldf files before the hard drives crashed
> completely. When attempting to load these files into a SQL Server 2k
> database, we hit a wall. SQL Server 2k refuses to attach the mdf file,
> saying that the file is not an mdf file. We also received a similar error
> in Query Analyzer, using both sp_attach_db and sp_attach_single_file_db;
> this error claimed that the file name might be incorrect.
> After this failure, we created a new database, stopped the services, and
> switched the mdf files with the new databases. This brought the database
up
> in suspect mode. We were then able to switch it to suspect/emergency
mode.
> From here, we attempted a dbcc checkdb, which errored out with an version
> error. We also attempted to import the data from the new emergency db
into
> a newer clean db. This failed with a login error, even though we were
> logged in under sa.
> I realize that we will probably not be able to retrieve all of the records
> from the corrupt file, but does anyone know a way to access any of the
data?
> Any ideas or suggestions are welcome.
>
> P.S. all of the servers that we manage are backed up daily... just
trying
> to fix another company's error
> Thanks,
> Joe
>|||I'm with Wayne. A secondary option can be to try
http://www.officerecovery.com/mssql/, not sure how much help such a tool can
be, though.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:OSKheOCwDHA.1680@.TK2MSFTNGP12.phx.gbl...
> One of the things you might try to do is to attach it to a SQL 7 server..
> Then the upgrade will not have to occur...
> --
> 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
> "Joe" <joe@.nospam.com> wrote in message
> news:uFAJlKCwDHA.1888@.TK2MSFTNGP10.phx.gbl...
> > I really hope someone out there can help me with this one... My company
> > recently acquired another company that was using SQL Server 7. The
> machine
> > that the database was housed on began to have hard drive issues. We
were
> > able to extract the mdf and ldf files before the hard drives crashed
> > completely. When attempting to load these files into a SQL Server 2k
> > database, we hit a wall. SQL Server 2k refuses to attach the mdf file,
> > saying that the file is not an mdf file. We also received a similar
error
> > in Query Analyzer, using both sp_attach_db and sp_attach_single_file_db;
> > this error claimed that the file name might be incorrect.
> >
> > After this failure, we created a new database, stopped the services, and
> > switched the mdf files with the new databases. This brought the
database
> up
> > in suspect mode. We were then able to switch it to suspect/emergency
> mode.
> > From here, we attempted a dbcc checkdb, which errored out with an
version
> > error. We also attempted to import the data from the new emergency db
> into
> > a newer clean db. This failed with a login error, even though we were
> > logged in under sa.
> >
> > I realize that we will probably not be able to retrieve all of the
records
> > from the corrupt file, but does anyone know a way to access any of the
> data?
> > Any ideas or suggestions are welcome.
> >
> >
> > P.S. all of the servers that we manage are backed up daily... just
> trying
> > to fix another company's error
> >
> > Thanks,
> >
> > Joe
> >
> >
>sql

Help with chinese character

sorry.. help with chinese character , cocode is nchar(10)
int (1), i can see the record of that china company, but in (2) , show
nothing...
(1)select cocode,invno ,netbaseamt from arinvinfo order by cocode
(2)select * from arinvinfo where rtrim(cocode) = 'vQ'Agnes,
You need to put N before any Unicode string, or it will
be converted to single-byte characters. It should be
this, with just the small change of adding the N:
select * from arinvinfo where rtrim(cocode) = N'宗利港塑料'
Steve Kass
Drew University
Agnes wrote:

>sorry.. help with chinese character , cocode is nchar(10)
>int (1), i can see the record of that china company, but in (2) , show
>nothing...
>(1)select cocode,invno ,netbaseamt from arinvinfo order by cocode
>(2)select * from arinvinfo where rtrim(cocode) = '宗利港塑料'
>
>|||Thanks Kass.
So for normal english character, I also use N'mycompanyname'
so, I need to correct it in all my store procedure ,right ? (If I use vb.net
. i also need to put N ?)
"Steve Kass" <skass@.drew.edu> glsD:esFp4HtIFHA.2276@.TK2MSFTNGP15.phx.gbl...[color
=darkred]
> Agnes,
> You need to put N before any Unicode string, or it will
> be converted to single-byte characters. It should be
> this, with just the small change of adding the N:
> select * from arinvinfo where rtrim(cocode) = N'vQ'
> Steve Kass
> Drew University
> Agnes wrote:
>|||Agnes,
It is good practice to use N'everything' whenever your data type is
Unicode
(nchar, nvarchar, ntext), but for strings of Latin letters, numbers and
punctuation
in the ASCII character set up to CHAR(127), you can leave it out.
For VB.Net, you can ask in a VB group. The N is for literal strings
specified
in Transact-SQL programs. It is not for every other programming language.
SK
Agnes wrote:

>Thanks Kass.
>So for normal english character, I also use N'mycompanyname'
>so, I need to correct it in all my store procedure ,right ? (If I use vb.ne
t
>. i also need to put N ?)
>"Steve Kass" <skass@.drew.edu> 撰寫於郵件新聞:esFp4HtIFHA.2276@.TK2MSF
TNGP15.phx.gbl...
>
>
>|||Recently, I found out one of query suffered huge performance, and found out
the jdbc driver converts all the query to be N'string', the query without N
is a lot faster. In this case how can you increase the performance if use
N'everything' ? Thanks
"Steve Kass" wrote:

> Agnes,
> It is good practice to use N'everything' whenever your data type is
> Unicode
> (nchar, nvarchar, ntext), but for strings of Latin letters, numbers and
> punctuation
> in the ASCII character set up to CHAR(127), you can leave it out.
> For VB.Net, you can ask in a VB group. The N is for literal strings
> specified
> in Transact-SQL programs. It is not for every other programming language.
> SK
>
> Agnes wrote:
>
>|||Jen,
I don't know the specifics of the situation you
mention, but I do know that if your data is *not*
Unicode, it can be very bad to specify string
literals with N'... . Specifically, if you have
a query like this:
select <columns>
from T
where nonUnicodeColumn = N'UnicodeConstant'
it will be impossible for the query processor to
use an index on charColumn, since the comparison
will be between cast(nonUnicodeColumn as nvarchar(<length> ))
and N'UnicodeConstant'.
If there is nothing causing a type conversion or collation
discrepancy, so long as the columns are Unicode types,
I don't know a reason why it would be a bad idea to use
the N prefix for literal values.
SK
Jen wrote:
> Recently, I found out one of query suffered huge performance, and found ou
t
> the jdbc driver converts all the query to be N'string', the query without
N
> is a lot faster. In this case how can you increase the performance if use
> N'everything' ? Thanks
> "Steve Kass" wrote:
>

Help w/ a SQL Query

In a sales software system that I built, a sales person belongs to a
department within the company. However, during their employment with the
company, they might work in several departments. So I implemented department
logging in the system.
CREATE TABLE [USER_DepartmentLog] (
[UserId] [int] NOT NULL ,
[DepartmentId] [int] NOT NULL ,
[DateTimeStarted] [datetime] NOT NULL ,
[DateTimeEnded] [datetime] NULL
)
GO
INSERT INTO USER_DepartmentLog (UserId, DepartmentId, DateTimeStarted,
DateTimeEnded) VALUES (33, 13, '06/24/2005', '05/01/2005')
INSERT INTO USER_DepartmentLog (UserId, DepartmentId, DateTimeStarted,
DateTimeEnded) VALUES (33, 12, '05/01/2005', NULL)
In this example, User 33 worked in Department 13 from 06/24/2005 to
05/01/2005
On 05/01/2005, they were transferred to Department 12
Each sales person books Jobs:
CREATE TABLE [Job] (
[Id] [int] NOT NULL,
[UserId] [int] NOT NULL,
[DateCreated] [datetime] NOT NULL
)
GO
INSERT INTO [Job]([Id], [UserId], [DateCreated]) VALUES(1, 33, '05/12/2005')
INSERT INTO [Job]([Id], [UserId], [DateCreated]) VALUES(2, 33, '05/01/2005')
INSERT INTO [Job]([Id], [UserId], [DateCreated]) VALUES(3, 33, '04/28/2005')
INSERT INTO [Job]([Id], [UserId], [DateCreated]) VALUES(4, 33, '04/05/2005')
I'd like to run a query that would return a list of jobs while at the same
time displaying the department that the sales person was in at the time they
entered the jobs. Here's what I would like my returned data to look like:
UserId JobId DepartmentId DateCreated
33 4 13 04/05/2005
33 3 13 04/28/2005
33 2 12 05/01/2005
33 1 12 05/12/2005
If a job was created on a date that the user transitioned from one
department to another, e.g. Job 2 was created on 05/01/2005 when the user
left Department 12 for Department 12, I'd like the job to appear under the
new Department.
Thank YouCORRECTION.
I meant '06/24/2002', not '06/24/2005'
INSERT INTO USER_DepartmentLog (UserId, DepartmentId, DateTimeStarted,
DateTimeEnded) VALUES (33, 13, '06/24/2002', '05/01/2005')
INSERT INTO USER_DepartmentLog (UserId, DepartmentId, DateTimeStarted,
DateTimeEnded) VALUES (33, 12, '05/01/2005', NULL)
In this example, User 33 worked in Department 13 from 06/24/2002 to
05/01/2005
On 05/01/2005, they were transferred to Department 12
"George Durzi" <gdurzi@.hotmail.com> wrote in message
news:%23wnB$nIXFHA.3340@.TK2MSFTNGP15.phx.gbl...
> In a sales software system that I built, a sales person belongs to a
> department within the company. However, during their employment with the
> company, they might work in several departments. So I implemented
> department logging in the system.
> CREATE TABLE [USER_DepartmentLog] (
> [UserId] [int] NOT NULL ,
> [DepartmentId] [int] NOT NULL ,
> [DateTimeStarted] [datetime] NOT NULL ,
> [DateTimeEnded] [datetime] NULL
> )
> GO
> INSERT INTO USER_DepartmentLog (UserId, DepartmentId, DateTimeStarted,
> DateTimeEnded) VALUES (33, 13, '06/24/2005', '05/01/2005')
> INSERT INTO USER_DepartmentLog (UserId, DepartmentId, DateTimeStarted,
> DateTimeEnded) VALUES (33, 12, '05/01/2005', NULL)
> In this example, User 33 worked in Department 13 from 06/24/2005 to
> 05/01/2005
> On 05/01/2005, they were transferred to Department 12
> Each sales person books Jobs:
> CREATE TABLE [Job] (
> [Id] [int] NOT NULL,
> [UserId] [int] NOT NULL,
> [DateCreated] [datetime] NOT NULL
> )
> GO
> INSERT INTO [Job]([Id], [UserId], [DateCreated]) VALUES(1, 33,
> '05/12/2005')
> INSERT INTO [Job]([Id], [UserId], [DateCreated]) VALUES(2, 33,
> '05/01/2005')
> INSERT INTO [Job]([Id], [UserId], [DateCreated]) VALUES(3, 33,
> '04/28/2005')
> INSERT INTO [Job]([Id], [UserId], [DateCreated]) VALUES(4, 33,
> '04/05/2005')
> I'd like to run a query that would return a list of jobs while at the same
> time displaying the department that the sales person was in at the time
> they entered the jobs. Here's what I would like my returned data to look
> like:
> UserId JobId DepartmentId DateCreated
> 33 4 13 04/05/2005
> 33 3 13 04/28/2005
> 33 2 12 05/01/2005
> 33 1 12 05/12/2005
>
> If a job was created on a date that the user transitioned from one
> department to another, e.g. Job 2 was created on 05/01/2005 when the user
> left Department 12 for Department 12, I'd like the job to appear under the
> new Department.
> Thank You
>|||Hi, George
Thank you for providing DDL, sample data and expected results. Try this
query:
SELECT Job.UserID, Job.ID as JobID, DepartmentID, DateCreated
FROM Job INNER JOIN USER_DepartmentLog
ON Job.UserID=USER_DepartmentLog.UserID
AND DateCreated>=DateTimeStarted
AND (DateCreated<DateTimeEnded OR DateTimeEnded IS NULL)
Razvan|||Try,
select
j.UserId,
j.[Id] as job_id,
u.DepartmentId,
j.DateCreated
from
job as j
inner join
USER_DepartmentLog as u
on j.userid = u.userid
and j.datecreated between u.DateTimeStarted and isnull(u.DateTimeEnded,
j.datecreated)
and j.datecreated != isnull(u.DateTimeEnded, dateadd(day, -1, j.datecreated)
)
order by
j.userid, j.datecreated
go
But better if you add a constraint to not allow a user to start working in
another department at the same time it is finishing working for another one
,
so it will force us to enter something like:
INSERT INTO USER_DepartmentLog (UserId, DepartmentId, DateTimeStarted,
DateTimeEnded)
VALUES (33, 13, '06/24/2002', '2005-05-01T08:00:00')
INSERT INTO USER_DepartmentLog (UserId, DepartmentId, DateTimeStarted,
DateTimeEnded)
VALUES (33, 12, '2005-05-01T08:00:01', NULL)
and the select statement will not need the expression:
...
and j.datecreated != isnull(u.DateTimeEnded, dateadd(day, -1, j.datecreated)
)
...
AMB
"George Durzi" wrote:

> CORRECTION.
> I meant '06/24/2002', not '06/24/2005'
> INSERT INTO USER_DepartmentLog (UserId, DepartmentId, DateTimeStarted,
> DateTimeEnded) VALUES (33, 13, '06/24/2002', '05/01/2005')
> INSERT INTO USER_DepartmentLog (UserId, DepartmentId, DateTimeStarted,
> DateTimeEnded) VALUES (33, 12, '05/01/2005', NULL)
> In this example, User 33 worked in Department 13 from 06/24/2002 to
> 05/01/2005
> On 05/01/2005, they were transferred to Department 12
>
>
> "George Durzi" <gdurzi@.hotmail.com> wrote in message
> news:%23wnB$nIXFHA.3340@.TK2MSFTNGP15.phx.gbl...
>
>|||Thank you both for your help
"George Durzi" <gdurzi@.hotmail.com> wrote in message
news:%23wnB$nIXFHA.3340@.TK2MSFTNGP15.phx.gbl...
> In a sales software system that I built, a sales person belongs to a
> department within the company. However, during their employment with the
> company, they might work in several departments. So I implemented
> department logging in the system.
> CREATE TABLE [USER_DepartmentLog] (
> [UserId] [int] NOT NULL ,
> [DepartmentId] [int] NOT NULL ,
> [DateTimeStarted] [datetime] NOT NULL ,
> [DateTimeEnded] [datetime] NULL
> )
> GO
> INSERT INTO USER_DepartmentLog (UserId, DepartmentId, DateTimeStarted,
> DateTimeEnded) VALUES (33, 13, '06/24/2005', '05/01/2005')
> INSERT INTO USER_DepartmentLog (UserId, DepartmentId, DateTimeStarted,
> DateTimeEnded) VALUES (33, 12, '05/01/2005', NULL)
> In this example, User 33 worked in Department 13 from 06/24/2005 to
> 05/01/2005
> On 05/01/2005, they were transferred to Department 12
> Each sales person books Jobs:
> CREATE TABLE [Job] (
> [Id] [int] NOT NULL,
> [UserId] [int] NOT NULL,
> [DateCreated] [datetime] NOT NULL
> )
> GO
> INSERT INTO [Job]([Id], [UserId], [DateCreated]) VALUES(1, 33,
> '05/12/2005')
> INSERT INTO [Job]([Id], [UserId], [DateCreated]) VALUES(2, 33,
> '05/01/2005')
> INSERT INTO [Job]([Id], [UserId], [DateCreated]) VALUES(3, 33,
> '04/28/2005')
> INSERT INTO [Job]([Id], [UserId], [DateCreated]) VALUES(4, 33,
> '04/05/2005')
> I'd like to run a query that would return a list of jobs while at the same
> time displaying the department that the sales person was in at the time
> they entered the jobs. Here's what I would like my returned data to look
> like:
> UserId JobId DepartmentId DateCreated
> 33 4 13 04/05/2005
> 33 3 13 04/28/2005
> 33 2 12 05/01/2005
> 33 1 12 05/12/2005
>
> If a job was created on a date that the user transitioned from one
> department to another, e.g. Job 2 was created on 05/01/2005 when the user
> left Department 12 for Department 12, I'd like the job to appear under the
> new Department.
> Thank You
>

help Sa password lost ?

One of our guy as left our company, and he has configured SQL server 2000
with sa password that he and I caanot remember.
Is there a way to reset sa passord on SQL server 2000 in order to set an
other one?
thnaks for your help
regards
serge
Hi
Login with windows authentication and at QA perform
A. Change the password of a login without the former password
This example changes the password for the login Victoria to ok.
EXEC sp_password NULL, 'ok', 'Victoria'
B. Change a password
This example changes the password for the login Victoria from ok to coffee.
EXEC sp_password 'ok', 'coffee'
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:14A10F77-EB04-46C1-AA05-366315B17921@.microsoft.com...
> One of our guy as left our company, and he has configured SQL server 2000
> with sa password that he and I caanot remember.
> Is there a way to reset sa passord on SQL server 2000 in order to set an
> other one?
> thnaks for your help
> regards
> serge
|||See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q9
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:14A10F77-EB04-46C1-AA05-366315B17921@.microsoft.com...
One of our guy as left our company, and he has configured SQL server 2000
with sa password that he and I caanot remember.
Is there a way to reset sa passord on SQL server 2000 in order to set an
other one?
thnaks for your help
regards
serge
|||Hi,
U can change the sa password by executing
sp_password.
u can have more information from bol.
hope this help
from
Doller

help Sa password lost ?

One of our guy as left our company, and he has configured SQL server 2000
with sa password that he and I caanot remember.
Is there a way to reset sa passord on SQL server 2000 in order to set an
other one?
thnaks for your help
regards
sergeHi
Login with windows authentication and at QA perform
A. Change the password of a login without the former password
This example changes the password for the login Victoria to ok.
EXEC sp_password NULL, 'ok', 'Victoria'
B. Change a password
This example changes the password for the login Victoria from ok to coffee.
EXEC sp_password 'ok', 'coffee'
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:14A10F77-EB04-46C1-AA05-366315B17921@.microsoft.com...
> One of our guy as left our company, and he has configured SQL server 2000
> with sa password that he and I caanot remember.
> Is there a way to reset sa passord on SQL server 2000 in order to set an
> other one?
> thnaks for your help
> regards
> serge|||See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q9
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:14A10F77-EB04-46C1-AA05-366315B17921@.microsoft.com...
One of our guy as left our company, and he has configured SQL server 2000
with sa password that he and I caanot remember.
Is there a way to reset sa passord on SQL server 2000 in order to set an
other one?
thnaks for your help
regards
serge|||Hi,
U can change the sa password by executing
sp_password.
u can have more information from bol.
hope this help
from
Doller

help Sa password lost ?

One of our guy as left our company, and he has configured SQL server 2000
with sa password that he and I caanot remember.
Is there a way to reset sa passord on SQL server 2000 in order to set an
other one?
thnaks for your help
regards
sergeHi
Login with windows authentication and at QA perform
A. Change the password of a login without the former password
This example changes the password for the login Victoria to ok.
EXEC sp_password NULL, 'ok', 'Victoria'
B. Change a password
This example changes the password for the login Victoria from ok to coffee.
EXEC sp_password 'ok', 'coffee'
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:14A10F77-EB04-46C1-AA05-366315B17921@.microsoft.com...
> One of our guy as left our company, and he has configured SQL server 2000
> with sa password that he and I caanot remember.
> Is there a way to reset sa passord on SQL server 2000 in order to set an
> other one?
> thnaks for your help
> regards
> serge|||See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q9
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:14A10F77-EB04-46C1-AA05-366315B17921@.microsoft.com...
One of our guy as left our company, and he has configured SQL server 2000
with sa password that he and I caanot remember.
Is there a way to reset sa passord on SQL server 2000 in order to set an
other one?
thnaks for your help
regards
serge|||Hi,
U can change the sa password by executing
sp_password.
u can have more information from bol.
hope this help
from
Doller