Make IT Complete

Technical Ramblings From an IT Professional

Entries for September, 2008

Map sharepoint document folder to a network drive

I want to expose Sharepoint content through mapped network drives. for example, I have my sharepoint document library:
http://Server/sites/mysite/Shared%20Documents/
then I mapped the \\Server\sites\mysite\Shared Documents\ as a network drive, it works fine in my Windows XP box. but it didn’t work in my Windows 2003 Server box, what seems to be the problem?
Second, if my Sharepoint server [...]

Remote Restart of XP using Remote Desktop

If you’ve ever used the Remote Desktop Protocol to login to a remote Windows computer, you’ve probably noticed that the Start, Shutdown options you’re used to seeing on a local Windows session aren’t there. Instead, you’ll typically see an option to “disconnect,” in effect saving your session for the next time you login, or to [...]

Email Templates in OSTicket

I have a number of clients that use OSTicket to provide a customer facing web enabled frontend to their clients.  The email templates can be customized using replaceable parameters.  I have included the list of replacable parameters below.
%ticket = The ticket ID
%name = Name on ticket
%companyname = Company name on ticket (one of our customizations)
%email [...]

Database Maintenance Plans and Backup Exec

Assuming you have the SQL Agent installed on your media server then yes Backup Exec will / can backup your live SQL databases.
From a DR point of view you don’t need the Maintenance Plan jobs, however if you have the storage capacity available I personally would recommend keeping them, simply due to the ease in [...]

Shrinking SABA Log files

We have SABA for our learning management system and from time to time the log files get out of control.
This script will shrink them
USE Saba_prod_tp2;
GO
– Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE Saba_prod_tp2
SET RECOVERY SIMPLE;
GO
– Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (tp2_Log, 10);
GO
– Reset the database recovery [...]

Shrinking a database log file

Sometime, it looks impossible to shrink the Trucated Log file. Following code always shrinks the Trucated Log File to minimum size possible.
This script should allow you to shrink a DB log file.
USE DatabaseName
GO
            DBCC SHRINKFILE(<TransactionLogName>, 1)
    BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
            DBCC SHRINKFILE(<TransactionLogName>, 1)

Can not open Activity Monitor on MSSQL2005

I have been unable to open the Activity Monitor on MSSQL 2005.  I get a message that I do not have privialges or the connection has timed out.  The later is the case as I am an admin on the server.

SharePoint 2007 Performance over 2003

I am in the middle of deployment of SharePoint 2007 and the perfromance sucks.  [more on this later]

Buttons not firing in ASP.NET page

This was fun.  I have a page with 2 buttons on it.  These buttons started to not fire when clicked.  On the page there is a user control.  This user control contained a form that had validation added to it but the validation was on a ajax panel that would popup for a user to enter [...]

Shrinking tempdb

From time to time we find that the tempdb database grows to a very large size.  This database should maintain itsself but of course things that should don’t.
Here is the method that I use to shrinl the tempdb when it has grown out of control.
dbcc shrinkdatabase (tempdb, 10)
I often find that I need to run [...]