I have SQL server express version installed on windows XP professional. It is running, accessible via Management Studio, and Visual Studio with "Computname\Sqlexpress" name and work fine with SQL ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2350...
Greetings,
I am running SQL Server 2005 Express Edition and the msb database is marked as suspect. I've tried using the different tools and links provided but haven't had any success trying to r...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23048075.html
Hi Experts,
I'm unable to establish concurrent connections to SQL Server 2005 Express Edition.
When I open SQL Mgmt Studio, if a SQL Server is being used by my ASP.NET web application I get a...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23058594.html
I've been asked to write an application for a small volunteer organization. I need to set up a database (I refuse to use MS Access for any part of this). We have a very small budget and one compu...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23213606.html
Hi,
I'm working on an attendence system. In this attendance system, I would like to join two tables.
Table 1: Consists of Subject_name, Date, Student_id, Enter_time, Exit_time
Table 2: Consi...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2334...
I want to connect my access front end that i currently have to an sql backend that i am desinging. Could any one give me some assistance please?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2339...
I have two tables say, EmpDetails and EmpSalary. The structures are below:
EmpDetails
-------------
EmpID int Primary Key Identity
EmpName varchar(30)
EmpSalary
------------
EmpID i...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2340...
Hi
What are the limitations of SQL Server 2005 Express Edition? I need to setup a demo using SQL Server but do not want to buy the full up version.
Thanks!
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2348...
In of my tables, 4000 rows are added every time an insertion is made. I want to add a RowID field of datatype "bigint" so that while deleting I can pick the RowID and delete a row. I don't want to ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23598481.html
I want to create a stored procedure that creates a new ID for the Row that is about to be inserted. The ID must be in this format:
Current Year + Current Month + Max Record Number of this Year a...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23598551.html
