Search results for query: *

Hi All, I've managed to solve the questions that I've posted earlier. Thank you for your help and support. Have a nice day. Bye

Hi Olaf, Thank you very much for your response and help. It had cleared my doubt and the given article is very useful. If it's not too much too ask, would like to check on the following 2 items: 1) Would it be possible to have below sql statement (SAMPLE 2) coded into SQLCMD command and...

Hi Olaf, declare @TableSpace table (TableName sysname, RowsK varchar(32), ReservedMB varchar(32), DataMB varchar(32), IndexSizeMB varchar(32), UnusedMB varchar(32)) Insert into @TableSpace exec sp_spaceused 'Production.BillOfMaterials'; Select * from @TableSpace Can I check what does...

Hi Olaf, Thanks for your response and help. I'll do further testing with your method. Thanks.

Hi Olaf, Thanks for your response and help. I've tried something like this, but it does not working. declare @tablespace table (TableName sysname, RowsK varchar(32), ReservedMB varchar(32), DataMB varchar(32), IndexSizeMB varchar(32), UnusedMB varchar(32)) insert into @tablespace exec...

Hi Olaf, Thanks for your response and help. Could you help on how can I use commands "sp_MSforeachtable" and "sp_spaceused" to check only for these selected tables: EMP001, EMP002, EMP003, EMP004, EMP005 ? Appreciate for your help. Thanks.

Hi Experts, I'm using Ms SQL Server 2008 R2 (Enterprise edition), I need some help in compiling the correct SQL query to check table size of certain tables. There are plenty of examples from forums on checking for all tables, however, this is not what I'm looking for. Let's say I've the...