Migrating data into dbf file

I have to migrate datat from my table to my accounting system.

The table fields of the accounting system are different from my sql table and the Acc sys accepts only .DBF files.

I would have to migrate the data daily.
So my question is: whats the best approach for doing this work.
Should I create a nother table in Sql Server with the field names as the dbf file and write a SP to get all the data from another tabel into this one and then using export wizard to export data into a dbf file.
Or is there any better appraoch
regards

Hi,
Perhaps the better approach is a Data Trasformation Service scheduled daily.
Best regards

Migrate SQL Server from 64Bit platform to 32Bit

Hi, All:

We have to migrate several 64Bit SQL Servers to 32Bit platform. Due to the 64Bit source systems are all production system, the downtime is too limited. So we can only get the DB files via Detach way. Among the source systems, both SQL2000 and SQL2005 exist.

My question are:

Is it possible to migrate the DB from 64Bit to 32Bit via Detach/Attach?

If ok, how to do that?

Any info will be highly appreciated! Thanks!

Best Regards,

Kevin

See the response to the same question here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1066278&SiteID=1

Migrate SQL Server from 64Bit platform to 32Bit

Hi, All:

We have to migrate several 64Bit SQL Servers to 32Bit platform. Due to the 64Bit source systems are all production system, the downtime is too limited. So we can only get the DB files via Detach way. Among the source systems, both SQL2000 and SQL2005 exist.

My question are:

Is it possible to migrate the DB from 64Bit to 32Bit via Detach/Attach?

If ok, how to do that?

Any info will be highly appreciated! Thanks!

Best Regards,

Kevin

Hi Kevin.

The on-disk layout of database files is the same for 64bit and 32bit databases, there's no difference...you can freely attach/detach, backup/restore, etc. to/from 32bit/64bit systems and vice-versa at will with no issues. Of course, this assumes you are moving the between supported migration/compatibility instances...i.e. you couldn't move a Sql 2005 64bit database to a Sql 2000 32bit system...

HTH

|||

Hi, Chad:

Greate thanks for your reply!

Best Regards,

Kevin

migrate SQL 2000 system users

I have installed a new SQL 2005 server and successfully moved a db from one to the other. The users from that db were also imported, but the system security was not. Users cannot access the SQL system to even attempt to login to the db. What am I missing to import/transfer/migrate the system logins from SQL2000 to SQL2005?

Thanks

David

Moving to the setup and upgrade forum.

Donald

|||

Take a look at http://support.microsoft.com/kb/918992/

Thanks,

Peter

Migrate Higher version of MDAC

Hi Friends,

I have a system with windows 2000 advanced server SP4 OS. In that system, How can i upgrade MDAC version from 2.5 to 2.8 sp2.

This is use of,

I am going to install sql server 2005 express edition advanced services SP2.

Please help me, how can i upgrade higher version of MDAC?

Thanks in Advance

Rameshkumar Thirumalaisamy

You just download the version you want from the Microsoft Download Center and install it. I believe that MDAC 2.8 is currently at SP1, not SP2 as you've indicated. You can find MDAC 2.8 SP1 here.

Mike

|||

Actually, if you install the SQL Server 2005 on the machine you can connect using the SNAC provider instead of using the MDAC stack. Although you should be up-to-date in the case another application needs parts of the MDAC stack.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

When installing SQL Server 2005 (any edition) on Windows 2000 there actually is a minimum version of MDAC that is required, although I can't recall what version is required, but 2.8 SP1 will certainly qualify since it's the newest. I don't know why this requirement exists only on Windows 2000.

Mike

Migrate Higher version of MDAC

Hi Friends,

I have a system with windows 2000 advanced server SP4 OS. In that system, How can i upgrade MDAC version from 2.5 to 2.8 sp2.

This is use of,

I am going to install sql server 2005 express edition advanced services SP2.

Please help me, how can i upgrade higher version of MDAC?

Thanks in Advance

Rameshkumar Thirumalaisamy

You just download the version you want from the Microsoft Download Center and install it. I believe that MDAC 2.8 is currently at SP1, not SP2 as you've indicated. You can find MDAC 2.8 SP1 here.

Mike

|||

Actually, if you install the SQL Server 2005 on the machine you can connect using the SNAC provider instead of using the MDAC stack. Although you should be up-to-date in the case another application needs parts of the MDAC stack.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

When installing SQL Server 2005 (any edition) on Windows 2000 there actually is a minimum version of MDAC that is required, although I can't recall what version is required, but 2.8 SP1 will certainly qualify since it's the newest. I don't know why this requirement exists only on Windows 2000.

Mike

migraiton from Analysis Service 2000 to 2005

I get this error during migraiton from Analysis Services 2000 to 2005

Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IDbGroup90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{CE55E9E9-9597-4214-B21F-30C7683467B1}' failed due
to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

IMRAN

Recently I successfully migrated OLAP database from 2000 to 2005 didn't see this error even I had to run few times migration wizards. Best guess, may be some thing not installed or configured correctly. However if you give at what step of migration you get this error that will help.

-Ashok

|||Databases:
FoodMart 2000
Data sources:
FoodMart
Dimensions:
Account
Category
Customer Pattern
Customers
Department
Education Level
Employees
Gender
HR^Pay Type
Marital Status
Position
Product
Promotion Media
Promotions
Store
Store Size in SQFT
Store Type
Time
Warehouse
Yearly Income
Years in the Company
Cubes:
Budget
HR
Sales
Trained Cube
Warehouse
Warehouse and Sales
Mining models:
Customer Pattern Discovery
Member Card RDBMS
Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IDbGroup90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{CE55E9E9-9597-4214-B21F-30C7683467B1}' failed due
to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).|||

Try upgrading your AS 2005 to SP2.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

migraiton from Analysis Service 2000 to 2005

I get this error during migraiton from Analysis Services 2000 to 2005

Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IDbGroup90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{CE55E9E9-9597-4214-B21F-30C7683467B1}' failed due
to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

IMRAN

Recently I successfully migrated OLAP database from 2000 to 2005 didn't see this error even I had to run few times migration wizards. Best guess, may be some thing not installed or configured correctly. However if you give at what step of migration you get this error that will help.

-Ashok

|||Databases:
FoodMart 2000
Data sources:
FoodMart
Dimensions:
Account
Category
Customer Pattern
Customers
Department
Education Level
Employees
Gender
HR^Pay Type
Marital Status
Position
Product
Promotion Media
Promotions
Store
Store Size in SQFT
Store Type
Time
Warehouse
Yearly Income
Years in the Company
Cubes:
Budget
HR
Sales
Trained Cube
Warehouse
Warehouse and Sales
Mining models:
Customer Pattern Discovery
Member Card RDBMS
Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IDbGroup90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{CE55E9E9-9597-4214-B21F-30C7683467B1}' failed due
to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).|||

Try upgrading your AS 2005 to SP2.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Migiration of DB from one storage sub system to another vendor

DB is 150GB and I cannot take it offline long enough to apply logs to a back up.
I am moving from one sub storage system to another.
Any mirroring ideas?
ThanksNot sure what you mean by applying the logs? You don't need to take sql
server offline to do backups. Mabye these will help:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"eudamon" <max789@.yahoo.com> wrote in message
news:cf4ef727.0401071937.136fb59d@.posting.google.com...
> DB is 150GB and I cannot take it offline long enough to apply logs to a
back up.
> I am moving from one sub storage system to another.
> Any mirroring ideas?
> Thanks|||Standard backs would work, but then I have a existing transactions on one server with sub storage system and a restored back up to a new sub storage system DB. Plus the time is takes to copy a couple 100gb. I was hoping for some way to mirror the existing DB to a new copy on the seperate storage subsystem. Hope this makes sense|||Are you talking about just a one shot deal or do you want to keep the two up
to sync all the time? If so you can use Log Shipping or replication but in
either case you need to get the whole DB there to start and that usually
involves a copy or some sort.
--
Andrew J. Kelly SQL MVP
"eudamon" <anonymous@.discussions.microsoft.com> wrote in message
news:7E1B5A95-DFC2-4A52-958D-3F411F824569@.microsoft.com...
> Standard backs would work, but then I have a existing transactions on one
server with sub storage system and a restored back up to a new sub storage
system DB. Plus the time is takes to copy a couple 100gb. I was hoping for
some way to mirror the existing DB to a new copy on the seperate storage
subsystem. Hope this makes sense|||If your're trying to move the DB files to a new storage system on the same
server then your best bet is to detach/move/re-attach the DB. If you aren't
able to be down long enough to be able to do this I think your only option
is to mess around with filegroups. Create new file(s) in an existing
filegroup on the storage system and use DBCC SHRINKFILE('file_name',
EMPTYFILE) which will move the data from that file to other files in the
filegroup. Or create a new filegroup with new file(s) on the new storage
system and rebuild clustered indexes specifying the new filegroup, which
will cause the table to be moved. You'll actually have to rebuild all
indexes specifying ON 'filegroup' if you use this method.
I don't believe there are any options for mirroring in SQL Server. Maybe a
third-party like Veritas has something that could mirror/unmirror live
volumes.
Mike Kruchten
"eudamon" <max789@.yahoo.com> wrote in message
news:cf4ef727.0401071937.136fb59d@.posting.google.com...
> DB is 150GB and I cannot take it offline long enough to apply logs to a
back up.
> I am moving from one sub storage system to another.
> Any mirroring ideas?
> Thanks

Microsoft.Jet.OLEDB.4.0" has not been registered

I'm trying to import an access database into a sql express database (32 bit system) and get the following error

Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

my script is as follows

SELECT *

FROM OPENDATASOURCE(

'Microsoft.Jet.OLEDB.4.0',

'Data Source="k:\armycwy.mdb";

User ID=Admin;Password='

)...CWAM_ROSTER

Anyone got an idea what is wrong?

TIA

Kevin

I noticed you mentioned 32-bit: is everything 32-bit - i.e. tha machine, Windows, and SQL Express, or is something perhaps 64-bit? We saw similar issues if running 32-bit SQL Server/SQL Express on a 64-bit machine (or vice versa).

What is the Windows version - e.g., XP, Winwdows Server 2000, 2003, etc.?

|||

hi kevin,

pleas try downloading and installing the latest driver

found on this site

http://msdn.microsoft.com/data/mdac/downloads/default.aspx

Joey

Microsoft##EESS and MSDE SQL 2000 on Windows 2003 Small Business Server

Currently a server running 2003 small business operating system has MSDE 2000 and Microsoft##SSEE.

A memory problem exists with SQL consuming over 50% of RAM. Total RAM is 4GB.

There is a SQL 2000 patch for this type of problem. However, it calls for SQL to be upgraded to SP4.

Problem:
Can this MSDE 2000 be upgraded with SP4 and have memory patch applied with Microsoft##SSEE also on this box?

Please let me know. Thank you.

Yes.

You might also investigate setting the MAX memory setting for both SQL instances.

|||

Hi,

Yes you can update with SQL Server SP4.

Refering to SQL Server memory architecture it goes upto maximum limit specify by you, and if not specified it can eat up all the memory it can access and freed up as N when require by another resources. I think below articles are good enough to clear it

http://sqljunkies.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk

http://msdn2.microsoft.com/en-us/library/ms187499.aspx

HTH

Hemantgiri S. Goswami

Microsoft SQL Server Management Studio SP2 upgrade

Hi
Having an issue after sp2 install on SQl 2005. The problem I am having is
when I try to open the Maintenance Plans applet in system manager. I get the
following error:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
--
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
--
BUTTONS:
OK
--
I do not see any of the previse jobs the only thing I get is this error.
Any help is appreciated.
Dell Poweredge 1950
Windows 2003 STD sp2
Intel Xeon 3.2
4.0 gb Ram
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCPDid you upgrade the client tools but not the server instance (database
services)?
--
Aaron Bertrand
SQL Server MVP
"jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> Hi
> Having an issue after sp2 install on SQl 2005. The problem I am having is
> when I try to open the Maintenance Plans applet in system manager. I get
> the
> following error:
> TITLE: Microsoft SQL Server Management Studio
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'from_msx'.
> Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I do not see any of the previse jobs the only thing I get is this error.
> Any help is appreciated.
> Dell Poweredge 1950
> Windows 2003 STD sp2
> Intel Xeon 3.2
> 4.0 gb Ram
> --
> Joel Cavazos
> Network Administrator
> MCSE, MCSA, MCP|||Aaron
Going back thur the update summary log I did find that thier was a error in
the update process regarding the database services the error is:
----
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could
not be started. Verify that you have sufficient privileges to start system
services. The error code is (1067) The process terminated unexpectedly.
----
Sorry I totally missed this.
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCP
"Aaron Bertrand [SQL Server MVP]" wrote:
> Did you upgrade the client tools but not the server instance (database
> services)?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
> news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> > Hi
> >
> > Having an issue after sp2 install on SQl 2005. The problem I am having is
> > when I try to open the Maintenance Plans applet in system manager. I get
> > the
> > following error:
> >
> > TITLE: Microsoft SQL Server Management Studio
> > --
> >
> > Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> >
> > Invalid column name 'from_msx'.
> > Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
> >
> > --
> > BUTTONS:
> >
> > OK
> > --
> >
> > I do not see any of the previse jobs the only thing I get is this error.
> > Any help is appreciated.
> >
> > Dell Poweredge 1950
> > Windows 2003 STD sp2
> > Intel Xeon 3.2
> > 4.0 gb Ram
> > --
> > Joel Cavazos
> > Network Administrator
> > MCSE, MCSA, MCP
>
>

Microsoft SQL Server Management Studio SP2 upgrade

Hi
Having an issue after sp2 install on SQl 2005. The problem I am having is
when I try to open the Maintenance Plans applet in system manager. I get th
e
following error:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
BUTTONS:
OK
--
I do not see any of the previse jobs the only thing I get is this error.
Any help is appreciated.
Dell Poweredge 1950
Windows 2003 STD sp2
Intel Xeon 3.2
4.0 gb Ram
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCPDid you upgrade the client tools but not the server instance (database
services)?
Aaron Bertrand
SQL Server MVP
"jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> Hi
> Having an issue after sp2 install on SQl 2005. The problem I am having is
> when I try to open the Maintenance Plans applet in system manager. I get
> the
> following error:
> TITLE: Microsoft SQL Server Management Studio
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'from_msx'.
> Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I do not see any of the previse jobs the only thing I get is this error.
> Any help is appreciated.
> Dell Poweredge 1950
> Windows 2003 STD sp2
> Intel Xeon 3.2
> 4.0 gb Ram
> --
> Joel Cavazos
> Network Administrator
> MCSE, MCSA, MCP|||Aaron
Going back thur the update summary log I did find that thier was a error in
the update process regarding the database services the error is:
----
--
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could
not be started. Verify that you have sufficient privileges to start system
services. The error code is (1067) The process terminated unexpectedly.
----
--
Sorry I totally missed this.
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCP
"Aaron Bertrand [SQL Server MVP]" wrote:

> Did you upgrade the client tools but not the server instance (database
> services)?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
> news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
>
>

Microsoft SQL Server Management Studio Express Error At Started!!!

有关调用实时(JIT)调试而不是此对话框的详细信息，
请参见此消息的结尾。

************** 异常文本 **************
System.IO.IOException: 无法在易变父项下创建稳定子项。

在 Microsoft.Win32.RegistryKey.Win32Error(Int32 errorCode, String str)
在 Microsoft.Win32.RegistryKey.CreateSubKey(String subkey, RegistryKeyPermissionCheck permissionCheck, RegistrySecurity registrySecurity)
在 Microsoft.Win32.RegistryKey.CreateSubKey(String subkey)
在 Microsoft.SqlServer.Management.UI.ConnectionDlg.RegisteredServersUtils.CreateKeyValueIfNotExist(String regPath, String keyName)
在 Microsoft.SqlServer.Management.UI.ConnectionDlg.RegisteredServersUtils.RegisterLocalInstancesIfFirstTimeUser()
在 Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnLoad(EventArgs e)
在 System.Windows.Forms.Form.OnCreateControl()
在 System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
在 System.Windows.Forms.Control.CreateControl()
在 System.Windows.Forms.Control.WmShowWindow(Message& m)
在 System.Windows.Forms.Control.WndProc(Message& m)
在 System.Windows.Forms.ScrollableControl.WndProc(Message& m)
在 System.Windows.Forms.ContainerControl.WndProc(Message& m)
在 System.Windows.Forms.Form.WmShowWindow(Message& m)
在 System.Windows.Forms.Form.WndProc(Message& m)
在 System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
在 System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
在 System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** 已加载的程序集 **************
mscorlib
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
-
Microsoft.SqlServer.Express.AppIDPackage
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.AppIDPackage.DLL
-
Microsoft.SqlServer.Express.VSIntegration
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.VSIntegration.DLL
-
Microsoft.VisualStudio.Shell.Interop
程序集版本: 7.1.40304.0
Win32 版本: 7.0.4054
基本代码: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
-
Microsoft.VisualStudio.OLE.Interop
程序集版本: 7.1.40304.0
Win32 版本: 7.0.4054
基本代码: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
-
System
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
System.Windows.Forms
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System.Drawing
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
Microsoft.SqlServer.Express.SqlTDiagM
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlTDiagM.DLL
-
Microsoft.DataWarehouse.SQM
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
-
Microsoft.SqlServer.Instapi
程序集版本: 9.0.242.0
Win32 版本: 9.00.1399.00
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
-
Microsoft.SqlServer.Express.ObjectExplorer
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ObjectExplorer.DLL
-
Microsoft.SqlServer.Express.ConnectionDlg
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ConnectionDlg.DLL
-
System.Windows.Forms.resources
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_zh-CHS_b77a5c561934e089/System.Windows.Forms.resources.dll
-
Microsoft.SqlServer.Express.RegSvrEnum
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.RegSvrEnum.DLL
-
Microsoft.SqlServer.Express.CustomControls
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.CustomControls.DLL
-
Microsoft.SqlServer.Express.SqlWorkbench.Interfaces
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlWorkbench.Interfaces.DLL
-
Accessibility
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
-
System.Data
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
-
Microsoft.VisualStudio.TextManager.Interop
程序集版本: 7.1.40304.0
Win32 版本: 7.0.4054
基本代码: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
-
Microsoft.SqlServer.Express.SqlMgmt
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlMgmt.DLL
-
Microsoft.SqlServer.Express.SQLEditors
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SQLEditors.DLL
-
Microsoft.SqlServer.Express.ConnectionInfo
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ConnectionInfo.DLL
-
EnvDTE
程序集版本: 8.0.0.0
Win32 版本: 8.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
-
Microsoft.SqlServer.Express.SqlEnum
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlEnum.DLL
-
Microsoft.NetEnterpriseServers.Express.ExceptionMessageBox
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.NetEnterpriseServers.Express.ExceptionMessageBox.DLL
-
System.Xml
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
-
mscorlib.resources
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
-

************** JIT 调试 **************
要启用实时(JIT)调试，
该应用程序或计算机的 .config 文件(machine.config)的 system.windows.forms 节中必须设置
jitDebugging 值。
编译应用程序时还必须启用
调试。

例如:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

启用 JIT 调试后，任何无法处理的异常
都将被发送到在此计算机上注册的 JIT 调试器，
而不是由此对话框处理。

I'm going to let the SSMSE guys handle this - moving to the Tools forum.

Mike