An IT Solution

Configuration:- Windows Server 2003 R2 32 bit Sql Express 2008 R2 While checking for server event as a part of maintenance we a information which is occuring after every 1-10 seconds the information is Event "Starting up database DatabaseName" We found the solution and implemnted the same. You need to open "Sql Express Management Studio>>Database>>Properties>>Options>>Auto Close" and set it to false. For more information on this property, please refer http://blogs.msdn.com/b/buckwoody/archive/2009/06/24/sql-server-best-practices-autoclose-should-be-off.aspx http://msdn.microsoft.com/en-us/library/ms135094%28SQL.90%29.aspx

We are developing Application for Google Smart TV and all is going well. We are using Table, Div or some other elements which cannot be focused on using .focus() of java script. We have used Table to show data in one of our page. Our target is to set the focus on first element of table i.e. first row. We tried different solutions suggested on web but nothing worked. All the posts are suggesting to use focusable controls like text box, check box etc. Finally we found solution on http://groups.google.com/group/mozilla.dev.tech.css/browse_thread/thread/42591922d95c6399 In the post "Stanimir Stamenkov" has used a term "if you just define a 'tabindex' on the element it becomes focusable" I assigned "tabindex" property to table row and then used .focus() and the focus reached to row. Hope this will help all who are looking for such nice solutions.

I am using asp.net 4.0 with Sql server. I have an requirement to pass special characters in URL query string. for example my URL need to be like http://mysite.com/default.aspx?a=xyx(abc) In the above URL my special character is "(" and ")". While development I have not faced any issue but as I uploaded the files to serve it start giving error 404 (page not found) where ever I have use "(" or ")" special characters. When I started searching I have tried many solutions. but nothing works for me. Then on some site some one has sugested to check IIS log. When I checked the log I found that I have Installed Microsoft URL Scan 3.1 on my server which is filtering the URL. So, I need to allow "(" and ")" on my server so, I decided to allow there characters in my URL. So, to add exception to URL Scan 3.1 you need to open urlscan.ini which you can find in "%windir%\system32\inetsrv\urlscan\" You can use 2 section...

We have a target to run a JOB on server to import data from another SQL server instance. For example take Server 1 - Main Server 2 - From which we have to import. If you have admin rights on both the servers you can "Link the servers" under "Server Objects>>Linked Servers" Right click on the same and provide all the parameters of server or as an alternate you can run following command. EXEC sp_addlinkedserver @server = 'db1', @srvproduct = 'SQLServer OLEDB Provider',  @provider = 'SQLOLEDB',  @datasrc = 'server2',  @provstr='User Id=sa; Password=abc' The above command parameters:-  @server- An identification name of server. @datasrc- Your server instance name or IP. Your SQL will look like:- Select * from db1.dbname.dbo.tablename If sometimes the server will get changed, the above statement gives you the option to change the user name, password and server at any points of time without effecting the ...

With the launch of VS 2010, we start using VS 2010 and used the new improved IDE and features of VS 2010. While woring with a windows based application we have requirement to use Crystal Report. We are able to add and design a new Crystal Report without facing any problem. After writing the code to show data, we start getting a unique problem of "crdb_adoplus.dl". We searched for many solution and finally find the solution. We added the following attributes in app.config <startup useLegacyV2RuntimeActivationPolicy="true"> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/> </startup> So, the final app.config will be :- <?xml version="1.0" encoding="utf-8" ?> <configuration> </connectionStrings> <startup useLegacyV2RuntimeActivationPolicy="true"> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/> ...