To patch SSMS you run the SQL/Server patching just like you are patching the DB Server. In other words download and execute the latest SP or CU. The...

Then by all means knock yourself out - don't ask if you don't want to know. Almost all of us don't do it for the reasons stated in previous posts.

Not a query; however, Idera has the "Idera SQL Admin Toolset" which has a Linked Server copy tool (among other cool tools) that will ease your Link Server migration.

If network speed is not the issue - Stripe your DB backup to multiple files.

Or use this script if you have multiple orphaned logins to fix and don't want to do it one at a time:

USE [DBName]

--Must run this in the context of the...

We use a script to zero in on the top blocking SPID then investigate that SPID. There are several good scripts on the net - below is one that...

You can use the Windows telnet client to check if SQL is not blocked and accepting connections.

From the web server open a cmd prompt. The command is "telnet MachineName...

This site will help you out:

http://sqlserverbuilds.blogspot.com/

R-click the DB, click Reports, click Disk Usage. Click the + next to Disk Space used by Data Files (at the bottom of the report).

Check out the SQL Server 2014 Upgrade Technical Guide. Don't let the title fool you as this is also for 2005, 2K8, 2K8R2, 2012 and 2014.

http://blogs.technet.com/b/sqlman/archive/2014/12/17/sql-server-2014-upgrade-technical-guide-now-available.aspx

http://sql-articles.com/ARTICLES/SECURITY/TRANSPARENT-DATA-ENCRYPTION-TDE-SQL-SERVER-2008/

http://sql-articles.com/articles/security/how-to-copy-move-a-database-that-is-encrypted-with-tde/

http://SQL-ARTICLES.COM/ARTICLES/SECURITY/IMPLEMENTING-TRANSPARENT-DATA-ENCRYPTION-TDE/

EXEC sp_who2 will give you the HostName where the query is running from. Then you can open a CMD prompt and issue a Ping HostName to get the IP...

--Display current backup/restore progress using DMVs.

--SQL 2005 and above

--From http://www.mssqltips.com/tip.asp?tip=2343

USE master

SELECT session_id AS SPID ,

CONVERT(VARCHAR(50), start_time, 100) AS start_time...

B:\ Backups

C:\ OS

D:\ Installation Files, Paging file etc

E:\ SQLData .mdf .ndf (usually make this drive the root for SQL)

F:\ SQLLogs .ldf (including TempDB Log)

G:\ TempDB .mdf .ndf

Awesome!

Just remember this is a undocumented option; however, you stated that you didn't need the log.

Thanks for replying back.