From SQL Server, how can I link to a table inside an ACCESS(mdb) file? ...more >>

Hi, I am a complete beginner to SQL server. I 've downloaded Visual Studio (VB 2005) on my machine along with SQL database option, which now I can create database inside VB.NET. I like to work and learn the SQL server RDBM itself. What I can see on my Start>Programs menu are only SQL configur...more >>

Hi all, I just downloaded a copy of the SQL Server 2000 64-bit help file in CHM format and can't seem to get it to work. I have SQL Server 2000 developer edition installed with SP4 on Windows XP SP2. Everything on my SQL Server works fine including the updated help files. Just the 64-bit help...more >>

I design computer-based training for intranets. The training files currently use an Access database to store user results. The training files send SQL commands to an ASP page that relays them on to the Access database. Access responds by sending data to the ASP page and back to the training...more >>

hello all How do i know whihch MDAC version i am using in my computer. I need to know the version of it and the driver fiile names stored in my computer . Thanks in advance PRash ...more >>

hello all I need a sql statment that will fetch 1000 rows at a time for example i have got a table called customer which consist of 7500 rows in my first fetch i need 1 fetch -- 0 -1000 rows 2 fetch -- 1001 -2000 rows 1 fetch -- 2001 -3000 rows 1 fetch -- 3001 -4000 rows so no I am ...more >>

An upcoming project is to monitor access logs in SQL Server 2000 SP3a. I noticed that SQL Logs are generated in two places, the Application Event Log and under "c:\program files\microsoft sql server\mssql\logs". I didn't see any authentication logs though. I tried logging in (mixed mode as sa ...more >>

Hi, I have two queries which will yield me the same result. Is there a way in SQL Server(Query analyzer or Enterprise Manager) to check the performance of both these queries and select one. I have heard of performance plans.... all those things. I am not familiar to it. But I would like...more >>

My ldf file is damged. How can i rebuild that file?...more >>

Hi, This looks simple but I couldn't get it right For eg. Table1 has 1 ABC 2 DEF 3 GHI Table2 has 2 DEF I need the result as(basically all the records of table1 and the matching record of table2 must be at the top) 2 DEF 1 ABC 3 GHI Any help will be appreciated ...more >>

Hello all, I know how to use MS Access's 'IIf' statement to test one field and get different results in another field. Is there some way of doing the same thing in SQL Server's Enterprise Manager and store it as a view? My SQL Server Admin class instructor showed me the UNION query, but...more >>

Hello all, Can I retrieve values from other records to create a calculated field in the current record? In our data we have a record for each account for each month in a time series consisting of Account Number, Current Balance, Current Rate, Month End Date among other fields. I would l...more >>

In 2005 or less, are there any built-in routines to compress and decompress "memo" type data? ...more >>

Hi, After I've installed a new instance of SQL server 2000 standard, I will apply the service pack. Do I need to re-apply the service pack to the existing default installation as well? Thanks, SW ...more >>

Hi groups, "select exam_date from cam_applicant [ here i want to show '0' if any = particular date was there ..say 01/01/1900 ]" I want to show '0' if any datefield is having this particular date = 01/01/1900=20 Im searching like Isnull...type of keyword to replace this 01/01/1900 to ...more >>

Hello. Why would a variable not be recongized in a subquery? I get this message - Server: Msg 8155, Level 16, State 2, Line 5 No column was specified for column 1 of 'A'. Server: Msg 8155, Level 16, State 1, Line 5 No column was specified for column 2 of 'A' When I run this query - ...more >>

We currently have a production database on SQL 2000 and have a separate 6.5 database running on a different machine, both on NT with the appropriate service packs. We have been reviewing the white papers to prepare for the upgrade but are curious to know if there are any issues or considerat...more >>

Hello. Thank you for reading this question. Any ideas on how to determine if the relationship between two fields in a table? As 1:1, 1:M or M:M? I'm spinning my wheels on how to get started with this. Thank you! Diane...more >>

Hi Group I like in the field with i.e. "ISRAEL ARTURO IÑIGUEZ PADILLA" separate this in First Name in a Column Middle Name in a Column Last Name in a Column Can help me with this ?? Tnks Hola Grupo Yo quisiera que en un Campo donde tengo "ISRAEL ARTURO IÑIGUEZ PADILLA" separar por Pri...more >>

Hi, What is the best way to use query analyser when you're looking at data in the grid and changing the SQL queries all the time? Other SQL systems I've used have some way of going back to the previous queries, to save typing them in again. Am I missing something in Query Analyser? It seems...more >>

hello all how can i replicate my customer_master to a table customer from a sql statement. I tried the following without success. Any one know the correct statement CREATE TABLE customers AS SELECT * FROM custmoer_masters /Prash ...more >>

Hi there I was wondering whether the performance of a T-SQL query would be improved by restructuring the expressions in the WHERE clause from the most specific (first) to the most general (last). Furthermore, would any difference in performance depend on the construction of the underlying i...more >>

I want to delete the index: How to run the output of: select 'alter table ' + b.name + ' drop constraint ' + a.name from sysobjects a inner join syscolumns on syscolumns.id = a.parent_obj inner join sysobjects b on syscolumns.id = b.id where syscolumns.name = 'rowguid' and objectprop...more >>

Hi all! I'm having problems with MS SQL 2000, SQLMail service... I have done everything by the book, created mail accaunt in Exchange = 2003, tested it. Installed Outlook 2003 on server with MSSQL, created mail profile using = same accaunt which starts both SQLAgent and MSSQL services.... I'...more >>

Does sqlserver 2005 support utf-8? In MySQL I can use charset=utf8 in the connectionString inorder to make query again utf-8 string work (collation) I can send query to the server like SELECT * FROM users WHERE firstName LIKE '%utf-8_string%'. But I can not figure out how to make the sam...more >>

Hi, I have a query that will show results from three tables: select paciente.num_abs, paciente.num_ref, paciente.registro, paciente.nome as pac_nome, paciente.nasc, paciente.data, paciente.data_lancado, unidade.nome as unid_nome, unidade.mne, unidade.cor_padrao, sum(case when paciente_laud...more >>

Situation: 1st time using Oracle for a training class. 1st install Problem: I just went through the instructions for " Installing the Oracle9i Database[1]". My problem is that I don't remember the passwords I created and I'm following the instructions for loggin in... I am failing m...more >>

I'm an Business Intelligence student and trying to do a cube assignment using September CTP of SQL 2005. When I try to browse my deployed cube by dragging any field from the cube attribute list into the data pane I get the following error: The query could not be processed: o Memory error:...more >>

Hello, I have a SQL server with a single user database. The database is about 1 Gb in size whereas the Transaction log is about 100 Gb. I've been backing up the database every day so why is the Transaction log so big? Doesnt the database backup shrink the log or truncate the log? any ideas?...more >>