.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

Text box Properties / Action and url calling a file:\\ SQL Server 2008 R2

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


I have installed the new version of sql server 2008 r2.  It looks like it does not support file:\\ in the url only http, https, ftp, mailto and news.  I need to use file:\\dir\filename.ext any idea of how to do this.


Thank you again



View Complete Post

More Related Resource Links

reading text file using sql server 2000 , 2008



can any one tell me how to read the data's in the text file using sql server 2000 and 2008.

i have a text file in a server and it contains one column name with the multiple column values i need to read that informations and i need to update in a table in the database.

how can we do this.



Windows Server 2008 + IE 8 + Text File


Hi  friends i am using VS 2008. My Problem is in Report Spooling. I will read some textfile(Notepad file) from particular folder, it will be good in( IE 6 & Windows XP), when i run same in windows server 2008 & IE 8 its not working alignment is mismatching in WS 2008.

When i read textfile using Solutions its working fine & reading text file using Publish Url its not working, alignment mismatches,

Help me!

Thanks in Advance

Read a text file on another server from a web page

How do I read/write a text file on another server from a web page. I get the error "Access to the path '//Server2/mydatafiles/test.txt' is denied". I do not get the error if I am running the browser on the server where the files exist. I think I need to set permissions on the destination server in some way.   Can you help? Thanks  

LDF File Disaster in SQL Server 2008

I am working on a startup company and the "dba" recently quit...come to find out he let the LDF file grow to 105GB - which effectively shut down the server due to lack of disk space.  I need to serious help as this database is also supporting our replication system and thus I cannot do anything drastic like detaching, deleting the LDF file and reattaching. I tried the shrink file option but the LDF file did not shrink at all.  I set the recovery model to simple, then tried shrinking and that did nothing.  This is a SQL Server 2008 machine - can somebody please help? Also, given that I am mainly a developer, is there some EASY reference on how to setup log file backups so this does not happen in the future?  Do I just perform a full backup every 30 minutes over-writing the previous backup, differentials, what? Thanks!

How to create a SSIS package to import records form SQl Server 2008 tables to text files

I am a newbie to SSIS and would like to create a package to accomplish the task referenced in the above title. Will appreciate any links and pointers in the right direction.   Thanksakoranteng

Restoring a BAK file via SQL Server Express 2008

How can I restore a BAK file that I received from a vendor.  They were unable to find a database schema for us so they just sent us a BAK file.  I'm using SQL Server Express 2008

Calling WCF Service from SQL Server 2008



        I'm facing a problem in accessing a WCF Service from a stored procedure in SQL Server 2008. The error obtained is as follows. An pointers to solve this issue wud be very helpful.

Msg 6522, Level 16, State 1, Procedure USP_CLR_ADD, Line 0
A .NET Framework error occurred during execution of user-defined routine or aggregate "USP_CLR_ADD":
System.TypeInitializationException: The type initializer for 'System.ServiceModel.ClientBase`1' threw an exception. ---> System.Security.HostProtectionException: Attempted to perform an operation that was forbidden by the CLR host.

The protected resources (only available with full trust) were: All
The demanded resources were: Synchronization, ExternalThreading

   at System.ServiceModel.DiagnosticUtility.GetUtility()
   at System.ServiceModel.DiagnosticUtility.get_Utility()
   at System.ServiceModel.ClientBase`1..cctor()
   at System.ServiceModel.ClientBase`1.InitializeChannelFactoryRef()
   at System.ServiceModel.ClientBase`1..ctor()
   at TestServiceClient..ctor()
   at Channel.ServiceChannel.GetSum()


Cannot attach a database file to SQL server 2008 Express


When I try to attach a database using SQL server 2008 express version, it gives me an error message.  it says

"Msg 18456, Level 14, State 1, Server LINDA\SQLEXPRESS, Line 1
Login failed for user 'LINDA\Linda'"

How can I fix this error?


property setting in report server (2008) config file is not working as expected.



I have set the <WorkingSetMinimum> property to 2.4GB in my reportserver 2008 config file.

By defintion, <WorkingSetMinimum> setting means,

  1. Lower limit of service memory consumption; memory will not be released if the consumption is below this amount, though the service will not reserve the designated amount of memory when it starts.
  2. If service uses more than the designated amout of memory, it will release back the memory only till this declared value and not beyond that, which means it should keep 2.4GB as designated.

See this link for definition: http://books.google.com/books?id=mzY_Xo_9J-gC&pg=PA589&lpg=PA589&dq=What+is+%3Cworkingsetminimum%3E+in+report+server+configuration+file&source=bl&ots=r_xhRp8erj&sig=E_o0-Dh2SXOgMNrW3sptt5oZrYI&hl=en&ei=f5mjTNeNM5O8ccmErJMI&sa=X&oi=book_result&ct=result&resnum=4&ved=0CCAQ6AEwAw#

SQL Server 2008 R2 Disk Usage report showing incorrect data file


When I go to ANY database (System, AdventureWorks*, user) in Managemant Studio, I right-click on the db, select Reports, select Standard Reports, and select Disk Usage.  The disk usage report shows the correct db on top, but always only shows AdventureWorks_Data.mdf when I expand Disk Space Used by Data Files section.  This happens to any db I try.  When I look at Database Properties/Files for that database, the logical and physical file names are correct.

Since the correct files appear in Database Properties/Files, I'm hoping it's just a bug in the report.  Same thing happens if I run a Disk Usage by Table report for ANY database,  The tables for AdventureWorks always only appear,

Thanks,  Mike

Enable Full Text Index in VWD 2008 / SQL Server Express 2008


 Hi, I am using VWD 2008 Express and SQL Server 2008 Express. I want to enable full text index in some of my table. How do I do that? I only have  SQL Server Management Studio Express 2008. As far as I know, I cannot use SQL Server Management Studio Express 2008 to update the full text catalog according to : http://msdn.microsoft.com/en-us/library/ms365247.aspx

My tables are also not enable Full Text Search by default. 


 Any help would be very much appreciated!

 Edit 1: Someone had a similar problem to mine on this link: http://forums.asp.net/t/1169961.aspx
I installed the Sql Server 2008 Express with Advance Services and made sure that Full Text functionality is installed. However I don't get a full text menu in SQL Server Management Studio. 

 Edit 2: I uninstall and reinstall SQL Server 2008 Express with Advance Services but still couldn't be able to enable full text index.

 Edit 3: After see this, I guess I have to do it manually then:  http://forums.microsoft.com/MSDN/ShowPost.aspx?siteid=1&PostID=3912985

Unable to change autogrowth properties of SQL Server 2008 data and log files


I have used the GUI and the CLI to attempt to change SQL Server 2008 log file autogrowth property all to NO avail. In other words, there are NO error messages of any kind, indeed the CLI reports that the command completed successfully. But re-examining the database properties shows that NO change was effected.

For the CLI command, I have used the following with dots filled in for my database and logfile:


Why doesn't this work? How to make it work?


uploading CSV file to SQL SERVER 2008



I want to upload csv file to sql server on my web portal website with validation check. Any ideas or any tutorials of uploading the csv file on to sql server 2008.

How to check for file exists on remote server in ssrs 2008?

I have a report that needs to display images that are stored on a remote web server. The problem is that I also need to check if the file exists first otherwise I get those annoying image not found red X's.

I tried entering the code at the bottom in the custom code section of the report which works if I run it on my local machine however it doesn't work in SSRS 2008. After doing a little trial and error I found it seems to be failing on the first line in the function,

Dim request = System.Net.WebRequest.Create(New Uri (fileURL))

Is there some specific permissions or configuration change needed on the SSRS2008 server for this code to work? Or is there a better way to do this?


Public Function CheckRemoteURL(ByVal fileURL As String) As String
Dim request = System.Net.WebRequest.Create(New Uri (fileURL))
request.Method = "HEAD"

Dim returnURL = ""

Dim response = request.GetResponse()
returnURL = fileURL
Catch ex As Exception
returnURL =""
End Try

Return returnURL
End Function

SQL Server 2008 file permissions


We're converting from SQL Server 2000 to 2008. We've set up a new DB server (Windows 2003 Server), we've installed SQL Server 2008. We've installed a few databases. Things seemed to be going well. Then...

I'm trying to move over a database from the old server to the new. I've tried detach/copy/attach and backup/copy/restore. I'm putting the file in the default database location (D:\MSSQL\Data or D:\MSSQL\Backup). But then I find that SQL Server can no longer access that location! I get a message that says:

"Cannot access the specified path or file on the server. Verify that you have the necessary security priveleges and that the path or file exists".

This as soon as I click on Add on the Specify Backup dialog or on the Attach database dialog.

I've tried: logging in with SQL Server authent. and Windows authent.; checking and changing permission on the folder and file; basically everything I can think of.




SQL Server 2008 r2 - Setup support files - Install error / reading from file


I'm installing SQL server 2008 r2 on a Win2003 R2 x86 system.

After i start the setup, the "setup support files" box begins installing, after a while i get this error:

"Error reading from file f:\1033_ENU_LP\x86\setup\sqlsupport_msi\PFiles\SqlServr\100\Setup\ewbfphdh\x86\Patch\rs2000.msp verify that the file exists and that you can access it."

I've tried another DVD, i've tried a mounted share on another machine...no go....i've tried an ISO file mounted on this server... same error.

Is there any way i can install this "setup support files" from another location? (download)

Is there a switch soo it won't install reporting services? (...i think this file rs2000.msp is from reporting services)





Parameter error writing to excell 2007 file using SQL 2008 Server Agent JOB, works in BIDS.


I am getting the following error message when I try to run a script that writes to an excel file calling my Package with a SQL 2008 JOB.

Executed as user: xxxx\xxxxxxx. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.1600.22 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Option "12.0;HDR=YES;" is not valid.  The command line parameters are invalid.  The step failed.

This same package runs correctly if I execute it in dev mode in BIDS.  I had to set 64bitmode to false in Dev mode to get it to work.  I set executable options in the job step to 'run in 32 bit mode'  The error message indicates to me it is trying to run in 32 bit mode which should be correct but it doesn't like the extended parameters. .   

Here is my connection string from the data sources tab on the job

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\xxxx.xlsx;Extended Properties="EXCEL 12.0;HDR=YES";

This was filled in ny the connection object for me.  I have read the article closely at http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html and still can't figure out what I need to change. 

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