In response to my previous post, I have just spotted the new "Publish to Provider" option in VS2008 server explorer.  It builds a script to recreate the db together with the data, and has an option to target 2000 – pretty easy solution all round... Cheers Ian Technorati Tags: SQL 2005,SQL 2000

Technorati Tags: SQL 2005,SQL 2000 I recently had to do this, and had to scratch my head a bit. Anyway here is the path I took I created an empty db in sql 2000 Generated a create db script for the sql 2005 db using management studio (Right click on DB > Tasks > Generate Script), including all objects in the selected db.  There is also an option in this wizard: Script for Server version, which I set to SQL 2000  Ran the script on the...

Technorati Tags: Silverlight 1.1 Until we get the controls for silverlight 1.1 you need to create your own.  This is actually reasonably easy once you know how.  Tim Heuer has a nice example of a glassy button.  But I thought it might be useful to have more examples out in the wild.  So I am going to publish a few here every now and then.  These are not commecial quality controls, just starting points for you to develop. First up is a Hyperlink control.  This is pretty simple, just a TextBlock and an animation to show...

Technorati Tags: Silverlight Streaming,Expression Encoder This is worth a look. A simple plugin to Expression Encoder that makes it trivially easy to publish your encoded content to the Silverlight Streaming service.  This wasn't that hard to do manually before, but it was a bit fiddly.  Now its a simple question of completing the following dialog.  Your encoded content will be uploaded with the created manifest, and it will generate the iframe code you will need to include on your web page.  In addition you get to see existing streaming applications you have created, see...