Wednesday 20 October 2010

SQL Server 2000, 2005 intellisense and snippets

In SQL Server 2008 there's a cool feature that improves productivity alot, intellisense or code completion as some people call it. But in the early versions there's nothing. In my daily work I use a lot SQL Server 2000 e SQL Server 2005.

I found the following aplication that does the trick, unfortunately there only a trial version,

SQL Prompt

Digging through I found out that old version 2.0.0.59 is free.For me it's good enough.

Download it for free HERE

Saturday 16 October 2010

Content Management Server 2002 stand-alone template explorer

Several peolpe told me that they couln't load the template explorer even with cmsEnable="1" in the  Vwd.webinfo file when opening a MCMS 2002 Project in Visual Studio 2005.


After some digging I found out that there was a stand alone MCMS template explorer available


Check the site Tools for Content Management Server 2002

Thursday 14 October 2010

Check for table dependencies on SQL Server

I particularly use  this instruction

EXEC sp_depends TABLE_NAME


But there are several methods as stated here

SQL Server 2000 guys please read de following the article BUG: SP_Depends Does Not List Triggers



Wednesday 13 October 2010

Error: 18452 Login failed for user ‘user’. The user is not associated with a trusted SQL Server connection

Just the other day I spent  an hour trying to figure the "Error: 18452 Login failed for user ‘user’. The user is not associated with a trusted SQL Server connection" error. 


I easily found out that I need to change the server authentication mode to mixed mode.


It took me a while but I just needed to restart the SQL Server as stated here


http://msdn.microsoft.com/en-us/library/ms188670.aspx

Tuesday 12 October 2010

How to use UDL File to create sql connection string


1. On a directory of your choosing, create file with UDL extension i.e. test.UDL
2. Open the file icon and a wizard will appear.

3. Create your connection string. First (in the first tab) chose appropriate Provider. Then (in the second tab) construct the Connection by filling the required information (servername, database or similar).
4. Test Connection. If the connection is successful, click OK.
5. Open the UDL file with NOTEPAD
In notepad, you will have the connection string like this
[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;User ID="";Initial Catalog=MySampleDB;Data Source=.;Initial File Name="";Server SPN=""
The wizard has constructed the connection string. This is for SQL Server. Copy the bolded part and use it as connection string in your application.

Saturday 9 October 2010

Date Picker JQuery Plugin

The same guy who developed the cool color picker done another excelent job with this date picker. Thanks Stefan Petre



Check how it works here

Nice Color Picker JQuery Plugin

Cool Jquery Plugin with no need of flash. Until now all that I found was in flash. It's A simple component to select color in the same way you select color in Adobe Photoshop.






Check out it works here 

Free print screen capture tool

Having to print webpage with a big scroll, all solution that I know were paid until I found this free tool, well free until version 5.3



FastStone Capture is a powerful, lightweight, yet full-featured screen capture tool that allows you to easily capture and annotate anything on the screen including windows, objects, menus, full screen, rectangular/freehand regions and even scrolling windows/web pages. It also allows you to record screen activities and sound into video files.


Thursday 7 October 2010

Connection problems using Live Messenger 2011 in Windows 7(seven)

I've just updated my messenger to the most recent version, and instantly got problems at work because I'm behing a proxy.

After I trial and error I just found out that all I need to do was to configure the proxy by command-line

Just do what I say in the link below

http://tkingarthur.blogspot.com/2010/10/proxy-configuration-windows-7-seven.html

For other windows use

proxycfg - p server_ip:port_number


Proxy configuration windows 7 (seven)

Working mostly in windows server 2003 never noticed that in windows 7 there's no proxycfg command.
You can do the same doing the following 
Start --> Run --> CMD
netsh winhttp set proxy proxy-server=PROXYIP:PORT