Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nandac
Starting Member
27 Posts |
 Posted - 2008-12-23 : 12:34:33
|
| if you keep running the below repeatedly (10 times or so) you will see that it will not return the same results :EXEC sp_MSForeachdb 'USE ? create table #tmp_sfs2 (fileid int,filegroup int, totalextents int, usedextents int,name varchar(1024),filename varchar(1024))insert into #tmp_sfs2 execute(''DBCC showfilestats'')select * from #tmp_sfs2'is it due to the temp table? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-23 : 13:29:55
|
| This is obvious when any files are used with DML operation. |
 |
|
|
|
|
|
what is the issue here?