Microsoft SQL Server Community & Samples

CREATED ISSUE: Attach database failed

jstevewitt — Sun, 11 May 2008 21:06:43 GMT

The database "AdventureWorks" cannot be opened because it is version 643. This server supports version 639 and earlier.

NEW POST: Sample SSIS Package Not Working With AdventureWorks

geraldbauer — Fri, 25 Apr 2008 17:01:32 GMT

I thought the same as you did only to discover that you, we, have done nothing incorrect. Look at the first task in the control flow for each dtsx. Specifically at "Create or truncate table." In the properties window for each task find SqlStatmentSource. You will discover that the tables we thought did not exist are being created or truncated.

NEW POST: Connection String not valid.

maxice — Wed, 23 Apr 2008 20:49:34 GMT

Get an error "A connection cannot be made to the database. Set and check the connection string." from BIDS Report Wizard when selecting a Data Source. The Connection string looks like the following: Data Source=.\SQLEXPRESS;Initial Catalog=AdventureWorks. Test Connection returns success.

NEW POST: Sample SSIS Package Not Working With AdventureWorks

fftw_ayi — Wed, 09 Apr 2008 17:05:40 GMT

I'm working with 2 tutorial sample SSIS packages located in

C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\Deploying Packages\Completed Packages\

(The "90" in the directory path means it's 2005 version, right?)

These packages require two target tables in AdventureWorks which do not exist in my version of AdventureWorks database. These tables are dbo.HighIncomeCustomers and dbo.OrderDatesByCountryRegion.

When I was downloading the sample database and the sample codes, I made sure I was downloading from SQL Server 2005 SP2a. What am I doing wrong?

UPDATED WIKI: Home

ReedMe — Fri, 28 Mar 2008 16:32:56 GMT

Microsoft SQL Server Community & Samples

CodePlex is the project hosting site for Microsoft SQL Server Samples and Community Projects. Projects listed here are official Microsoft samples for SQL Server (released with Service Packs or major releases of SQL Server) and applications developed by MVPs, and the SQL Server community at large, including:

Microsoft Product Samples All-in-One
Sample Databases
End to End Samples
Microsoft SQL Server Analysis Services
Microsoft SQL Server Database Engine
Microsoft SQL Server Integration Services
Microsoft SQL Server Reporting Services
Platform Tools & Utilities
Forums & Answers

Unless noted otherwise, the download links are for the latest release of the project (typically SQL Server 2008); see the individual project sites (on the Releases tab) for prior version releases. Most projects have more than one file download for a given release; read carefully to be sure you choose the ones that you need.

Got questions? Helpful links to answers are below.

Microsoft SQL Server 2008 Community Technology Preview

To obtain the latest SQL Server 2008 Community Technology Preview software, please sign up (for free!) with Microsoft Connect for the SQL Server SQL Server 2008 CTP Program.

Microsoft Product Samples

Note: This is one monolithic set of all Microsoft SQL Server product samples (except for the sample databases, due to size constraints) and does NOT include any community projects.

Project	Project Site	Download
All Microsoft Product Samples in a Box	Project Site	Download

Sample Databases

Project	Project Site	Download
Microsoft Sample Databases	Project Site	Download

End to End (multi-technology, complete, integrated)

Project	Project Site	Download
Microsoft End-to-End Samples	Project Site	Download
Community End-to-End Samples Gallery (sponsored by DPE)	Project Site	Download

Microsoft SQL Server Analysis Services

Project	Project Site	Download
Microsoft Samples (OLAP, Data Mining, Administration)	Project Site	Download
Community Analysis Services Samples Gallery	Project Site	Download
Analysis Services Stored Procedures	Project Site	Download
MDX Script Performance Analyzer	Project Site	Download
powerSSAS: A PowerShell provider for SQL Server Analysis Services	Project Site	Download

Microsoft SQL Server Database Engine

Project	Project Site	Download
Microsoft Database Engine Samples (CLR, Full Text, SMO)	Project Site	Download
Microsoft Data Programmability Samples (ADO.NET, OLEDB, ODBC)	Project Site	Download
SQL Server 2D Matrix Builder	Project Site	Download
Microsoft Replication Samples	Project Site	Download
Microsoft Service Broker Samples	Project Site	Download
Community Service Broker Samples	Project Site	Download
Microsoft Transact-SQL Sample Scripts	Project Site	Download
Microsoft XML Samples	Project Site	Download
Microsoft TechNet SQL Server Scripting Center	Project Site
Open DBDiff	Project Site	Download

Microsoft SQL Server Integration Services

Project	Project Site	Download
Microsoft Integration Services Samples	Project Site	Download
Metadata Driven ETL Management Studio (MDDE)	Project Site	Download
ssisUnit	Project Site	Download

Microsoft SQL Server Reporting Services

Project	Project Site	Download
Microsoft Reporting Services Samples	Project Site	Download

Platform Tools & Utilities

Project	Project Site	Download
DMV Stats performance data warehouse (for SQL Server 2005)	Project Site	Download
SQL Nexus performance analysis tool	Project Site	Download
BIDS Helper for Visual Studio 2005/SQL Server 2005	Project Site	Download
SQL Server 2005 Service Manager	Project Site	Download
SQL Server Hosting Toolkit	Project Site	Download
SQL Web Data Administrator	Project Site	Download
SQL Web Query	Project Site	Download

Forums & Answers

Project	Project Site
SQL Examples by MVPs (answers from the forums)	Project Site
SQL Server Katmai forums	Project Site
SQL Server forums	Project Site

Got questions or problems?

MSDN

COMMENTED ISSUE: SQL Server 2005 Samples Download - Reporting Services.

vm_rajashekar — Tue, 25 Mar 2008 20:31:13 GMT

This is releated to 2005 Reporting services. I installed sql server 2005. I downloadedand installed Sqlsamples.msi from codeplex (under SQL Server 2005 SP2). Now where do I find the MDF/Data to attach it in my Database, I mean in Management studio to check the below query. The reason is.. I am NOT able to run the query which i found in "How to do ---> Reporting Services" from the help menu.

The following is the query.

SELECT S.OrderDate, S.SalesOrderNumber, S.TotalDue, C.FirstName, C.LastName
FROM HumanResources.Employee E INNER JOIN
Person.Contact C ON E.ContactID = C.ContactID INNER JOIN
Sales.SalesOrderHeader S ON E.EmployeeID = S.SalesPersonID

And the samples.msi doesnt have it.
Comments: ** Comment from web user: vm_rajashekar **

ohhhh noo.. probably i was drunk at work. ignore my previous post :)

Microsoft provides tutorials when hit F1 in SQL Management studio. When navigated into tutorials related to Reporting Services, topics like create basic reports, connect datasource, etc.. are found, but there is no link within the tutorial which points to the correct sample database, It would be better if microsoft provides "please do this before starting the tutorial".

COMMENTED ISSUE: SQL Server 2005 Samples Download - Reporting Services.

vm_rajashekar — Tue, 25 Mar 2008 20:27:48 GMT

Microsoft provides tutorials when hit F1 in SQL Management studio, when navigated into tutorials related to Reporting Services topics like create basic reports are available but microsoft provide a link within the tutorial to download the sample database, the way to configure and start.

CREATED ISSUE: SQL Server 2005 Samples Download - Reporting Services.

vm_rajashekar — Tue, 25 Mar 2008 20:24:23 GMT

NEW POST: +SQL CRUD code generator+

perrog — Sun, 23 Mar 2008 14:40:25 GMT

Sorry to be picky, but what are you asking for? Are you planning to create a new Database API? Or a new API for applications with persitent data objects, like GNUstep's or Apple's Core Data Framework?

NEW POST: +SQL CRUD code generator+

topmcsd — Fri, 21 Mar 2008 02:34:29 GMT

Please make or point to c# code that generate CRUD for a table in SQL Server

0) Required: Create, Retrieve, Update and Delete script/sp for table xyz
1) Optional: Parameterized query or stored procedure
2) Optional: Support for identity int column SCOPE_IDENTITY()
3) Optional: User selection of key column(s)
4) Optional: File or clipboard output
5) Optional: Configurable code style
6) Optional: Mapping or user definable parameters
7) Optional: Output parameters instead of rowset
8) Optional: Refresh (return inserted/updated row)
9) ... add you own requirements here...

If anyone want to work with me on this, let me know.

COMMENTED ISSUE: Missing columns in AdventureWorks tables

deeshubby — Wed, 19 Mar 2008 15:48:30 GMT

I have installed some sample VB.NET Windows Forms code from this Microsoft site:
http://msdn2.microsoft.com/en-us/vbasic/ms789075.aspx (scroll to bottom)

The readme that came with those files specifies the following reqirements, which I have fully met.

This sample requires the following to be installed:
- Microsoft Visual Studio 2005
- Microsoft SQL Server 2005 Express
- AdventureWorks database installed at the default location

I downloaded the 27+ MB "AdventureWorksDB.msi" from this CodePlex site, and then ran the query commands in SQL Studio to properly attach the resulting data files.
I worked through initial issues of having the wrong connection string, and have verified my project now correctly connects to my SQL Server 2005 Express AdventureWorks database...
connectionString="Server=MYWORKSTATION\SQLEXPRESS;Database=AdventureWorks;Trusted_Connection=True;"

If I open up the sample "UsingBindingSource" project in Visual Studio 2005 and further open up the QueryBuilder, in order to preview the data for the "AdventureWords_DataDataSet.xsd", it tells me the following columns are invalid:

ShiftID
EmergencyContactID
AddressID
BaseRate
PayFrequency

This is the full query that is trying to execute, but is failing:
SELECT EmployeeID, NationalIDNumber, ContactID, LoginID, DepartmentID, ManagerID, ShiftID, Title, EmergencyContactID, AddressID, BirthDate,
MaritalStatus, Gender, HireDate, SalariedFlag, BaseRate, PayFrequency, VacationHours, SickLeaveHours, CurrentFlag, rowguid, ModifiedDate
FROM HumanResources.Employee

P.S - the "UsingBindingSource" example has a README at the following location, which is I'm referring to, specifically:
My Documents\MSDN\101 Samples\Windows Forms\VB\UsingBindingSource\UsingBindingSource\README.htm

How did I arrive at the wrong AdventureWorks (2005) data schema? How many are there?
Comments: ** Comment from web user: deeshubby **

For what it's worth, I've modified the base query for the VB sample code that was supplied, and the example seems to work fine now.

Evidentally, the sample did not necessarily need the additional columns to function.

I simply removed these from the SELECT statement that was used to build the dataset...
ShiftID
EmergencyContactID
AddressID
BaseRate
PayFrequency

CREATED ISSUE: Missing columns in AdventureWorks tables

deeshubby — Wed, 19 Mar 2008 14:05:42 GMT

NEW POST: C++ sample code user-defined functions

perrog — Wed, 19 Mar 2008 08:25:34 GMT

bobb wrote:

Did you use managed C++ and remember to compile with the /safe switch? There is a Visual Studio C++ project for SQL Server assemblies tshat should have all the right compiler setting

Are you sure there is one such project template in VS 2008? I can't find anyone. (yes, I'm using VS 2008, but SQL Server 2005.)

After playing around a bit (essentially inside SQL) I managed to run a C++ compiled function in SQL. I am having the assembly compiled with /clr:safe and a strong name.
But when I create the assembly inside SQL I always need to set permission to UNSAFE, otherwise it wont work (according to the error message above.) Also, I have to import the assembly private key into MSSQL, and then set up a new login and user that have access to this key. Luckely, there is a posting about this on forums.microsoft.com: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1673459&SiteID=1

I thought the /clr:safe compile option was only required if you wanted to have SAFE permission assemblies in SQL. Is this option always required? (C.p. http://msdn2.microsoft.com/en-us/library/hc912f03(VS.80).aspx)

NEW POST: C++ sample code user-defined functions

bobb — Tue, 18 Mar 2008 17:15:05 GMT

Did you use managed C++ and remember to compile with the /safe switch? There is a Visual Studio C++ project for SQL Server assemblies tshat should have all the right compiler setting

perrog wrote:
Hi!

I'm having a hard time trying to get C++ user-defined function to work. Are there any C++ sample code that I can learn from, other than samples in C# and VB?
I'm running SQL 2005 and my problem is that the server don't accept load or execute the function because of permission error.
"An error occurred in the Microsoft .NET Framework while trying to load assembly id 65561. The server may be running out of resources, or the assembly may not be trusted with PERMISSIONSET = EXTERNALACCESS or UNSAFE. Run the query again, or check documentation to see how to solve the assembly trust issues."

The assembly was created with
CREATE ASSEMBLY <name> FROM '<path>' WHERE PERMISSION_SET=SAFE

Are there C++ sample code?

NEW POST: C++ sample code user-defined functions

perrog — Tue, 18 Mar 2008 14:30:20 GMT

Hi!

I'm having a hard time trying to get C++ user-defined function to work. Are there any C++ sample code that I can learn from, other than samples in C# and VB?
I'm running SQL 2005 and my problem is that the server don't accept load or execute the function because of permission error.
"An error occurred in the Microsoft .NET Framework while trying to load assembly id 65561. The server may be running out of resources, or the assembly may not be trusted with PERMISSIONSET = EXTERNALACCESS or UNSAFE. Run the query again, or check documentation to see how to solve the assembly trust issues."

The assembly was created with
CREATE ASSEMBLY <name> FROM '<path>' WHERE PERMISSION_SET=SAFE

Are there C++ sample code?

UPDATED WIKI: Home

ReedMe — Mon, 17 Mar 2008 17:55:21 GMT

Microsoft SQL Server Community & Samples

Microsoft Product Samples All-in-One
Sample Databases
End to End Samples
Microsoft SQL Server Analysis Services
Microsoft SQL Server Database Engine
Microsoft SQL Server Integration Services
Microsoft SQL Server Reporting Services
Platform Tools & Utilities

Microsoft SQL Server 2008 Community Technology Preview

To obtain the latest SQL Server 2008 Community Technology Preview software, please sign up (for free!) with Microsoft Connect for the SQL Server SQL Server 2008 CTP Program.

Microsoft Product Samples

Note: This is one monolithic set of all Microsoft SQL Server product samples (except for the sample databases, due to size constraints) and does NOT include any community projects.

Project	Project Site	Download
All Microsoft Product Samples in a Box	Project Site	Download

Sample Databases

Project	Project Site	Download
Microsoft Sample Databases	Project Site	Download

End to End (multi-technology, complete, integrated)

Project	Project Site	Download
Microsoft End-to-End Samples	Project Site	Download
Community End-to-End Samples Gallery (sponsored by DPE)	Project Site	Download

Microsoft SQL Server Analysis Services

Project	Project Site	Download
Microsoft Samples (OLAP, Data Mining, Administration)	Project Site	Download
Community Analysis Services Samples Gallery	Project Site	Download
Analysis Services Stored Procedures	Project Site	Download
MDX Script Performance Analyzer	Project Site	Download

Microsoft SQL Server Database Engine

Project	Project Site	Download
Microsoft Database Engine Samples (CLR, Full Text, SMO)	Project Site	Download
Microsoft Data Programmability Samples (ADO.NET, OLEDB, ODBC)	Project Site	Download
SQL Server 2D Matrix Builder	Project Site	Download
Microsoft Replication Samples	Project Site	Download
Microsoft Service Broker Samples	Project Site	Download
Community Service Broker Samples	Project Site	Download
Microsoft Transact-SQL Sample Scripts	Project Site	Download
Microsoft XML Samples	Project Site	Download
Microsoft TechNet SQL Server Scripting Center	Project Site
Open DBDiff	Project Site	Download

Microsoft SQL Server Integration Services

Project	Project Site	Download
Microsoft Integration Services Samples	Project Site	Download
Metadata Driven ETL Management Studio (MDDE)	Project Site	Download
ssisUnit	Project Site	Download

Microsoft SQL Server Reporting Services

Project	Project Site	Download
Microsoft Reporting Services Samples	Project Site	Download

Platform Tools & Utilities

Project	Project Site	Download
DMV Stats performance data warehouse (for SQL Server 2005)	Project Site	Download
SQL Nexus performance analysis tool	Project Site	Download
BIDS Helper for Visual Studio 2005/SQL Server 2005	Project Site	Download
SQL Server 2005 Service Manager	Project Site	Download
SQL Server Hosting Toolkit	Project Site	Download
SQL Web Data Administrator	Project Site	Download
SQL Web Query	Project Site	Download

Got questions or problems?

MSDN

NEW POST: Having trouble with attaching the Databases

bonniefe — Wed, 27 Feb 2008 23:44:10 GMT

Are you sure you downloaded the sample database installers from the appropriate page? The default installers are for SQL Server 2008. Please see our FAQ for how to locate the SQL Server 2005 sample database installers.

NEW POST: reporting services samples for sql 2005

bonniefe — Wed, 27 Feb 2008 23:40:33 GMT

You can find reporting services samples here. You can find all the samples on our portal page at http://CodePlex.com/SqlServerSamples.

CLOSED ISSUE: Sql Server 2005 Samples?

bonniefe — Wed, 27 Feb 2008 23:37:08 GMT

The msi package contains Sql Server 2008 samples. Where are the Sql Server 2005 samples? The Microsoft Download site states to go to the SqlServerSamples site to download the Sql Server 2005 samples.
Comments: Exactly. If you click on the Releases tab and then look for the Releases pane, you'll find a list of active releases. Just click on the SQL Server 2005 SP2a link and the installers for the sample databases for SQL Server 2005 will appear towards the bottom of the page (you might have to page down).

CLOSED ISSUE: Ascmd Command-line Utility

bonniefe — Wed, 27 Feb 2008 23:12:43 GMT

Hi
I'm trying to download the Ascmd Command-line Utility.
I have downloaded "AdventureWorksBI.msi" but it was not included in it. what msi do I have to download?
Thanks for your help
Nir
Comments: Please have a look at http://www.codeplex.com/MSFTASProdSamples. AdventureWorksBI is just the sample databases, not the sample code.