hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
2929my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.
1 3459can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?
1 5139
What is the largest component inside a field?
What do we have to check in database testing?
Can you roll back the ddl statement in a trigger?
How do you handle datasets larger than 50 gb?
What is a domain constraint give an example?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Difference between 2NF &3NF ?
Explain how to integrate the ssrs reports in application?
What are xml indexes?
what is a join? : Sql server database administration
Write a sql query to display the current date?
Explain the use of keyword with encryption. Create a store procedure with encryption?
How many ways to create table-valued functions?
What is the difference between system objects and user objects?
What the different topologies in which replication can be configured?