I would like to be able to run an on demand backup of a .Net MVC app's SQL Express 2008 database to eg a flash stick plugged into the machine running the app. I tried QuickstemDataContext db = new QuickstemDataContext(); string quickstem_path = Path.Combine(save_path, "quickstem.backup"); db.ExecuteCommand(string.Format("BACKUP DATA...
I have installed Team Foundation Server 2010 (basic configuration) on a Windows Server 2003 without any problems. But when I go to administer the Team Foundation Server Administration Console, I get the error when in the press "Administer Security" or "Group Membership" Server was Unable to process request. ---> Team Foundation services...
I have a Database with some tables, I wanna to run a method in C# whenever some data is written in the tables. I know I have to use triggers, but I don't know how!!! It would be appreciated if you guide me. P.S: I'm using SQLExpress 2008 ...
Assume one fine day an admin comes to the office like he always does to do his admin tasks on Sql Server Databases and to his surprise finds a database missing. He has no clue of who dropped it or was it from an external batch or SQL injection etc ... where do one start an investigation and what are the important parameters/ findings tha...
I'm stumped. I have a client site on a virtual private server - Windows Web Server 2008 SP2, IIS7, SQL Server 2008 Express. I'm trying to setup a second web application, to allow him to review updates prior to their going live. I've created the web application in IIS7, and I have added a second database to SQL Server. The second db i...
I went through MSDN pages to learn ADO.Net using Commands. I am able to read using the sample code posted there. But when I tried to use the modification code below, the insert is not happening. I am not ale to figure out why. Can someone please tell me what is wrong with this code? string connectionString = "A_VALID_CONNECTION_STRING"...
Hi everyone I need to execute a sql query from within a c# class. I have thought of 2 options Starting a process of sqlcmd. Using a SqlCommand object. My question is which would be the better way? It's important that the solution only holds a connection to the server for a short time. I'm open to other ideas if the above aren't goo...
When i attempt to deploy a SQL Server Report, i get the following error: An attempt has been made to use a data extension 'OLEDB-MD' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound) This error occurs only when i try to deploy a certain report. Rest...
How can I create a SQL user in a SQL Server Express database that I added to my project? I need to create a user to use in a connection string that doesn't use Integrated Security. ...
The ASP.NET web application I am developing needs to support two different types of databases, namely Access and MS SQL Server 2008 Express. I already have connection strings for each database type stored in web.config, and I have another web.config value that specifies which one to use. So I can get the proper connection string with no...
I have a simple SQL query that updates some date fields in a record, on a SQL Express instance. I'd like to have it run automatically every month. What is the best way of accomplishing this in SQL Server 2005 Express using the Management Studio? ...
Hi, While trying to bulk insert 3M records from CSV file to SQLExpress database the procedure throw the timeout exception which was set to 30s. I tried to set the Connect Timeout to 1800 but again the procedure threw the same exception. Does anyone know whether the exception is thrown due to too many records or the timeout was not set ...
I have two tables. One is a 'Users' table. Each row (user) in the table has a unique id (primary key). The second table is a 'Tasks' table. Each row in the Tasks table has a foreign key which points to the user (in the Users table) that owns that task. Using SQL Express 2008, what query must I use to obtain a list of all tasks assigned...
I'm new to TVP in SQL Server and trying to understand the basics. I created a sample TVP in the Northwind database in SQL Express. My code from VB.NET is fairly simple (see below). The TVP parameter is empty in the procedure. I've tested the TVP in SQL Server and it works fine. Any ideas? Does SQL Express fully support table value parame...
New to actually deploying a Asp.Net MVC web application with sqlexpress in the App_Data folder, how would I handle database updates after it is live and in use. Here's my scenario and a few questions: I have an Asp.Net MVC 2 Web app w/ sqlexpress databases: [myappData.mdf, aspnetdb.mdf]. I was planning on publishing this to the produc...
My C# .NET 3.5 application uses MS SQL Server 2008 Express. I am writing huge amount of data to the database. At some point I get an exception: {"Could not allocate space for object 'dbo.Attachment'.'PK_Attachme_3214EC0707020F21' in database 'Cases' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, d...
Hi.I want to make setup for my project and i have one folder "Resource" in this path ..\bin\Debug.now how can i make setup file ,that when i install setup "Resource" folder with it's files become created in the install folder ? my database is sqlexpress for my database file what should i do?it's folder is App_Data in ..\bin\Debug path.Th...
I am trying to get query notifications to work, but my application is not receiving any notifications. How do I debug Query Notifications? I am using the code availble here http://www.codeproject.com/KB/database/chatter.aspx. I can see that the queues, the services and the stored procedures are being created on the server, but the OnCha...
If i have a server with ASP.NET 3.5 installed, where no one explicitly installed SQL Express. Can my web application still connect to an MDF file in the App_Data folder ...
Hi, How do I permanently set the date format for SQL Express to be UK format (dd/mm/yyyy). I know I can use SET DATEFORMAT DMY, but this only works for that connection. I have also seen, exec sp_addlanguage 'British', 'English', 'January,February,March,April,May,June,July,August,September,October, November,December', 'Jan,Feb,Mar,Ap...