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.1673
my 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 1563
what is advantages in sql 2005 over sql 2000?4 4968
Differnce between sel server 2000 and 20053 3680
can 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 3447
i need some interview questions on sql server developer plz any onee send some links.2 3680
what is mean by crystal repoart? ahere we will mainly use that?1 2539
how to rename the table3 4119
how many type of subquery?2 4930
role of sql sever 2005 in database rather than any other database
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is the difference between NOROW and LOCKROW?
1 01 101 01010
ow to bring suspect mode datbase online from scratch
whats new about truncate in sql server 2008?
Tell about MOM Tool(Microsoft Operator Manager)?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Delete duplicate rows without using rowid.
OPTIMIZATION OF SP,CURSOR,TRIGGERS
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How to convert a table data in XML format in sql server?