Jon Sayce - All Comments

Total SQL Recall : Cool Add-in for SQL SERVER 2005 SSMS « Let’s Learn

Total SQL Recall : Cool Add-in for SQL SERVER 2005 SSMS « Let’s Learn — Mon, 14 Jul 2008 13:38:25 GMT

Pingback from Total SQL Recall : Cool Add-in for SQL SERVER 2005 SSMS « Let’s Learn

Link Listing - March 31, 2008

Christopher Steen — Tue, 01 Apr 2008 06:33:42 GMT

Link Listing - March 31, 2008

re: Browsers, processes, cookies and session state

jonsayce — Wed, 26 Mar 2008 09:10:05 GMT

There was a comment on this post from someone called Ronnie in the last few days, but it seems to have been lost during the upgrade of the blog's software.

"We are having the same issue with Session sharing in muti pages in IE (New Window type)

Is there a way to disable the New Window (Or new tab)? base on an ID passed to my cookie?"

I don't think this is possible. The cookie is designed to store information about the user and, as far as I know, cannot be used to change the behaviour of the browser.

http://sqlblogcasts.com/blogs/jonsayce/archive/2008/01/14/Total-SQL-Recall.aspx

http://sqlblogcasts.com/blogs/jonsayce/archive/2008/01/14/Total-SQL-Recall.aspx — Wed, 26 Mar 2008 08:55:14 GMT

Pingback from sqlblogcasts.com/.../Total-SQL-Recall.aspx

Bookmarking the web - w07/2008

Bookmarking the web - w07/2008 — Sat, 16 Feb 2008 18:48:26 GMT

PingBack from http://www.d2design.be/bookmarking/bookmarking-the-web-w072008/

re: Total SQL Recall - A Recent Queries (SQL Execution History) SSMS Add-in

jonsayce — Tue, 05 Feb 2008 16:05:50 GMT

Hi moff,

Glad you're finding it useful.

If you contact me through the page shown below then I can email you a file to turn on tracing for your colleague, which may help pinpoint the problem.

Your colleague isn't using SQL Server Express is he? I haven't tested it, but I don't think it works with that.

http://sqlblogcasts.com/blogs/jonsayce/contact.aspx

re: Total SQL Recall - A Recent Queries (SQL Execution History) SSMS Add-in

moff — Tue, 05 Feb 2008 15:34:40 GMT

great add-in!

works fine for me but a colleague gets an error

"The Add-in 'SauceCode Total SQL Recall' 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 Message: Class not registered

Error number: 80040154"

trying to register the dll manually generates an error. 'not entry point'.

re: Building a SQL Server Management Studio Add-in

jonsayce — Fri, 01 Feb 2008 08:56:30 GMT

Hi Oleg,

I haven't tried building an add-in for SSMS Express, but I know Mladen has:

http://weblogs.sqlteam.com/mladenp/

Jon.

re: Building a SQL Server Management Studio Add-in

Oleg — Fri, 01 Feb 2008 07:34:33 GMT

Hi, thank you

How I can create it for SSMS Express?

Regards,

Oleg.

SQL Management Studio add-ins 相关文章

代码乱了 — Mon, 21 Jan 2008 01:56:54 GMT

发现国内根本没有SQLManagementStudio

re: Total SQL Recall - A Recent Queries (SQL Execution History) SSMS Add-in

jonsayce — Mon, 14 Jan 2008 21:33:22 GMT

Hi Mladen,

I've had SQL Prompt and Refactor installed during development and my add-in seems to work fine with them. I've also just installed SSMS Tools Pack as well, and everything is still OK.

If it hasn't showed up as the last item on your View menu then I'd be interested to know what's going on - I'll email you a file to switch logging on.

Jon.

re: Total SQL Recall - A Recent Queries (SQL Execution History) SSMS Add-in

Mladen — Mon, 14 Jan 2008 19:03:44 GMT

Hi,

i've installed the x86 version for 2k5 and i've started the ssms but i don't see it anywhere nor does it save anything. I also have redgate's sql prompt, refactor and my ssms Tools Pack addins installed. does it clash with then in any way?

Pages tagged "history"

Pages tagged "history" — Mon, 14 Jan 2008 18:05:44 GMT

PingBack from http://www.blogbookmarker.com/tags/history

re: Browsers, processes, cookies and session state

LeonC — Mon, 17 Dec 2007 20:32:48 GMT

Thanks John. Yes, this is as I suspected. Unfortunately, this system has about 2500 users around the state of CA and there's no way to dictate their platform. I think what I'll probably have to do is move to some kind of Ajax-based "window" that acts like a modal dialog box. I've not tried this but believe I have the tools to do something like this. Anyway, thanks for your input.

re: Browsers, processes, cookies and session state

jonsayce — Sun, 16 Dec 2007 23:56:48 GMT

Leonc,

I don't know any way to force IE to share cookies that I would trust enough to rely on in an internet scenario.

Using window.open generally opens the child window in the same process (i.e. sharing the cookie/state), but there's no guarantee of this in IE6 or IE7. IE7 seems much more likely to start new processes than IE6, so I suspect that's the root of your problem.

Using window.showModalDialog and showModelessDialog seem to reliably open the dialogs in the same process (when using IE), and I've used these before to share session between an application and a dialog, but only in an intranet system where I knew (and had control of) the user's setup, including the version of browser being used. Neither of these methods is W3C standard, and there's little support for them in browsers other than IE.

Without knowing more details of your app it's hard to say what the best solution would be. Using showModalDialog or showModeless dialog would probably work if you know everyone is using IE, but you might want to consider the alternatives. Would it be possible to make the data entry window part of the main application so you can avoid a dialog that needs session? Or could the dialog work without access to session, maybe getting the information it needs from a database? Perhaps you could pass the important information from session to the dialog in a different way, e.g. query string?