Fuzzylogic

jQuery Validation Plugin: Remote Validation With AJAX (3/4)

noreply@blogger.com (Cameron Townshend) — Sat, 14 Nov 2015 08:34:00 +0000

Using PowerShell-FTP-Client to download and delete files from an FTP server

noreply@blogger.com (Cameron Townshend) — Tue, 10 Nov 2015 13:11:00 +0000

Configure PowerShell - out the scope of this blog entry, but here with Microsoft
Download and install the PowerShell FTP Client Module by Michal Gajda.
Use the code below which logs on to the FTP server and then gets a list of files
Downloads each file in the list
Deletes the file after download

$FtpServer = "ftp.server.com"
$User = "username"
$PWD = "cleverpassword"
$Password =  ConvertTo-SecureString $Pwd -AsPlainText -Force
$FtpCredentials = New-Object System.Management.Automation.PSCredential ($User, $Password)
Set-FTPConnection -Credentials $FtpCredentials -Server $FtpServer -Session MyFtpSession -UsePassive 
$FtpSession = Get-FTPConnection -Session MyFtpSession
$ServerPath = "/backups/test/"
$LocalPath  = "C:\Data\test\"
$fileList   = Get-FTPChildItem -Session $FtpSession -Path $ServerPath -Filter *.txt
foreach ($element in $fileList ) {
 $filename = $ServerPath  + $element.name
 Get-FTPItem    -Path $filename -Session $FtpSession -LocalPath $LocalPath -Overwrite $true
    Remove-FTPItem -Path $filename -Session $FtpSession 
}

How to allow a user to run a SQL Server Agent Job from a client application.

noreply@blogger.com (Cameron Townshend) — Tue, 10 Nov 2015 06:09:00 +0000

I wanted to allow users to run a SQL Server agent Job from a client application. Short Answer CALL msdb.[dbo].[sp_start_job] I had a number of errors but the fix was to 1) Add their login as a user to the msdb database 2) Put the user into group: SQLAgentOperatorRole
Long answer I had a stored procedure like below

CREATE PROCEDURE [dbo].[startJob] @JobName nvarchar(255) as
BEGIN
 declare @retval int
 EXEC @retval = msdb..sp_start_job @JobName
 return @retval 
END

And runs OK for me but didnt work for a user. Problem 1 "the execute permission was denied on the object 'sp_start_job' database 'msdb'" To check this permission run this query

SELECT PR.NAME, DP.PERMISSION_NAME, DP.STATE_DESC
FROM MSDB.SYS.DATABASE_PERMISSIONS DP
JOIN MSDB.SYS.OBJECTS O ON DP.MAJOR_ID = O.OBJECT_ID
JOIN MSDB.SYS.DATABASE_PRINCIPALS PR
ON DP.GRANTEE_PRINCIPAL_ID = PR.PRINCIPAL_ID
WHERE O.NAME = 'SP_START_JOB'

Results
NAME                 PERMISSION_NAME STATE_DESC
TargetServersRole EXECUTE         DENY
SQLAgentUserRole EXECUTE         GRANT

USE [msdb]
GO
CREATE USER [domain\securitygroup] FOR LOGIN [domain\securitygroup]
GO
EXEC sp_addrolemember N'SQLAgentUserRole', N'domain\securitygroup'
GO

Then I got

Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 61
The specified @job_name ('My Job X') does not exist.

This is because the user did not have permission to run someone else's job. They need to be made a member of the SQLAgentOperatorRole to do that.


EXEC sp_addrolemember N'SQLAgentOperatorRole', N'domain\securitygroup'
GO

References:

Amazing video

noreply@blogger.com (Cameron Townshend) — Mon, 15 Apr 2013 11:39:00 +0000

This is an live action short video from Russia (I believe). It's in the style of a first person shooter game.

How to stop Excel from automatically splitting a CSV

noreply@blogger.com (Cameron Townshend) — Tue, 05 Feb 2013 04:07:00 +0000

One of the annoying features added to Excel is that when you open a file with csv extension it automatically parses the file on the "," and butchers your file. This is annoying if the file uses another character to split or contains German numbers which use a comma for the decimal etc. So how do you fix this? 1) Open Excel (dont double click on the CSV) 2) Go to "Data" -> "Get External Data from Text" 3) Select the CSV file 4) Click "Import" 5) Go through the wizard and specify the delimiter and that all fields are text not numebrs etc 6) You are done.

Learning Silverlight

noreply@blogger.com (Cameron Townshend) — Thu, 22 Nov 2012 19:12:00 +0000

I recently had to take over a Silverlight application and had to remind myself how it hangs together. Here are some good blogs on the topic

How to blog Code

noreply@blogger.com (Cameron Townshend) — Thu, 22 Nov 2012 19:08:00 +0000

Here is a great blog on how to post code snippets.

http://www.craftyfella.com/2010/01/syntax-highlighting-with-blogger-engine.html
Copy and paste source into http://www.opinionatedgeek.com/dotnet/tools/htmlencode/encode.aspx
encode the source then copy from above step and paste into blog
Then wrap in tags

I was recommended a good Yum Cha in Sydney

noreply@blogger.com (Cameron Townshend) — Thu, 22 Nov 2012 19:06:00 +0000

Mr Chao Seafood Restaurant TEL:0295808003 Address:127-137 Forest Road Hurstville Nsw 2220, Hurstville, NSW, 2220

POS Hacked

noreply@blogger.com (Cameron Townshend) — Thu, 22 Nov 2012 19:03:00 +0000

I recently heard about a Point of Sale (POS) system that was hacked. The owner of the restaurant had to compensate the victims of credit card fraud. http://www.wired.com/threatlevel/2009/11/pos/

SSRS reports in new window

noreply@blogger.com (Cameron Townshend) — Thu, 22 Nov 2012 18:59:00 +0000

I recently received this request

On Thu, Nov 15, 2012 at 2:26 PM, Ajay wrote: Standard SSRS web interface, where displays the various reports. (from the page, where each reports have a menu which has options for Move, Delete, Subscribe etc.) When the link is clicked it navigates to the report Can this link be configured so that when clicked, it opens the report in a new window. We are using this SSRS page as Iframe in existing web page, and by default on clicking it opens in the iframe and is hard to read the report. Thanks Ajay

Heres the answer. If you are brave. Open Folder.aspx in MSSQLServerSSRSRootFolder\Reporting Services\ReportManager\Pages\Folder.aspx and add the following JQuery to the top of the file

<script type="text/javascript" src=//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script language = "Javascript">
$(function(){
    $('a').click(function() {
        $(this).attr('target', '_blank');
    });
});
</script>

How this works is that the Folder.aspx page contains the HTML that each report will be listed in when displaying the default SSRS folder window. The JQuery will add code to the click event on each hyperlink "a"nchor tag. The JQuery is telling the browser to open in a new window. Cameron __________________

Cannot Restart SQL Services

noreply@blogger.com (Cameron Townshend) — Thu, 22 Nov 2012 18:52:00 +0000

I recently received this request to restart the SQL Server Services Hi All I've a Local copy of SQL Server installed on my Computer ( SQL Server 2008 R2), it was all working fine up until below situation. I used local SSMS to connect to remote SQL server(SQL Server 2008 ) and performed some queries and closed the session. Then when I tried to connect to my Local SQL server using local SSMS, it pops up a message saying " Cannot Connect to localhost" A network specific or instance specific error occurred while establishing a connection to SQl Server. I observed under "SQL Server Configuration Manager" all services are stopped !! When I tried to re-start them it comes up with another error as " The request failed or service did not respond in a timely fashion. Consult the event log or other applicable error logs for details" Here's the answer Can you send the event log information? Have you tried a complete reboot? other issues to look at are login account username/pwd problem. I have also seen networking problems where the network trace route to the local host is not working. This could be a networking problem e.g. you have logged in to a vpn client or similar and it is still connected etc. Hi, Thanks, it looks like Logon issue, since my password has been changed after SQL server was installed on this machine, ??I Event Log says: "The SQL Server Analysis Services (MSSQLSERVER) service failed to start due to the following error: The service did not start due to a logon failure." Just like it says on the box. The answer is the event log. You just need to remember/know where to know.

ApplicationPoolIdentity in IIS 7.5

noreply@blogger.com (Cameron Townshend) — Thu, 22 Nov 2012 18:48:00 +0000

I found this fantastic article on ApplicationPoolIdentity in IIS 7.5 http://www.iis.net/learn/manage/configuring-security/application-pool-identities Very Good article on how the IIS7.5 service creates Virtual Accounts and Secures them

SQL Query to Calculate Surrender Amounts

noreply@blogger.com (Cameron Townshend) — Thu, 22 Nov 2012 18:46:00 +0000

I recently received a request to handle closing out repayment data in a SQL query as per below. (Answer at the end.) Hi All, I am working on a stored procedure which use to update a Table, I have come across a business request, which I need some assistance of developing suitable logic: Appreciate if someone can provide some advice on how to handle below situation in SQL please. My main question on this regard is how to distribute 'Surrender' ( Return Amount ) as per below Logic???? I have two tables,“Master Table” and “Detail_Table”, a stored Proc been used to populate “Detail_Table” based on records in“Master Table” Pseudo Code explanation: Read a record by record from “Master Table” and update "Detail Table" If ‘Transaction Type’ = ‘New’ then Put “Monthly_Net_premium” as Annual_premium/12 into “Detail_Table” NEXT #### My concern is how to handle 'Surrender' ## ### If ‘Transaction Type = “Surrender” then Update “Detail_Table” as below logic ( Which I have no idea how to do ))) Reverse Monthly values received from the policy, reversing from last premium received until it reaches Return Amount. (e.g. 52 + 52 + 52 + 44 as Return amount = 200) Master Table record containing Fin_id =216, is the record for 'Surrender', which has Annual Premium value(624) as well , and we know it distributed (i.e. Annual_premium/12 ) ** What is the methodology to use to apportion Return amount , compensating what had received until it reached return amount?? e.g. of processing first two records in "Master Table" shown in Tables Master Table Fin_id Policy_id Transaction Type Annual Premium Return Amount Start Date End Date 215 4402 New 624 - 1/Apr/2009 31/Mar/2010 216 4402 Surrender 624 (200) 1/Apr/2009 31/Mar/2010 Detail_Table Fin_Id Policy_ID Effective_Date Monthly_Net_Premium 215 4402 April-2009 52 215 4402 May-2009 52 215 4402 June-2009 52 215 4402 July-2009 52 215 4402 August-2009 52 215 4402 September-2009 52 215 4402 October-2009 52 215 4402 November-2009 52 215 4402 December-2009 52 215 4402 January-2010 52 215 4402 February-2010 52 215 4402 March-2010 52 216 4402 December -2009 (44) 216 4402 January-2010 (52) 216 4402 February-2010 (52) 216 4402 March-2010 (52) Part of stored procedure: USE [Mira_Test] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[UpdateDetail] AS BEGIN SET NOCOUNT ON; WITH c_Daily AS ( SELECT fin_id , policy_id , transaction_type , Return_Amount , Start_Date , End_Date , direct_debit_details_id , Surrender_Date , CASE WHEN transaction_type IN ( 'Surrender' ) THEN 0 -- I need Help Here ################# ELSE (Annual_premium) / 12 END AS monthly_net_premium FROM dbo.masterTable ) -- Now generate a row for each transaction day INSERT dbo.DetailTable ( FinID , Policy_id , Effective_Date , monthly_net_premium --- some joins etc... END; RETURN 0; Heres the answer Mira Here is some SQL that may help. I have put in an update statement for a single pass and also a slect statement, so you can test it. Basically, it works out the number of whole months that you need to take the premium out of the return amount then it works out the balance. It does it in reverse order based on the business rule. Update Detail_Table Set Monthly_Net_Premium = CASE WHEN transaction_type IN ( 'Surrender' ) THEN (case When DATEDIFF(month, Effective_Date, End_date) = (floor(-1*Return_amount / (Annual_Premium/12) )) then (-1*Return_amount - ((floor(-1*Return_amount / (Annual_premium/12))) * Annual_premium/12)) else ((Annual_premium) / 12) end) ELSE (Annual_premium) / 12 end from Detail_Table inner join Master_Table on Detail_Table.Policy_id = Master_Table.Policy_id and Detail_Table.Fin_id = Master_Table.Fin_id Select Detail_Table.Policy_id, Detail_Table.fin_id, Monthly_Net_Premium, transaction_type, DATEDIFF(month, Effective_Date, End_date), (floor(-1*Return_amount / (Annual_Premium/12))), DATEADD(month, -1*(floor(-1*Return_amount / (Annual_Premium/12) ))-1, End_date), Effective_Date, (-1*Return_amount - ((floor(-1*Return_amount / (Annual_premium/12))) * Annual_premium/12)), ((Annual_premium) / 12) from Detail_Table inner join Master_Table on Detail_Table.Policy_id = Master_Table.Policy_id and Detail_Table.Fin_id = Master_Table.Fin_id Regards Cameron

SQL basics to Expert

noreply@blogger.com (Cameron Townshend) — Thu, 22 Nov 2012 18:41:00 +0000

Depends on whether you want to be excellent at TSQL dev or SQL Server management. Assuming dev track first then. The progression I have below should take you from zero to hero pretty quick. Once you have done all of this material you will be a 1%er. Will take you about 1-2years to do everything suggested here. Do the books that lead to 70-433 certification. I did the dev track recently 70-433 and learnt alot about TSQL especially the new additions. The Self Paced Training kits from MS are excellent starting points MCTS Self-Paced Training Kit (Exam 70-433): Microsoft® SQL Server® 2008 Database Development - http://www.amazon.com/MCTS-Self-Paced-Training-Exam-70-433/dp/0735626391 Then there is the excellent SQL Server Internals to understand whats happening under the covers. Microsoft® SQL Server® 2008 Internals (Pro - Developer) - http://www.amazon.com/Microsoft%C2%AE-SQL-Server%C2%AE-2008-Internals/ Improving .NET Application Performance and Scalability - http://msdn.microsoft.com/en-us/library/ff649152.aspx especially Chapter 14 — Improving SQL Server Performance - http://msdn.microsoft.com/en-us/library/ff647793.aspx The book that really mad a difference for me a long time ago was this one. Not available anymore but superb - Microsoft SQL Server 2000 Performance Tuning Technical Reference - http://www.amazon.com/Microsoft-Server-Performance-Technical-Reference/dp/0735612706/ Read Paul Randells blog - phenomenal - http://sqlskills.com/blogs/paul/ Also get yourself a subscription to PluralSight, excellent material presented by good people. Well, there are various tutorials via MS (and a host of other places), there are quite a few samples in the online help as well… This page is archived but still has a list of pretty good links : http://archive.msdn.microsoft.com/SQLTutorials There is also a wide range of tutorials : http://msdn.microsoft.com/en-us/library/ms167593(v=sql.105).aspx (for example look at lesson 1 : http://msdn.microsoft.com/en-us/library/ms365325(v=sql.105).aspx ) If specifically with ASP.NET then there are some good tutorials and sample apps over at : http://www.asp.net/mvc

SSRS Automatically View Report after selecting drop down parameter value

noreply@blogger.com (Cameron Townshend) — Mon, 12 Nov 2012 06:11:00 +0000

In SQL Server Reporting Services (SSRS), I had a client who wanted to automatically rerun their report after selecting a value in a drop down without having to click on the "View Report" button. This can be done using JQuery and below is how it is done. 1.) Go to the "Report.aspx" page in the ReportManager directory. On My machine it is here. C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\Pages\Report.aspx" 2) At the top of the file after the "Page" directive in asp.net add the following script.

<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7/jquery.min.js"></script>
<script language = "Javascript">

 $(function(){
 $('body').on('change', 'select', function () {
 $('input[value="View Report"]').click();
 });
});
</script>

3) Now every time you click on the value in the drop box it will automatically postback and refresh the form with your selected parameter.

Postscript
After various feedback, people have asked for how to make the report refresh only on a particular control. This can be done with jQuery. Naturally with jQuery there are lots of ways of achieving this, so I have opted for the simplest. The short answer is here is the code below.

<%@ Register TagPrefix="MSRS" Namespace="Microsoft.ReportingServices.UI" Assembly="ReportingServicesWebUserInterface" %>

<%@ Page Language="c#" CodeBehind="Report.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.ReportWrapperPage" EnableEventValidation="false" %>

<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7/jquery.min.js"></script>
<script type="text/javascript">
    $(function () {
        $('body').on('change', 'select', function () {
            var currentControl = this
            //Need to add checks here that we have selected values etc.
            var allBoxes = $('select');
            var fire = true
            allBoxes.each(function () {
                if (this.value == "0") {
                    fire = false;
                }
            });
            if (fire == true) {
                var relevantControlPrompt = 'Asset Type';
                var relaventspanText = $('label[for="' + currentControl.id + '"]').children("span").html();
                if (relaventspanText == relevantControlPrompt) {
                    fire = true;
                } else {
                    fire = false;
                }
            }
            if (fire == true) {
                $('input[value="View Report"]').click();
            }
        });
    });
</script>

How does it work? It relies on the way that SSRS renders the report page. SSRS programmatically generates the controls on the form. We don't know the name/id of the controls before we start looking at the HTML that is generated. However Microsoft kindly took advantage of the HTML "for" attribute which links form prompt labels with their relevant input control. So in jQuery I can take advantage of this.
SSRS a) Creates a list of controls with prompts stored in labels. b) the labels are flagged with "for" with a pointer to the relevant select drop down list box. c) using jQuery we can now find out if the current Select is the one that we want to watch. In the example below, we have chosen to look at the "Asset Type" drop down. ...snippet from outputted html by SSRS

<label for="ctl32_ctl04_ctl06_ddValue"><span>Asset Type</span></label>

the relevant select looks like this

<select name="ctl32$ctl04$ctl06$ddValue" id="ctl32_ctl04_ctl06_ddValue" style="width: 182px;">

So the label has a "for" attribute "ctl32_ctl04_ctl06_ddValue" which points to the id of the relevant select. The code will run for every select on the form but will only refresh the report for the chosen select. The selector uses the jquery syntax to search for a label with the for attribute = to my control id. I then get the child span and then get its html. This should then say "Asset Type" or whatever is the relevant select for your requirement.

var relaventspanText = $('label[for="' + currentControl.id + '"]').children("span").html();

Note: The javascript also includes logic to suppress refreshing until all values have been selected, if that is required.

Quick Code Generator

noreply@blogger.com (Cameron Townshend) — Sat, 13 Oct 2012 11:32:00 +0000

Sometimes you want to generate a quick bit of code and dont want to use a massive code generator. Well what if you could just get a list of values and apply a template to them quickly and generate the resulting code. The answer is http://nimbletext.com/live

I need to insert a few values from Excel into a SQL Database. The template looks like below Insert ADX.tbl_PROD_ADVERTISER_Mapping( ADVERTISER_ID, ADVERTISER_NAME_SB, REVENUE_STREAM, ADVERTISER_NAME_ADX) Values ($0, '$1', '$2', '$3') go To split on tabs (defualt when copying from Excel) use \t as the column separator.

Hadoop - What is it and Why do I care? Or how to explain Hadoop to a girl in the pub.

noreply@blogger.com (Cameron Townshend) — Fri, 13 Jul 2012 07:45:00 +0000

Pretty Girl: What Do You do. Cameron: I work with Large computer integration problems. I'm currently looking at Hadoop. PG: Whats that? Cameron: Hadoop is the Open Source version of the Google Map/Reduce algorithm. Pretty Girl: My brain hurts. Cameron: Well imagine if you had to download the internet every night and index it and make it searchable. That would be pretty hard to do right? Girl: Well I guess. Why do I want to do that? Cameron: Well that’s how Google makes the Internet searchable every time you want to find something like Britney Spear’s New Song or where to find those really cool Black Milk Stockings.

Google do the indexing for you beforehand so you get your answers back really quick. Don’t you reckon that’s cool? Pretty Girl: Well yeh, I wonder how they do that? Cameron: Good question. Well Google could write a check with lots of zeros on it and give it to Oracle, but Oracle could never make a database big enough and fast enough to solve this problem. So what Google did is they decided to solve the problem in a different way. They split the job up into hundreds and thousands of little jobs. Send a piece of the problem to all of these little cheap computer boxes. Wait for them to work out their little piece of the problem. Once they had done their bit they would send it back to the answer box and it would collate all of their bits of the data and give you the answer.

Pretty Girl: That’s clever. Cameron: Yeh, really clever, and really simple (in hindsight). The first bit is called “Map” where they send the data off to the little boxes. The second bit is called “reduce” where they bring the answer back and give it to you. This is what they call Map/Reduce. Pretty girl: Oh. Cameron: And now Google has made this clever trick available to all of us. And that is called Hadoop.

We can use it to solve problems that we couldn’t solve before. Pretty Girl: Like what? Cameron: Well for example the Beijing Genomic Institute is mapping the DNA of millions of people.

They are developing “personal medicine” which will target the DNA of an individual person and the medicine will work just for them. Currently cancer medicine is called cytotoxic and this means it kills cells – cancer cells and healthy cells. Yucky stuff. With Personal medicine they wont have to do that. . Or what about seeing what people are saying about your brand on twitter (remember Qantas twitter fail.

), Facebook, and linked-in. Or detecting credit card fraud, or … This is only possible with the massive computing power available in the cloud. This is called Big Data. We are seeing the impossible become possible. This is why we should all be aware of what Hadoop, Big Data and Cloud are all about. Pretty girl: What’s the cloud? Cameron: That’s a talk for another day.

MGET with delete for FTP

noreply@blogger.com (Cameron Townshend) — Mon, 28 Feb 2011 09:13:00 +0000

A common problem for FTP users is how to download all the available files from an FTP server and delete them once they are downloaded. You can not simply perform mget *.* followed by mdelete *.* because there may be new files arrived onto the FTP server since your started and you will delete them before they are downloaded.
i.e. bad - potentially deletes files that we havent retrieved yet.
mget *.*
mdelete *.*

There are a number of approaches to solving this problem for example WINSCP grabs a file then deletes it one at a time. I wanted to use the inbuilt Microsoft FTP command in a batch to download the files to our local machine then delete the files that have successfully arrived one at a time from the FTP server but not delete files that I have not retrieved that may have arrived since we started work.
This is how it is done.
1) Create a batch file that gets the files that you want using an ftp script and then call two batch files which create a delete script and then call the delete script, which we will do in steps 3 and 4 below

FTP -i -s:C:\TWC\GetFiles_FTP.txt ftp.XXX.XXX
call C:\Data\createDelete.bat
call C:\Data\Del_FTP.bat

2) The GetFiles_FTP.txt looks like this, a simple mget with your particular login details and path details

username
password
cd remotefolder
bin
mget *.* "C:\DATA\FILES\"
bye

3) This is the magic step in createDelete.bat. The trick here is that we generate an ftp script file on the fly by echoing out the ftp login details to a file along with the output of the Forfiles command. This command loops though a path "-p" (note: no trailing back slash on the path) and for a file mask "-m" it performs a command "-c". I am echoing "del filename" into the script file so we get a list of del commands for each file that we have successfully retrieved onto our local machine. This means we wont delete files that we haven't retrieved.

echo username> C:\Data\deleteFiles.txt
echo password>> C:\Data\deleteFiles.txt
echo cd /remotefolder>> C:\Data\deleteFiles.txt
echo bin>> C:\Data\deleteFiles.txt
Forfiles -p "C:\Data\Files" -m *.* -c "cmd /c echo del @file>> C:\Data\deleteFiles.txt"
echo bye>> C:\Data\deleteFiles.txt

This creates a file similar to this
username
password
cd /remotefolder
bin
del "filename1"
del "filename2" etc
bye
4) Final step is to create Del_FTP.bat which simply calls the FTP command with our newly created script file.
cd C:\Data\
FTP -i -s:C:\Data\deleteFiles.txt ftp.xxx.xxx

Now of course this is all a lot easier with PowerShell, if you are so inclined.

Problems Installing SQL Server 2008 RTM

noreply@blogger.com (Cameron Townshend) — Thu, 14 Aug 2008 05:59:00 +0000

I've spent a couple of days trying to install SQL Server 2008 RTM. I received the following error message.

TITLE: Microsoft SQL Server 2008 Setup
------------------------------
The following error has occurred:
The process does not possess the 'SeSecurityPrivilege' privilege which is required for this operation.
Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0xE32A4906%25400xB49B3A64

------------------------------
BUTTONS:
&Retry
Cancel
------------------------------

When you go to the Microsoft link provided there is a very unhelpful error message.

Details
ID:
50000
Source:
setup.rll
We're sorry

There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.

Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.

----------------------

Well anyway after a bit of searching it appears that the 'SeSecurityPrivilege' is linked to the local security policy - "Manage auditing and security log". You can access this by going to Control Panel\Administrative Tools\Local Security Policy. Then link to Local Policies\User Rights Assignment\Manage auditing and security log\

When you open that screen, you will see that your current account is not authorised to Manage auditing and security logs, this will cause the SQL Server 2008 install to fail. To rectify this, you will have to add your user or group to this list.

Notice however that the "Add user or group" is disabled on my machine. This is because my PC is a member of a domain and this setting is set by the Domain administrator and not configurable by an end-user. This is despite my account actually being both a local and domain admin. You will have to get your domain administrator to add a group that you belong to into this role in the domain. After rebooting your machine to pick up the new privileges from the domain controller you will be able to install SQL Server 2008 successfully.

format string in MSAccess

noreply@blogger.com (Cameron Townshend) — Fri, 18 Jul 2008 06:12:00 +0000

I recently trained some users in how to use the Format function in Microsoft Access. They wanted a definitive list of what the format strings could be. So it's probably not possible to document every single combination, however the new Microsoft Access 2007 online help does document a large number of really useful types. Go to Microsoft Office help Online

http://office.microsoft.com/client/helppreview.aspx?AssetID=HV012026591033&ns=MSACCESS.DEV&lcid=3081&QueryID=gRnDnXje30&respos=1

Here is an excerpt.

Returns a Variant (String) containing an expression formatted according to instructions contained in a format expression.

Syntax

Format(expression[, format[, firstdayofweek[, firstweekofyear]]])

The Format function syntax has these parts:

q
Display the quarter of the year as a number (1 – 4).