Use this tag for questions specific to scaled down, free edition of SQL Server 2005.
Questions tagged [sql-server-2005-express]
193 questions
0
votes
4 answers
SQL Server 2005 Express
Can anyone decipher this error message? Somebody gave me a SQL script and when I run it, I get this error:
Thanks.
Skizz
- 1,211
- 5
- 17
- 28
0
votes
1 answer
SQL Server 2005 Express - generate script to create VIEW based on relational tables?
Is there a way in SQL Server 2005 Express to generate a script that would create a VIEW based on tables primary/foreign key relationships?
I have multiple databases with thousands of tables, and its very time consuming to look at the "table…
tdjfdjdj
- 2,391
- 13
- 44
- 71
0
votes
0 answers
cannot connect to SQLExpress usign node.js
I am using SQL Server (SQL EXPRESS) 2005 9.0.3042
I have poured through lots of examples.
Made sure TCP port 1433 open for all IP.
Made sure browser is started
Tried all kinds of config settings
using tedious or mssql
Just trying to find something…
prestonjb
- 1
- 2
0
votes
2 answers
Modify query sql
I have a query to aggregate (compress) data from 1 min to any other time frame, and it works perfectly.
Use StockDataFromSella;
DECLARE @D1 DateTime
DECLARE @D2 DateTime
DECLARE @Interval FLOAT
SET @D1 = '2008-09-21T09:00:00.000'
SET @D2 =…
Alberto acepsut
- 1,972
- 10
- 41
- 87
0
votes
3 answers
TCP Ports when Web Server communicates with SQL Server Express
We have a asp.net 3.5 web application running on a hosting company's web server that's got a very strict firewall setup. The web application communicates with our sql server express 2005 which is on a completely different network.
The problem is…
Morne Ferreira
0
votes
2 answers
SQL Express remote access
Is there any way to install SQL Express 2005 silently while configuring to allow remote access, or must the configuration be done with the SQL Server Management Studio UI?
Rob Hunter
- 2,787
- 4
- 35
- 52
0
votes
2 answers
Problem with saving data in tables in asp.net with c#
Hello i have a problem with my application today it encountered a major problem :
I'm using vs2008 prof with it's sql server 2005 express edition.
The problem is that when i try to make an update on a row in one table the update.executeNonQuery()…
Bogdan
- 11
- 3
0
votes
1 answer
How to delete two records from two tables?
Hello I need to be able to search for a record that is a year old and then delete it. I have this script which allows me to delete the record from one table, based on a date given by another table,however I need to add code to this so that I am able…
Leigh
- 133
- 1
- 10
0
votes
1 answer
Send an SMS as a User logs in to the sql server database with valid credentials
I want to send an SMS as a User logs in to the sql server database.
is this possible in sql express? please help me with the code.
i would use a trigger for sending the message. As soon as the user would log into an sql database with correct…
sqlchild
- 8,754
- 28
- 105
- 167
0
votes
3 answers
how to export / import batch of data to SQL Express 2005 in vb.net
I'd like to make a program module that exports all records from three tables in a database into a file at once(I means not adding row by row, maybe like BULK). Here I have some questions
Is it possible to export records of three tables into a file?…
soclose
- 2,773
- 12
- 51
- 60
0
votes
1 answer
export all sql table records in vs 2005 (vb.net)
Programmatically using vb.net, could we export all records of a sql table into a txt file at once?
soclose
- 2,773
- 12
- 51
- 60
0
votes
1 answer
Date only in sql
My data is like below
2010-11-09 13:20:02.000
I'd like to get date only. Which sql function will i use?
soclose
- 2,773
- 12
- 51
- 60
0
votes
3 answers
Error Opening CrystalReport viewer
I have this problem which I am trying to debug for a lot of time.
The setup is like this:
i. The application is a Windows application developed using VS2005, .net 2.0.
ii. I use the Cyrstal reports component Crystal Report Viewer and dynamically…
rAm
- 1,086
- 2
- 16
- 23
0
votes
1 answer
An error occurred during local report processing - SSDT
I am planning to shift from Crystal Reports to SSDT.
I have created a Report Project in Visual Studio and am trying to create a basic report pulling 3 columns from a single table.
My query is:
select SRNO, EMPSRNO, PYMONTH
from PYHeader
where…
Prasad Kamath
- 182
- 2
- 15
0
votes
1 answer
Validate data for a SQL Server stored procedure
I am used to using the validate object in ASP .Net to check the users input before I would execute the sp to insert the data into the DB.
How does one go about using a validate object in a win application?
I am using:
VS C# 2008 express
MS SQL…
Yaron Buki
- 81
- 2
- 12