I have a procedure which is trying to insert data into a table on Server A. This insert is done based ona return value from a select statement from Server B . A linked server has been set up for Server B on server A. The error when populating table by inserting data is Server: Msg 7391, Level 1...more >>

I'm looking for a property or function whose value uniquely identifies the SQL Server, something like a serial number. The best I can find is the server name, but that isn't unique. The Sid values in the sysdatabases table of the Master database identify the creator of the databases. Any ideas? ...more >>

Hi, I noticed that the oldest post is 6/11/2004 on this list. where can I find the post before that time? Thanks...more >>

Server: Msg 8624, Level 16, State 3, Line 1 Internal SQL Server error. I've looked at several KB articles. 1) http://support.microsoft.com/?kbid=885442 This doesn't describe my problem as the view does not have a delete. 2) http://support.microsoft.com/kb/290817 This does describe my pro...more >>

I'd like to use a trigger on a table in this way: I'd like to update a field in a row when the first field of same row is bigger than 7 . Is it possible to do it through trigger? Thanks ...more >>

Heres the problem... I have a huge table (about 30 columns, 22 million rows). I am doing a simple select of 2 fields. One of these fields is a date field. It is indexed. Running a query on this takes about 25 seconds. If I add another field (a non-indexed amount field) the same select takes mo...more >>

Hi guys, Do you have complete reference for sql error numbers? I want to design customize error message, I want to know how to RAISERROR with correct error number. thanks ...more >>

I have order table with ORDER_ID [int] IDENTITY (1, 1) NOT NULL , as Primary key and by default also clustered index. I use this ID in my INNER JOINS with order items to connect them. I have also orderDate column in my order table, which is datetime field.. A lot of my queries include sear...more >>

Is there any way of starting a job via SQL? Had a look in all the sys% tables but nothing looks like it might do the job. Cheers Mike ...more >>

First time poster to the group, very impressed with the posts I've read so far. Need help with the following parameters. Running on SQL 2000 and the program this will be implemented to is Goldmine (CRM app). Here it is: We have a contact2 table that only has one record per entity. We hav...more >>

Hi all, how can I copy a horizontal table (like excel) to a new vertical table? TBL_HOR Prod Jan Feb Mar Apr a 1 2 1 3 b 2 1 3 2 into TBL_VER Prod month value a jan 1 a feb 2...more >>

How to I create a global variable for several SPs to share? For example, I might have two status vars, such as statusred = 3 and statusgreen = 1. Thanks, Brett ...more >>

I am basically new to sql server 2000. I work in a small programming shop where there is no DBA. I want to add to columns to an existing table. One column is area code and the other column is phone number. Thus I have the following 2 general questions: a. To add these fixed length column...more >>

Hi I want to be able to execute a sql script via my VB6 app How can I do it ? thanks ...more >>

Hello there I have table with field which is a text field that provide numbers and text I would like to drop all the records that on the current field has text and leave only the records with the number on the field For this i've tried to use the convertion process but it gave me an error ...more >>

Hello, At present SQL Server supports 5 types of documents (.txt ,.doc, .htm, ..ppt, .xls ) to be searched as part of Full-Text indexing. Is there a way for inserting the files in SQL server which are not in the above 5 formats Any particual way to include .PDF files? Regards Sathian ...more >>

I'm using sqlDataAdpater to call a stored procedure for insert statements. The stored procedure inserts into all columns except primary key, which it then selects back at end. The program does a number of these inserts and then reads back from database, this all works okay. Later when I go...more >>

While doing a demonstration of an alpha application written in VB.NET, I got an error message complaining of a Late Get. I am presuming that this is a SQL Server related error, rather than a VB.NET error, but not sure. Any know what might generally be causing this error message? I have never...more >>

Here's the setup: Table A --------- ID..........Code A................X B................X C................Y Table B --------- Code.......Desc_Line.......Desc X.................01............This is a description X.................02............for Code X Y.................01..........more >>

I have a program that writes a sample to a database (Table A) every minute. I like to put together a script that would check the Table to see if last 5 minutes that were sampled were not 0 or NULL. If the samples were 0 or NULL then send alert to the RSTK.com email account. Table A Sam...more >>

I'm having a problem with coding/syntax. I need to be able to loop through a list of categories and programmatically add them as fields to an existing table. I can loop through the categories (values in a table) with a cursor, pull each as a variable and build the field names I need fr...more >>

In access: ' select (1+2) as T1, ([T1]*2) as T2, ([T2] *3) as T3 from tbl_test ' is fine But why it can not be run at mssql 2000. How can I achieve this function in mssql 2000?...more >>

Hello, I am trying to program a automatic Replication for a VB.NET solution. I am using SQL Server 2000 SP3 Developer Edition. Now I have a Database on a PC and I want to Publish and Distribute this Database from within my program. When this is finished I?d like to add Subscribers to my public...more >>

Hi, Consider the following sample. (just to illustrate the problem) -------------------- drop table tblTest create table tblTest (id int) go insert into tblTest values (1) insert into tblTest values (2) insert into tblTest values (3) drop function fnTest go CREATE FUNCTION fnTest(@sta...more >>

Hi, I'm trying create a simple select statment with a join in the tempdb. However i'm getting errors which says that it can't resolve a sortingconflict in the equal to line. Here's my select statement, maybe someone can see the problem. use tempdb select p.name, ad.adress from test.db...more >>

I have a table (charges) with the following columns which show how much we charge for a certain medical procedure. Amt is our standard fee, and cob1_amt is what we wharge the insurance company based on a contract we have with them. charge_id char(12), cpt4_code_id char(12), amt money(8), ...more >>

Hi, I posted a few triggers queries for the last couple day, but I still have not resolved my problem. Trigger to update records on another server. Here is my complete scenerio: Step1: Query1 - produce 2 records on some records have more or less Step2: I combined the those comments into one r...more >>

I have three tables like this: Table1: studentID IsntID FN LN ====== ===== === === Primary Key :studentID + IsntID Table2: InternalID studentID IsntID FN LN ====== ====== ===== === === Primary Key :InternalID Unique constraint: studentID + IsntID ...more >>

To setup SQL mail do I need to install Outlook on my SQL cluster?...more >>

I need to return 2 values from a stroed proc. Can you have more than one output parameters in a stored proc? If not, would bringing back a dataset be better than two round trips to the database to get the 2 values I need? -- Robert Hill ...more >>

I have a stored procedure which returns a decimal field from a table and i want my asp.net page to read in the result and then diplay it in a textbox or a label. What is the best way to do this?...more >>

a bit of a begginer's request here. I have a table called t_user in which username is the primary key and one of the fields is a decimal called bsl. I'm trying to write a stored procedure that selects the right record based on the username (input from a cookie) and then inserts the bsl val...more >>

I was seeing if anybody knew how to simplify a solution. Given the following numeric values: 1 = Sunday 2 = Monday 4 = Tuesday 8 = Wednesday 16 = Thursday 32 = Friday 64 = Saturday Obviously, combining these values in any combination gives a unique value in return. If I send a stored pro...more >>