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