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...
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 ...
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,...
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 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 ...
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...
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...
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...
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...
I am trying to create a table in SSRS that lists various categories of items, and then the aggregated totals - but sorted by the total, not the alphabetized category. Even if I directly indic...
Hello All,
I am trying to create a stored procedure that will create another stored procedure in another database. Every time I try to use the stored proc I get the error that the "Identif...
There is an address list that is kept in Excel 2003 with 3 Columns ( Name, CompName, CompAddress). I am building a web-app that will allow users to edit the maililng list. First step was to br...
Hi
I did not create any SQL trigger or procedure before. What I need is that I three tables as:
1- Parent [Employee]: EmpID (PK), EmpName ...etc.
2- Child [EmpCourse]: EmpID (FK), CourseN...
timeout occurred when trying to save a table that had a new primary key added. It's timing out at about 3 minutes, how can this limit be increased?
hello experts.
i need some urgent help regarding my sql server 2008 server.
i am teaching some people about the new features of sql server 2008 so i need to sort this out as soon as poss...
Dear Experts,
I need load Oracle data into SQL Server Database. I need help to convert Oracle CLOB data type to varchar data type in SQL Server. How can I do it?
I have a newly built Windows Server 2008 Enterprise server built on a VMware ESX virtual machine running SQL Server 2008 Standard. This server is a member of our Active Directory domain and t...
We currently develop a majority of our web-based applications using SQL Server 2005 as our backend database, however we are starting to use SQL Server 2008 as well. Are there issues and/or ca...
where is the Microsoft SQL Server Management Studio Express for 2008 because this is for 2005 .
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796...
I need to change a column from Real to Money, but when I try to do so I get the message:-
Saving changes is not permitted. The changes you have made require the followilg tables to be dropp...
We are currently running Sharepoint 2007 w/the default installation on SQL express 2005. However the 4GB limit will become a factor shortly. We have purchased SQL 2008 and have been unsuccessf...
I am a fairly new beginner with SQL and I having a couple of issues.
I want to insert data in a pre-existing table from a separate table. For instance, table A has a column entitled prod_id...
I hope this is somewhat clear. Recent deployment of SQL Server 2008 Standard on a Windows 2003 Server. All mandatory service packs and hotfixes have been applied.
I have 2 issues:
1. Del...
