Summary: Hi, I have a quick question regarding unions in SQL 2005 (using express edition for development at the moment). I am setting up somewhat of a stock ma...
Summary: Quick general question... We have the trial version of SQL 2005 installed and now have the full version ready to be installed. I have read that i just...
Summary: I am still researching the procedure for upgrading my trial version of SQL 2005 to the retail version. If anyone has a good article on the procedure ...
Summary: I am not a sql db manager by any means but I've been asked to reset the sa password for a sql 2005 server. My concern is ...will changing this passwor...
Summary: Hi people, I have a question about SQL 2005 stored procedures. I have a stored procedure that determins the current price of a stock item and I want t...
Summary: I figured this out myself. For reference, the problem was that i had installed sharepoint 2003 on a machine running sql 2005 and it wouldnt go throug...
Summary: Hello Forgive my poor SQL knowledge. Im looking after an SQL 2005 machine which i inherited. I typically just need to maintain it, however, Im after g...
Summary: I have a sql database that I need to monitor with nagios but it will not work with sql 2005. I was wondering if a sql query that can watch the databas...
Summary: I want to attach a database to SQL 2005, but i am restricted as to where the database backup file can be in. I would like it to be in my documents/.....
Summary: I have a table which stores a date value. From this value I want to do a select statement which adds 28 days to the value in my table. I understand ...
Summary: After installation of SQL Server 2005 Developer Edition, only have Configuration Tools available, I have XP SP3, and I have SQL Server 2000 already in...
Summary: hi all, have a sql question. i have a table which has a column varchar2(10) which holds employee numbers e.g 'X1234'. I need to update these and...
Summary: I find myself very confused regarding database tools and a matter of what does what and what is capable of what. For a personal endeavor of mine, i wi...
Summary: I have developed a few reports on SQL Server 2008+VS 2008 and deployed them to the SSRS built in reporting URL (http://servername/reports) During the ...
Summary: Hello, i am interested in learning Microsoft SQL, and possible take a low level cert. I would like to start off as inexpensive as possible, so this we...
Summary: OK i first want to apoligze for posting a message a couple of months ago about the same issue. It's just that i have no idea what i am doing but i wan...
Summary: I'm rusty with my SQL, but couldn't you do this?INSERT INTO A(primary_key, Name) SELECT sequence.NEXTVAL, name FROM SELECT DISTINCT name FROM B; ...
Summary: Hi, We have just installed visual studio 2008 which includes sql server compact edition 3.5. We want to export an sql server 2000 based database to ne...
Summary: Hey all. I have a quick question on my sql, im a bit new to the the commands ect and havin a bit of bother tryin to figure out how to do the following...
Summary: Hey everyone, im taking an SQL class and im working on my first assignment. It seems simple but i keep getting an Error 1062, duplicate entry '1' for ...
Summary: Hi, I have an issue i need to display a date say (14-sep-2005 11:20:00) as 14-sep-2005 12:20:00) and (22-dec-2005 11:20:00) as (22-dec-2005 11:20...
Summary: Hello, I just installed SQL Server 2005 Express, and am having trouble starting the Service for it. I accessed the SQL Server Configuration Manager, a...
Summary: Hello, I have been stuck on an SQL statement I have to write for class for extra credit. I have been trying to figure it out for literally hours. If...
Summary: Hi The question is: I would like to know how to upload images into a database from a web page and can I use ASP.Net 3.5, SQL Server 2005 and VB with M...