Tag Info

New answers tagged

3

This is not the installation of SQL Server itself. It is much more likely one of the following: a log file for a database (or databases) with a lot of activity, in full recovery mode, but you have never taken a backup or a log backup. a data file that you have populated with a lot of data (perhaps inadvertently, like tempdb) or attached a large database ...


1

Even if you keep your databases on other drives the default installation puts the system databases on C:. This includes tempdb which can grow fairly large depending on your application(s). This can be moved though, see here amongst other places. Another possibility for SQL server suddenly seeming to take more space on C: is that backups go there to by ...


5

Neither MySQL nor Yum are explicitly aware of RAID at all. All mySQL cares about is that it has filesystems to put its files on, if that is hosted on a RAID volume (or NFS share, or anything else) or not makes no difference to it. The same for Yum - it is just a package manager and does not need to be aware of the intricacies of the block device the ...


0

The reason that SQL isn't starting is that the SSL certificate that you've configured SQL Server to use for encrypting the SQL Server traffic can't be found, so SQL can't start. Open the SQL Server configuration manager Under "SQL Server Network Configuration" right click on "Protocols for MSSQLSERVER" and select properties. On the certificate tab change ...


1

Are you talking about the Oracle Client? In that case you can review the installation logs in the Oracle Inventory directory and look for the INSTALL_TYPE property: INFO: INFO: --------------------------------------- INFO: INFO: Starting to setup InstallClient INFO: INFO: Initializing setup InstallClient INFO: INFO: Session Details : INFO: ...


2

Visual Studio Shell is just the plumbing required to run the shared components within SSMS. If you want to manage .aspx files etc., you'll need to install the free Visual Studio Express (or a higher edition if Express doesn't have all the functionality you need).


8

Well, if you have a legal copy of SQL Server, you should be able to install Management Studio from that media wherever you need to manage SQL Server from. That said, the Express version of Management Studio, since 2012 Service Pack 1, has been a fully functional product with absolutely no differences (except you can download it instead of finding your ...


-5

Its very difficult to find SQL Server management studio which is not express version because Microsoft only ships complete version with installable of Licensed version. If you have setup of any SQL Server 2012/2014 licensed version you can run the setup and install SSMS by selecting client tools. There is no addictional license for SSMS. Other good point is ...


7

You can download and install SQL Server Management Studio using the links provided in: Scott Hanselman's website There are links to various SSMS versions (2012, 2014, for x86, x64), as well as links to various SQL-Server Express versions. By the way, you can also use the latest SSMS 2014 to manage your 2012 database.


1

For instance installation date: SELECT instance_installed = create_date FROM sys.server_principals WHERE name = N'NT AUTHORITY\SYSTEM'; For the database creation date, why on earth do you care about the create_date for system databases like msdb, model, etc.? And tempdb gets re-created every time you restart the service, so unless you're also looking ...


2

determine the actual create date for SQL Server This can be found using SELECT createdate as SQL_SERVER_INSTALLATION_DATE FROM sys.syslogins where sid = 0x010100000000000512000000 Note : sys.syslogins is deprecated, so using sys.server_principals will give you the same results. So you can use : --Using sys.server_principals SELECT ...



Top 50 recent answers are included