My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I have never setup a server from the beginning, so I am a little new at creating server groups. Alright, I am trying to create a server group. I right click on the "SQL Server Group" and make a name of "TEST" and put in the sub...more >>

Hi, I am getting errors in the following... Is it even possible to join on CONTAINS? SELECT ListA.Content FROM ListA LEFT OUTER JOIN ListB ON CONTAINS(ListB.Content, ListA.Content) WHERE ListB.Content IS NULL Thanks! ...more >>

Hi there! I have a problem I can't get rid of... I hope anyone can help me with it! For a room-booking application I need to select available rooms for a given period. First I do the availability check which is no problem, than I need to find out if there is a tariff available for every nigh...more >>

Hi All I want to insert rows from a table in a server into another table in another server using INSERT SELECT command. For example : INSERT INTO Server1.database1.dbo.Tab1 SELECT * FROM Server2.database2.dbo.Tab1 WHERE Col1 = 1 Can the command like this work ? If not, could ...more >>

Is there any reason at all to use a timestamp column in a table having a primarykey column??? lq...more >>

We tried to load a file that contained 1 column of datetimes of the format yyyy-MM-dd hh:mm:ss into a table that had the column set as a datetime type. We did this using a DTS package. The error from DTS is attached. There seems to be strange characters hidden in the file because a visual scan ...more >>

I had a databases running on SQL Server (EVALUATION VERSION). I moved it to another system running: -Windows 2000 Server -IIS 5.0 -BlueDragon Server -MSDE I applied all of the latest service packs, security updates, etc... Intalled SQL Server Web Data Administrator and .NET framework. ...more >>

Hope MSDE questions ok here. I would like to distribute a MSDE application on CD ROM. I don't have any of the packaging solutions i.e. Visual Studio, Office Developer or VB Pro. I'm using MS Web Matrix to build an ASP.Net front for MSDE. How distributable is MSDE without the additional distrib...more >>

I have a table tblEmails where the columns are id,list_id,address_id. I have many lists. I need to find out if a couple of lists (list_ids - 1000,1001,1002) have same address_ids in common or not. Snaphot 1,1000,1234 2,1000,2345 3,1001,4567 4,1001,1234 now the query should return...more >>

Hi! I have a large table width values like this: 000024634300 000-37500000 002783868891 000009603857 000-60000000 000001672396 000000195200 000010315112 000017000000 I need to convert the numbers into an integer-type field. Is this possible with just native sql-commands? I don't wa...more >>

I know that I can have up to 2 GB RAM for the Standard Edition of SQL Server, but if I had two instances, can I have 2 GB per instance, say for 2 instances which would equal 4 GB, or is it 2 GB for that installation of SQL Server and all of it's instances? Thanks. ...more >>

Can anyone please tell me if it is possible to bcp in a file with hex data into SQL Server 2000? I have a file that the characters appear as blocks when viewed in notepad but appear as hex values in a hex editor. I have put just one of these characters (hex 1A) into a file and tried to bcp it ...more >>

I have been a Software Developer for 25 years mostly PC based for the last 20. I have been earning my Doctorate for the past 4 years and am now doing my Dissertation. The theme of my dissertation is the relationships between job characteristics, job satisfaction and turnover intention among Soft...more >>

Let us consider the example of a stock system. Suppose that in each transaction, cumulative totals of sales are kept. Now to find the cumulative sales at any time a composite index of stockcode and transaction timestamp could be stored. To access the index a composite key of stock code and ti...more >>

Hi all, How to determine whether a user has the right to create a databse in MS SQL Server programatically. With Regards, A.Ilamparithi....more >>

How can I determine which port MS SQL is running. I known that this can be set at SQL Server Network Utility, but I wonder why my ASP.NET script can connect to SQL Server even I change its running port. Another thing I want to know.... actually it doesn't concern with SQL that is, how can I ...more >>

Hi folks, I need to know which EXE's of SP3 to install with SQL Server 2000 Personal Edition. From the Microsoft website: http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en ....it has these 3 files: Database Components ...more >>

Ho all SQL gurus, I've searched for samples on how to automatically scripting SQL2000 tables to export data between databases via a sql script. (somehing like: INSERT INTO [ges1gara].[dbo].[CategAtleti]([CodCat], [Denominazione], [LimiteBassoDonne], [LimiteBasso], [LimiteAltoDonne], [LimiteAlt...more >>

Ho trasportato sul Sql-Server del cliente: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: ) un db sviluppato su un mio sql-server di sviluppo: Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86) Desktop Edition on Windows NT 5.0 (Build 2195:...more >>

Hello, I am trying to write a VB.NET monitoring application for a MS SQL server. For that I need to know the following: 1. How do I count the number of read/write accesses per database on the server since the creation of the DB? 2. How do I get the last access time of the database ? Any i...more >>

MS SQL-Server 7.0 Bypassing recovery for database 'EfW_765' because it is marked IN LOAD. What does this mean? Our customer is backing up is maindatabase and is recovering it to this database for testing. Our custumer tries it serveral times and then the recovery works and the data are corrupt...more >>

Hi How can i make textreports after backup with t-sql without using Database Maintenance Plan. thanks alex *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hi all, i am pretty new to ms-sql server 2000 so do not go to hard on this one. I am trying to retrieve information from a table that grows a couple of hundreds new record every second. When i issue a select statement i get a timeout expiration error from the server; i guess what happens is th...more >>

Hi everyone, I am wanting to store documents (doc, xls, pdf, ppt...) within the DB. Is it advisable in general (I don't know exactly how big the docs are going to be) to compress the files before putting them into the DB? How does this affect Full Text Searching? Thanks for your help in adv...more >>

Hello, I have run into some problems with logfiles and backup logfiles (MS SQL server). I have read much about them but uptil now I dont seem to grasp how it works. Specially the part of working with backup log files. Can someone please help me with this? What I want todo is to create ba...more >>

I need to create a stored procedure in the master database that can access info to dynamically create a view in another database. It doesn't seem like it should be very hard, but I can't get it to work. Here's an example of what I want to do. CREATE PROCEDURE create_view @dbname sysname AS ...more >>

This is a request for help fixing a SQL Server 2000/ADO problem on Windows XP. I would appreciate any useful assistance. PROBLEM: SQL Server access on my machine fails as follows: 1. All of my VB6 apps reference the following ADO typelib: Microsoft ActiveX Data Objects 2.7 Library Locate...more >>

Hi all i am building a SQL 2000 database that it is proving a little challenging, i have companies with multiple addresses, phone numbers, owning mine sites etc and also joint ventures so maybe you get the picture with a few design issues that i ma encountering My queriy is about a primar...more >>

Hi All, First, where can I get some questions of this sort answered? Preferably, are there good books or online guides that I can consult for these types of answers when necessary? 1. How do I know, when executing a query from Query Analyzer or otherwise, how many temporary tables will be ...more >>

I have a table with a column called Schedule. It's setup as varchar(120). Schedule can contain several items at once like 'MO','WE','FR'. I am trying to do a select like the following but I can't get any results back. I'm using MS Sql 2000. SELECT * from tblMail where 'MO' IN (Schedule) ...more >>

I have never written a trigger before and now am seeing the light. Is there a way to write a trigger so that if a user changes any column in a single row on one table then the trigger will write the value of this (these) rows to a second table. I don't want the unchanged columns, just the change...more >>

In a 'Top n' type statement I wish to be able to insert the n value from a parameter, within a stored precedure eg Having declared @pageSize as a parameter I want to run the following type of query : SELECT DISTINCT TOP @pageSize routeID, routeName FROM tblRoute_Header When I att...more >>

I have two questions. First is there an easy way to tell what edition of MS SQL Server is on a machine? I found some code that is supposed to do this, but if I put that code into the query analyzer, it doesn't work. (Doesn't look like SQL query in any case.) A more general question...more >>

I am looking at various software packages that can help deploy SQL data to a remote DR facility. Essentially I am looking for something that would allow us to bring up a cold or warm standby SQL server to be used in the event of a site disaster. In the past I have used EMC technologies and found...more >>

I used to have a sql script that searches all tables' columns in a database for a string in the column name. For example: Searching for 'account' will produce all column names with table names that have the string 'account in their names. AccountNumber.. AccountNum.. etc. Anyone has such ...more >>

pls anybody help me with this. i need to make a query where i have to display all names of a category heirarchically. C1-->C2-->C3-->C4 where C1 is the top level category it shud b displayed as C1/C2/C3/C4 Also there can b any no of category levels. pls anybody help me manu...more >>

SQL Server 2000 Ent, PowerBuilder 6.5 Ent, Window 2000 Pro Hi, My only experience is with Oracle,so please bear with me... We have some new clients that require our pricing data be imported into their Sql Server databases. The price lists are in Excel files, which we recieve from numerous...more >>

Hello, I'd like to know if I use DTS. If I use it immediately, I can see the error in the dialog box, instead, if I use it with scheduling, where Can I check the error ? Thanks Saimon(Florence) ...more >>

Is it possible the existence of a return parameter on an SP running insert statements would cause blocking to happen (any removing it might help eliminate it?) The SPs in question have three INSERT INTO statements using an @@IDENTITY to help populate the second and third tables based on the PK ...more >>

I have a situation where I want to pull strings from one table of a SQL 2000 database and find matches for it in other tables of the same database and have those values returned. i.e. In one table I have prospects and I want to match their names to a table that stores the names of prospects tur...more >>

In an Insert Into statement I have used the Host_Name() function to identify which user has suppied a record to a table that holds temporary data. I'm using an Access2K front end. Code: Alter procedure SPName @parameter1 int AS Set nocount On Set xact_abort off Declare @myHost nvarcha...more >>

Dear Sir I have problem which I am describing below:- In my databse , size of Data file is 40 MB size of Log file is 4158 MB which is causing the size of my database so huge why this log file is so huge ? How I can control it, I have already set Parameter for Da...more >>

If I have a hardware firewall in place and I do not open any ports for SQL Server, is there still any possibility someone can hack the machine through a SQL Server vulnerability? Also, if so, how do I stop the outside world from accessing SQL Server? The only thing I want accessing the databases ...more >>

Dear Group I'm having trouble with the clause below. I would like to select only records with a distinct TransactionDate but somehow it still lists duplicates. I need to select the TransactionDate once as smalldatetime and once as varchar as I'm populating a drop-down with Text/Value pairs. So...more >>

Hi all, I have a server from which keeping clients off for maintenance is difficult. They all have VPN connections and can be online any time they want, and uptime as always is important. Now I need to run dbcc shrinkdatabase, checkdb and of course checkpoint right before backups, and when ...more >>

Hi!I had strange problem: There are two user databases on the serser. I backed up both database and transaction log for two databases. Dump tran and dump db are good for one database. But for another database, only dump db is good, dump tran is failed every time. The message is: "Executed as use...more >>

Hi everyone, In using the SQL Server Database Wizard in Access 2000 to create a new access project, I get two consecutive error messages and then the wizard shuts down. The first, which apprears immediately after starting the wizard is a message box stating something like "the property value i...more >>

or in registry? where?...more >>

I have the following 2 tables: location: place lft rgt ------------------- Europe 0 99 England 1 10 France 11 20 Italy 21 30 Asia 100 199 London 12 12 staff: name locLft -------------- Edwards 0 Smith 1 Leveil 11 Rossi 21 Lee 12 Chan 100 location uses the Celko hierarchy mod...more >>

Hi, I am using data from multiple databases and/or queries. It would greatly simplify and speed things up if I could use CONTAINS in processing the results. However, "CONTAINS" requires the data to be indexed. Due to the amount of processing, I think it would be faster even if I had to re-inde...more >>

Hi, where Can I see the default size of new database in database MODEL ? In which table ? Saimon(Florence) ...more >>

Just wondering if this is good form: Alter Procedure "mySPName" @UniqueID int AS set nocount on set xact_abort off DELETE FROM tblNameOne WHERE (tblNameOne.UniqueID = @UniqueID) DELETE FROM tblNameTwo WHERE (tblNameTwo.UniqueID = @UniqueID) Is it a good idea to run multip...more >>

Is there any benefit as far as performance for creating a database diagram in SQL Server 2K? Just wondering... lq...more >>

All, if I were to write an app that has one task, determine whether or not an SQL Instance is running, what would be the easist method for this? I personally think that a query against the masterdb would do the trick. I would appreciate any feedback you can provide. L...more >>

How Do I use an ODBC database in Query Analyzer? Presumably I could then join a table from another database to a SQL table to either pull information together or pass information back and forth between the two databases. Thanks....more >>

I have used Linked Servers to hook up to an Oracle 9i database in SQL Server 2000. I can see all the Tables and Views when I look in the linked server section. I can also run the following SQL statement : Select * from Orcldb..SYSTEM.CrossTabSaveSites and get a return result. The problem...more >>

SELECT * FROM organization WHERE (departmentID = divisionID) AND (divisionID = branchID) AND (branchID = sectionID) AND (sectionID = unitID) Is there anyway I can make this query more simlified w/o repeating the same column in the where clause? thanks s/RC...more >>

When I change a column from text to varchar using the design view of a table within Enterprise Manager the varchar value (less than 8000 characters) appears in the column but does SQL Server automatically delete the text values from their pages? If not are they removed by routine reindex...more >>

I was wondering if anyone knows a better way in which to accomplish the following search request. I am making a business directory website and when a user performs a search on this site I need to return matched company names together with a list of the category names which those companies belo...more >>

Hello, I have a test database with table A containing 10,000 rows and a table B containing 100,000 rows. Rows in B are "children" of rows in A - each row in A has 10 related rows in B (ie. B has a foreign key to A). Using ODBC I am executing the following loop 10,000 times, expressed below ...more >>