Go to that database-->Storage-->Partition Functions-->Your function(right click and script it out).

MJ

You can try the below mentioned code provided you eunderstand enabling xp_cmdshell security effects.

EXEC master.dbo.xp_cmdshell 'wmic LOGICALDISK LIST BRIEF'

Manu

Adam,

Could you please share your SSIS package as I am also in similar situation?

Thanks in advance.

MJ

Try restarting the application(s) concerned(involved in tht hung transaction) and hope that it has a recovery mechanism to deal with any MSDTC transactions that were left unresolved.

Try running the job step definition under SSMS manually and see if it gives you more detailed message.

Also, try whts listed at-->http://www.sqlservercentral.com/Forums/Topic117030-5-1.aspx#bm117428

MJ

Search in default trace file for databasename='yourdbname' and eventclass=164 and objecttype=16964

Reserved is nothing but size of pages that have been allocated for that object.

For example, if you create a empty table as below.

CREATE TABLE [dbo].[Table1] (

[nh] [char] (10) COLLATE...

I think counter value parameter is in milli seconds.

Manu

It is same as reserved column generated in output of sp_spaceused.

reserved

varchar(18)

Total amount of space allocated by objects in the database.

http://msdn.microsoft.com/en-us/library/ms188776.aspx

DBArtisan,Rapid SQL,AquaStudio and several third party tools can be used to administer sql servers of all editions.

I believe that TOAD, from Quest software, can be used to...

I think yes. MSDAORA is the name of the Microsoft OLE DB Provider for Oracle-->http://www.sqlmag.com/Articles/ArticleID/49687/49687.html?Ad=1

MJ

SQL Server 2005 introduces automatic horizonal partitioning based on a column and specification of the ranges for the partition. If you have a date column you can partition based on...

Try what worked for Deepak, stated on http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/c6e9c5ff-0d72-4af0-be40-a13e5f063eec

MJ

Thats correct.

A new table or index is generally allocated pages from mixed extents. When the table or index grows to the point that it has eight pages, it then switches...

Did you gave this a try?

MJ