.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

uid.sbmp.tmp files on SSAS temp directory

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server

Hi, We browse a cube thanks to the Microsoft datapump and after a benchmark I notice the process msmdsrv has 2000 handle count.

Thanks to Process Explorer I know that this is the *.sbmp.tmp files stored in the temp directory.

Someone know what is these files?



View Complete Post

More Related Resource Links

Polling FTP-Server and downloading files to our local directory on regular intervals

Issue regarding downloading same file again and again. Let me be clear, I am using SSIS to poll FTP Server on regular intervals to download different files to my local directory. Once the file is downloaded I need to load the file name into table and validate that particular file name against FTP Server next time when I am polling, so that I don't download same file again.                              Question here is how could I implement this either using SSIS or VB Script ???

ASP.net copies my dll and pdb files inconsitantly to temp folders

Hi - Basic problem is I can't debug because the dlls and pdb files get out of sync. Seems ASP.NET (or my VS2008 Pro settings) copies the dlls and pdb to asp.net files inconsistantly. For example today (9/8/10) I just did a clean, then rebuild of the project. Then when I look for the dll and pdb files on the hard drive I see:  Volume in drive C has no label. Volume Serial Number is 3EAF-1489  Directory of C:\Mypower\Mypower_WebEngine_UI\Mypower_WebEngine_UI\bin 09/06/2010  09:29 PM           221,184 Mypower_WebEngine_UI.dll  Directory of C:\Mypower\Mypower_WebEngine_UI\Mypower_WebEngine_UI\bin 09/06/2010  09:29 PM           501,248 Mypower_WebEngine_UI.pdb               2 File(s)        722,432 bytes  Directory of C:\Mypower\Mypower_WebEngine_UI\Mypower_WebEngine_UI\obj\Debug 09/06/2010  09:29 PM           221,184 Mypower_WebEngine_UI.dll  Directory of C:\Mypower\Mypower_WebEngine_UI\Mypower_WebEngine_UI\obj\Debug 09/06/2010  09:29 PM           501,248 Mypower_WebEngine_UI.pdb     &

Web Service Unable to access Directory (Temporary ASP.NET Files) CS0016

QuestionMoving web service to a production level server. This is not a new server, but is new to running an ASP.NET 2.0 web service. No other websites or services existed on this server.

Installed .Net 2 and specified that ASP is registered for 2.0 using aspnet_regiis. Installed missing components such as Front page extensions. When I try to browse to the services asmx page I get the error saying that the process has a compilation error and cannot access the asp.net temp directory under the 2.0 Framework. I looked at the directory and it appears that the asp.net process and others have correct access.

Note a basic asp.net page will come up as well as a basic html page.

All comments are welcome.

  • .Net 2
  • ASP.NET aspnet_regiis specifies .Net 2 as root
  • C#
  • IIS6
  • Windows Server 2003 SP1

File.Copy to Program Files Directory.

I searched high and low and have found some discussions on this topic but do seem to see any solutions.   So here is my issue.   I have an application that will copy 2 files to the Program Files directory.   What happen is, when I run it and the files exist (this should be what normally happens) I get accessed denied.   If I try to do a File.Delete (in code) first I get an access denied, however I can manually (in OS windows explorer) delete the files and then the copy will work.   I am running the application as Admin, so permissions to the folder are good.  

The application is restoring a 3rd party software file that tends to get corrupted a lot.   We have mechanism that will back this file up, but when I try to restore it I get the problem described above.   (not a file lock issue, I have made sure no programs have a handle to the file)

OS = Vista32
Program written in C#

Is there anyway of accomplishing this?


Programmatically copy all files from a SharePoint Library to a local directory on the server with an


Through the use of an event receiver I am trying to copy all the files in a document library to a local folder on the server.  I am finding examples of how to upload but none to download.

Can someone show me the code or have a good reference for me?


Cannot publish files in root directory?


Hi Everyone,

I have a website(not an application) built in VS2008. When I try to publish the site, any of the files that are in the root folder are not published. This has only just started happening and I am unsure what I have changed to cause this. The files are not excluded from the project.

Thanks for the help


Getting files from a directory in a server


Can someone help me with moving files from a server to another server. Ive tried using the FOREACH loop container, but it seems that the files have to be on the same server to use a flat file enumerator.

My issues is I have Server A, and Server B. I need to pull files from a folder in A onto B, B has SSIS on it. I tried creating a connection manager to the existing folder on A, but I cant seem to use it in the FOREACH container.




You are so wise...like a miniature budha covered in fur. -Anchorman

lengthy processing (getting data in to 3 different temp files)



I need to do lengthy processing (getting data in to 3 different temp files) for final report.

I have SQL script ready and it works on SQL Studio however, same query from ASP get timeout error.

I am looking for some ideas on how to handle and make this work. Where can I place this processing?



Exclude some files or directory to require authentification in an asp.net forms authentification pro



I have an asp.net which requires forms authentification, which i configured in the root web.config file

My problem is that i want some aspx.files be accessible without requiring to authentificate


Is it possible ? In the web.config file ? IIS ?

Or do i have to put them in a special directory ?  

When using a custom theme, there is no custom files added to "_themes" directory.


I've been working on customizing some Sharepoint 2010 Team sites and have read through many helpful articles on how to create and edit custom themes. The most consistent method is to create a base theme in Powerpoint which I've done.

I then install this THMX file in the themes library and apply it to my pages which seems to work as expected. The one inconsistency with what these articles say and what is happening on my end is that there is no numbered directory created in the "_themes" directory when I view All Files. These articles explain that this directory is created every time you apply a theme to your site so you can further edit the images and CSS associated with the theme. All I see in this "_themes" directory is "Custom.thmx, CustomPreview.thxm."

Is there some site setting or permissions issue I should look into to have this directory available to me?


System.UnauthorizedAccessException when enumerating files in directory




as the title says, I've been getting a System.UnauthorizedAccessException when enumerating the files in a directory. The exact line that throws the error is:

string[] files = System.IO.Directory.GetFiles(path, "*.htm*");

My first thought was that I had insufficient NTFS privileges on the directory, but the error kept occuring even when I granted Full Access to Everyone. Running the program as Administrator (Win 7) produced the same result. Googling didn't give me any other ideas either. Anyone have a clue what the problem could be? Thanks.

Calculating the size/files count of a directory (including subdirectories)




I've been told that the fastest way to calculate the size/files count of a directory (including subdirectories) was something like this:

                ProcessStartInfo startInfo = new ProcessStartInfo("CMD.exe");
                Process p = new Process();
                startInfo.RedirectStandardInput = true;
                startInfo.UseShellExecute = false;
                startInfo.RedirectStandardOutput = true;
                startInfo.RedirectStandardError = true;

                p.StandardInput.WriteLine(@"dir " + this.Path + " /s/-c");

                string output = p.StandardOutput.ReadToEnd();


And then reading the sums somewhere in the end o

Directory.GetFiles with searchPattern to get all *.dll and *.exe files in one call


Hi experts,

is it possible to use Directory.GetFiles with searchPattern to get all *.dll and *.exe files in one call?




SQL CE 3.5 corrupt temp files

I have a desktop C# application that reads and writes to an SQL CE v3.5 database file.  The file is typically around 12Mb in size and resides next to my appilcation exe.  When I run the appilcation it reads data from the file but then at some point I get the common Data corruption error, run Repair utility etc, but the error says the corruption is in a file located at c:\windows\temp\sql123.tmp or similar, this is not where my db file is located.   This temp file is also only 84k.   If I try to run the repair utility on my 12Mb file it reports that the database file is not corrupted.  I wondered why I am getting this error now and why SQL CE is creating this small file.  There is nothing in my code to say that the database has to be read only.

Directory.GetFiles throws System.IO.IOException: There are no more files


We are having problems with the Directory.GetFiles method in our production environment.  We have a console application that is started every 5 minutes 24/7 and it runs fine, but once in a while we get the following exception:

System.IO.IOException: There are no more files.

  at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
  at System.IO.Directory.InternalGetFileDirectoryNames(String path, String userPathOriginal, String searchPattern, Boolean includeFiles, Boolean includeDirs, SearchOption searchOption)
  at System.IO.Directory.GetFiles(String path, String searchPattern, SearchOption searchOption)
The exception occurs on the folowing line:

string fileMask = "*.xml";
filenames = Directory.GetFiles(dataFolder, fileMask);

The documentation of that function clearly states that if no files are found, the function returns an empty array, and it does so in 99,999% of the cases.

Some background information:

The program runs and reads on the local D drive of a virtual W2K3 clustered machine.  That D drive is swapped between cluster members during failover, but at the time of the exception no failover is taking place.

As the problem on

Any method to get all files under a directory and its sub-directories?


I am wondering if there is any method equivalent to the following DOS command:

dir /a-d /s /b

which lists all files under a directory and all its sub-directories. I know one can do this by writing a simple recursive function which is what I am doing now.

I would like to update my database based upon files that are found in a certain directory.


I'm having an incredibly hard time with this, I'm really new to it.  I'm creating a website for free web graphics and I would like to add data to my database whenever more files are added to my server.  I've found a way to list all the files in the directory:

<script language="C#" Runat="server">
        // declare the page level variable for the path
        String FilePath;
        protected void Page_Load(object sender, EventArgs e)
            FilePath = Server.MapPath("~/thumbs");            
            GetFiles();  //call the GetFiles method
            lblHeader.Text = "Files in " + FilePath;
        private void GetFiles()
            //Create the DataTable, with columns in which to add the file list
            DataTable dt=new DataTable();
            dt.Columns.Add("Thumb Exists?", typeof(System.String));
            DataRow dr=null;
            DirectoryInfo dir=new DirectoryInfo(FilePath);

            // Iterate through the datatable,
            // adding file to a new row, along with the  filesize to each row
            foreach (FileInfo 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend