I'm using DSN-less connections to my SQL Server in an Access database. However, whenever I try to write a "Pass-Through" query and run it, a dialog box pops up asking for the DSN.
Sql-server – How to create a passthrough query in access using a DSN-less connection
dsnms-accessms-access-2010sql serversql-server-2008
Related Solutions
You can use the sp_columns stored procedure:
exec sp_columns MyTable
Microsoft should advertise this functionality of SSMS 2008. The feature you are looking for is built into the Generate Script utility, but the functionality is turned off by default and must be enabled when scripting a table.
This is a quick run through to generate the INSERT statements for all of the data in your table, using no scripts or add-ins to SQL Management Studio 2008:
- Right-click on the database and go to Tasks > Generate Scripts.
- Select the tables (or objects) that you want to generate the script against.
- Go to Set scripting options tab and click on the Advanced button.
- In the General category, go to Type of data to script
- There are 3 options: Schema Only, Data Only, and Schema and Data. Select the appropriate option and click on OK.
You will then get the CREATE TABLE statement and all of the INSERT statements for the data straight out of SSMS.
Related Topic
- Sql – How to see active SQL Server connections
- Ms-access – Creating a DSN-less connection for MS Access within Java
- Sql-server – SQL Server query to find all permissions/access for all users in a database
- Sql – How to turn IDENTITY_INSERT on and off using SQL Server 2008
- Sql – How to delete using INNER JOIN with SQL Server
- Sql-server – Cannot Connect to Server – A network-related or instance-specific error
Best Answer
In SQL view, choose properties after you have selected passthrough query and insert an ODBC connect string. For example:
See also: http://www.connectionstrings.com/sql-server-2008