Browse by Tags

TSQL to get default location of database data and log files?

Published 8 January 8 6:37 AM | SSQA.net

By default the SQL Server database data & log files are created on the default data directory which is Program Files or based on where SQL binary files are installed. In order to find what is the default location you can run following TSQL: declare...

Filed under: sql server, databases, location, tsql, data file, log file, default, program files

Learn LINQ in relation to TSQL, Orcas and many more

Published 25 July 7 5:4 AM | SSQA.net

In continuation to my post on Linq-TSQL I was drowing on web to know more about LINQ and how-to in relation to TSQL. Here comes the resources I have used and using so far in getting information about LINQ: First, MSDNForum link on "What is LINQ?...

Filed under: microsoft, blogs, linq, location, tsql, learning, backups

Change SQLAgent log file location after SQL Server installation

Published 11 July 7 4:17 AM | SSQA.net

Can we change the location of SQL agent error log file after the SQL Server program is installed? Yes, i n terms of configuring a specified number of SQL Server Agent error logs, this is not possible. The default number of log files for SQLAGent is 9...

Filed under: sql server, log, sqlagent, error log, location, path