Hi! Guys, May be this question is little stupid but I want to clarify this. Let suppose I have image data field in Sql server 2000 and I am uploading an image of 10KB(thru asp.net application). What would be the size for that table with image data field ? Is it 10KB or less than 10KB or more th...more >>

Greetings All, I was hoping that some of you might be aware of any free scripts that were written explicitly for the purpose of monitoring a SQL Server database. I want to be able to determine up/down events, Error Log updates, Long running Transactions, Deadlocks, etc. My plan is to use a cen...more >>

Hi all, I have a table of text and associated data. I want to break apart the text into individual words, yet retain the data in other columns. For example: Sentence: Chapter: -------------------------- I like cats. 1 Joe likes dogs. 2 Should become: ...more >>

I've defined a linked ADSI server and I seem to be able to query the local domain ( localdomain.com ) with: DBCC TRACEON(7300) GO SELECT * FROM OPENQUERY(ADSI, 'SELECT displayName FROM ''LDAP://DC=localdomain,DC=com'' ') But I also have a trusted domain ( trusteddomain.com ) which I would ...more >>

Why is the transaction id returned by the profiler (or sp_trace_getdata) does not match with that in the transaction log ( as seen with select * from ::fn_dblog(default, default) ) in SQL2000/SP3? Thanks, sg...more >>

Hi I am a novice with SQL server as i have experience with access. I need to do some front end development in access for a client who runs SQL 6.5 or so he tells me... (i have been told that data files under 6.5 are .dat and under 7.0 they are .mdf? is this correct?) I have taken a copy of ...more >>

I have a table named Contact that has a guid primary key. After each insert in Contact, I want to insert the primary key value into another table called accountnumber. As I understand it, a temporary table called Inserted is created for triggers, but I'm not having much luck creating the trig...more >>

What tools has everyone used for cleaning name and address data (including identifying not-immediately-obvious duplicates) in connection with a CRM project or the Customer dimension of a data warehouse? What did you like/dislike about the tool you used? How customizable was the tool you used?...more >>

Hi, I have a view in which I have 3 cols...(pno,ptno,diff)..diff is the difference in time in minutes.I want to calculate Median(diff) group by pno,ptno...using a sql query for SQL server... Any help is greatly appreciated.. Thanks AJ...more >>

Awhile back there was some discussion about ways of sending multiple rows of data to SQL Server. The ADO .UpdateBatch method was one of the possibilities mentioned, and Erland said he thought that probably once the data get to SQL Server they are probably actually inserted one row at a time. ...more >>

I have created a view to test some of the data in my database. I am relatively new to SQL so may have caused this problem by doing something wrong. I have a table called SYS_Individual which contains records on individuals. A number of the fields in this take a numeric entry which corresponds...more >>

Is it true that SQL Server Standard edition can only use 2 GB of RAM? If so, and the box has more, does that mean the excess WILL be available for the O/S and any other apps?...more >>

First of all, I have never done any web-based stuff, so if the following sounds ignorant, it's because I am! So far all our SQL Servers are accessed only over our network and we use Windows authentication. Now the guy I'm working with on the design of our next stuff wants the two new databa...more >>

I've been designing SQL server databases for a while and have always assumed that primary keys and linking keys should be numbers rather than textual fields to improve performance. As an example, if i were to create a new table i would put in a surrogate primary key that autoincrements. I've...more >>

At my current workplace, whenever I check table sizes using the 'reserved' column from sysindexes, or sp_spaceused, I get a total for all user tables which exceeds the physical size of the database. Running sp_spaceused with no parameteres, I get a NEGATIVE value for unallocated space in the d...more >>

I have a table which I want to update by dividing one field into another. The update runs with no errors, but the results come out as only a positive integer number. The datatype for the result field is float. The datatype for the other fields are int. I have tried testing by dividing 7 ...more >>

It's me, one more time. My last request didn't quite filter all my records, I have one more field I need to evaluate in the script. DESCR TYPE SELL StartDate EndDate Number 65048 04 Price A 4/21/2004 4/26/2004 35456 65048 06 Price ...more >>

SQL Users/DBAs, I'm trying to move data files around for a database that is in standby mode. I can detach/attach the database fine using SP_DETACH_DB/SP_ATTACH_DB , but when I re-attach the database the log sequence is broken and I can't restore any more logs. Does anyone know if there is a...more >>

First, let me apologize for how easy this probably is: DESCR TYPE SELL StartDate EndDate 65048 04 Price A 4/21/2004 4/26/2004 65048 06 Price C 4/20/2004 4/27/2004 65048 08 Price B 4/22/2004 4/28/2004 65049 0...more >>

Hi there, I want to insert a new record into my database table, giving new field values for all but one (an image field), which I can copied from an existing record. The background to this is that I am allowing a user to create a new "template" from an existing one, thus I want a new record, ...more >>

How to build a TRIGGER that copies, all the time, the data from the table on which the transaction occurs to the historical table? thanks Fernand --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.659 / Virus Database: 423 ...more >>

I need to select records that begin with the letter A or B or C.. etc Here is my select query: SELECT '<a href="' & LINK & '"> ' & PLANNAME & '</a>' AS hyperl FROM TABLE; Where in here would I add A* to only pull PLANNAME records that start with A?...more >>

Say I have a table like this (just for example) ID Date Name __ ____ _____ 1 1/2/2004 Store A 2 1/1/2004 Store A 3 1/3/2004 Store B 4 1/2/2004 Store B Say I wanted to get the rows for the maximum dates for stores A and B aka this record set.. I...more >>

I am getting 2 resultsets depending on conditon, In the second conditon i am getting the above error could anyone help me.......... CREATE proc sp_count_AllNewsPapers @CustomerId int as declare @NewsId int set @NewsId = (select NewsDelId from NewsDelivery where CustomerId=@CustomerId ) ...more >>

Hi, Urgent Help appreciated.... I am getting resultset with first condition and when try to get the resutlset from second condition i am getting the above error in SQL200. I know that i am getting more then one value in the second condition but even i am getting more then one value in my...more >>

We have just installed a SQL Server 2000 (SP 3A) onto a computer that has Windows-2003 Server on it. Now, we cannot get access to that database server from other computers. Seem like this may be an issue with Active Directory. Our network consists of Windows-2000 Servers (SP 4) and Windows-200...more >>

I 've have a stored procedure that compares fields across databases. In order to do so it requires 2 values it acquires from 2 tables. The search is based on the ID of the data owner and a subject: proc_evaluate_results @StudentId = '222222', Course = 'PSY101' In order to obtain those values...more >>

Hello, My server is part of a W2K domain. What do you advice me as account to run my SQL*Server, service started with a domain user account or as local system ? I need advices from a security point of view. Thank's in advance...more >>

Hi, I want to change the datatype of an existing column from char to varbinary. When I run the "Alter Table" statement, I get the following error message - Disallowed implicit conversion from data type char to data type varbinary, table 'test.dbo.testalter', column 'col1'. Use the CONVERT ...more >>

I have created a table with the following columns... Date(datetime),Actual (Int),Planned (Int) I need to insert weekending dates starting from 23/04/04 looping thru'for the next 52weeks automatically into the date column. Then in the actual and planned colums, I need to insert a count of so...more >>

Hi everybody, I need some help on calculated values in my database design. I'm creating an accounting / business management application with the usual modules like A/R, A/P, Inventory, etc. I don't know how to handle calculated values in fields like "Customer Balance", "Inventory Item Qt...more >>

Hi, I've a problem with a job in SQL Server 2000. By enterprise Manager I try to schedule a job which will run a stored procedure. When I finish to schedule it I try to run it up manually but after few seconds it displays to me a failed message. The error message don't have an id so I cannot s...more >>

We have a DTS package developed on our development PC's (SQL 7). It runs fine. When we schedule it on the server (SQL 7), it fails. We have been able to find that this is a known issue down to the use of permissions (running it uses the users permissions, scheduling it uses the servers). http://...more >>

Hi All, I need to change a column value in several thousand records in a table and output a list of the record ids of the records I've updated into another table. The table, however, is being used by other users via a website, so I need to make certain that website requests don't touch on t...more >>

Hello I have spent the last weeks trying to solve this problem but with no luck at all, I have a piece of code that looks like this declare @bestnr int, @artnr varchar(25), @journalnrrow int, @bestlevant decimal, @vb_inpris money set @bestnr = 33434 set @artnr = '1441' set...more >>

Hello, I have just purchased a new CPU and when I attempt to install MSDE the process nears the end and stops, and removes the installed files. If anyonr has an idea on a correction let me know. Thanks ...more >>

Hi All Sorry for the spare info. It wasn't because I didn't want to display it. I just didn't know how to get the data that you needed. I think I've got it now so please note the following: 1) The DB is SQL 6.5. 2) My DDL for the tables in question: /****** Object: Table [dbo].[SAL...more >>

Dear Group A while ago I've asked how paging is possible and have read the articles on aspfaq.com. Great work, esp. the speed comparison of all the different techniques. Thank you to everyone who has responded to my post. Somewhow Google didn't let me reply to the thread! All of the methods...more >>

Hello!! How can I check my actual login i MSSQL. I need it becouse Login is argument of my procedure. Is it possible to make something like this?? Please help me!! ...more >>

I am trying to write a stored procedure that utilizes something like a while in ASP. my select statement is like this. s = select distinct(employee_id) from employee_table rs.Open s while not rs.EOF then I want to use employee_id in about twenty different sql statements. They are all ...more >>

We connect to a SQL 6.5 server (IP for example 202.64.213.11) on WIN NT using ODBC DSN and / or SQL Client (DB-LIB). Everthing was working fine then the some XP client machines (192.168.0.1 and 192.168.0.3) started giving problems. All TCP/IP connections go thru the WIN 2000 multihomed machine ...more >>

Can somone explain me how to run some procedure everyday at 22:00 in MSSQL. This is not an Administrative Task, it's my procedure. ...more >>

Hi All, I'm wondering if anyone can tell me if it's possible to search for stored procedures by their contents? I tend to leave very descriptive notes in stored procedures and they're beginning to build up in number, so I'm wondering if it's possible to search in Query Analyzer for stored p...more >>

Is there an easy way to loop through every stored procedure in a database and create a file containing all of the SP code? lq...more >>

I have an inventory database that Im trying to create a report out of the IP address are a lookup on a seperat table but I keep getting the above error can I change the table row to something to fix this or what. SELECT i.INVENTORY_ITEM_ID AS [IP Address],i.HOST_NAME AS [Server Name], '' ...more >>

Hi everyone, I have a cursor that goes through one table and does a comparison with another table, code below ============== CREATE PROCEDURE spMyDataBaseMatch AS set nocount on Declare @FirstName varchar(100) Declare @LastName varchar(100) Declare @PhoneNumber varchar(100) Declare @CourseCo...more >>

What are the units of measure for the Duration and CPU column in the Trace output view?...more >>

I have a table called BOLDetail and I need to update a column called "Tons" from int to decimal with a precision of 5 and scale of 3. I attempted to change the setting in Table Design but received an error when trying to save my changes. There's only about 12 records in this particular table, ...more >>

Hi All, I just got thrown to the lions. Can anyone suggest a light reading book with a crash course in SQL 2000 server that will get me up and running quickly? Thanks! Bill ...more >>

When I create a view consisting of an inner join between a view and a table the columns refernced in the the view are returned incorrectly, example select id.itemcode, id.description, iv.linevalue, iv.vatvalue from dbo.tbl_itemdetails id inner join dbo.vw_invoices iv where dbo.tbl_itemdetails...more >>

Hi, I'm writing a stored procedure to run a dts package and I've successfuly got this working using my sotred proc and the syntax of dtsrun is correct. However, I'm trying to pass a variable to the DTSrun command and this is where I'm having the problem the code for the proc is: Decla...more >>

These are my table structures . Could you please suggest me an alternative: tblArticles: ArticleID,Title,Summary,ContextSubTypeID,PostDate tblArticlePages: ArticlePageID,ArticleID,PageNum,Content tblAuthors:AuthorID, Name tblArticleAuthors:ArticleID,AuthorID tblContextSubtype:ContextSubTypeI...more >>

Hello! I would like to change the SQL server 2000 from Standard version to Development edition. I have two database running on this server, both replicated, with few jobs, etc ... Can you recommend the easiest way to do this? I heard, it would be as easy as, detaching the databases, deleting ...more >>

Hi, I'm a SQL Server newbie, so I'd appreciate if someone would tell me if this is possible. I'm running SQL Server 2000 on Win2k Server I have one table with a large number of columns. I have two pieces of logic that I'd like to execute depending upon whether an insert or an update state...more >>

I need to write a stored procedure that takes the following data: ID Sequence ColumnName 71 1 CustomerAccountName 71 2 RevenueClass And loops through the record set to concatenate Column Name into a string. The result should look like this: ID ColumnName 71 Custo...more >>

When using a Guid as your primary key in a table, does it make sense to make it a clustered index? Thanks, Rick...more >>

We are using a java codebase which writes data to a SQL Server 2000 database using the JTurbo (3.0) JDBC driver. We are finding that a record update takes longer and longer as the table grows. For example, when the table has ~200,000 records, the update will be around 1 second. Once table is u...more >>

Hi all, I bet this doesn't exist, but does anyone know of an MS SQL Enterprise Manager-type application for Linux that would give me access to a DTS stored on the server? I'm a web programmer by profession, and most of my tools are Linux-based, but because I do so much indepth work in MS SQL...more >>

I have never written a trigger before, but I have a couple of uses for them now so I am trying. I have a view that I created and I want to have this trigger, run anytime the view is run. I don't know if my problem is with the trigger or permissions on the view, right now I have given everyone p...more >>

I have two tables STUDENTS and REGISTRATIONS. I wish to update my STUDENT table field, LAST_ATTENDED_SESSION_ID from my REGISTRATION table of the max SESSION_ID found in the REGISTRATION table. STUDENT starts off with: STUDENT_ID LAST_ATTENDED_SESSION_ID 123456789 000000 234567890 ...more >>

Hi ! Can anybody tell, how to transfer the sql server 6.5 Data to SQL server 2000. I use the upgrade utility, but it gives an error....more >>

Background: I am using a MS Access 2000 front end with SQL Server 8.0 back end. I have the requirement to import all text files (regardless of filename) from a given folder on the network into a table within SQL Server. This import needs to run continuously, as more text files will be saved ...more >>

Hi all, a bit of a nasty one here! Ive inherited a server that has just collapsed. It contains SQL Server and has a fair amount of data on it. The server would only boot into a BSOD Stop Error. I suspected that one of the hives in the registry was corrupt so I used the Win2K Recovery Consol...more >>