seanprice - All Comments

SQL Management Studio Snapshot Add-In

Noticias — Mon, 11 Aug 2008 04:03:57 GMT

Un snapshot de la base de datos es una vista estática y de solo lectura de la base de datos origen

re: SQL Management Studio Snapshot Add-In

Henry — Mon, 28 Jul 2008 15:12:10 GMT

I'm not sure if I've done something wrong. I installed the add-in and got an .NET error message (see below). I installed the add-in in the default directory c:\program files\. Can someone help out with this?

System.TypeLoadException: Could not load type 'Microsoft.SqlServer.Management.Smo.Edition' from assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'.

at MauiCode.SnapshotAddin.SnapCreateMenuItem.Invoke()

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItemBase.MenuInvokedHandler(Object sender, EventArgs args)

at System.Windows.Forms.MenuItem.OnClick(EventArgs e)

at System.Windows.Forms.MenuItem.MenuItemData.Execute()

at System.Windows.Forms.Command.Invoke()

at System.Windows.Forms.Command.DispatchID(Int32 id)

at System.Windows.Forms.Control.WmCommand(Message& m)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.TreeView.WndProc(Message& m)

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Glorf IT - Bedenkliches aus dem IT-Alltag » SQL-Server: Datenbank-Snapshots leicht gemacht

Sun, 08 Jun 2008 20:12:05 GMT

Pingback from Glorf IT - Bedenkliches aus dem IT-Alltag » SQL-Server: Datenbank-Snapshots leicht gemacht

re: Data Scripter Add-in for Management Studio

Sretlaw — Thu, 17 Apr 2008 17:22:52 GMT

Hi Sean - I tried to install the utility with SQL Server Management Studio Express, but never got the menu option for scripting the table. Not sure if this is because I'm using the Express version or not. Thanks.

Free SQL Server tools that might make your life a little easier

Zunanji viri — Wed, 06 Feb 2008 22:27:41 GMT

Update: New Stuff from the latest update will be in RED . This list will grow as I find new tools. So

re: SQL Management Studio Snapshot Add-In

Charles Hwang — Thu, 08 Nov 2007 06:07:36 GMT

This addin does not work on SMSS running on Vista.

I got the following error:

"The add-in 'Snapshot Add-In ' failed to load or caused an exception. Would you like to remove this Add-in?

If you choose yes, you will need to reinstall the Add-in to use it again.

Error messages: Class not registered

Error number: 80040154

Any ideas?

re: Data Scripter Add-in for Management Studio

Yan Liberman — Thu, 11 Oct 2007 19:23:24 GMT

Hi,

nice utility!

Milliseconds in dates are lost. Example: "2006-07-03 13:44:15.670" -> "03.07.2006 13:44:15"

IMHO It’s better to use an universal format ("yyyyMMdd HH:mm:ss.fff") for datetime values.

Еще один простой бесплатный Add-in для SQL Server Management Studio 2005

Yan Liberman — Wed, 10 Oct 2007 09:01:43 GMT

Вдогонку к моему предыдущему посту.

re: Data Scripter Add-in for Management Studio

seanprice — Tue, 18 Sep 2007 18:50:22 GMT

Piotr,

I can't repeat that error. Can you send me a DDL script for the table that's giving you problems and some sample data and I'll see what I can do. You can send it to my gmail account. The account name is the same as my blog name.

re: Data Scripter Add-in for Management Studio

Piotr Rodak — Mon, 17 Sep 2007 10:06:26 GMT

Good work, thanks. I find it very useful. I would change one thing though: I would add explicit datetime conversion to generated script. Right now I get 'value out of range' errors on datetime fields, due to implicit conversion of generated dates in insert statements. If you had time to add convert function into your code it would be great :)

Recent Queries

Jon Sayce — Sun, 02 Sep 2007 17:59:24 GMT

Have you ever needed to write some SQL that's almost the same as a previous query, but the previous query

Data Scripter : AddIn SQL Server Management Studio pour générer un script des données d'une table

CoqBlog — Sat, 01 Sep 2007 23:23:37 GMT

Sean Price , auteur de l'addin pour les snapshots dont je vous avais parler précédemment , a rendu disponible

Interesting Finds: August 29, 2007

Jason Haley — Wed, 29 Aug 2007 14:02:19 GMT

re: SQL Management Studio Snapshot Add-In

danielm — Fri, 10 Aug 2007 00:27:55 GMT

Champion Sean - That looks like a great start!

re: SQL Management Studio Snapshot Add-In

seanprice — Thu, 09 Aug 2007 23:57:50 GMT

Daniel,

This link has a fairly good tutorial. http://aspalliance.com/1374_Extend_Functionality_in_SQL_Server_2005_Management_Studio_with_Addins