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
Wednesday, 20 October 2010
SQL Server 2000, 2005 intellisense and snippets
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
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
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
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=""
; 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
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
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
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
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
Subscribe to:
Posts (Atom)