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
1 answer

Unstable query in SQL Server

I am using SQL Server 2008-R2 Express Edition. I wrote the query shown below to generate number sequences from 1 to @n. In testing it (purely in a query window), I found that if I significantly change the value of @n, I get incorrect results.…
IamIC
  • 17,747
  • 20
  • 91
  • 154
0
votes
1 answer

SQL Server make Column data undeletable

I am using SQL Server 2008 R2. I want to make a column data undeletable. Is it possible to make the data undeletable without using Triggers? If it is, please let me know.
Aniruddha Nath
  • 11
  • 7
0
votes
2 answers

SQL Qry required to get a comma separated string from a table

In my database there is a table with values below image attached In need a qry to get the result like this
Shyam Prasad
  • 974
  • 1
  • 6
  • 17
0
votes
1 answer

How to make event/function in SQL Server 2008 R2 database instead of VBA Macros?

I have a SQL Server 2008 R2 Express database with one table. Windows XP. I wrote this macro to request table size and delete rows if the table bigger than I need, I call VBA from SCADA every 1 hour. Option Explicit Dim strConn As String Dim strSQL…
Роман Кириллов
  • 139
  • 1
  • 10
0
votes
1 answer

is adding reserved fields for future values a good idea

I have tables like Customer, Purchase etc which sometimes have associated documents with them, by documents I mean some file somewhere (like a scanned drivers license or something) We cannot have the application upload these documents straight into…
gideon
  • 19,329
  • 11
  • 72
  • 113
0
votes
0 answers

SQL Server 2008 R2 Express cant connect to my editors

I'm using SQL Server 2008 R2 Express to edit my database. I can edit my database with query codes but there is a editor program which can help me to edit my database easily. But when I'm trying to open this editor program, I get an error: No SQL…
Umut Turgay
  • 1
0
votes
2 answers

SQL Server Login failed for user after a couple hours

I've been struggling with this problem for a while. When I tried to connect to my database I'm getting the error 18456: "Login failed for user ". I've checked all my settings and everything seems to be fine. If I access to the server via Windows…
Maw Ceron
  • 319
  • 3
  • 9
0
votes
1 answer

SQL Server 2008 R2 Recordset apears not created

Environment: SQL Server Express 2008 R2, EW4, Windows XP SP3 Here are a few important program statements from the ASPX page. conn=Server.CreateObject("ADODB.Connection") conn.Open (connString) --> conn.State = True sql1 = USE [my_db]; SELECT *…
kennr
  • 49
  • 1
  • 1
  • 6
0
votes
3 answers

Simple SQL Bulk Insert not working

I'm trying to create a simple Bulk Insert command to import a fixed width text file into a table. Once I have this working I'll then expand on it to get my more complex import working. I'm currently receiving the error... Msg 4866, Level 16, State…
David P
  • 411
  • 7
  • 21
0
votes
0 answers

DataGridView CheckBox Functionality Not Working

I have a DataGridView that has CheckBox Field. I am trying to update Checkbox values in database. But it's giving me this Error. I already implement method ufGview_DataError with value e.Cancel = true. I am interested to store 0 when it will be…
Mistr Mowgli
  • 131
  • 1
  • 3
  • 10
0
votes
1 answer

Export contents of SQL Server 2008 R2 table to CSV WITHOUT xp_cmdshell

I need to export the contents of a SQL SErver 2008 R2 Express table to a CSV or TXT file. I cannot enable xp_cmdshell nor can I allow ad hoc distributed queries. It needs to be executable from a trigger on one of the tables.
Maa421s
  • 159
  • 1
  • 12
0
votes
1 answer

Cannot connect to SQL Server Express with SSMS and SQL Server Authentication

I've been using SQL Server Express with Windows authentication for many years with no problems. However, for a different application I need to use server authentication. I'm running SQL Server 2008 R2 Express. Here is what I've done so far in…
bdristan
  • 1,048
  • 1
  • 12
  • 36
0
votes
1 answer

Database in restoring state

Hope to get a solution on my issue facing in SQL Server 2008 R2 Express. One of my colleague mistakenly restored a database in my working database. While getting restored he realize the error & cancelled the operation in between. Now the database…
Amy
  • 1
0
votes
3 answers

How to Check Valid Date Time from Sql Table

I want to check either my current DateTime is between two DateTimes or not. I have first time 2016-05-19 04:23:00.000 and second time 2016-05-19 04:50:00.000. How to write a query to return true if current DateTime is between first and second time…
Jani Mani
  • 27
  • 6
0
votes
1 answer

Mdf file is not attaching in Sql Server after data written in mdf file by windows application

I developed a windows based application where I use .mdf file for backend operations. When no data is passed through application into .mdf file that means a fresh .mdf file, I am able to attach this .mdf file in my SQL Server 2008 R2 successfully.…
RosiReddy
  • 27
  • 3
  • 14
1 2 3
…
14 15