hi guys, what is max number of triggers you can have on a table? is it unlimited? or 255? ...more >>

query = UPDATE OrderFormLineItems SET cc_status = null, cc_auth_number = null, cc_settle_number = null WHERE ordergroup_id = '@id' and cc_status != 'SOK' what to you think it does if the cc_status ...more >>

Hi, I am having a heck of a problem on 2 machines (2k & XPPro). SQLServer 2000SP4 Query Analyzer keeps giving me problems and I lose hours tracking down the problem. Now I don't know exactly what QA is doing, but I do know that QA will show a line break, but the proc is behaving as i...more >>

Hi friends, In my project I have redesigned my database structure. In the existing structure there is no Primary key and no relationship b/w data. In the new structure Primary key and the relationship is added. Now I want to migrate the existing data into the new structure. There i...more >>

Hi friends, In my project I have redesigned my database structure. In the existing structure there is no Primary key and no relationship b/w data. In the new structure Primary key and the relationship is added. Now I want to migrate the existing data into the new structure. There i...more >>

Until recently we have been writing SQL Server 2000 procedures that return data to Excel pivot tables and Access front ends that reside on our company network. Now we need to develop a Web-based front end to SQL Server that provides data access to users who reside both inside and outside t...more >>

How to automate FTP files to unix server from Windows server ? I dont want to use SQL Server but run a bat file that migth ftp files to unix server...more >>

How can I add one or two fields to about 50 tables without having to go into each one seperately?...more >>

I have a client that wants me to develop and deploy reports based on Microsoft Reporting Services. I noticed Sql 2005 has very much enhanced reporting services (Ad-Hoc reports, and other Reporting Services Enhancements). Since my client is very excited about Ad-Hoc reports, I need to look ...more >>

Is it Case-Sensitive? In other words, are these two expressions equivalent? LIKE '[a-z]' vs LIKE '[A-Z]' -- Peace & happy computing, Mike Labosh, MCSD "When you kill a man, you're a murderer. Kill many, and you're a conqueror. Kill them all and you're a god." -- Dave Mustane...more >>

If I add an ORDER BY clause to a SELECT that returns a TEXT column I get the error: "Server: Msg 8626, Level 16, State 1, Line 1 Only text pointers are allowed in work tables, never text, ntext, or image columns. The query processor produced a query plan that required a text, ntext, or image ...more >>

Hi, I have a stored proc that has one output parameter. When I call this sp from my client program (an MS Access VBA) it has always worked fine, but just recently started to give me a message saying that the stored procedure is expecting a parameter named @TPRD but did not receive it...more >>

Hi all, I am developing a multi user application using Delphi. Currently I am using a database engine that is terrible. I am considering switching over to SQL Server. One of the features that I could really use is for the client applications to be notified when data changed. That is, if on...more >>

i posted this in the asp.general newsgroup, as well- i apologize for my redundancy, but i wasn't sure of the best group to handle this question- can someone point me in the right direction for learning more about how to go about sending a batch of sql statements from asp to sql server, and hav...more >>

When I try to add an ORDER BY clause to a SELECT with a UNION ALL clause I get the following error. Server: Msg 8626, Level 16, State 1, Line 1 Only text pointers are allowed in work tables, never text, ntext, or image columns. The query processor produced a query plan that required a text, n...more >>

Hello, I am upgrading a database from SQL Server 7.0 to SQL Server 2000. I am wondering if anyone can tell me what differences there are between T-SQL commands in 2000 versus 7.0. I would like a list of the actual commands that behave differently in 2000 versus 7.0. Also, I'd b...more >>

I don't know much about the Image data type. When I query a record and get only 16bits of the an Imaeg field, instead of the actual data? Any documentation and guidance for this problem? It seems not on the Books Online. Thanks very much....more >>

Hi, I've been always wondering if the join order in select statement matter, for example, I expected these two statements have different execution time but they seem to have the same execution plan. select .... from ( SmallTableA A join SmallTableB B on A.id = b.id ) join BigTableX X on x....more >>

Hi, I am trying to do a JOIN on two tables where one table could have more than one record however I only want the top one. Is there a way to do this in the JOIN statement or do I have to seperate the JOIN into a sub select statement? Thanks ...more >>

I need to create a view that contain a table from a database that reside in another sql server. The view is a simple select statement joining two tables; i.e. table A inner joining table B that resides in different server. I hope this make sense. I thank you in advance for any recommendat...more >>

I have a field set to Image data type, and store a long string(possible other objects)into it with size 5663, and returned with 5663+28 bytes. These strings wil be deserialized after retrieving. However failde because the bytes seems to include some extra bytes with \0 and 0x01 and have 28 mo...more >>

We have an intermittant problem with a stored proc that runs as a job (i.e., the job consists of executing the single stored proc). When the stored proc is called directly, it executes fine. When it is called as a job we get the following error: Executed as user: CORP\SQLSvcAcct. Login fai...more >>

I have a very uncommon problem ... I have a application that runs like this: 1) it receives users inserts, including a Status = 'U' field; 2) based on a Status field (index) the application query and select the last inserted registries all day long, each 30 seconds; 3) every time it read the r...more >>

Hi, As part of the user administration tools I'm writing for my program, I want to view which sql roles the users are members of, for each login (i.e. not for the currently logged in user but for all users). My code is as follows: SELECT [Name] GroupName, IS_Member = CASE WHEN EXISTS(S...more >>

i need some info about when a computed column is recalculated. i am using a udf and return value depends on columns from other tables. what if these columns are updated ? is the computed columns updated too then? thanks ...more >>

I'm using vb6 and i'm trying to create a connection string using an application role. If this is possible. I don't know what the string should look like or whether i have put everything in place. I'm using Windows Authentication Mode. However I created a Application Role and password ...more >>

Hi. In the where clause of my query I will be converting a char column to an int to match it to another int column. But the char could contain characters and not convert to an int. In that case I don't want the query to fail but simply not do the match. Is that possible? select * from A, B whe...more >>

I have written a sql query using the For XML Explicit. How do I get the resulting XML document into a Text datatype? I am using SQL 2000. Thanks! Christel...more >>

I'm trying to set up my adhoc query to return just one single record, which is aliased as 'foreign' in my sql statement (which is just the total amount of foreign overseas orders for just one day. All Sale_Type_Ids over 2 [integer datatype] are foreign orders): SELECT SUM(CASE WHEN Orders....more >>

Hi All, It is possilble in some way to make operation in a view? Example: SELECT fieldA > fieldB AS TestCompare FROM myTable Thanks ...more >>

I'm looking at a database someone else designed that contains data for individual months, and these months are stored in the format "0805", "0905"... are there cases when using this format is preferrable to using a proper datetime data type? Paul ...more >>

Do large column names hamper performance?...more >>

hello everyone, i'm performing a database transformation, and part of this transformation is the reformatting of phone numbers so that the databased values don't contain any formatting characters. unfortunately the database looks far uglier than anyone wanted to mention, so i'm curious how ...more >>

hello everyone, i'm performing a database transformation, and part of this transformation is the reformatting of phone numbers so that the databased values don't contain any formatting characters. unfortunately the database looks far uglier than anyone wanted to mention, so i'm curious how ...more >>

If I have two tabels with a 1 to many relationship like Table OL with fields Licno, CloseDate, Name and Table Fees with fields Licno, FeeDate I want to write a select saying "Select * from OL" where table Fees does not contain any records with FeeDate = 10/01/2005 and field CloseDate in the f...more >>

This is the message: Error: 1933, Severity: 16, State: 1 I can't find any reference to 1933. Suggestions? Arnie Rowland ...more >>

I have an n Rows by 2 Columns result set from: select intID, decAmount from mytable order by intID which could be hundreds or thousands of rows long. I would like to view this data using 10 columns instead of 2 as in: intID(0) decAmount(0) intID(1) decAmount(1) intID(2) decAmou...more >>

Consider the following set of records: RecID ParentRecID Z Y Y X X T P T T (null) This table defines a history of RecIDs over time. So for example T relates to P. T also relates to X which relates to Y which relates to Z. I ...more >>

How do you programmatically delete ALL indexes for all tables in SQL Server? Is this possible? I was thinking about using SQL DMO to do this. adv-thanks-ance...more >>

Hi . I cant execute a user function(returns an escalar) on other sql instance using select server.db.dbo.fn(xx,yy) where server is a linked server It works when i query a table but not with a function. Any idea? Regards Robson (MCSD) Brazil. ...more >>

Hello, I am looking for a statement or function that returns the first non-null value as in the pseudo code below. Select something(col1) from table1 I appologize in advance if I am out of context here, but I am really looking for a statement/function that deals with first non-null va...more >>

Hi everybody! I have, among others, the following statement in one stored procedure: INSERT PatientErrors (MeasurementID, EntryTime, ErrorID, DeleteResult) SELECT MeasurementID, CURRENT_TIMESTAMP, @NO_VISIT_NUMBER, ModelDAPatientIDNeeded = ( SELECT DAPatientIDNeeded FROM [dbo].[Model] ...more >>

Hi all, I'm trying to user proc1 to call proc2. proc2 is a search proc which returns a resultset, but how can i have proc1 read that resultset without having that resultset being sent to the client? i need to read that resultset in proc1 and then make another resultset out of that one tha...more >>

Currently working on an existing system written using an Access 2002 project (.adp) and SQL Server 2000 and need to add some ehancements. The system is a leasing system where a customer leases one or more assets for a defined term (eg. 24, 36, 48 months...). Each lease may also be associate...more >>

I have a somewhat complicated query that is intended to do analisys. It joins a series of tables and uses a few userdefined function. One function was borrowed for a user here. That function will take a varchar list and convert it into a table that is used for a join. the query goes through a ...more >>

I have made an dts package which takes an *.txt file and imports it into an table in my database, it get´s the *.txt file from another server on a mapping o\\server\folder and it works fine but when i schedule the packag to run every night it fails??? i can browse to the file in explorer and ...more >>

How can I construct a query dynamically to select all the columns in a table? I currently have something like this: sSQL = "SELECT * FROM " + TableName I want to replace the * with the column names in the table. I have seen some post here that stresses that SELECT * should be avoided when...more >>

I am new to SQL Server and need to know which are the best SQL server books I know SQL I just need books that deal with SQL Server T_SQL Thanks ...more >>

Hello; I have a question about tracking computers and their respective organizational units. The following table is populated nightly from Active Directory. create table computer_ou ( computername varchar (20) not null, ou varchar (50) not null, scandate da...more >>

Hi, I want to raise an 'Event' in SQL Server (can be a trigger, other client, .....). Where an other applciation (or job) can listen on that 'Event' and start doiing something. In Oracle i use DBMS_ALERT.Signal and DBMS_ALERT.WAITANY for this. Is there a similair way in SQL Server 2000. ...more >>

Dear all, I wonder if there is any encrypting function that I can use to encrypt the data on the fields I want. Can anyone advise? Thanks. Ivan...more >>

i am interested in knowing how to make sure that whenever a record is deleted or updated from the query analyzer i can save the record, user name(person making the changes) and date on a logfile or table. how do i make sure that this happens and what are the implications of doing this with reg...more >>

Dear folks, How do I know variables such as: % in growing up of each database (as time goes by) or number of transactions commited per day. Using the following query I obtain the number of commited transactions from a point till another but my idea is to obtain too how many mb has grow up...more >>

Hi I am looking for a step by step tutorial on how to do a winform database app using parameterised stored procedures. Any suggestions would be appreciated. Thanks Regards ...more >>

Hi I'm having an Intranet db, that needs to be update with data from a payroll system. In the Intranet db, I have a field for address, Zip code and City, where it's only one field in the payroll system. Does any body knows a way to split this one field into three? The only useable rule I c...more >>