Viewing 15 posts - 1 through 15 (of 47 total)
In fact.. I just found that out.. Yes, DB Limit had limitation of 4GB in SQL 2005 Express. and I was hitting that limit..
Thank you for your reply..
August 2, 2013 at 2:06 pm
Can't you use report link from the subscription you are using for this report? Subscription will have destination folder for this report...
July 25, 2013 at 11:16 am
Use this..
exec sp_msforeachtable @command1="print'?' dbcc dbreindex ('?')"
Taken from
http://qa.sqlservercentral.com/scripts/Indexing/31908/">
http://qa.sqlservercentral.com/scripts/Indexing/31908/
Or
You can use following to reindex all tables in all databases..
July 24, 2013 at 8:11 am
You can try something like this...
DECLARE @TeamTable TABLE
(
TeamID VARCHAR(3),
...
July 23, 2013 at 6:58 am
selected SSDT as didn't think about 2014 version there...
July 22, 2013 at 9:11 am
True..
XP_Fixeddrives will give actual free disk space on the server.. whereas script I gave above will give detail about size of the file and amount of space that is...
July 12, 2013 at 12:00 pm
To automate,
You can use function DB_Name() instead of typing dbname to pass the first parameter to your proc.,
For backup device type; you have to fetch/derive that value from table...
July 11, 2013 at 11:36 am
Probably, this is what you were looking for!!!
select
Name as 'Database'
, Filename as 'Location'
, convert(numeric(10,2),round(a.size/128.000,2)) as SizeMB
...
July 11, 2013 at 11:02 am
Try this..
Select DISTINCT Object_Name(Object_Id) AS TABLE_NAME
, case when Row_Count <= 2 then 'NOT ENOUGH ROWS' ELSE CAST(row_count AS VARCHAR) END NUM_ROWS
From sys.dm_db_partition_stats
order by Object_Name(Object_Id)
July 11, 2013 at 9:57 am
The explanation provided in BOL is the link I have provided!! Are you saying, one is correct but not the other!!!
" * = Result length too short to display....
July 11, 2013 at 9:11 am
Thank you SSC for posting this question.. 🙂
and
Thank you all members.. Yes, explanation provided on BOL link doesn't fit but couldn't find any other source to support this. 😀
July 11, 2013 at 8:23 am
I am also looking for this... Can someone help!!!!
June 3, 2010 at 12:29 pm
Viewing 15 posts - 1 through 15 (of 47 total)