Declare @ID uniqueidentifier DECLARE cursor_name CURSOR FAST_FORWARD READ_ONLY FOR SELECT ID FROM tableName OPEN cursor_name FETCH NEXT FROM cursor_name INTO @ID WHILE (@@fetch_status <> -1) BEGIN PRINT @ID FETCH NEXT FROM cursor_name INTO @ID END DEALLOCATE cursor_name
select * from table for xml auto, elements
BULK INSERT table FROM 'c:\file.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) GO
Boot from Linux CD with
ntchpw utility installed. Most of the time I used PING. Pretty sure most of Live CD’s do have that utility.
Mount Windows partition to Linux:
ntfs-3g /dev/hda1 /mnt/ntfs
mount -t ntfs-3g /dev/hda1 /mnt/ntfs -o force
The last one is used if windows did not shut down properly.
In Windows partition Navigate to
chntpw SAM. As a safety measure you can copy SAM file somewhere available to restore, if things go wrong.
This utility will ask you number of options. Blank the password, do not set a new one. Agree to write hive files when finish.
Restart computer to boot into Windows.
chntpw is loading administrator account. You can load another user if required. Read man page for chntpw to figure out how to do this.
Here is the problem: Vista is connected through wired or wireless connection to a router. IP assigned, no error messages in the connection. Pings are going too Google and updates are downloaded from Microsoft. Probably can go online in messenger or ICQ. But when you start up Firefox or IE, it does not let you go surfing the net.
When you boot Windows into Safe Mode with Network it can go browsing with no problem.
The solution in my particular case was to remove Norton Anti-virus suite. Just when I uninstalled it everything worked fine. Did not even need to reboot.
If you want Firefox to open a link in a new tab when you click on it with middle button do this:
middlemouse.contentLoadURL to false
cmd as Administrator. To check MTU issue:
netsh interface ipv4 show subinterfaces
This will give you a list of network adapters with MTU
To change the MTU issue following
netsh interface ipv4 set subinterface "YYY" mtu=xxxx store=persistent
Where “YYY” is a network interface name like “Wireless Network Connection”.
create table #table(text nvarchar(200))
EXEC master..xp_cmdshell 'dir *.exe'
select * from #table
After uninstalling Vista SP1 you may get the yellow triangle error for
the wan miniport (SSTP). You can’t uninstall wan miniport (SSTP) or
This is the solution:
Use the following commands to be carried out as the user Administrator
(Run as Administrator) from Command prompt (cmd):
netcfg -e -u ms_sstpminiport
You may have to find the course Hardware ID device from the Device
Manager and selecting the Details tab-> Hardware IDs if it is not
‘ms_sstpminiport’ which is causing the problem.
Taken from: Here
Vodafone VMC Lite does not want to connect to the network if if is executed under Windows XP user with restricted privileges. The software comes up, but saying “No device” and no chance to connect.
How to resolve this: Login as Administrator, Uninstall VMC Lite and install full featured VMC software from Vodafone. Connect to the network. Then login as user and try to connect again – it should work now.
Bear in mind that WinXP is treating every USB port available as separate instance, not connected to each other.. so being logged in as Administrator plug in USB modem to every available port and connect. Otherwise you’ll hear moans from users saying modem is not working.
Simple solution, but I’ve spent quite a time to figure out the way.
RIP Vodafone -)