I can not get SP2 for either regular or express versions to install from Microsoft update. I have the same problem with .Net 3.0 by the way. Any have any ideas. Please help. Thanx ahead of time. ...more >>

Hi guys, just started learning the Integrated Services with the BI Studio tutorial. I did install everything of my Developer Edition, tools, samples and files also. But the samples files escpecially the SampleCurrencyData.txt file that I need to do the tutorials does not exist!? Where ...more >>

I am going to set up SQL Server 2005 evaluation (enterprise version) to test an application that uses 2005 standard version. Will I be able to export my data from the enterprise evaluation and import it into the standard version when my purchase order goes through?...more >>

Why is it MS SQL Server does not have a feature to backup a database including data to a SQL script? All other major databases can do this. Can someone reccommend a third party tool to do this? Thanks in advance. ...more >>

Hi I'm struggling to install the above mentioned edition. When i get to the screen where i must specify the SQL Server database instance there are 2 options in the dialogue box "<myservername> and <myservername\microsoft##SSEE>. If i choose my servername and click next the curser changes to a...more >>

Hi, just tried to install the SQL Server Developer Edition on my PC. But I coulnd't install the Tools on CD2, because the setup says: "None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, cl...more >>

In the statement(s) below I'm trying query out 'amount' values that are less than zero (amount > 0) but I can't actually use 'amount' as it isn't actually a column. So, how would I go about it? select amount = (total-paid) ,datedue = dateadd(day, 30, stmtdate) from iheader where tot...more >>

Hello, we have a MS SQL Server Express database that runs on a remote computer. When i try to create a backup the backup file is written to the remote computer. Is it possible to create a backup and write the file to my local computer? I am currently using the management studio and i can...more >>

Using SQL Server 2003, I am trying to add a field, then populate it. I am getting an error on the last two lines saying the column ClaimType does not exist. When I look at the columns in the table, indeed, it is not there. If I remove the two update lines and run the query again, the cilumn...more >>

Hello All, I am brand-spanking new to SQL Server - will be installing it soon. I'm a software app engineer and have used Oracle for many years - and yes, I'll be buying a book (any suggestions welcome!). So a quick into newbie question ... is SQL Server's catalog similar to the Oracle Sc...more >>

I want to put together a demo of the top 10 SQL admin tasks, but using PowerShell (if it supports that task) to demo it. Anyone know of an online reference that might point me in the right direction, or even just post your own "top 10 list" here. Marco -- ---------------- PowerGadgets ...more >>

Hi, The following query lists 21786 records when UNION ALL is used and 19015 records when UNION is used. In both cases, only LASTNAMEs are displayed. What am I doing wrong? I'm playing with UNION to understand its use so I can combine several queries into one. TIA Ana SELECT LASTNAME F...more >>

Very new to sql and not a programmer. I am learning to create a very = simple database for my client using infopath. I am trying to create = tables and as I am doing the insert by doing new query editor..it does = not work. I can not add to the table. I am using sql server 2005 = management ...more >>

I'm having trouble trying to creat a query that does several things. I have two tables. One is called address the other customer. Both tables have the same column names (mostly, for our purposes here). The goal is to pull out all address related records (addr1, city, state, zip) from the ad...more >>

Hi, Im new at SQL and have a question. I need help with a query command that can shrink log files for several DBs when running this query. Greatfull for help. Regards Henrik ...more >>

Hi The following 3 servers i do have (all latest updates) 1) Win 2003 Server with Exchange 2003 on it. All latest updates. (E-mail server) 2) Win 2003 Server. Pastel is on it with its SQL database component. 3) Win 2003 Server. I'm setting up Portal 2003 on here. SQL Enterprise is also i...more >>

Hi, I have three basical questions as a sql server newbie. 1. Which version do I have to buy when I need to fulfill the following requirements: - 30 users - Reportings services - Notification services Would it be a good idea to start with a rented root or share server? D...more >>

I am trying to query all of the column headers for a given table. Can anyone help me with statement to do so. Any help would be greatly appreciated Thanks, ...more >>

I am being asked by a banker if their loan accounting system data can be imported into SQL server. The LAS system is on a IBM iSeries platform. Is this something that can probably be imported into a SQL Server database or is this something that will likely be very difficult. The reason to brin...more >>

Okay, so people keep trying to convince me that the SQL 2000 QA is all great & powerful, etc. In three years, I've never had much use for it except as an immediate execution window and occasional query-plan verification tool, but have decided to "get to know it better" in the hopes that someh...more >>

Hi all I get the following error when installing SQL 2005 trail version. TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.m...more >>

Hello, I need to be able to get a database with populated tables created on-the-fly. This is for a classroom environment where each student works with his/her own SQL or SQL Express database on their local machine. I need to find a quick way to take my data (currently in Access 2003) and ...more >>

When I tried to apply service pack 2 for SQL 2005, it wont let me update Database services (status NA). Why is that? After the update, MSSQLServer still stays version 1399 for the original. Can someone advise?...more >>

We have two SQL2000 standard machines (two seperate boxes). One is our primary, production database and the other is a testing database which has a copy of the database from the production server. Being tasked with making the testing server up-to-date, I was wondering which would be a bette...more >>

Is possible create a script for rename some file with date/time for name??? Thanks. ...more >>

is there any server other than apache that is easy to use which can be used with mysql and php? i am trying to use apache but it is not working on my computer.... IIS works on my computer........... ...more >>

I got this error: A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations. This is the select statment I used. select amount=(total-paid) ,datedue=dateadd(day, cast(@value as int), [date]) ,total ,paid ,stmtdate ,guarantor ,@invoic...more >>

Can I create an vb.net client/server Windows application using SQL Express as the backend database? If so what is the pros and cons as to compare it with the Access database? ...more >>

I'm experimenting with some SQL trying to add the rows from a single column into a variable then looping through it to produce a single result set of all the returned rows. I can get the loop but produce one result set per row of data. I'm using a cursor (first time in eveer trying to attem...more >>

Dear All, I am running SQL Server 2005, how to kill users who has blkby <> . at once ? currenly, I am running it manually by running the following: sp_who2 kill <n> one by one Please help Thanks & Regards Winanjaya...more >>

I am new to SQL 2005 and want create a new database diagram but in my SQL server in Database Diagram I cannot find 'New Database Diagram Node" any Idea Why?? Following are my steps 1.. On the View menu, click Object Explorer. 2.. Open the Databases node and then open the <My Datanas...more >>

Hi all I need to use SQL 2005 Server as the database to implement our Portal 2003 Site. Anywhere on the web where i can read up the basics about SQL 2005, how to operate and do the basics. thanks for all the help... ...more >>

The sql server 2005 managment studio that I work with does not recognize a -- as a comment when I am executing a script when the -- starts in column 1. I can put the -- starting in column 10 to whatever as long as there is a sql statement and the -- on the same line. However when the scr...more >>

Hello everybody. How is possible make a scripts (for every first day of month) automatically export my database in EXCEL file??? Thank very much. ...more >>

I am very new to SQL and was wondering if anybody has any recommendations on books that would help me understand the database and all aspects of SQL. Thanks, Jasper ...more >>

I'm trying to figure out the best way to compare data in 2 tables that are being created from different processes but should contain roughly the same data. I can't do an exact comparison because one contains columns the other doesn't, but I can select a few columns that are the same in each an...more >>