How do I view a stored procedure in sql server query?
From where can you change the default port?
Why use stored procedures in sql server?
What is data source document?
What is the command used to recompile the stored procedure at run time?
What is the difference between Stored Procedures and triggers?
What is scheduled job and how to create it?
How to create Clustered Primary Key to table?
What is SQL Server?
What is 3nf normalization?
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.
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is stored in the mssqlsystemresource database? : sql server database administration