How can I, if possible, get the maximum length of the data in a column, if the datatype is text? I Tried: select max(len(comments)) from Table1 but am getting errors: Server: Msg 409, Level 16, State 2, Line 1 The maximum aggregate operation cannot take a void type data type as an...more >>

Which would you recommend to setup as a failover database server? (We do not have the ability right now to setup a sql cluster). What is the difference between log shipping and database replication? Pros/Cons? Thanks. - Gabe ...more >>

Hi, Is it possible to create a stored procedure that will sit in one database but perform a select statement on tables existing in another database? I can't put the stored procedure in the same database! Thanks SW ...more >>

Hello, I'd like to setup notification on my SQL 2000 server is jobs fail or server experiences any severity errors. I dont want to install outlook on my server so looking for alternatives. Any ideas? Thanks ...more >>

I have installed Developer Edition (from the CD) on my desktop with Win XP Pro SP2. During Setup, I selected Local Computer and Server & Client Tools. I installed 2 instances: a default instance with Windows Authentication, no password and local system account; and a named instance (called ...more >>

I have to following Access2003 Code that needs to run in SQL 2000 SELECT extend, Source, Count(PersonalID) AS RecordCount, Count(IIf([Literature1Quantity]>0,([Literature1Quantity]),Null)) AS Item01, Count(IIf([Literature2Quantity]>0,([Literature2Quantity]),Null)) AS Item02, Count(...more >>

Hi, I need to catch the SQL error messages, generated while executing a query. Basically with reference to the Error Number, I can get the message from sysmessages table. But that would be a raw one. For ex, that would be like : Must declare the variable '%.*ls'. But normally the error me...more >>

Hi. I'm relatively new to SQL Server, and I've come across a problem I can't seem to solve. I have several SQL Servers running in our network. We recently implemented a new system for Human Resources Dept, which contain lots of sensitive personal data. I use SQL Server authenticatio...more >>

I am sorry to ask this here but do you know a good forum for ASP ? A ...more >>

I am very new to sql and would like somebody to tell me if the following table will maintain its integrity ....by this I mean if somebody other than the database owner or someone who has permission to write data to the table. Thanks for any help if exists (select * from dbo.sysobjects where ...more >>

I am trying to log performance monitor counters to a sql database. Does anyone know of sql files that generate a database for performance monitor counters. I need to create the tables and views....more >>

Hello! I am trying to get some information about certification for Database Administrators. Since SLQ Server 2005 will be released in November, will there be a certification for SQL 2005? or should I just take the SQL Server 2000 exams? Any ideas out there? -- mycherrypie...more >>

Hi, I've two instances of SQL Server on the one machine. I'm using per seat licensing. When I look in Control Panel, however, I only see one SQL Server 2000 Licensing applet, and no option to change between the instances. So does one CAL allow you to use any instance of SQL server on that mach...more >>

I have a client who has developed a customer sql based app. They want us to provide hardware and installation. Looking for Tools or Rule of thumb in help to size server to SQL application. Client has not been able to provide requirement to us so we are looking to create a questionaire to ask t...more >>

I am self taught in Access using the Jet database, and am now looking at upsizing my databases to SQL. I know enough to be dangerous, but not enough to probably do the job correctly or get the most functionality out of SQL. I am looking for any training suggestions that you may have. I am u...more >>

I want to select on the value of a portion of a field, rather than the whole field, and I want it to be case insensitive. For example, let's say I'm searching on field A1, and I want to find all records where the first 7 characters (regardless of case) of A1 are "PRODUCT". How can I do this?...more >>

Hi, Is there a place where I can find a database with countries-region-cities of the world? Country code - country name - region (state or province...) - city name Eventually, I'll look for GMT- currency- country telephone code-city telephone area code... Are there any standard place I can loo...more >>

Can someone tell me how i can create an iif function to do the following? I need to look a field that has an amount in it. if it is 90K or less make it 1 if its 180 to 90001 make it 2 etc... So for every 90K in that amount add 1.. I tried to do a VB code to create a ceiling funciton but Ac...more >>

Hi I am upsizing my mdb to msde. (tables only). Why does the tables keep going to the master database instead of the database I want? Thanks is advance Richard ...more >>

When logged in as a database owner, select user_name() returns "dbo". I am logged in using NT Authentication so I have to think that I should be able to grab my real user name from somewhere. Is there another a way to find my NT log in name in a query and stay logged in as a database owner?...more >>

Hi, I have a full database backup on database A (SQL Server 2000). Now I want to restore only the tables from database A to database B rather than restoring the entire database. What are the steps to achieve that?...more >>

My SQL Query Statement is as follows: SELECT DISTINCT e.vchrFirst_Name, e.vchrSurname, ecc.vchrCost_Centre, ac.vchrPersonal_Expenses FROM tblEmployees e INNER JOIN tblEmployee_Cost_Centre ecc ON e.vchrCost_Centre = ecc.vchrCost_Centre INNER JOIN ...more >>

I recently upsized a JET database to an ADP project and I would like to know how I can re-run the query (without closing the form) to change the data that I am viewing. For example: If I am viewing client A and want to switch to Client B using the same form. Currentlyy,the form has a command b...more >>

Hi, I have a problem that I am hoping to get some help with. We had a propritary database made for us (VB and SQL Server 2000). There have been several times where the software has crashed and we have had to uninstall it and reinstall it. We have also had to restore the backup. About ha...more >>

Hi, i'm currently converting a MS Access application to MSSQL. In Access, i have a primary HelpDesk database that use some linked tables from another database. I've created the two DBs on the SQL server (HelpDesk & Contract). Now, i need to link tables from the Contract DB to the HelpDesk ...more >>

I simply want to load an XML (either from a file or text), then validate it against an XSD (file or text). 1.) I have NO idea how to do this, please help. 2.) Can this be done strickly in SQL Server 2005 (or do I need VS2005) ...more >>

Hello, I am using MS SQL Evaluation Edition for my ASP.NET web application. But it suddenly stop working. I guess that it is because it expired and I forget to backup all tables and stored procedures. Then, I bought MS SQL Server 2000 Developer Edition and want to install it (replace the eval...more >>

Tengon una parametro el cual es un varchar(200). El string que le paso viene con un caracter |, por ejemplo: "aaaaa|bbbbbbbbbb" necesito separar ese string en 2 string independientes, uno es "aaaaa" y el otro "bbbbbbb" ¿¿¿hay alguna forma de hacerlo en el procedimiento??? ...more >>

I am trying to setup MSDE for the very first time. So I am absolutely a newbie. I downloaded sql2ksp3 from microsoft site. I unpacked the file to a folder and then clicked on setup. I get an error message about using the command line to supply a strong password and the setup exits... I use ...more >>

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 >>