Hi all, I have a query as follows: update stage.FinanceVehicleSummary set vin = (select VIN from stage.ChasisLookup where stage.chasislookup.chasis = stage.FinanceVehicleSummary.ChasisNo and stage.chasislookup.sr_registration_number = stage.FinanceVehicleSummary.srregno) and ...more >>

I have the need to restore a database to a user's laptop on a daily basis. This has been no problem using Enterprise Manager. I found a stored procedure to run the restore and tried to call it from a visual basic program. While I can connect to the database, I get an error telling me "exclusi...more >>

Hi, I want to find out in my SP the filegroup associated with a particular table? I was not able to establish the relationship between sysobjects and sysfilegroups table. Is there any other way to find filegroup of a table in T_SQL? Also lets say there are 3 dtatfiles in a filegroup 'FG1' and...more >>

I've read frequently how stored procedures we create shouldn't be named with sp_ since SQL Server will first check the master db before the current db when trying to find the sp to execute. I always nodded and thought how I was glad I hadn't done that. For some reason it never clicked that UDF ...more >>

I need to export a list of name and email address fields from a SQL table, in some format so that a user can take the file I generate and Import it into Outlook and it will keep all the names together in a Group or Distribution List rather than dumping them into the user's main address book. An...more >>

I just discovered that all my records appear twice inside my table, in other words, they repeat on the row below. How can I delete all of the duplicates? I'm sure there must be a tidy line of sql to do that. Thanks, Bill...more >>

im not very good at sql but need to query the database to use in my programming script. if the database is just like this id name parent_id 1 A null <----- root 2 B 1 3 ...more >>

Hi, A query is exceeding the length of varchar and nvarchar variable. Because I'm picking the data from each record from table and giving it to the query. suggest me some way to do it. sample query: SELECT P1.*, (P1.Q1 + P1.Q2 + P1.Q3 + P1.Q4) AS YearTotal FROM (SELECT Year, ...more >>

I am trying to view all the ntext from a profiler trace. The data is truncated at 256 and I am not sure why... The max length is 1820 via this command:select max(datalength(textdata)) from "monitor forms usage" where textdata like '%gforms%' . I then issue set textsize 8000 select (textda...more >>

Hi there, I'm pretty new to SQL and am having some porblems with a linked server. I have a table on a SQL server which stores employee information. I also have a view on a linked server which stores the same information. What I would like to happen is, whenever the view changes on the link...more >>

Hi, I recently had to add a new column to a table that resides off-site, in a customer's environment. Previously, the table had around 300 columns, all of which were in alphabetical order. I found that the ALTER TABLE command appeared to be only capable of appending a new column, but wasn'...more >>

The following SP gives an error of: Server: Msg 245, Level 16, State 1, Procedure spSelectSEICData, Line 26 Syntax error converting the varchar value '@' to a column of data type int. In the Procedure I am using the Select * for testing purposes. Here is the proc. CREATE PROCEDURE spSelectS...more >>

Hi, I have a funny Error in our sql server 7 & 2000. When I compare two string in Unicode format. I receive that it is the same when I add new nchar. I don’t understand why? Could you help me ? declare @str nvarchar(128), @str2 nvarchar(128) Set @str = nchar(21121)+ncha...more >>

Hi, I am having a problem accessing SQL Server 2000 via UNIX. I am accessing SQL Server 2000 from Solaris using Sybase Open Client (CT-Lib). Here is the error message: CT-LIBRARY error: ct_connect(): network packet layer: internal net library error: Net-Library operation terminat...more >>

hello can anyone tell me if it is possible to use activeX components (com/dcom) in MS-sql stored procedures? tia ...more >>

Has this happened to anyone else? I have a large job and all the queries run fine when used individually, but in the job, SQL says completed with success but in two cases the queries did not run. One of them is even ridiculously simple: DROP TABLE tblMyTable, etc....more >>

I'm currently updating one of our web sites and have encountered a strange problem. The page that is giving me the problem is written in ASP and hits a SQL 2K DB. When I click submit I have 4 procs that need to be executed. I always get a sql server timeout error. I opened up Profiler and tr...more >>

I am new to MSDE and want to deploy it in my company (because it is free). However, when I install it in a W2K professional machine, there is a message box saying that a "strong SA password is required". How can I solve the problem? Arthur Cheung (The MSDE engine was downloaded from the...more >>

I'm trying to test and tune two functions that retrieve records from a property database (housing characteristics & transactions). One returns information about a subject property, the other about properties near the subject. They both return tables, with identical structures. The first wil...more >>

Hi, has anyone gotten the error "semaphore timeout" when trying to do a backup to disk? The disk is a logical partition. There are two drives, c: and d:. Backing up to c: is fine. However, backing up to d: produces the error below. Thanks in advance for any help. Here is the command : ba...more >>

I have production SQL Server database that must be moved to a new machine. There is a fairly complex DTS package on the original server that is used to handle the weekly updates to the database. Is there a way to export this DTS package in order to set it up on the new machine as well? Bes...more >>

Does anybody know where a copy of the MS-SQLServer software is posted?...more >>

Can anyone help me with an problem I have come across in my database design. I have a primary table and a related table with 3 child records (each with a numeric field). I require a query to return the primary key from the main table and the PRODUCT (i.e. all numeric values multiplied togeth...more >>

Hi There, I can't seem to see what's wrong with the query below DELETE FROM Users_Details UD1 WHERE UD1.UserID = ( SELECT TOP 1 UD2.UserID FROM Users_Details UD2 WHERE UD1.useremail = UD2.useremail ) Keeps giving me incorrect syntax on Line 1 near UD1. Can you not alias tables when u...more >>

I am having difficulty writing a SQL statement and I was wondering if one of you gurus could help me. I have a table that has three fields: InvoiceID, Item, ItemPrice. Each InvoiceID is associated with one or more Items. I am trying to write a SQL statement that returns the record (all three fiel...more >>

Hello Everybody Please tell me which is the best method to adminster SQL Server database in remote web server. Eg. I am storing all the information of SQL database in my work place and after that have to upload the modified table to remote web server. Please tell me what is the easiest way ...more >>

Hi, Trying to get a grip on the "join" thing :) Up until now, I allways used this kinda method: "(select t1.a from t1 where t1.b in (select t2.ab from t2 where t2.b=0))" How can this be accomplished using joins? And if you have the time please explain the "bits" :) Thank you. -- T...more >>

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