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
1 answer
How to configure SQL Server 2005
I have just downloaded SQL Server 2005 express edition from here:
To be used as a database for a vb.net program.
But I'm confused in using sql server. I do not know where to start from here:
http://screencast.com/t/ZTdiMDU5
Do I have to create the…
user225269
- 10,743
- 69
- 174
- 251
0
votes
2 answers
SQL Server Express 2005 set tcp listen port using command tool
I am making silent installation for SQL Server Express 2005 using the following command
SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SAPWD="****" ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,Client_Components,Connectivity,SDK
I need to know is…
zac
- 4,495
- 15
- 62
- 127
0
votes
0 answers
SQL query times out although all records have been read
For several years I've been using a C# application that is using a SQL Server 2005 Express database with about 250 tables. What could cause suddenly (never happened before) a simple SELECT * query from a single table to read all records from the…
0
votes
1 answer
How to Attach and Detch the database
HI guys I have 2005 database I attached to 2005 instance how to convert it to 2012 SQL
after I do attach show me this. so what is the next step can you provide some guidelines please. thank you in advanced
user3398348
- 59
- 1
- 1
- 6
0
votes
1 answer
How to get Server time without using GET DATE()
I'm having a hard time of searching about retrieving/getting server time without using GET DATE(). My previous application, I used GET DATE() and it works but when it is installed in local pc(multiple users) the get date is not the same just like…
rayncorg
- 963
- 4
- 16
- 33
0
votes
1 answer
Multiple Selection in T-SQL and Transpose one cells to another's rows
I have a project that has dynamic field details for an asp page. When the page is executed, the database is queried for the list of dynamic fields and then all the controls are created at runtime on the asp page. Now all these dynamic fields have…
Cyberpks
- 1,401
- 6
- 21
- 51
0
votes
2 answers
SQL Mangement Studio Cannot show requested Dialog
When using Server Management in SQL Server 2005 Express with Visual Studio 2010, I get the following error when attempting to add a database:
What could be causing this? I already verified that the service is running...etc..
InCode
- 503
- 3
- 8
- 25
0
votes
0 answers
Use Javascript to connect to local SQL Server 2005 express Database
I am creating a local html application (that will not be used over the internet) on my home computer. I have setup a SQL Server 2005 Express database and am having the hardest time finding a connection string that works. I've tried all the…
Micah Chaney
- 71
- 1
- 2
0
votes
1 answer
Any way to send mail on SQL trigger (without using the paid services)?
I have SQL Server 2005 with Management Studio Express. Is there a way to send an email in a SQL trigger without having to buy the Agent or Database Mailer?
I've heard something about a sendEmail program but I can't figure out what to do to configure…
Vantalk
- 367
- 2
- 5
- 21
0
votes
3 answers
Creating a Database Server for home use in SQL Server 2005 Express
I am looking to create a database server that can be used to store data using a VB.net application. When I initially installed SQL Server 2005 Express edition, I believe I installed this using the LocalDB option.
As it stands my application is a…
dmoney
- 861
- 2
- 16
- 24
0
votes
0 answers
How to Split String in Sql Server 2005
I am using SQL Server 2005 Express (not mysql).
I have a string
str = 'E1 ; abc ; E2 ; def';
I want to split string str with respect to delimiter ; and then insert values into table as follows:
Name Value
E1 abc
E2 …
Adwait
- 23
- 6
0
votes
1 answer
SSAS Processing tasks Optimization
I have 10 Dimensions and 10 MeasureGroups
I tried to process a particular MeasureGroup(say MeasureGroup-1) and associated dimensions(Which i saw in a window while > Right click on cube > newQuery > MDX >Selected MeasureGroup-1 in dropdown list) in a…
user2889510
- 11
- 2
0
votes
1 answer
Cannot connect to SQL Server 2005 Express account with sa
I was trying to connect to my SQL Server 2005 Express instance with the sa account but I can access to other instance with sa.
Please let me know how to connect how to connect to SQL Server Express instance with sa account.
I have tried this link…
0
votes
1 answer
Deploying and SQL Server 2005 Express connecting for a standard user
I have tried days to find solution maybe simple problem as newbie with SQL. A program is coded using SQL Server 2005 Express and for installing is used InstallAware Express, which was included with Delphi X package. Deploying and using later on…
KaEl
- 1
- 2
0
votes
0 answers
provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server 2005
I have deployed one vb.net desktop application and sql server is used for backend. It is properly working on local machine but when accessing database from remote machine it giving the error in the title.
I have done these things already:
Started…
madhura
- 1
- 1
- 1