HI, i got a problem while using StrConv function in sql server. My requirement is:- suppose in a name field i have "jhon smith" Now i want to run a sql which will give me the result like "Jhon Smith"--which means upper case first. Now i am running a query like below which is giving me "Jhon...more >>

Hi all, Does someone have the material(PDF or PPT) of this course: Microsoft Course 2073? Thanks,...more >>

I have a web-based admin section for a site and I would like to be able to query the SQL Server database size and display it within my admin area. Is there a function or method of doing this? My database is hosted by a third party... I appreciate any tips or advice you can provide! Rob ...more >>

I downloaded the latest version on JDBC from Microsoft and I got problems. Indeed, when fetching a smallint from SQL Server i got instead an Integer. How can i do to avoid such a problem? Some hints? many tanks, gaetano ...more >>

I have an application that I am working on that uses some small temp tables. I am considering moving them to Table Variables - Would this be a performance enhancement? Some background information: The system I am working on has numerous tables but for this exercise there are only three that re...more >>

How to make a query which contains fields from two different bases ? Thanks in advance. ReN ...more >>

I have a table in my database on SQL Server which holds a file name that refers to a file that is stored on the server. I would like to create a trigger to delete this file from the server if the row in the table is deleted. I have been trying to use this command in a trigger (<filename> is th...more >>

Hello Suppose a database Db1 with tables tl1 and tl2 and a second database db2 with tables tl3 et tl4. Is it possible to make a join between tables of the two databases ? As for example, Select * from tl1 INNER JOIN tl3 where tl1.Field1 = tl3.Field3 Thank for any help Thierry ...more >>

Good morning: At least it's morning where I am. :) I have a rather newbie question I'm afraid. I have VisualStudio.NET, and have installed it along with SQL server. However I can't seem to find an administration front-end to SQL, other than the VisualStudio, which is ok for creating databas...more >>

how do i specify the table destination only not the whole database from a text.txt source? thanks, trint...more >>

Hi All, I want to create a cube using MSSQL2000 i dont know any thing how to create and what is parameter required so if any body help me i will be thankfull to him/her.For information : i have 4 tables custdetailtable which contain all about a customer as per example customer ID,name,add,CUS...more >>

Hello all... I'm stuck, I cannot figure out how I should go about flagging conflicts on a sheduling app. I currently have 8 columns (school grades) that have class over the course of 9 periods. I am populating the asp page fine, and making changes to the database with forms lists. I need to compa...more >>

I have a SQL Server database that is showing 2853.44 mb in size but when I export the data into MS Access the size is less than 1 mb. Can anyone tell me how to reduce the size of my SQL Server database so that it's less than 15 mb? Thanks in advance! Rob ...more >>

Hi I tried running ITW against one of our databases, and it came up with a number of suggestions, but also filled the Application Log with messages like:- The description for Event ID ( 4 ) in Source ( ITW ) could not be found. It contains the following insertion string(s): Error in Parsi...more >>

Hi, I just want to know to turn this: CREATE TABLE [dbo].[tblTierCs] ( [idTierC] [int] NOT NULL , [txtNoEmploye] [varchar] (50) COLLATE French_CI_AS NULL , [noSubDomain] [int] NOT NULL , [txtNameTierC] [varchar] (50) COLLATE French_CI_AS NOT NULL , [noOldTierC] [int] NULL , [noRSDTierC]...more >>

Hi all, Here is my problem, I have 3 tables : People ------------- IDPeople Firstname Lastname Cars ------------ IDPeople Carname Boats ------------ IDPeople Boatname 1 person can have 0 or n car/boat I want to a result set displaying : Firstname, Lastname, NumberOfCars, N...more >>

Should be easy, but I've been trying to figure this out for about half an hour with no luck. There is a table 'Cybex' which has all the Cybex products we sell, and a table 'Datasheets' which contains a list of the datasheets available for products. Both tables have a PartNumber column. On wit...more >>

Consider this SQL Query: ----------------------------------------------------------------- SELECT c.CASE_NBR, DATEDIFF(d, c.CREATE_DT, GETDATE()) AS Age, c.AFFD_RCVD, c.PRV_CRD_ISS, x.RegE, x.Type, x.Fraud, c.CUST_FN + ' ' + c.CUST_LN AS CustFullName, c.ATM_CKCD_NBR, x.T...more >>

I have created a DTS package that pulls data in from Oracle into SQL Server. When I run it directly on the server (from Enterprise Manager), it works fine. When I run it from Enterprise Manager on a client machine that does not have the Oracle client software, it does not run, giving me the erro...more >>

The following query works fine against SQL Server 2000 here in the US: SELECT * from TNEWSARTICLES where CreatedOn < '2003-04-25 14:22' But in the UK, it returns this error: 80040e07: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value I...more >>

Anyone has a "one sql statement" to get the total spaceused and total space allocated of an instance ? ie same as sum of relevance fields from sp_spaceused for each database in an instance, that works accross version of mssql from 6 onward. Thanks KD...more >>

Hello all, I have the following requirement (SQL 2000, SP2) 1. Need to restore production database(A) to another database (B) on another server (No direct connection) 2. In the restored back-up(B) SP codes should not be visible (even to sa) or all SP's can be deleted . 3. This nee...more >>

Hi, I've run into a bit of a sticky design issue. We have products in three categories which I will call 'A', 'B' and 'C'. We have "kits" which contain three products, one from each category. Below is some sample SQL to set things up, but I need to ensure that each kit gets three products...more >>

How do I order a query by a date field ASC, but have any NULL values show up last? i.e. 7/1/2003 7/5/2003 7/10/2003 <NULL> <NULL> Any help will greatly be appreciated...more >>

I'm having a difficult time calling UPDATE when my 'WHERE" clause calls ID, which is numeric and the primary key. I found that I can do a SELECT just fine with "WHERE ID".. Is there something special about UPDATE that i'm not getting? I've searched the internet but it appears that what I'm doi...more >>

I keep getting the following error message when I run a serie of SQL commands: Server: Msg 9002, Level 17, State 6, Line 15 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space. I have tried "dump transaction tempdb ...more >>

I have user that we just migrated his Access database to SQL Server. All went well with the migration, but then he came up with another requirement to be able to replicate the database to a local SQL server living on the hard drive of a laptop. Before the migration he just copied the entire Ac...more >>

Hello All, SQL 2000, case insensitive database I have a situation where I need to find abbreviations in the rows in a table. The rule i came up is, get all the rows from the table where there is more than one character is capitalized consequtively eg. "USA", "TIMS", "AIR" Here is the sam...more >>

I am getting lot of deadlocks in my application. As it is very complex ti avoid deadlocks at this stage of application we have done few steps to lessen the impact. We have added retries after deadlock is capturted. We have added select * from TABLE with (nolock) wherever possible. But interes...more >>

How would I create a database alias name for the following database testingdatabase.com This database exisist on a remote server. I have tried using the database name as server.[testingdatabase.com].dbo.table were server is a linked server using sp_addlinkedserver [testingdatabase.com] is ...more >>

Hi, I have a SQL script which create few tables. Currently, I have to paste the scripts to the SQL Enterprise Manager and highlight one by one to run it. It can't seem to run it as "one unit". My script looks like below: CREATE TABLE T1 AS ...; CREATE TABLE T2 AS ...; Any comments?...more >>

Having this description column in a table "Cookies, peanut butter sandwich, regular" When using this WHERE clause: WHERE (((Food_Data.Description) Like "*Butter*" & "*Peanut*")); I dont get any results, however when using it this way round WHERE (((Food_Data.Description) Like "*P...more >>

I am at a client that uses an xml form to email from java rather than setup a true email server. Does anyone have any suggestions as to how ms sql can write to the xml or maybe even call java or xml directly. This will be done as part of the error detecting process of various sql jobs in EM. ...more >>

Hi, Is it possible to switch to another user's credentials after logging in? I seem to remember that there is a stored procedure for this, but I can't find details anywhere. I want to temporarily suspend my login's admin privileges and become an "ordinary" user, for testing purposes. Thanks...more >>

We have forms written in Visual Basic 6.0. They were previously written for an Access database which was moved to SQL Server 2000. Here's the connect string I used: ODBC;UID=visualbasic;PWD=password;SERVER=MPSQL;DRIVER={SQL SERVER};DATABASE=MPPhoto The user visualbasic and the user logged ...more >>

Hello, I am having a problem with a join. Either I am just not seeing the obvious, it isn't possible, or I need to use a different approach. I have an application with a vsflexgrid that needs to display the following: filenumber, BL, Container_BL, BL_HBL, HBL, Container_HBL The tables ...more >>

Is there a script anyone has that will automate the addition of an access database to the OBDC datasources in control panel. Thanks ...more >>

I have a SQL Server 2000 database that I will need to take from development and put into production. Currently the database is on a workstation running Windows 2K Server for development purposes. The database will have dozens of users with data entry capability and hundreds of users with viewing...more >>

Hi I am getting this common error once or twice a day: Error: 9002, Severity: 17, State: 2 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space. provided...... 1. My log file drive has more than 20 GB free out of 30 GB 2. B...more >>

I have a table I'd like to copy so I can edit it and play around with the data. How do I create copy of a table in SQl Server? Thanks, Bill...more >>

Any help would be appreciated. I am running a script that does the following in succession. 1-Drop existing database and create new database 2-Defines tables, stored procedures and functions in the database 3-Imports data using bulk insert 4-Analyzes data using stored procedures I would ...more >>

Hi All, I am facing a problem with a sql what i used in MS Access but its not returning the same result in MS Sql Server 2000. Here i am giving the sql: SELECT TOP 3 format( MY_DATE, "dddd mm, yyyy" ) FROM MY_TAB WHERE MY_ID=1 The above sql in ACCESS return me the date in below format in o...more >>

I have an ODBC link to DB2 Database. I can see the values of the DB2's tables in Access but not in SQL Server DTS. IN DTS, I connect the Source but when i want to see the values in the Data transformation task, i have this message : HResult of 0x90040e37 (-2147217865) returned. Erreur inattend...more >>