push pause/break button repeatedly while booting to see the options for the BIOS
Month: January 2011
in order to take more than 1 hop – you must have kerberos setup to check if it is – run this: select auth_scheme from sys.dm_exec_connections where session_id=@@spid if it is running ntlm – you can only take 1 hop for example – if you…
To change the multiserver results options In Management Studio, on the Tools menu, click Options. Expand Query Results, expand SQL Server, and then click Multiserver Results. On the Multiserver Results page, specify the option settings that you want, and then click OK.
In Registered Servers, click the server type on the Registered Servers toolbar. If Registered Servers is not visible, click Registered Servers on the View menu. Right-click a server or a server group, point to New, and then click Server Group. In the New Server Group…
Login into SQL Server using Windows Authentication. In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties. Change SA password, and confirm it. Click OK. Make sure to restart the SQL Server and all its services and…
so that you can rollback if you don’t get the expected results using rollback transaction if you don’t use BEGIN TRANSACTION, then you will have to revert the database to a backup to restore the data if you get the expected results from the transaction,…
SELECT * INTO AdventureWorks.dbo.CustomersTemp FROM Northwind.dbo.Customers Just remember that using this query will only transfer the schema and data. It does not transfer the indexes, foreign keys, statistics etc.
You need to run the Performance Monitor service under a domain account that has privileges to the system you want to monitor. You cannot use NT AUTHORITYNetworkService. To start the Performance Logs and Alerts service under a different account: Right-click My Computer, and then click…