Terminal Server Commands: QUERY

http://support.microsoft.com/kb/186592

How to Take Full Ownership of Files & Folders in Windows 8

Refer - http://www.thewindowsclub.com/take-ownership-windows-8

The User Profile Service failed the logon

When you log on to a Windows 7-based or a Windows Vista-based computer by using a temporary profile, you receive the following error message:

The User Profile Service failed the logon. User profile cannot be loaded.

1. Click Start, type regedit in the Search box, and then press ENTER. 
2. In Registry Editor, locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList
3. In the navigation pane, locate the folder that begins with S-1-5 (SID key) followed by a long number.
4. Click each S-1-5 folder, locate the ProfileImagePath entry in the details pane, and then double-click to make sure that this is the user account profile that has the error.
5. Delete the error SID.

Complete details here! http://support.microsoft.com/kb/947215

Get-SPScripts : PowerShell Scripts for SharePoint: Perform an IISRESET on multiple servers using Powe...

Get-SPScripts : PowerShell Scripts for SharePoint: Perform an IISRESET on multiple servers using Powe...: This is quite a quick script, but very useful if you need to restart IIS on multiple servers in one hit. The only pre-requisite is to ensure...

How to know the Phone Carrier information

From Telephone Number Identification http://tnid.us/ This amazing service has so far determined the correct current wireless carrier and the correct original wireless carrier for many different cellular phone numbers. From Cingular/AT & T:  http://www.wireless.att.com/cell-phone-service/mobile-to-mobile/lookup.jsp The above web page from Cingular/AT&T lets you enter in your friends phone numbers and then it tells you if they are part of the AT&T wireless cellular network or not. The instructions at AT&T wireless are login and click on Message Center. In the right hand column look for Mobile to Mobile. Direct Link: https://www.wireless.att.com/olam/m2mLookupAction.olamexecute?dispatchEvent=handleCheckMoreNumbers

From Verizon Wireless:  http://www.verizonwireless.com/b2c/LNPControllerServlet?path=lnppromo1The above web page from Verizon Wireless lets you enter in your friends phone numbers and then it tells you if they are part of the Verizon Wireless cellular network or not. (If the are IN) The above web pages from the cellular companies are great services in my opinion. If you know of a similar service from other cellular providers then please email me at jeffsbaker@sbcglobal.net

From number-finder.info http://www.number-finder.info/ Make and take a lot of calls from your cellular phone? This tool isn't as handy as it used to be because of number portability (you can now take your number from one cell provider to a new provider). But if you want to know if the phone number might be in your network, type it in at the above website. The above website will tell you what carrier that number was originally sold to. If it is in your network you might be able to call this person without being charged. The above web site is also useful if you didn't answer your phone because you didn't know who was calling. Type the number in at www.intelius.com and if it is a listed number it will tell you the name of the person or business or at at least the city and state.

From Addresses.com http://phonenumbers.addresses.com/phone.php The above web page has a field under "Reverse Phone Lookup". If you enter a phone number there, it seems to have a better chance of finding out who owns the number then intelius.com does.

Who Called Us http://www.whocalled.us/ The phone is ringing and you do no recognize the number. The above site can help you figure out who is calling and what they want, especially if they are a telemarkete

snagged from
http://www.seabreezecomputers.com/tips/phone.htm

How to Enable Session Cookies

Netscape Navigator:
1.Click the Edit menu and select Preferences.
2.Click on Advanced in the list of topics on the left side of the window. The right side of the window should now display a series of checkboxes.
3.Find the box labeled Accept all cookies and make sure it is checked.
4.Click OK.

Microsoft Internet Explorer For Windows - Version 6.xx
1.Click on the Tools menu and select Internet Options.
2.Click the Privacy tab at the top of the window.
3.Make sure that the slider is set at a level not higher than Medium.
4.The bottom of the slider section of the Security window contains several buttons. Click on the one marked Advanced.
5.In the new window under the Cookies section, check the box labeled "Override automatic cookie handling".
6.Now you will see the other settings that are enabled and can be configured.
7.Under the First-party Cookies section, click the Accept button.
8.Under the Third-party Cookies section, click on the Block button.
9.Check the box labeled "Always allow session cookies."
10.Click on OK.

To Kill SQL Server Connections for a database

Disclaimer: Snagged & Sharing

1. Manual way:

Get all processes attached to the database
SELECT spid FROM master..sysprocesses WHERE dbid = DB_ID(@DatabaseName)
and AND spid != @@SPID

Note : @@SPID is your connected instance Service Process id "SPID"

and Perform Kill operation
EXEC('KILL '+RTRIM(@spid) )

2. Create Script

Use Master
Go

Declare @dbname sysname

Set @dbname = 'name of database you want to drop connections from'

Declare @spid int
Select @spid = min(spid) from master.dbo.sysprocesses
where dbid = db_id(@dbname)
While @spid Is Not Null
Begin
Execute ('Kill ' + @spid)
Select @spid = min(spid) from master.dbo.sysprocesses
where dbid = db_id(@dbname) and spid > @spid
End

3. Use Stored procedure

CREATE PROCEDURE dbo.clearDBUsers
@dbName SYSNAME
AS
BEGIN
SET NOCOUNT ON

DECLARE @spid INT,
@cnt INT,
@sql VARCHAR(255)

SELECT @spid = MIN(spid), @cnt = COUNT(*)
FROM master..sysprocesses
WHERE dbid = DB_ID(@dbname)
AND spid != @@SPID

PRINT 'Starting to KILL '+RTRIM(@cnt)+' processes.'

WHILE @spid IS NOT NULL
BEGIN
PRINT 'About to KILL '+RTRIM(@spid)
SET @sql = 'KILL '+RTRIM(@spid)
EXEC(@sql)
SELECT @spid = MIN(spid), @cnt = COUNT(*)
FROM master..sysprocesses
WHERE dbid = DB_ID(@dbname)
AND spid != @@SPID
PRINT RTRIM(@cnt)+' processes remain.'
END
END
GO