I am running a SP that entries that are older than 6 months. These entries have a file associated with them. Is there anyway I can delete that physical file with SQL server too? Its a Win2K3 server with sql server 2000.
View 3 Replies
How to write a Sql Query for insert, Delete for Image from sql server 2005.
View 2 RepliesI have been searching for some information on how to import my xml file into a series of tables using a mapping file (schema).
View 2 RepliesI have a problem, I have created a website that is run on local host database is make in 2005 sql server
now i am using sql 2008 and visual studio 2010 , I attach the sql 2005 mdf file in sql 2008 server and run it working correctly when we host it then it is not working
problem gives "NT NETWORK SERVICE FAILED "
how we can convert the sql 2005 mdf file to sql 2008 file.
I have a web site that you can upload images, the image path is saved in the ImgPath field in the data database and retrieves the image and displays it in the grid view. I want to be able to delete the image from a folder within my project when I delete the record. I'm trying to delete it from the Detailsview_ItemDeleting event.
View 4 RepliesI am using VS 2008 with SQL in express edition . I have made my website and hosted it on server with cuteftp .Now i want to change
the website so when i tried to delete all files the App_data folder does not delete .
So i am unable delete my mdf and log file which are in this folder. It says file error.
I always use SQL in design window in VS and know less of coding in SQL.
I have 5 GB data, when I move from SQL server 2000 to 2008 with Import and Export wizard, my LDF size is increased to 30 GB, Can I reduce my LDF file or move. In my one of the table contain around 20 Lakh data which i have normalized in 2008 and create 4 tables, so my data is entering in normalized form in 2008. But due to size by hard disk is full. I have used shrnik command but it reduce to only 1 GB.
View 5 RepliesI have created database .sql file for create schema with export database. (its .sql file size is 48.2 MB)
View 1 RepliesHow to delete a file in server with out access denied error? Because File.delete(path) is working locally once if I put in IIS and access the application from another computer I am getting access denied error while deleting the file. How to resolve this.?
View 1 Repliesi am downloading a file from a server and i plan to delete the file that i have downloaded on the server after it gets downloaded on the client side. My download code is working fine but i dont know when to put the command to delete the file.
string filepath = restoredFilename.ToString();
// Create New instance of FileInfo class to get the properties of the file being downloaded
FileInfo myfile = new FileInfo(filepath);
// Checking if file exists
if (myfile.Exists)
{
// Clear the content of the response
Response.ClearContent();
// Add the file name and attachment, which will force the open/cancel/save dialog box to show, to the header
Response.AddHeader("Content-Disposition", "attachment; filename=" + myfile.Name);
//Response.AddHeader("Content-Disposition", "inline; filename=" + myfile.Name);
// Add the file size into the response header
Response.AddHeader("Content-Length", myfile.Length.ToString());
// Set the ContentType
Response.ContentType = ReturnExtension(myfile.Extension.ToLower());
//// Write the file into the response (TransmitFile is for ASP.NET 2.0. In ASP.NET 1.1 you have to use WriteFile instead)
Response.TransmitFile(myfile.FullName);
// End the response
Response.End();
}
Now i know the response.End() will stop every thing and return the value, so is there another way too do so. I need to call a function
DeleteRestoredFileForGUI(restoredFilename);
to delete the file but dont know where to put it.. i tried putting before and after Response.End() but it does not work.
i am trying to delete using Gridview from child first and check if there is no child to delete in parent table i am using sql datasource in the delete tab in sql datasource i put DELETE FROM table1 WHERE (IDtable = @IDtable) IF (SELECT count(*) FROM table1 WHERE parent_dtl_id = 66) =0
BEGIN delete from parent_dtl where order_dtl_id= 66 END
i deleted all items,deleting from 2 tables child and parent was successfully on the last row from gridview but i have this error on my page on the last delete Specified argument was out of the range of valid values. Parameter name: value
I am saving different file formats as varbinary in a SQL Server 2005. The web application is VS 2005 using VB.
How can I put a link in a page to the file saved in the database?
I have a requirement to fill the pdf file.
We are using Sql server and i want to transfer data from SQL server to pdf file.
i want create a file excel from sql server? how can i do?
and can i create it using also sqldatasource control?
I have a file delete option for the files uploaded by the user, user can upload many files at a time.The uploaded files will be stored in a folder in server and when its is deleted its is moved to trash folder from where it will be manually cleared.
when a user tries to delete many files in the web page IIS get hangs and all session is expired. This case only present in server,in local host this issue is not available.
ALL the operations is carried out completely ie
Database gets updated. Files is moved from upload folder to trash folder in server.
I cannot determine what is going wrong,I just tried to delete many files totally around 35-36 MB. Is the issue with process taking long or is there any changes have to be made in order to perform large files operation, my project is done on VS2005 which is running in 2008 server.
I a webproject in asp.net my project worked fine in my pc but after uploading it to a iis server it is not working.My webproject is to delete a file,
string s;
int i;
s = Environment.GetEnvironmentVariable("temp"); ;
[code]...
I am following this article [URL]
The code from the article is:
[Code]....
After commenting the lines in bold..I can upload word files too...The article also has
GenerateBrochureLink method...which generates link..but when i click the link to download my word file.i get some zip file...with xml.
How can i download the word file which i have uploaded with the view brochure link in gridview.
I have to create PDF Files reading data from SQL Server where the data is in Binary format as Image data type.
View 2 RepliesI am using an sql server 2005.
I want to insert to my table a column of some date,like that the user can insert a text file.
how to do that?
and how can I make that the user can only insert an int of length 9 for id?
I have a table with a varbinary(MAX) column. I want to use the FileUpload control to save the file directly there by a stored procedure. How do you do it without using SaveAs to create a temporary file first?
View 9 RepliesI created an MDF file in VS 2008 in the Solutions Explorer window and can see the file path for this file as:
C:Documents and SettingsAdminMy DocumentsVisual Studio 2008WebSitesAddSQLRecordsApp_Data
But when I try to add this MDF file in SQL Server 2005 Express, I click the Add button but cannot find this exact path above. How do I find this? I am running this on a 32-bit XP OS.
While writing to the SQL Server database, I might encounter the below error message:
"Error 823I/O error <error> detected during <operation> at offset <offset> in file
'<file>'"This error message may occur every time when I start SQL Server and access the MDF file.
How to port the data of a SQL Server table to a excel file?
View 8 RepliesFor my web application I need to allow the user to upload a word document to the database. I've searched the forums and I've only been able to find with uploading to a server. Can anyone one give me a link to a tutorial or step by step guide on how to do it? I'm not even sure what data type to set the attribute to in the database.
View 4 Replieshow can i write a sql to execute the file at specific time sql server database.
View 3 Replies
