DECLARE @TableName Varchar(50)
DECLARE @ColumnName Varchar(50)
DECLARE @SQL Varchar(500)
DECLARE get_TableName CURSOR FOR
SELECT [TABLE_NAME]
FROM DatabaseName.INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' ORDER BY [TABLE_NAME];
open get_TableName
FETCH NEXT FROM get_TableName INTO @TableName
WHILE @@FETCH_STATUS = 0
Begin
DECLARE get_ColumnName CURSOR FOR
SELECT [COLUMN_NAME]
FROM NPU_INFO.INFORMATION_SCHEMA.COLUMNS
WHERE [TABLE_NAME] = @TableName ORDER BY [COLUMN_NAME];
open get_ColumnName
FETCH NEXT FROM get_ColumnName INTO @ColumnName
WHILE @@FETCH_STATUS = 0
Begin
Print @TableName+'/'+@ColumnName
SET @SQL='What you want to run'
EXEC(@SQL)
FETCH NEXT FROM get_ColumnName INTO @ColumnName
End
CLOSE get_ColumnName
DEALLOCATE get_ColumnName
FETCH NEXT FROM get_TableName INTO @TableName
End
CLOSE get_TableName
DEALLOCATE get_TableName
[ add comment ]
| permalink | related link | ( 3 / 9332 )
TCP/IP stack repair options for use with Windows XP with SP2/SP3.
Start, Run, CMD to open a command prompt:
In the command prompt window that opens, type type the following commands:
Note: Type only the text in bold for the following commands.
Reset TCP/IP stack to installation defaults, type: netsh int ip reset reset.log
Reset WINSOCK entries to installation defaults, type: netsh winsock reset catalog
Reboot the machine.
[ add comment ]
| permalink | related link | ( 3 / 3673 )
I have only tried it on a XP Professional CD, but it should work for the Home and OEM versions of Windows XP from restore disks.
How-To: Find Windows XP Product Key from the Windows XP CD:
1) Insert Windows XP cd into a working computer.
2) Exit the Autorun introduction.
3) Open “My Computer”
4) Right Click on the Windows XP cd-rom drive and select explore.
5) Open the USWXP32P_ZX folder. (It may be as a hidden folder. If you cannot locate the folder, you may also search for unattend.txt and mark “Search Hidden Files”.)
6) Open the sysprep folder.
7) Open unattend.txt
Your CD’s product key is contained within the unattend.txt file.
[ add comment ]
| permalink | related link | ( 3 / 2128 )
The solution is very simple. Find through search in disc C file “AdobeUpdaterPrefs.dat” (c:\Documents and Settings\UserName\Local Settings\Application Data\Adobe\Updater5), click with right mouse button and change Attributes of this file to "Read only". UPD: Open this file with any text editor (Notepad) and change year value in this line to 2008 or 2009 <LastDateCheck>2008-10-29</LastDateCheck> or just delete this file, though its very radical cure to my mind.
[ add comment ]
| permalink | related link | ( 3 / 8087 )
So you have a script of your own that you want to run at bootup, each time you boot up. This will tell you how to do that.
Write a script. put it in the /etc/init.d/ directory.
Lets say you called it FOO. You then run
% update-rc.d FOO defaults
You also have to make the file you created, FOO, executable, using
$chmod +x FOO
You can check out
% man update-rc.d for more information. It is a Debian utility to install scripts. The option “defaults” puts a link to start FOO in run levels 2, 3, 4 and 5. (and puts a link to stop FOO into 0, 1 and 6.)
Also, to know which runlevel you are in, use the runlevel command.
[ add comment ]
| permalink | related link | ( 3 / 7610 )
Next