.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

SQLSERVER 2008 - FILESTREAM - filename filesystem

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

hello, i use filestream sqlserver 2008. When a file is inserted on sqlserver filestream, this file is put on a directory and rename with this: "00000055-000000f9-0009" for example. If you add extension (jpg for example), you can open this file. It's good. But, i dont't know how get the name "00000055-000000f9-0009" for example when i have my colum filestream of my table and the uniqueidentifier.

It is important for me because i wan't to access to this file if my application have a problem. I am administrator DBA sqlserver and i wan't to retrieve the correspondance and file GUID of my table and file system "xxxxxxxx-xxxxxxxx-xxxx" created.


View Complete Post

More Related Resource Links

how to upload files (5MB-50MB) into sql server 2008 by using filestream

Hi!i have some files, and i need to upload these files into sql server 2008 by using filestream.lets take table name as custfiles,              columns are fileid,filename,filepath,filesize.1.how to create table using filestream?2.how to insert file (record) into table from .net environment?3.how to retrive that file from .net environment?please provide related code....THANS FOR ANY HELP

SQLServer 2008 Tools and SQL 2005 Cluster

I recently built a SQL Server 2005 cluster on the o/s Windows Server 2008 R2.  I have been attempting to connect to the cluster from my Windows 7 dekstop with my SQL Server 2008 Tool set.  I have been unable to attach to this cluster since its creation. The firewall is temp off, remote connections in the surface area configuration is set to pipes and tcp/ip and the Browser surface is up and running. I ran Wireshark against the cluster and I could see that there was UDP conversations for ms-sql-m (SQL Port) but that was as far as it would get.  I am using a named instance so not using 1433, but I do see the cluster offering up high RPC ports but the client never responds after the initial UDP response. When I noticed that there was a two way conversation taking place, I went to a seperate machine and fired up SQL Server 2005 Tools and I was easily able to attach to the cluster.  So my question is - Are there any known incompatibilities between SQL Server 2005 cluster services and SQL Server 2008 Tool set?  I can use my 2008 tools to attach to a non-clustered SQL Server 2005 w/o issue.   Error when attempting to connect: A network-related or instance-specific error occured while establishing a connection to sql server.  The server was not found or was not accessible.  Verify that the instance name is correct and the SQL Server is con

Not able to install SqlServer 2008 says Restart computer failed

While trying to install SqlServer2008 it show Restart computer as failed. I have restarted my computer and still it shows the same error. Cant proceed further. Please advice on how to proceed to install SqlServer 2008.   Thanks Ashok

sql server 2008 - sqlserver(mssqlserver) services can't start

Sorry i need help, i have instal and reinstal sql 2008 over and over but always failed the problem is the services can't start and when i cek error log this written: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.1600.22%26EvtType%3d0xE53883A0%400xBE03358B%401306%4024

Accessing the FileSystem from SqlServer

Hi All I need a Sql Stored Proc which tells me the list of Files that are greate than 1GB on my Physical Drives. Lets say i have C,D E drives on my server. When i run my SP it has to list me put all the file names and Size greater than 1GB.   I started trying some DOS commands using XP-CMDShell.is thr any other better way to approach this.??   Thanks    

Restoring 2008 Database with Filestream - Process cannot access file error

I'm trying to restore a copy of a database that has a filestream and am getting the error below. I've tried with move option to specify a new path and left it with default path, neither worked. Did a trace with procmon, didn't see anything. FileStream1 is a new folder that the restore process creates. I've deleted the folder, tried it with a new name, re-took the backup from the source machine, restarted SQL, rebooted the machine, drive permissions are open. I've run out of ideas on how to debug further. Looking up the error online wasn't much help either. Msg 3634, Level 16, State 1, Line 1 The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'OpenFile' on 'X:\Data\FileStream1\4ecb2e48-0eee-4c99-a3f0-f1e6c7f00b24\f2efe374-9481-4c1b-a7f2-dcdcee350807\0000001b-0000aaa6-00f6'. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. ' SQL Server 2008 SP 1, MS Server 2008 R2 Server


Hi All, Yesterday we installed SQLSERVER 2008 R2 in our development mechine , and already it have Microsoft TFS 2008. When i open my report project it came up with the upgrade messagebox i clicked on Yes.And i try to run the reports locally its giving me exception like "An attempt has been made to  use the data extention 'custom datasource extention 1.2' that is eaither not registered for this report server or is not supported in this edition of reporting services'.So i did the changes like adding the dlls into the reportserver bin and added the data block which i have configured for SSRS 2008 i have applied the same setting for the SSRS 2008 R2 but still i am gettign the same exception do we need to do any changes in SSRS 2008 R2. because i am able to run the reports sucessuflly in SSRS 2008 but not SSRS 2008 R2? Any body have ideas on this. Thanks, Veeren.

Cannot Connect SQLServer 2008 with the provider SQLNCLI... Is there any SQL Server 2008 patch to sup

We have a program which developed under SQL Server 2005. In the program the provider of the connect string is hard coded as "SQLNCLI". It's ok running on SQL Server 2005. Now, for some reasons, this program must run under SQL Server 2008 (x64). But our program cannot access the SQL Server. We check the reason, found that, in SQL Server 2008, SQLNCLI is changed to SQLNCLI10, this caused our program cannot run. So I want to ask, is there any patch of SQL2008, so that the legacy program can normal access SQLserver with SQLNCLI WITHOUT rebuild a new version?  

Can't enable filestream on SQL Server 2008 Express 64bit under Win 7(64 bit WOW)

I have a newbie question.  I am running Win7(64 bit WOW). I installed SQL Server 2008 Express R2 (64 bit), but when I go to enable filestream, it reports that my edition of SQL Server does not support filestream.  I thought that the 64 bit edition would.  It says to install SQL Server 2008 64 bit.  Am I correct that that is not a free download?  Do I have any other options?

multiple dataset in sqlserver 2008

show the code for how to do multiple dataset in sqlserver 2008

multiple dataset in sqlserver 2008

How to do multiple datset for a single report in sql server 2008  

Problems with SMO 2008 Redist + Microsoft.SqlServer.BatchParserClient

Hi,    I'm trying to run my application using SMO 2008. Everything works just fine if i have sql 2008 server installed.   My problem starts when I try to use SMO 2008 Redist. First it does not install Microsoft.SqlServer.BatchParserClient or Microsoft.SqlServer.BatchParser. After a little research, I found that this is a problem and that these files have to be copied manually to the folder where the application runs.  So I tried copying the files: No luck, i get a Could not load file (Below).  Then i tried to adding these files to the GAC manually: Same thing, Could not load file:   Code Snippet Microsoft.SqlServer.Management.Smo.FailedOperationException: ExecuteNonQuery failed for Database 'DB2008'.  ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)        Then I looked at the version of the files and they seemed to be version, so I went to my app.config and added a bind redirection from to now it finds the assembly but says that Manifest doesnt mach the reference:   Code SnippetMicrosoft.SqlServer.Management.Sm

SQLServer Express 2008 R2 - Cannot connect Error: 18456, Severity: 14, State: 11.

I have just installed  running MSSQL Server 2008 R2 (Express), along with Visual Web Developer 2010 Express In SQL Server Configuration Manager I can see the SQL Server Service running (SQLEXPRESS) and the SQL Server Browser service running. On running SQL Server Management Studio when trying to log on I get the message Login failed for user Phil-PC`Phil (Microsoft SQL Server, Error: 18456) In the SQL Server Error log I see this error 2010-09-16 10:24:16.07 Logon       Error: 18456, Severity: 14, State: 11. 2010-09-16 10:24:16.07 Logon       Login failed for user 'Phil-PC\Phil'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>] I have been unable to find anything useful on Google on how to resolve this problem. I have tried running the command line utility sqlcmd -L and this lists the following Servers:     Phil-PC     Phil-PC\SQLEXPRESS   In my list of Installed programs in Control Panel I see both MS SQL Server 2008 & MS SQL Server 2008 R2, is that correct?

Restoring 2008 Database with FileStream - CreateFile Sharing Violation

I've previously posted this question and turning off the anti-virus scan helped fix it. But I'm having same issue on a machine that doesn't have anti virus scanning enabled. Back story: I'm trying to restore a copy of a database that has a filestream and am getting the error below. I've tried with move option to specify a new path and left it with default path, neither worked.  Also tried the with replace option. FileStream1 is a new folder that the restore process creates. I've deleted the folder, tried it with a new name, re-took the backup from the source machine, restarted SQL, rebooted the machine, drive permissions are open. Msg 3634, Level 16, State 1, Line 1 he operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'OpenFile' on 'R:\Data\FileStream1\4ecb2e48-0eee-4c99-a3f0-f1e6c7f00b24\f2efe374-9481-4c1b-a7f2-dcdcee350807\0000001b-00005fcf-005a'. RESTORE DATABASE is terminating abnormally. ' I found the file on filemon and below is the error, stack and processes running. Date & Time:    9/15/2010 6:33:48 PM Event Class:    File System Operation:    CreateFile Result:    SHARING VIOLATION Path:    R:\Data\FileStream1\4ecb2e48-0eee-4c99-a3f0-f1e6c7f00b24\f2efe374-9481-4c1b-a7f2-dcdcee350807\

SQL Server 2008: When creating database with filestream group pc hangs


I am facing this STRANGE problem with sql server 2008. When I try to create a new database with filestream group my system hangs. When I restart pc by direct power off and then on, I cannot see the new database but at the given location I could see that database files and filestream group has been created. 

Solutions Tried.
Uninstall, download new version then reinstall but to no use.
Set maximum permissions to current user (according to my knowledge).
Using Mix mode authentication.

PC configuraion:
XP Home Edition SP2,
Intel Dual Core 2.0 GHZ Processor
4GB Ram,
SQL Server express SP1 installed on NTFS Partition
Plenty of Disk Space
Comodo Firewall pro, Avast Antivirus ( Already tried to stop firewall and antivirus still no use)

Any help would be appreciated.

SQLExpress 2008 R2 64bit using NewName results in logical filename losing last letter in Backup


We have a problem that is only occurring on the 64 bit edition of SQL 2008 R2 (the 32 bit R2, and 64 bit original are fine). 

As part of our install we restore a database called TaxMasterFresh’ and rename it to ‘TaxMaster’. We have a step to rename the logical files of the database to complete the operation:



SQLServer 2008 R2 180 days Evaluation copy download


The download manager for the file


does not work. returns error:

The server returned an error. Would you like to retry.


Still does not work

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