Hi I got this error mes. when i tried to sort som data: ORDER BY items must appear in the select list if SELECT DISTINCT is specified. I dont understand what that means. I cant make any more subquerys because i have alot of parameters in and out. Thankes for any help /Anders...more >>

I don't know if anyone of you have done this: I'd like to have a lock in place that will keep an employee from being deleted from the employee directory if their employee.id is in any tables (loan table for example). The employee.id can have a FK in any number of tables at anytime and I w...more >>

Hi all, I have a mssql2k table with 10 million rows and an index on a varchar(5) column. there are 5 possible values in that index ("hardw", "soft", "inter", "perh" and "misc") Will I gain any noticeble advantage if I switch the index to use tinyint (1-5) values? Thanks! ...more >>

I would like to ask for assistance regarding server librabry files. I have recently uploaded my ASP files into the server. Initially I was using the PWS to run the files where everything runs as programmed. But this error pop up when accessing the files from the server. Microsoft.VBScript...more >>

I have a table item(id, item_name, item_added_date, item_price). The second table is item_viewedby(id, item_id, userid). The second table holds the users who are viewing a certain item. So data in first table item is like: id item_name item_added_date item_price 1 toothbrush 01/01/2003...more >>

Hello All, This Scripts show error. Any Friend help me? set xact_abort on begin transaction create table tb_teste (aaa int) alter table tb_teste add bbb int insert into tb_teste values (1, 1) insert into tb_teste values (1, 2) insert into tb_teste values (2, 2) insert into tb_teste valu...more >>

Hi All here, I'm writing a store procedure to create a temp table. After executing the store proc, I try to retrieve the data from the temp table in same session. A message "Invalid object" is shown. Would anyone tell me what's wrong with that? Thks Rdgs. Ellis ...more >>

Hi, I am writing my first Extended Stored procedure and a need a little help getting the Name and instance of the server. Reading the documentation on Srv_pfieldex I can get the Instance of the SQL box I'm connecting to , this is fine. But I can seem to find how to get the server name itself.....more >>

All, Can I tell to Enterprise Manager to generate sql script as following: Generate the CREATE <object> command for each object that DOES NOT EXIST. I know that I can DROP and generate a new object ( under the formatting tab). But what I need is to generate if the object does not exist ( I...more >>

Hello, Is there a command I can issue to SQL server to drop all open connections to certain databases, and lock them out until I can issue a "RESTORE" command, to restore a backup of a database, I want to make sure SQL server doesn't give me the ever popular error "database could not be locked...more >>

I have an import table coming from an external source, and I wish to unpack the words in the description column. For instance I have id Description -- -------- 1 Paco 2 Hello world 3 This is fun 4 Are you happy Mr. Superman? I wish to have a t...more >>

Hi, It seems stop/starting the service is not enough to have SQL Server Agent use any newly set Environment Variables. We have to reboot the machine in order for the Environment Variables to be 'seen'. Is there a less drastic way to get SQL Server Agent to update it's Environment Variables ...more >>

For Query Analyser that comes with SQL Server 7.0, if I do "Display Execution Plan", sometiems some of the icons have a small yellow circle with 3 arrows pointing to the left on top of an icon. For eaxmple I can see it on top of the Icon for "Clustered Index Scan" and "Hash Match Inner Join". But...more >>

I have an ASP application that's been working fine for ages. Suddenly, when trying to add a record to a table, I get: Violation of PRIMARY KEY contraint: 'PK_Responses': Attempt to insert duplicate key in object 'responses'. So there is a table called 'responses'. It has a field (among oth...more >>

Hi,=20 I install SQLServer 2000 it=B4s working but when try to=20 connect whit my application send this error [Microsoft] [ODBC SQL Server Driver][DBNETLIB]Invalid connection. My string is ..ConnectionString =3D "driver=3D{SQL=20 Server};server=3D192.168.0.36;uid=3Dsa;pwd=3Dpasstest;databa...more >>

Dear All, Inspired by the idea of enforcing non-nulls to be unique but allowing multiple nulls - I have been attempting to enforce uniqueness in a primary key column across 2 separate tables with an indexed view, but failing miserably. I do not have control over the data in PartNumber, so ca...more >>

Hi How do I read data from a text file into a text field in a table? Any other method than Bulk insert? Thanks Jignesh...more >>

Hi, I have two tables that each have a fk contraint to the other table. How do I do an insert in such a situation? The problem is that I cannot seem to find a way to tell the db that two inserts are 'atomic', as in the constraints (invariant) must not be checked between the inserts. Here ...more >>

I am using the BulkCopy operation in VB6 to push data to a Sql database (SQL Server 2000). The problem is that sometimes my customers receive this error: Number: -2147221504 Description: "Method '~' of object '~' failed" It happens on both Windows XP and 2000 machines. The sqldmo.dll regi...more >>

Hi I need some help with grouping and ordering of a sql statement. The table I have is detailed below:- Id Date Sales_Total I need to be execute a query which will return the aggregate sum of the sales total for each month for the last 12 months. I can manage to do this by using the ...more >>

Hi guys, I have the following query: Select count(*) as total, count(*)/(select count(*) from tbl2) as percentage from tbl1 the resulf of the count(*)/(select count(*) from tbl2) always give 0, because it will consider percentage as int, so any value less than 0 will give 0. Anybody know ho...more >>

Hello All, How could make SQL Server database read-only, through T-SQL, is there ant SET command or something like that??? Thanks in advance Maher K. Al-Jendasi maher@fr.fm ...more >>

Hi, How do i pass a text datatype variable to a stored procedure. If it is impossible is there any way you can tell me how to read a text file into a text field of a table through stored procedure or a query? Thanks Jignesh...more >>

SQL 7.0 I scheduled a Optimization job to run weekly once and its taking around 5 hrs .During this time users are getting locked. What are all the best options to handle this ?? We are not able to get a continuous 5 hrs down time for application ?? Thx Sh ...more >>

Hi, I created a trigger that works correctly on tables that have no other tables dependant on them. Once the tables have tables dependant on them (Ref int. with cascade del and update), I get errors when the trigger runs. More specifically, the error only occurs when I delete a record. ...more >>

I am using SQL 7 I created a DTS package, and when I execute it through enterprise manager it runs with no errors. But when I try to run it through query analyzer using a stored procedure it does not work. Any clue where I can start to debug this issue? Thanks....more >>

4 tables CREATE TABLE computers( comp_id INTEGER IDENTITY, name VARCHAR(32) NOT NULL, more_fields VARCHAR(100) ) CREATE TABLE computer_aliases( comp_id INTEGER, name VARCHAR(32) NOT NULL ) CREATE TABLE op_systems( os_id INTEGER IDENTITY, comp_id INTEGER NOT ...more >>

Hi, I have a self-referencing table called Categories and another table called Products. I want to be able to select all products for a given category. If the category has child categories (sub-categories) then all products associated with these should be included in the result set as well. Th...more >>

I encountered some unexpected speed issues over the weekend running some scripts in Query Analyzer on a remote server via dial up and TCP sockets. After 3 hours of my script running, I finally cancelled it and logged into the server via Terminal Services. When running the script from Terminal...more >>

At my work place they wont give developers Enterprise manager, for security purpose's Does anyone have any input to any shareware programs that would serve the same purpose...more >>

Hello, can I set a trigger on one table and the statement will change data on other database (on the same server) ? can you give me an example for such a trigger thanks for your time Yaron. -- éøåï ðçåí "îéëåðéí" ...more >>

I get the following error message : Server: Msg 2627, Level 14, State 1, Line 2 What I am trying to do though is IMO fairly easy. I have a table of records (Example1) that I am trying to "copy" into (Example2) with Example2 having a primary key on "Phone" I know 100% that there are an ab...more >>

Does anybody can me to explain how consultation it is it works? If I place the line " AND L.Status = ' Coletar' " in the consultation of the lot (str_cmp) not back the correct data. str_sel = "SHAPE {SELECT RFCQA.* " _ & "FROM Rec_Ficha as RFCQA LEFT JOIN Lotes as L" _ & " ON RFCQA.NR_F...more >>

How to define a constraint for a field based on another field in the same table? In my Table I have fields Id, IdFK, Plant, TagIdentifier... I define a constraint using Table properties tab and check constrains on Plant field as Plant In ('Met', 'Sen', 'Blu'....) I want to define an...more >>

Could someone recommend a book on SQL Server Architecture for a developer with a lot of Oracle experience and good knowledge of RDBMS concepts? In other words I don't want a book that explains how to write SQL queries or basic OS concepts but gets to the point right away. It should be focused ...more >>

I have a field with hourly and minutely values. E.g. Field1 (Hourly time) Field2 (Minutely time) 2003-07-01 00:00:00 2003-07-01 00:00:00 2003-07-01 01:00:00 2003-07-01 00:01:00 2003-07-01 02:00:00 2003-07-01 00:02:00 .. . .. ...more >>

Can a view be created via stored procedure? I was hoping to pass date range to stored precedure to create view....more >>

I am trying to see if the item is PastDue. first I check to see if an item exists in csh10002, if one does not then past due is definetly false(0). otherwise i need to check another table for the minimum due date if the due date is greater the today then pastdue should equal 1 else it should eq...more >>

Hi all, I have a problem with calling a SPROC from another SPROC. I call SPROC B from within SPROC A to create some entries in a table. Unfortunately SPROC B returns 2 IDs of the records it created. However I don't want this recordset in my SPROC A as it disrupts my error handling in the V...more >>

Hi I have a linked server oracle and i receive this message when execute any query with it. "OLE DB provider 'MSDAORA' reported an error. [OLE/DB provider returned message: Oracle error occurred, but error message could not be retrieved from Oracle.] OLE DB error trace [OLE/DB Provider '...more >>

What is incorrect in my sp? Attached file is not working? CREATE PROCEDURE CDO_SendMail_test( @From varchar(255) = 's@yahoo.com', @To varchar(255), @Cc varchar(255) = '', @Bcc varchar(255) = '', @Subject varchar(255), @MessageFormat int = 0, -- default to HTML, 1 = text, 0 ...more >>

Hello. I am using a stored procedure to insert records into a SQL Server database. I am inserting the records using a SQLConnection and SQLCommand object from C# code. Everything seems to work fine except when the value of one of the fields is over 900 in length, nothing gets inserted f...more >>

Hello, When I run a stored procedure in Sql server through DataEnviroment in VB6 (using the OLE DB Provider for Sql Server for the connection) I take only updates in the table of my database but no results of my stored procedudure's variables appear. How Can I make this variables appear as o...more >>

Hiya I am trying to execute a COM objects method from T-SQL. I am using sp_OAcreate to create an instance - which is not producing an error. The Method expects 3 variables, int, string, string. and returns a 1 or 0. I am referencing it as below.. EXEC @hr = sp_OAMethod @object, 'OLogon...more >>

I have been trying to get a results from a third Party accounts system. From all the help given i the past i have managed to get this far. if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tmpnomdat]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Tmp...more >>

Hi, I am not pretty sure in which category should I post this question. So I posted it in sqlserver.tools group and now I am re-posting it in here. I am able to configure SQL Mail and send mails using the available external sp's. But the only problem with this is that I need t...more >>

we have developed a project in MS VB6.0 with SQL Server7.0 as back end, we have both the application and SQL server running in the same machine, where our application itself consumes an average of 94% of CPU, we had sql server getting terminated saying some exceptions. in this situation is...more >>

Hi out there, can someone tell me how I get the current(server-)date in a Procedure(UPDATE-clause)? Something like: ..... ..... SET @MyDate=CURRENT_DATE INSERT INTO [MyDB].[MyTable] ( [DateCreation]) VALUES ( @MyDate) .... .... just won't work... Thanks a lot for your ...more >>

Hi, Can anyone please help! I want to store some data as follows Table A, ResultID - int (Primary Key, Identity) Date -Datetime Data- {1,1/1/2003}, { 2,2/2/2003} Table B, Data_id - int (Primary Key, Indenty) ResultID - int Name - string Value - Double Data - {1,1,"Files",200.0},...more >>

Is it better to save directly the pictures (thumbnails) in the sql database or to use a text path to the thumbnail location folder like I did with "Access". I am creating a picture gallery for my website "www.legac.net" and wonder what is the best way?...more >>