Referenced Memory Problem with Enterprise Manager

When I attempt to attach a database using the wizard in the manager, I get
the following error when I click on the button to select MDF file of
database to attach:
The instruction at "0x41d53c0a" referenced memory at "0xffffffff". The
memory could not be read.
I've reinstalled SQL SP3a and Windows 2003 patches. Is this error a result
of a memory hardware problem or a conflict with another installed
application?
How can I resolve the problem since I am unable to use the manager for this
function?
thanks.Could me several issues. Could be a bad SQL Server binary. Mismatched
MDAC. Bad MMC build. Or, your worst fears, the .MDF file may be locked or
corrupt.
I'd try to attach to another SS server and/or use Query Analyzer and
sp_attach_db to narrow down if it is the .MDF file the local SS installation
or just the SQL EM tool.
Sincerely,
Anthony Thomas
"Dan Slaby" <dslaby3@.comcast.net> wrote in message
news:eq6sX9WAFHA.2180@.TK2MSFTNGP10.phx.gbl...
When I attempt to attach a database using the wizard in the manager, I get
the following error when I click on the button to select MDF file of
database to attach:
The instruction at "0x41d53c0a" referenced memory at "0xffffffff". The
memory could not be read.
I've reinstalled SQL SP3a and Windows 2003 patches. Is this error a result
of a memory hardware problem or a conflict with another installed
application?
How can I resolve the problem since I am unable to use the manager for this
function?
thanks.|||I resolved the problem by making another install of SP3a.
"Dan Slaby" <dslaby3@.comcast.net> wrote in message
news:eq6sX9WAFHA.2180@.TK2MSFTNGP10.phx.gbl...
> When I attempt to attach a database using the wizard in the manager, I get
> the following error when I click on the button to select MDF file of
> database to attach:
> The instruction at "0x41d53c0a" referenced memory at "0xffffffff". The
> memory could not be read.
> I've reinstalled SQL SP3a and Windows 2003 patches. Is this error a result
> of a memory hardware problem or a conflict with another installed
> application?
> How can I resolve the problem since I am unable to use the manager for
> this function?
> thanks.
>
>

Reference a file name

Hi,
How can I reference the ldf or mdf (using the logical names) file of a
particular database when I'm in a diferent context, for instance, I've got
two databases PG and PG1 and being in PG1 I want to do the following
DBCC SHRINKFILE (PG_Log ,100)
Any ideas?One option,
EXEC('Use PG DBCC SHRINKFILE (PG_Log ,100)')
-Sue
On Thu, 27 Apr 2006 17:35:01 -0700, FJC
<FJC@.discussions.microsoft.com> wrote:

>Hi,
>How can I reference the ldf or mdf (using the logical names) file of a
>particular database when I'm in a diferent context, for instance, I've got
>two databases PG and PG1 and being in PG1 I want to do the following
>DBCC SHRINKFILE (PG_Log ,100)
>Any ideas?|||Thanks Sue, I worked.
"Sue Hoegemeier" wrote:

> One option,
> EXEC('Use PG DBCC SHRINKFILE (PG_Log ,100)')
> -Sue
> On Thu, 27 Apr 2006 17:35:01 -0700, FJC
> <FJC@.discussions.microsoft.com> wrote:
>
>

Reference a file name

Hi,
How can I reference the ldf or mdf (using the logical names) file of a
particular database when I'm in a diferent context, for instance, I've got
two databases PG and PG1 and being in PG1 I want to do the following
DBCC SHRINKFILE (PG_Log ,100)
Any ideas?One option,
EXEC('Use PG DBCC SHRINKFILE (PG_Log ,100)')
-Sue
On Thu, 27 Apr 2006 17:35:01 -0700, FJC
<FJC@.discussions.microsoft.com> wrote:
>Hi,
>How can I reference the ldf or mdf (using the logical names) file of a
>particular database when I'm in a diferent context, for instance, I've got
>two databases PG and PG1 and being in PG1 I want to do the following
>DBCC SHRINKFILE (PG_Log ,100)
>Any ideas?|||Thanks Sue, I worked.
"Sue Hoegemeier" wrote:
> One option,
> EXEC('Use PG DBCC SHRINKFILE (PG_Log ,100)')
> -Sue
> On Thu, 27 Apr 2006 17:35:01 -0700, FJC
> <FJC@.discussions.microsoft.com> wrote:
> >Hi,
> >How can I reference the ldf or mdf (using the logical names) file of a
> >particular database when I'm in a diferent context, for instance, I've got
> >two databases PG and PG1 and being in PG1 I want to do the following
> >
> >DBCC SHRINKFILE (PG_Log ,100)
> >
> >Any ideas?
>

reduce the File Size less then Original Size in SQL 2000

I have one db test with one .mdf and .ldf file.
..mdf file size is 100mb and for some reson i removed all the tables
from that .mdf file and transfer it into new secondary file so all the
tables moved into secondary file now i want to reduce the first .mdf
file from 100 mb to 50mb is that possible,it's showing 90mb is free.

Please reply(ShailendraPune@.gmail.com) writes:

Quote:

Originally Posted by

I have one db test with one .mdf and .ldf file.
.mdf file size is 100mb and for some reson i removed all the tables
from that .mdf file and transfer it into new secondary file so all the
tables moved into secondary file now i want to reduce the first .mdf
file from 100 mb to 50mb is that possible,it's showing 90mb is free.

Look at DBCC SHRINKFILE in Books Online.

Although I would say that with the sizes you have indicated, I would not
consider a secondary file at all. (Unless you are doing this a training
exercise.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Reduce MDF file for SQL

How we can reduce unused space for SQL data tables?
You can shrink the file using DBCC SHRINKFILE, however unless you know that
you won't be requiring that space later, you will be better off leaving it
as it is. If the file has to endure an autogrow event, this can impact
performance during normal operation...
http://www.aspfaq.com/
(Reverse address to reply.)
"Martin" <Martin@.discussions.microsoft.com> wrote in message
news:CDDB0286-21E6-4E4D-9184-6CEA3A18CB75@.microsoft.com...
> How we can reduce unused space for SQL data tables?
|||A good explanation of how to do it and why you may not want to do it at
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Martin" <Martin@.discussions.microsoft.com> wrote in message
news:CDDB0286-21E6-4E4D-9184-6CEA3A18CB75@.microsoft.com...
> How we can reduce unused space for SQL data tables?

Reduce MDF file for SQL

How we can reduce unused space for SQL data tables?You can shrink the file using DBCC SHRINKFILE, however unless you know that
you won't be requiring that space later, you will be better off leaving it
as it is. If the file has to endure an autogrow event, this can impact
performance during normal operation...
http://www.aspfaq.com/
(Reverse address to reply.)
"Martin" <Martin@.discussions.microsoft.com> wrote in message
news:CDDB0286-21E6-4E4D-9184-6CEA3A18CB75@.microsoft.com...
> How we can reduce unused space for SQL data tables?|||A good explanation of how to do it and why you may not want to do it at
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Martin" <Martin@.discussions.microsoft.com> wrote in message
news:CDDB0286-21E6-4E4D-9184-6CEA3A18CB75@.microsoft.com...
> How we can reduce unused space for SQL data tables?