I have developed a system with a front of Access 2003 with visual basic code accessing data on SQL server 2000 (enterprise).
I am in the process of migrating to Access 2007 and SQL server 200...
In my SQL Server 2005 Tables, there are some date and time columns with the follwoing shape: 1217147736160
How can I change it to a meaningful date and time format such as 'DD/MM/YYYY'?
I'm trying to schedule a daily job to pull out specific data from a table that gets added every night. I accessed Jobs icon under SQL server agent and proceeded to creating a job using 'new jo...
Please provide code for connecting a project developed in Visual Basic 6.0 with SQL Server 2008.
I am trying to retrieve simple data from 2 related tables in SQL. I want the data in XML format without using the FOR XML clause.
I would like the data to be in this format
<module>
...
Been fighting with sql and continually get errors when running this statement.
UPDATE [FSSINC].[dbo].[Customer]
SET [CustomerName] = CustomerName
WHERE <,,> i add the criteria. What i...
Hi,
I just installed the SQL Server 2008 (February CTP version) on a spare PC to see what its like. I noticed that :
a) the Management studio has some nice new features and
b) you can c...
I am trying to install SCOM 2007 on a Server 2008 using SQl 2008, during the pre-check it says I need SQl 2005 SP1. Makes no sense to me, I ahve looked on the MS SQL 2008 support site and cann...
Hello, what Account Name should I specify in the installation of mssql 2008 in the service accounts tab? Should I create a user?
Thanks
Hi
I have MS SQL 2005 EXPRESS AND SSMS 2005 on my desktop.
I want to install MS SQL 2008 EXPRESS and SSMS 2008. Do I need to uninstall the 2005 version?
I have a Trigger that fires off during an insert or update in one table. I need to get the ID for that line and send it to a stored procedure and use that ID to do some more calculations. I'm ...
<cfset datepassed = #DATEFORMAT(now(), "dd/mm/yy")#>
SELECT CONVERT(VARCHAR(10), TIMEDATE , 120) as varDate
FROM orders
WHERE YEAR(TIMED...
Hello
I have installed SQL Server 2008 Express Edition with Advanced Services (which includes the Management Studio) on a WIndows XP Client.
After the successful installation, I open the...
After upgrading to SQL-Server from 2005 to '2008 with tools'. I can open and reattach most data files through Sql Server Management Studio. However, one database throws an error and refuses ...
I have installed Server 2008 on a 64 bit system including SQL 2008 x64.
When the prerequisites are run it complains it is unable to find SQL Server 2005 SP1.
I have checked the firewall ...
I am a newbie with SQL, so bear with me. I need to create a SQL statement that will do the following. Read a customers file (a) and update the file when zip5 and zip 4 of customers file (a) ...
I would like to create a dynamic SQL update/insert statement based on some parsed data in a table in SQL and run this against an existing table in the same database. The issue I'm having is th...
I am building a database to work in a multi-user environment. It's currently planned to use a MS Access database on a networked location.
The database will be split with a front-end on u...
Hi, I have a Vista machine running SQLExpress. I want my WinXP machine to connect to the SqlExpress DB but I keep getting a "Sql Server does not exist or access denied" error msg.
I've dou...
Hi,
I am trying to duplicate an Access database table using SQL Server Express 2008.
The existing Access table has a Yes/No field (a boolean). This appears as a checkbox when viewing the dat...
I need to compare data between 2 fields (actually more but the solution to 1 will work for all). The values in these fields are intended to be money type data but the website stores the data ...
I would like to install MS-SQL Server 2008 on a box currently running MS SQL Server 2005 -- is there anything in 2008 that would prevent installation as a separate instance on a box running 20...
Hi
Does anyone know whether Microsoft have introduced a rich textbox control into reporting services 2008? We currently have a number of letters in crystal reports that we want to migrate o...
I'm learning how to use MSSQL, I have SQL Enterprise Manager installed on my machine at work. I was also given access to the databases so I could start creating reports using Crystal Reports. ...
Hello,
I work on sql server, and we have a table with a column that store a number from a java code with Date.getTime() function (it returns a long data type).
A previous solution seems to...
