|
Search:
Advanced search
|
Browse by category:
|
Glossary | Contact Us |
what is the method to change location of tempdb? |
||||
1. Determine the logical file names of the tempdb database and their current location on the disk. SELECT
name, physical_name FROM sys.master_files WHERE database_id = DB_ID('tempdb'); 2 Change the location of each file by using 3. Stop and restart SQL Server. 4. Verify the change Reference: Microsoft SQL Server Books Online |
||||
Comments
|
31 Dec, 1969
|
Guest
|
|
microsoft sql server 2008 express |
|
31 Dec, 1969
|
Guest
|
|
sql server management studio download |
|
31 Dec, 1969
|
Guest
|
|
web hosting sql server |
|
31 Dec, 1969
|
Guest
|
|
bpm database |
|
31 Dec, 1969
|
Guest
|
|
database management system software |
|
31 Dec, 1969
|
Guest
|
|
what is sql |
|
31 Dec, 1969
|
Guest
|
|
sql server classes |
|
31 Dec, 1969
|
Guest
|
|
web hosting sql server |
|
31 Dec, 1969
|
Guest
|
|
microsoft database software |
|
31 Dec, 1969
|
Guest
|
|
sql clustering |
|
31 Dec, 1969
|
Guest
|
|
database programmer |
|
31 Dec, 1969
|
Guest
|
|
sql server 2008 developer edition |
|
31 Dec, 1969
|
Guest
|
|
sql server monitoring |
|
31 Dec, 1969
|
Guest
|
|
dbms software |
|
31 Dec, 1969
|
Guest
|
|
sql select unique |
|
31 Dec, 1969
|
Guest
|
|
sql server 2008 r2 download |
|
31 Dec, 1969
|
Guest
|
|
database programming |
|
31 Dec, 1969
|
Guest
|
|
dbms components |
|
31 Dec, 1969
|
Guest
|
|
sql joins |
|
31 Dec, 1969
|
Guest
|
|
sql server 2005 training |
Showing: 1-20 of 35 »»
Powered by
KBPublisher (Knowledge base software)