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...
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...
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...
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...
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 ...
Please provide code for connecting a project developed in Visual Basic 6.0 with SQL Server 2008.
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 ...
I am trying to upgrade a SQL Server 2005 Standard x64 instance running on Windows Server 2008 Enterprise x64 running on VMware ESX 3.5 Update 2. At first I thought it was a bad ISO and so redo...
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>
...
Hi,
I have an integer field in a table. I like to perform a division and store the result in this integer field, rounding to the nearest whole number. The round function only rounds down,...
Hello, what Account Name should I specify in the installation of mssql 2008 in the service accounts tab? Should I create a user?
Thanks
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 ...
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 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...
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...
Was using this RoundTime function on a SQL 2000 box for the longest time, and it worked well. I use it to round datetime fields to the nearest (in this case) 5 minutes.
When I brought it ov...
Let me start off by saying I am a complete novice to Sql Server. I have no problem connecting to SQL 08 on a my standalone computer but what I would like to do is have it on a LAN and be able...
I have a Sharepoint 2007 site installed in a stand alone configuration on a machine.
I also have SQL Server 2008 with Reporting services enabled on this machine.
I have changed the working ...
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 have just installed Windows Server 2008, SQL Server 2008 and VisualStudio Team Suite 2008, applied all updates, including hot fix KB956717. When I try to render any Reporting Services repor...
I recently installed both versions of SQL Server 2005 and 2008, and am running into a roadblock as I have yet to come across any proper documentation on how to create a database and table. Is...
Hi,
We have a newly installed SQL 2008 server running on Server 2008 x64.
We have created various AD security groups used to assign permission to various databases such as database reader...
Hi - if anyone can help with this query I'd be a very happy girl :)
I am using SSIS. In my package I have an xml source that retrieves an XML structure simliar to (scaled down for readibili...
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...
