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