Sample to display Image on mouse hover.

Created the following sample for one of a small web requirement.

Hosting it since it could be useful for some one who is looking for it...

Sample Link: http://checkthiz.com/publicfiles/ImageHover.html

Hope it helps

Fauzi ~ 4Z

How to connect to SQL Server Desktop Engine Remotely

Hi all,

Lesson learnt for the day is when you try to connect to SQL Server Desktop Engine (MSDE) remotely, the scenario where i tried to connect was from SSIS - Sql Server Integration Services. I tried to create a OLEDB connection. When i tried to create the OLEDB connect the same like we use to do for SQL server; the following error message was shown



Solution: When i googled, came to know that we need to give the Server name with instance name when we create a connection.

like: <ServerName>/<InstanceName>
And we need to give the database name if not displayed in drop down list.

Hope It helps

Regrads
Fauzi ~4Z

MOSS: document-library file upload limitation

Hi,

When we created shared folder for our business users, I had a doubt about the file upload limitations which might occur when our users upload files. When i googled for the same found that the default size is set to be 50MB (maxRequestLength="51200"). and to increase the limit we just need to configure the xml file in the following location

Solution:
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\web.config

Config file:
<location path="upload.aspx">
<system.web>
<httpRuntime maxRequestLength="2097151" />
</system.web>
</location>

Resource: http://www.synergyonline.com/blog/blog-moss/Lists/Posts/Post.aspx?ID=8

Hope it helps

Regards
Fauzi ~4Z

SQL: comparision of SQL Server Databases 2005

hi,

Here is the comparisons of different types of SQL Server 2005 databases in terms of Scalability and Performance, High Availability, Manageability, Security, Programmability, Integration and Interoperability,Business Intelligence

Resource : http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

Hope it helps

Regards
4Z ~ Fauzi

MOSS: Email Notifications and Alerts problem in Tasks

Hi...

We had a mysterious problem in MOSS sharepoint portal in Tasks.
Following were the issues:
1. When ever a task is created; the alerts goes to people(some one in AD) for whom the tasks has not been assigned!
2. When ever edited also the same issue Plus the description will be striked & shown as such it has been changed.
3. When the tasks is deleted; the alert goes to the respective persons in the assigned to field and also to some other person in random!



Solution:
Seems it is resolved in SP2 and there is also a Hotfix for the same issue.

Resource: http://social.msdn.microsoft.com/Forums/en-US/sharepointgeneral/thread/398f0a1d-621b-4813-a64a-4065d35c0842

Hotfixes:
http://support.microsoft.com/kb/948945

http://support.microsoft.com/kb/948947

Hope it helps...

This is My 100th post, Thanks for your continuous support :)

Regards
Fauzi

MOSS: How to disable checkin option in document Library

Hey...

We had a requirement to disable checkin functionality in document library. The Idea was to reduce the steps to be done by the end user to upload documents easily. The bottom line was to make it simple for easy accessibility. Following are the steps to be done.

To enable/disable check-in and check-out on a SharePoint document library:

1. Navigate to the SharePoint document library on which you want to enable check-in and check-out.
2. On the Settings menu, click Document Library Settings .
3. On the Customize page under General Settings , click Versioning settings .
4. On the Document Library Versioning Settings page, select Yes /No for Require documents to be checked out before they can be edited? , and click OK .

To enable version control on a SharePoint document library:

1. Navigate to the SharePoint document library on which you want to enable version control.
2. On the Settings menu, click Document Library Settings .
3. On the Customize page under General Settings , click Versioning settings .
4. On the Document Library Versioning Settings page, select Create major versions if you only want to enable major versions on documents or select Create major and minor (draft) versions if you want both major and minor versions on documents, and click OK .
   

Reference

Hope It helps...

Fauzi 4z

How to run a DTSX Programmatically through C#

Hey there...

For a data integration service, I create four DTSX packages. These were generic packages which needs to be executed one after the another. I tried using SQL Server Agent to schedule it as a JOB which has four steps to be executed sequentially. Unfortunately the package which is working fine is visual studio is not working when scheduled. There seems to be some permission issues(had the same issue few days before). As i had users waiting the see the output. I have to find an alternative solution soon. Here is the C# code to run the DTSX from a EXEC file.

Code:

Package pkg;

Application app;

DTSExecResult pkgResults;

Variables varStore;

pkgLocation = @"c:\documents and settings\Path\Filename.dtsx";

app = new Application();

pkg = app.LoadPackage(pkgLocation, null);

varStore = pkg.Variables;

varStore[YourVariable].Value = 123;

pkgResults = pkg.Execute();

Required NameSpace: The reference of Microsoft.SQLServer.ManagedDTS.dll has to be added and in code -

using Microsoft.SqlServer.Dts.Runtime;

Hope it helps :)