Indon Chung

Transforming Invalid Data Formats in SQL Server 2000 DTS Using ActiveX Script N41 by Nouvolution

Parsing a URL with SQL Server Functions N41 by Nouvolution

T-SQL Best Practices – Don’t Use Scalar Value Functions in Column List or WHERE Clauses — DatabaseJournal.com N41 by Nouvolution

SQL Server Reporting Services Configuration Tool N41 by Nouvolution

PowerBuilder Q & A N41 by Nouvolution

Backup SQL Server Databases with a Windows PowerShell Script - PF N41 by Nouvolution

Download details: Microsoft SQL Server 2008 Express with Tools N41 by Nouvolution

Download details: Microsoft SQL Server 2008 Management Studio Express N41 by Nouvolution

Download details: XML Notepad 2007 N41 by Nouvolution

SQL Server Date function that determines date range based on weekday - PF N41 by Nouvolution

SQL Server Unique Constraints for Large Text Columns - PF N41 by Nouvolution

GS1 US BarCodes and eCom - The Global Language of Business N41 by Nouvolution

Streamlining SQL Server Documentation - PF N41 by Nouvolution

Index Usage Report in SQL Server - PF N41 by Nouvolution

Configuring SQL Agent Jobs to Write to Windows Event Log - PF N41 by Nouvolution

SQL Server 2005 tablediff command line utility - PF N41 by Nouvolution

SQL Server Configuration - The Basics N41 by Nouvolution

Process Explorer N41 by Nouvolution

You cannot delete a file or a folder on an NTFS file system volume N41 by Nouvolution

Configuring SQL Agent Jobs to Write to Windows Event Log - PF N41 by Nouvolution

T-SQL Debugger is back in SQL Server 2008 ... debugging now made easy - PF N41 by Nouvolution

Simply Run the script in current database. DECLARE @p_SPID int, @p_SQL nvarchar(2000),@dbName nvarchar(100) SET @dbName = DB_NAME() DECLARE #cur_Processes CURSOR FOR     SELECT p.SPID FROM master.dbo.sysprocesses AS p JOIN master.dbo.sysdatabases AS d ON( d.dbid = p.dbid )     WHERE d.Name = @dbName AND p.SPID > 50     -- AND spid >= 51 (because spids of 50 or less are reserved for internal use.) OPEN #cur_Processes FETCH NEXT FROM #cur_Processes INTO @p_SPID WHILE @@FETCH_STATUS = 0 BEGIN     SET @p_SQL = 'KILL ' + CONVERT( nvarchar(30), @p_SPID )         PRINT @p_SQL         EXECUTE( @p_SQL )     FETCH NEXT FROM #cur_Processes INTO @p_SPID END CLOSE #cur_Processes DEALLOCATE #cur_Processes

Script to determine SQL Server Reporting Services parameters, path and default values - PF

Introduction to SQL Server 2008 Report Builder 2.0 - PF

Microsoft Access Pass-Through Queries to SQL Server - PF

Managing SQL Server Database Fragmentation - PF

Using the Built-In Time Dimension and Time Intelligence in SQL Server Analysis - PF

SQL Server Monitoring Scripts with the DMVs - PF

Exchange - DNS, Reverse DNS and MX Records | Amset.info

Microsoft Exchange Server 2007 - create mailbox

Index Usage Report in SQL Server - PF

Rounding Functions in SQL Server - PF

Solid State Disk Drive Considerations for SQL Server - PF

How to identify when a database was restored, the source of the backup and the date of the backup - PF

How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server - SQLServerCentral

How to Backup and Restore a SQL Server FILESTREAM Enabled Database - PF

Poor Man's Enterprise Feature - Lock Pages in Memory

Export data from SQL Server to Excel - PF

Getting your IP whitelisted with Yahoo (solving the deferred 451 problem) - Forums & Blog

Date/Time Conversions Using SQL Server - PF

How to identify when a database was restored, the source of the backup and the date of the backup - PF

How to identify when a database was restored, the source of the backup and the date of the backup - PF

Whitelisting MS Outlook

Introduction There are number of BOOT.INI switches that are useful for driver developers that wish to test their drivers under a variety of different system configurations without having to have a separate machine for every one. For example, limiting the amount of memory NT sees can be useful for stressing memory loads, and limiting the number of processors for testing scalability. I've compiled a complete list of the options that BOOT.INI currently supports. This list is reproduced in the Startup, Shutdown and Crashes chapter of Windows Internals, where you'll find more information about the boot process. Note: to see what options a system has booted with examine HKLM\System\CurrentControlSet\ Control\SystemStartOptions. /3GB Increases the size of the user process address space from 2 GB to 3 GB (and therefore reduces the size of system space from 2 GB to 1 GB). Giving virtual-memory- intensive applications such as database servers a larger address space can improve their perf...

Open DBDiff for SQL Server 2008 — DatabaseJournal.com N41 by Nouvolution

indonchung - Nouvolution Newsletter N41 by Nouvolution

Unable to reconcile accounts or to create, print, or email PDF files N41 by Nouvolution

Question: Hello, When I try to send e-mail in Microsoft Outlook I get an error message from Symantec Email Proxy: "Your email message to (e-mail address) with the subject of ( subject of email) was unable to be sent because the connection to your mail server was interrupted. Please open your email client and re-send the message from Sent messages folder." Thanks.     Solution : Hi, I got this from the Symantec site Unfortunately no link on that page. So pasting the lot. Your email message to with the subject was unable to be sent . . ." (1003,9) Situation: This page tells you what to do when you see the message "Your email message to with the subject was unable to be sent because the connection to your mail server was interrupted. Please open your email client and re-send the message from the Sent Messages folder." (1003,9). Solution: When do you see this message? I only see the message when I send email I only...

Rebuilding the SQL Server master database - Part 2 N41 by Nouvolution

Creating a SQL Server 2008 FILESTREAM Enabled Database and Using INSERT, UPDATE and DELETE statements to manage FILESTREAM Data - PF N41 by Nouvolution

Rounding Functions in SQL Server - PF N41 by Nouvolution

SQL Server Service Broker example on how to configure, send and receive messages - PF N41 by Nouvolution

How To Configure SQL Server Reporting Services 2005 to Run in SharePoint Integrated Mode - PF Problem We have heard about running SQL Server Reporting Services in SharePoint Integrated Mode but are not really sure how to go about configuring this. Can you provide the details on what capabilities this provides as well as how to do it? Solution Probably the biggest benefit of running Reporting Services in SharePoint Integrated Mode is that you can deploy and manage reports directly in SharePoint rather than the Report Manager web application. This is probably easier for our business users. As a matter of fact you no longer use the Report Manager after you switch to SharePoint Integrated Mode. The highlights of the capabilities provided by SharePoint Integrated Mode are the following: A Report Viewer Web Part that provides report viewing capability, export to other rendering formats, page navigation, search, print and zoom. Web application pages so that you can create subscriptions and sc...

Script to check SQL Server connection pooling N41 by Nouvolution

ntwdblib.dll download N41 by Nouvolution

Troubleshooting Slow SQL Server Replication issue due to Distributor Database Growth N41 by Nouvolution

Microsoft Access and SQL Server Integration - PF N41 by Nouvolution

Sending email from SQL Server Integration Services (SSIS) N41 by Nouvolution

Disable Triggers in SQL Server 2005 N41 by Nouvolution

How to isolate the current running commands in SQL Server

This is a pretty straightforward error indicating that there was an MX lookup error. What is the rest of the error message (include the specific domain, not a placeholder)? Have you checked the DNS for your domain to make sure all is well? Do a DNSreport here: http://www.dnsstuff.com/ What are you using for a spam filter? Some spam relay services can cause this issue.

Configuring Roaming User Profiles: Group Policy

Easy Access and Storage Part of N41's New Look - Special Reports - Features - Apparelnews.net N41 by Nouvolution

Nouvolution: New Player on the ERP Front - Columns - Features - Apparelnews.net

Roaming user profile - Wikipedia, the free encyclopedia N41 by Nouvolution

Folder redirection - Wikipedia, the free encyclopedia

Find a spare machine and reboot it. Select the "Refresh" option when the Rembo menu comes up. Continue to the next step, making sure nobody else uses that machine while you're working on everything else. If you are logged into *more than one* machine, log out of *all except one* of them; otherwise, log in on a spare machine in the lab (leave the other one refreshing). You must only be logged into one machine for this to work. Double click on "My Computer" and double click on your home drive "H:". Right click on the H: drive window. Select "New", then "Text Document". Change the text "New Text Document.txt" to "REMOVE_MY_PROFILE.txt". - If you are not given an option to do this immediately, right click on the file and select "Rename". It will highlight the filename and you can replace the name with "REMOVE_MY_PROFILE.txt" (sans the quotation marks, of course). Reboot this system via the option ...

What is a profile? A Microsoft Windows User Profile describes the Windows configuration for a specific user, including the user's environment and preference settings. For example, those settings and configuration options specific to the user - such as installed applications, desktop icons, colour options, etc. - are contained in a User Profile. A profile also stores data like your email settings, shortcuts and/or files on your Desktop, files cached by Internet Explorer, custom screen backgrounds that you use, some application settings, drive mappings that you want reconnected every time you log-on, and so forth. What is a roaming profile? A roaming profile is a profile stored on a network share (as opposed to on the local machine) which can thus be accessed from any computer. A user who has a roaming profile can log on to any computer for which that profile is valid and access that profile. Roaming user profiles provide the user with a consistent working environment from machine to...

1. N41 Home Page N41 now introduces exciting new home page with “Favorite menu” and “To Do List”. You can easily add and access your mostly used features and reports from your home page. Simply right-click on the menu and “Add to Favorites” You can assign a task to yourself or another N41 user using “To Do List” with “Due Date” 2. Digital Asset Management You can manage your documents and images on N41. You can upload a file using multiple keywords. When upload a file from a style, customer, PO, or Invoice, N41 will create links between files and the style, customer, PO, or Invoice. You can search and find a documents or image on “N41 Digital Asset Management” menu or access directly from Style Master, Customer Master, Invoice, etc on upper right hand corner of the screen.

Hi, I got this from the Symantec site Unfortunately no link on that page. So pasting the lot. Your email message to with the subject was unable to be sent . . ." (1003,9) Situation: This page tells you what to do when you see the message "Your email message to with the subject was unable to be sent because the connection to your mail server was interrupted. Please open your email client and re-send the message from the Sent Messages folder." (1003,9). Solution: When do you see this message? I only see the message when I send email I only see the message when I send email In this case, the connection between your computer and your Internet service provider was broken before the email was completely sent. It does not mean that there is a problem with your Norton program. If you increase your email program's "Server Timeout value," the connection will stay open longer. The following steps increase the value for Microsoft Outlook Express. If you use a diffe...

This article describes how to use the Inbox Repair Tool for Microsoft Outlook 2000, 2002 or 2003. If you are using Microsoft Outlook 2007, we recommend you to use the Office Diagnostics tools, instead of the Inbox Repair Tool. What is the point? If Microsoft Office Outlook 2000 (or higher) can not open your mailbox folders and it is reporting that your Inbox folders or Outlook PST file may be damaged, then you should use the Inbox Repair Tool supplied by Microsoft. This tinny tool is installed by default when installing Microsoft Office 2000 or higher. What is an Outlook PST file? PST files or Personal Folder Files are used by Microsoft Outlook for storing Outlook data, including mailbox files, email folders, contacts or any other personal data related to Microsoft Outlook. Up to Microsoft Outlook 2002 (XP), PST files are formatted according to the American National Standards Institute (ANSI) format, which limits the file size to 2Gb. Starting with Microsoft Outlook 2003, PST files a...

PowerBuilder Top Feature Picks | SYS-CON INDIA Shared via AddThis

Description Calculates the total number of rows in the specified column. Syntax Count ( column { FOR range { DISTINCT { expres1 {, expres2 {, ... } } } } } ) Argument Description column The column for which you want the number of rows. Column can be the column name or the column number preceded by a pound sign (#). Column can also be an expression that includes a reference to the column. FOR range (optional) The data that will be included in the count. For most presentation styles, values for range are:• ALL - (Default) The count of all rows in column.• GROUP n - The count of rows in column in the specified group. Specify the keyword GROUP followed by the group number: for example, GROUP 1.• PAGE - The count of the rows in column on a page.For Crosstabs, specify CROSSTAB for range:• CROSSTAB - (Crosstabs only) The count of all rows in column in the crosstab.For Graph and OLE objects, specify one of the following:• GRAPH - (Graphs only) The count of values in ...

Description Calculates the average of the values of the column. Syntax Avg ( column { FOR range { DISTINCT { expres1 {, expres2 {, ... } } } } } ) Argument Description column The column for which you want the average of the data values. Column can be the column name or the column number preceded by a pound sign (#). Column can also be an expression that includes a reference to the column. The datatype of column must be numeric. FOR range (optional) The data that will be included in the average. For most presentation styles, values for range are:• ALL - (Default) The average of all values in column.• GROUP n - The average of values in column in the specified group. Specify the keyword GROUP followed by the group number: for example, GROUP 1.• PAGE - The average of the values in column on a page.For Crosstabs, specify CROSSTAB for range:• CROSSTAB - (Crosstabs only) The average of all values in column in the crosstab.For Graph and OLE objects, specify one of the ...

OleObject wsh integer li_rc CONSTANT integer MAXIMIZED = 3 CONSTANT integer MINIMIZED = 2 CONSTANT integer NORMAL = 1 CONSTANT boolean WAIT = TRUE CONSTANT boolean NOWAIT = FALSE wsh = CREATE OleObject li_rc = wsh.ConnectToNewObject( "WScript.Shell" ) li_rc = wsh.Run("Notepad" , NORMAL, WAIT) messagebox("hello", "world") If WAITING, then Run returns any error code returned by the application. In the example only three CONSTANTs are defined. But more options are available : 0 Hides the window and activates another window. 1 Activates and displays a window. If the window is minimized or maximized, the system restores it to its original size and position. An application should specify this flag when displaying the window for the first time. 2 Activates the window and displays it as a minimized window. 3 Activates the window and displays it as a maximized window. 4 Displays a window in its most recent size and position. The active w...

BUTTONFACE = 78682240 WINDOW_BACKGROUND = 1087434968 WINDOW_TEXT = 33554592 APPLICATION_WORKSPACE = 268435456 TRANSPARENT = 553648127 BLACK = RGB(0, 0, 0) WHITE = RGB(255, 255, 255) LIGHT_GRAY = RGB(192, 192, 192) DARK_GRAY = RGB(128, 128, 128) RED = RGB(255, 0, 0) DARK_RED = RGB(128, 0, 0) GREEN = RGB(0, 255, 0) DARK_GREEN = RGB(0, 128, 0) BLUE = RGB(0, 0, 255) DARK_BLUE = RGB(0, 0, 128) MAGENTA = RGB(255, 0, 255) DARK_MAGENTA = RGB(128, 0, 128) CYAN = RGB(0, 255, 255) DARK_CYAN = RGB(0, 128, 128) YELLOW = RGB(255, 255, 0) BROWN = RGB(128, 128, 0) These values are hard-coded, if you need more flexibilty, you can query Windows to dynamically get the current color setting. [External function declaration] FUNCTION unsignedlong GetSysColor(int nIndex) LIBRARY "user32.dll" using the following parameters : COLOR_SCROLLBAR 0 COLOR_BACKGROUND 1 COLOR_ACTIVECAPTION 2 COLOR_INACTIVECAPTION 3 COLOR_MENU 4 COLOR_WINDOW 5 COLOR_WINDOWFRAME 6 COLOR_MENUTEXT 7 COLOR_WINDOWTEXT 8 COLOR_CAPT...

질문1) 로그인을 하면서 mdi 프레임을 사용하여 특정 사용자에 따라서 메뉴를 다르게 하고 싶은데 방법을 부탁합니다. 예) mdi 프레임의 open event 에서 if gr_user_level='master' then this.menuname = 'm_menu_master' elseif gr_user_level='member' then this.menuname = 'm_menu_member' else this.menuname = 'm_menu_null' end if 이런식으로 실행하고 싶습니다 질문2) 파워빌더에서 작성한 텍스트 색상과 appeon web상에서 실행하면 텍스트 색상이 다르게 나타 납니다 예) 색상을 노랑색인데 검정색으로 나타납니다 질문1) ChangeMenu() 함수를 사용하세요. 질문2) PictureButton 텍스트 컬러는 PowerBuilder11 부터 지원가능합니다. 아직 Appeon에는 반영되지 않았기 때문입니다. 이 부분은 어느 버전에서 지원할 계획인지 확인해보겠습니다. 데이타윈도우의 칼럼에 포커스를 놓고 바코드를 스캔하면 스캔한 내용이 보입니다. 이 경우 2~3초후에 자동으로 후프로세스를 실행하고 싶은데 데이타윈도우 컨트롤 이벤트에는 timer이벤트가 없어서 방법을 모르겠습니다. 조언을 바랍니다. 정확하게 하시고 싶은 일이 어떤 일이신지요? 만약, 스캔후, 다른 컬럼을 찍고 또 스캔을 한다면, itemchanged 이벤트 쪽에 작성하시면 될 것이며. Timer 를 사용해서 주기적으로 하고 싶다면, 마찬가지로 Editchanged 쪽에 Timer 함수를 이용해서, 윈도우명을 지정하시고, 해당 윈도우의 Time...