Stack Overflow
Stack Overflow

Questions tagged [sql-server-2008r2-express]

Use this tag for questions specific to scaled down, free edition of SQL Server 2008 R2.

223 questions
0
votes
2 answers

Unable to sent mail in sql server 2008 r2

I have installed SQL server 2008 r2 express in new machine. I have configured some profile in msdb database. I tried EXEC msdb.dbo.sp_send_dbmail @profile_name = 'DBMAIL', @recipients = 'sakthivels@c8888ht.com', …
Singaravelan
  • 809
  • 3
  • 19
  • 32
0
votes
2 answers

Can I use one .mdf file with multiple DBMSes (SQL Server 2008 and 2012)?

At home, I have SQL Server 2008 R2 (Express) installed which is attached to a certain .mdf file. I'm in the process of installing SQL Server 2012 (Developer Edition). Can I attach 2012 to the same .mdf file? Logically, it seems like this would work…
Hugh Seagraves
  • 594
  • 1
  • 8
  • 14
0
votes
3 answers

Connecting Database using c# in Visual Studio 2013

I have a problem connecting my database (created in SQL Server 2008 R2 Express) with c# in vs 2013 Here is the code I wrote string connStr = ConfigurationManager.ConnectionStrings["newSchool"].ToString(); SqlConnection conn = new…
user3100088
  • 335
  • 3
  • 8
  • 20
0
votes
1 answer

SQL data export: The ConnectionString property has not been initialized. (System.Data)

I am trying to export my database as .Net SqlClient Data Provider format but I keep getting this error message The operation could not be completed ADDITIONAL INFORMATION: The ConnectionString property has not been initialized. (System.Data) Program…
Justin
  • 3
  • 2
  • 3
0
votes
0 answers

sql connection from visual studio 2010

I have an asp.net website that I am trying to connect to a SQL Server 2008 R2 Express database but I keep getting the error shown below. I am developing in Visual Studio 2010 and SQL Server 2008 R2 Express
Zidane
  • 1,696
  • 3
  • 21
  • 35
0
votes
2 answers

What to know SQL Server 2008 R2 Express Stored Procedure is currently executing or not before execute

I have a stored procedure GenerateAttendance, execution time will take approx 3-4 min. Meanwhile my program requests the same stored procedure for execute. I want to restrict my program from executing it if it's currently running. Is there any way,…
gbbosmiya
  • 509
  • 8
  • 23
0
votes
2 answers

SQL Server : get name for each id in a row from another table (ASP.net)

I am developing a site in VS2010 using SQL Server 2008 R2 Express and C# My tables are like: Table 1 I want to write a query that will select all rows from table 1 but instead of showing choice1 or (2..3)'s ID, it will grab their name from table…
Sakir Khan
  • 15
  • 1
  • 5
0
votes
1 answer

ASP.net Showing just Date (without time)

I am using VS 2010 with SQL Server 2008 R2 Express to develop an ASPX page In my database there is a column of type Date. I stored data in dd/mm/yyyy format. Didn't put any time there and it doesn't show any time when I view table data in SQL…
Sakir Khan
  • 15
  • 1
  • 5
0
votes
0 answers

SQL Server 2008 trigger inserting multiple rows

I am new to triggers and what I do know is self taught, so please bear with me and keep it simple! I have created a trigger to capture data changes (I'm using SQL Server 2008 R2 Express) but I can't understand why I'm getting two rows inserted into…
Heather Webster
  • 1
  • 2
0
votes
2 answers

SQL Server Express - Connect from remote machine

I have two Win 7 64 bit machines. On the first one I have installed SQL Server 2008 R2 Express and have no trouble connecting via Management Studio with Windows Auth and also via SQL Auth with a user I set up on the database. On the second machine I…
David
  • 1,203
  • 6
  • 25
  • 48
0
votes
1 answer

How to install sql server 2008 r2 express silently using installshield

I have created a C# Windows application and used SQL Server 2008 R2 for database. So I need to install SQL Server on my client's machine to run my application. For this I have created a setup using Installshield and added prerequisites SQL Server.…
Raghubar
  • 2,768
  • 1
  • 21
  • 31
0
votes
2 answers

T-SQL syntax to remove CR LF only on END of text string

How can I perform a replace query only on the end of a string where a hidden CRLF are present? Something like this but only at the end of the string not anywhere within the string declare @NewLine char(2) set @NewLine=char(13)+char(10) update…
htm11h
  • 1,739
  • 8
  • 47
  • 104
0
votes
2 answers

Incorrect float data is inserted

In my SQL Server i have a table with a column called FloatValue With a Float data type. I update this value from a WCF service with this method: public int UpdateConfig(float value) { try { using (SqlConnection conn =…
Yoav
  • 3,326
  • 3
  • 32
  • 73
0
votes
3 answers

Execute sql script on SQL server using C#

SQL Server 2008 R2 Express, .Net Framework 4.0, Visual Studio 2010 I'm trying to execute a SQL script from a command prompt application. I found a sample code and trying to implement the same. But the following using statements are not recognized.…
Kurubaran
  • 8,696
  • 5
  • 43
  • 65
0
votes
1 answer

Cannot connect jdbc to sql server 2008 r2

I am using sql server 2008 r2 sql express. I usually connect to my sql like this: Now I want to connect to sql server 2008 r2 from my eclipse. I searched google and I found that I have to download a jar file and I did and I added it to my project…
Marco Dinatsoli
  • 10,322
  • 37
  • 139
  • 253
1 2 3
…
14 15