SELECT name, database_id, create_date FROM sys.databases ;
Month: November 2014
CREATE DATABASE [dbname_with-odd_chars (May)] ON (FILENAME = ‘L:something.mdf’), (FILENAME = ‘I:something_log.ldf’) FOR ATTACH;
must also USE database GRANT CONNECT TO [domainlogin] in order for them to be able to login
select name, filename, CONVERT(decimal(12,2),round(a.size/128.000,2))as FileSizeMB, CONVERT(decimal(12,2),round(fileproperty(a.name,’SpaceUsed’)/128.000,2))as SpaceUsedMB, convert(decimal(12,2),round((a.size-fileproperty(a.name,’SpaceUsed’))/128.000,2))as FreeSpaceMB from dbo.sysfiles a
SELECT d.name, ROUND(SUM(mf.size) * 8 / 1024, 0) Size_MBs FROM sys.master_files mf INNER JOIN sys.databases d ON d.database_id = mf.database_id WHERE d.database_id > 4 — Skip system databases GROUP BY d.name ORDER BY d.name
http://www.sqlservergeeks.com/sql-server-failover-cluster-initiating-manual-failover/ Expand Services and Applications & select SQL Server service. You should be able to see the current owner of the service. In my example below, node1 owns the service. Right click the service and click on the options as shown in the image… You…
https://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx The following procedure describes how to configure SSL for SQL Server. To configure SSL 1. Install a certificate in the Windows certificate store of the server computer. 2. Click Start, in the Microsoft SQL Server program group, point to Configuration Tools, and then click…