So I blew it! I did not follow the important uninstall procedure when i removed SQL Server 2005 Beta. Now, I am trying to install the CTP for Sep, and I keep getting: "SQL Server 2005 CTP Setup has detected incompatible components from Visual Studio or SQL Server. You must run..." How...more >>

I have an Access Project front end that has alot of nicely formatted reports. Is there a way to create a SQL Job that can run a weekly Access Project report and then save it out to a spot on our intranet? (Each week saving over top of the prior copy so that a somewhat current report is out...more >>

I have one table with 300,000 records and 30 columns. For example columns are ID, COMPANY, PhONE, NOTES ... ------------------------------------------------- ID - nvarchar length-9 COMPANY - nvarchar length-30 NOTES - nvarchar length-250 --------------------------------------------------- ...more >>

I would like to query tables from two databases (Vista and VistaPortal) and would appreciate help on how to right the query in SQL 2000. Please accept my appreciation in advance....more >>

I am trying to update a temporary table with data from another table. The problem is that the field which is common between the two has a many to many relationship to the field I am trying to update. Therefore when I run the update I am getting the first record returned to my temp table. W...more >>

I've been trying to create a full-text index using Enterprise Manager. If I right-click on the table, "Full-Text Index Table" is grayed-out. If I try to start the Full-Text Indexing Wizard it tells me that the "Full-Text Server service needs to be running." The SQL database is on a remote serv...more >>

I am doing a new installation on new clustered hardware. The database and transaction log files will reside on an extenal RAID. Is it better to keep the two files in the same partition or on different partitions?...more >>

Hi I have installed a msde 2000 on the server with windows authentication. Does this mean that anyone that has access to any of the computers connected to the server has a way to getting into the database? I am using access mdb front-end for data entry and linking via odbc using file dsn pl...more >>

Hi, I have the query below, the problem is that it returns duplicate results (with same a.id's) I need to add a 'distinct' clause so that I don't get repeated results for the a.id --------------- SELECT a.id, a.caseid, a.firmid, a.maincase,b.comid, b.comments, b.Updatedby, b.LastUpd...more >>

My actual table has more columns and entries...Iam trying to eliminate the empty cells. Column 1 and 2 need to maintain their relation to each other and 3 and 4 need to maintain their relationship to each other Table 1: Column1 Column2 Column3 Column4 23 100 ...more >>

Hi EveryExpert! We are using SQL Server 2000. I want to get information about all the tables in a given database ('ABD'). Following information need for each table. - No of records - Create Date - Last Modified Date - Last Accessed date (if its possible) - Size (most import information) ...more >>

I have a table that contains all the login dates and computer names. I want to get the last login date of each computer. Here is my statement, but it is giving me an error in the FROM statement. SELECT ComputerName, TimeWritten FROM LogInfo IN (Select TOP 1 TimeWritten FROM LogInfo ORDER BY...more >>

AgileInfoSoftware LLC is proud to announce AgileInfoSoftware PowerQuery 4.1 release. PowerQuery is free database query tool to work with multiple databases simultaneously and effectively. The key features of PowerQuery 4.1 are: One unified user interface works with all your databases. No ne...more >>

Hi Can someone please show me where to look for the transaction log in the Enterprise Manager? Thanks in advance Richard ...more >>

Hi, I have received SFKC_DATA.mdf with no log file. While trying to attach, EM ask for location of log file. How can I create log file Regards SF ...more >>

Hi, I have 2 tables with identical schema on 2 different servers; with one table containing the most up-to-date data and another containing one day behind data. I want to compare these tables and insert the changes into a table (also identical schema) on a third server. How can I achieve thi...more >>

This works except when there are duplicate paid values. If 2 lines have the same paid value, then top 1 becomes top 2. Is there any way a single top value when there are duplicates on the value you are sorting by? I don't care which one I grab as long as I get one of the ones that sort to t...more >>

I have a recordset that I need to paste into Excel. But depending on the criteria, this recordset could be larger than 2 sheets, sometimes 3. So, I need to be able to devide this record set up evenly. What I've done is created a view that counts the number of records in a table. The nex...more >>

Any suggestions much appreciated. I have just found out that I can't update a textarea field using the 'replace' function e.g. UPDATE myPages SET myTextarea = replace(myTextarea,'foo','bar') I've been searching around but can't find any way of getting round it. Even when I try linking th...more >>

....just what are they and how do they work? I've tried looking at SQL (2K) help but can't find anything that really explains them. For background, I'm coming from the angle of writing stuff in VB.Net, using SQL as my data store. I understand the use of indexes in tables but over the weekend...more >>

I have been looking through some sql literature and notice that there is a capitol 'N' in front of some quotes sometimes and sometimes not. What does that mean? For instance: use northwind select contactname from customers where contacttitle = N'owner' will provide the exact sa...more >>

I want to ask if there is a way to delete a record only if a certain amount of time is passed like i have an EmailVerified bit column, and i want to delete that coulmn after x days if the value of emailverified is False after the x days has passed. I also have the DateOfRegistration Fie...more >>