Does some exist it sorts things out of to compare all the records of all the fields of two tables and to see that this different one among the tables? Each table has 90 fields example table 1 table 2 table1 table2 field1=a ...more >>

I am trying to use the SQL Server Distribution ActiveX control in Visual C# to trigger the replication of a snapshot that has already been created at the publisher. The replication is working correctly, but the "status" event is not triggered. I have attached an event handler, but it never app...more >>

I need to store in some way the result that the clause computes me brings. Please, help me. ...more >>

I am with a problem, I have the sql 2000 installed in a server. When I tie the server the sql it occupies some 250 Mb of the RAM memory, even without any user to be accessing the base. That value is going increasing more and more, even if the users don't use. He/she/you would like to know somebo...more >>

I am not sure if to post this here or on the Excel newsgroup. I will start here. I am trying to import data from an Excel file into an SQL table. My problem is that some of the data is loaded as NULL values. This seems to be because some of the rows contain what Excel claims to be "numeric dat...more >>

Hi, I have a smalldatetime field called "dteDuration" in a table that holds the duration of a support call. I need to sum that field for a given customer over a given date range so that I can bill then for time on the phone. How can you do that in TransactSQL as Summing of datetime or smalld...more >>

With the following code(there is more code in the SP): If I have 2 records in my Import Table that have no match in Customer. I want to make sure I write both records to my ErrorLog Table. When I run this code only one record get written to the ErrorLog Table. How do I get it to write all the ...more >>

Hi, I'm getting the following message back (via ODBC diagnostics): [Microsoft][ODBC SQL Server Driver][SQL Server]The current user is not the d atabase or object owner of table '#bogiecumret'. Cannot perform SET operation. pat ...more >>

We are getting this error on SQL Server 2000 ( SP3) " a time out has occurred while waiting for buffer latch type 4 " As per Microsoft this may happen when memory is >3GB and awe enabled ,and this is fixed in SP2 But in my case SQL Server 2000 -Standard Edition (SP3) AWE disabled OS Memo...more >>

Is it possible to use table datatype variables within cursors? For some reason when I try, SqlServer tells me that the table variable has not been declared when it obviously has. Specifically I am trying to do the following: declare @cond int declare @var table (/*table definition*/) set...more >>

I'm stuck: In a query I am trying to compare two fields with a date/time data type and a LongTime format to get the difference in hours (minutes and seconds if possible). After that I need to determine if the difference is greater than 5 hours. The part of the query looks like this so far (...more >>

Hi all, We have used the following select statement in stored procedure: Note: @ProdName, @SortBy - SP parameters SELECT * FROM Product WHERE ProdName LIKE '%' + @ProdName + '%' ORDER BY CASE WHEN @SortBy =3D 'ProdNum' THEN ProdNum CASE WHEN @SortBy =3D 'OrderDate' THEN OrderDate ...more >>

The table contains 2 key fields like Type (some number) and Date (some date). I need to collect the _last_ records (i.e. Date has max value) for _every_ Type. I think to use UNIONs and SORT BY Date with TOP, if possible. Any other more perfect query advice? ...more >>

Hello Newsgroup I have a SP that queries the database based on several parameters. One of the parameters referes to a customer table, the others are optional and refer to different tables. For performance reasons, I would like to query and join these related tables only if I really have to....more >>

Hi, Does anyone have some basic rules of thumbs for adding indicies to a SQL server 2000 database? I have been going throught the stored procedures we have trying to optimize performance. I am wondering if I should put indicies on the fields used in foreign key relations. Any thoughts? j...more >>

Consider the following table CREATE TABLE Attributes( id int identity(1,1), name varchar(100), mask bigint) Now, attribute mask will be a bit mask of the attribute name. Consider the data: id nam...more >>

I promise I'm not a complete newbie. However, I cannot figure out this problem. RANK - VARCHAR SOURCE - VARCHAR SELECT COUNT(*) FROM TABLE_X WHERE (RANK LIKE 'XXX') AND (SOURCE NOT LIKE 'AAA') AND (SOURCE NOT LIKE 'BBB') result: 8365 records. I've done it manually by selecting * ...more >>

Hi, I have sql statement: restore database northwind from Disk='c:\data\northwind.bak' with FILE = 2 How to get the info from the bak file? How do I know the file is 2 not 3? Thanks... ...more >>

Hi , I'm obviously missing something here ... Can someone tell we why I get this message (db option recursive trigger is not switched on !) Thanks Johan /****** Object: Table [dbo].[T_JOBI] Script Date: 8/10/2003 15:02:28 ******/ CREATE TABLE [dbo].[T_JOBI] ( [IdNr] [int] NOT ...more >>

Please, In ASP code, I can extract the time of a DATETIME object using <%TimeValue(RS1.Fields.Item("NameObjetc").value)%>. How can I extract a time of a DATETIME object using JAVA Script? ...more >>

I have defined a Cursor - DYNAMIC LOCAL UPDATE FOR . - in a Stored Procedure. When I try to Update it by using UPDATE csrCURSOR in the same Procedure the error message 'undefined object .. name is displayed. any Help in Updating data by using the Updateable Cursor will be welcome -- Tanveer...more >>

Folks, In SQL 2000, I've got one table (Contracts) that has a field (SalesmanID). SalesmanID comes from the table Associates where the AssociateType indicates that this person is a salesman. How can I ensure that the value entered into Contracts.SalesmanID is a person in Associates with A...more >>

Hi, I have a stored proc that takes 2 parameters. It checks one of the paramters for null and if it isn't then it does some processing. The problem is that after importing the data from another db the test now fails. I thought it was the ANSI NULL Default checkbox in options. It seemed to of fix...more >>

In SQL server, I want to know what is the data type of time? I use datetime for the data type of both date and time, it turns out when I add a new record like this: insert into [timecard] (ID, TimeIn) VALUES ('1001', '12:03:31 PM'); It will insert 1/1/1900 12:03:31 PM in the database. Any...more >>

Hi All: I am getting the error : Cannot resolve collation conflict for UNION operation. I've read all I can find in the books online on this, and tried whatever I could think of to solve this, but I can't get Unions to work in my SQL 2000 db when I try to do a union on two views. If I unio...more >>

Hi, I have two Sql Connections one is Fetching the data from the table at constant interval of time and another will update the data at constant interval of time. My problem is when ever the update Connection is updating the data it is locking the rows, Though I am not fetching the locked...more >>

Hello I'm currently developing a web application that contains a search form with various (mandatory) fields. As I would like to use SPs with paramters rather than to assemble the whole SQL string, I was asking myself how the query optimizer would ignore parameters which would only contai...more >>

Hello, What configuration could cause a database to substitute a space character for empty strings ? Two databases on the same server. In one the statement select '' + '123' + '' yields " 123 " and on the other the same statement yields "123". Thanks for any insight AP ...more >>

How would you link these table on a diagram: create table ClientLetters ( UserCode varchar(8) not null , LetterID int not null primary key(UserCode,LetterID) ) GO create table Letters ( LetterID int not null Primary key, OriginalLetterID int not null, Version int, De...more >>

Hi All, I have the following case. I have a table in MS SQL 2000, which has 8 fields and already populated with data. Now, I need to modify the table with the existing data in the following way. I need to condense the table (or move some fields from its current location, not deleting...more >>

Iam inserting records from table T1 to table T2 using following syntax insert into T2 (col1,col2) select col1,col2 from T1 T2 has contstraints on certain columns. Is it possible to determine which record failed during insert operation. Both tables have primary keys. If i insert single r...more >>

I want to run replication before SQL Service stops. I notice that it can be done in alerts... But which event do I have to capture ?? ...more >>

has anybody used sql server to serve up .mpg files for an internet application. we are now using SQL to store product images but wondered about movies Dan <><...more >>

This may be a very simple question, but I am wondering if someone can help me. I'm using the DMO Table object's Script method to script the tables in a database (I must generate the script because I am manipulating the output text). In the DMO documentation there is this line for setting the S...more >>

Hi... I'm writing a rather complex DTS script, and in one of my calculations, it'll be dividing by a variable from one specific table. Some of this data is null, so it's dividing by Null, which errors out saying I'm dividing by zero. Is it possible to tell MS SQL 2000 to produce a null in ...more >>

Hello, I need to populate another table with new records based on a data entry table. Basically in this data entry table, I have two fields that represent a range of numbers, an example record (range1 = 12, range2 = 18) In the table I'm populating, I need to insert a record for each value...more >>

We are taking big performance hits joining our cost information to different fiscal calendars for reporting purposes. Can anyone recommend a solution? I have my cost information stored in 1 table like the following: Vendor StartDate EndDate Cost A 1/1/03 1/7/03 1...more >>

I have an identity field in a db used by an ASP-driven intranet app. The field is the primary key, and it is a number the the user sees and uses. We went live with the app last week, and I reseeded the field to start back up at 1000. It had been 10000 when I was testing prior to going live, and...more >>

Can anyone give me any tips or links as to what the best practices are for SQL Server security? I am also interested to know the best ways to utilize a database remotely without the connection string being made available. Thanks , Ron ...more >>

Hi, I would like to load a file to our db server. I have the file on my local hard drive. Can I do it from query analyzer on my box? how can I specify the data_file? Thanks...more >>

What is the proper syntax to set an integer column to identity column? EM creates a new table, pumps the data over and then drops the table. This is TOTALY unacceptable! What if I have millions of rows in that table? In 1 single transaction it going to pump millions of rows into the transaction ...more >>

How do I get older bb postings. I was here about 9 mos ago and read a post, now I can't find it anymore. I think it was some time in 2002 or 2001. When I set the date back that far I get 0 results. ...more >>

When I try to run the code bellow, I have the answer: Server: Msg 226, Level 16, State 5, Line 3 CREATE DATABASE statement not allowed within multi-statement transaction. WHY???????? BEGIN TRAN BDPP WITH MARK 'Criação do Banco de Dados PP' CREATE DATABASE PP ON ( NAME = 'PP_D...more >>

Hello All & Greetings. I have the following scenario and am looking for some help and will appreciate any suggestions. Thanks in advance. Scenario: I Have 2 Tables. Table Structure: table1: partID, itemcode, speakers, DIN (bit field) table2: partid, vid For UPDATEs, I have to do ...more >>

The following trigger: =========================== create trigger update_trig on TEST for update as insert TEST_AUDIT select * , getdate() , 'UPDATE' from inserted i return ========================== gets fired when a row in the TEST table gets updated. We write the change to a...more >>

Hi! I need to "warehouse" data from an Informix table as a linked server into SQL Server. As there is no facility to see what changed, I would like to update all records or insert them, if there is none. Whats the best method to do something like that in a stored procedure? I looked to turn...more >>

To Whom it may concern: I have the SQL server 2000 installed. and I do know how to create the Databases using the SQL shortcuts. I do not know how to type the command "CREATE DATABASE newdb" to create a database. Do I do it on DOS prompt or is somewhere a "QUERY" link on the SQL Server ...more >>

I'd like to query records that meet a requirement, and then union in all records from the same Table that are referenced by those in the original result set. This second set can also reference records, and so on. Example: ID Description ParentID So, I'd like find all records that me...more >>

To Whom it may concern; I would like to create a database using the CREATE DATABASE command and I do not know where to apply it. Please let me know where I can type the command create database to create databases. Thank you Cristian Vitan...more >>

I get this message when I attemt to execute a stored procedure from an ASP.net page: "OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. \r\nINSERT INTO ##TempImport(APC,ServiceIndicator,Weight,NatCoin,APCDesc,Release) SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;HDR...more >>

Inventory Product_id Color Size Qty 12345 white A 2 12345 white B 4 12345 white C 5 12345 white E 2 12345 red A 4 12345 ...more >>

Hi Guys, Someone delete one system stored procedures (sp_grantdbaccess). How can I add this back. If I try to add, the owner is ok (as "dbo"), but the type is "user" which is not correct. I need it as "system" because all others have type as "system". In future how can I hide these...more >>

hi, I have created a linked server from my sql server to another sql server say "B". Iam trying to write an sp which has the foll. tsql commands. select * from B.master.dbo.sysobjects if @@error <> 0 print 'Error !' Now the problem here is that if the linked server "B" is down, i...more >>

Hi all! I need to return the output of the PRINT command to my VB6 application. I use the connection.Errors collection to get error information, but PRINT commands don't seem to add errors to this collection. I must be missing something... Thanks Vlassis ...more >>

Hi everyone I need to be able to extract data from a table (A_temp) so that i can pump that data into another table (Sales). Both table have the same columns but the A_temp table holds data that sometimes already exist in table Sales. In Oracle you could use the MINUS arguement to compare t...more >>

I have a deadlock scenario which I am finding hard to resolve. It appears to be deadlocking on an index rather than data. My application has multiple threads submitting queries to the database. Two threads often run the same stored procedure at the same time. Sometimes a deadlock resul...more >>

password_id standard_id password passworddate 1 4 password1 8/20/2003 13:00 2 4 password2 12/25/2003 12:30 3 4 password3 12/25/2003 13:30 4 2 mypass 6/5/2002 18:00 ...more >>