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.
2992my 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 3559can 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 5238
Can primary key be null?
What is update_statistics command?
What is the maximum number of index per table?
What is a db view?
How to connect ms access to sql servers through odbc?
What are the default system databases in sql server 2000?
Define left outer join?
What new data source types were added in ssrs 2014?
What is xdr?
What is the report builder?
What is log in sql server?
Do you think BCNF is better than 2NF & 3NF? Why?
what is dbcc? : Sql server database administration
Is foreign key unique?
What are the difference between primary key and unique key? : sql server database administration