Rating Thread / Thread Starter	Last Post	Replies	Views
Looking for very good SQL Server DTS books Hello, folks. I'm searching for some good must-have books on SQL Server DTS. If you are in the DTS business daily, you probably know which books are... Trent	08-19-2004 01:48 AM Narayana Vyas Kondreddi	1	61
Derived Columns in one to many relationships I'm trying to write a query that concatenates multiple records into one derived column. Let's say I have an author (Joe Writer) who has... Big Time	08-18-2004 04:53 PM Erland Sommarskog	4	56
Looking for very good SQL Server DTS books Hello, folks. I'm searching for some good must-have books on SQL Server DTS. If you are in the DTS business daily, you probably know which books are... Trent	08-18-2004 04:42 PM Trent	0	68
NON DOMAIN AND DOMAIN CONNECTION Hi all, it happen to me a strange problem: i have a mdb file (in Access 2K) with SQL Server 2K linked tables who runs on a workstation which is on... RavieR	08-18-2004 04:24 PM Erland Sommarskog	1	67
Storing variables from a user-defined function I've looked all over but can't find a solid answer. I've got a function that runs from a View and when the function runs the first time it is... Steve D	08-18-2004 04:20 PM Erland Sommarskog	2	60
General questions New to using databases that are NOT Access. New to MS SQL Server. I'd like help understanding some concepts. Firstly, I'd like to know how to... Oz	08-18-2004 04:15 PM Erland Sommarskog	1	66
Looking for very good SQL Server DTS books Hello, folks. I'm searching for some good must-have books on SQL Server DTS. If you are in the DTS business daily, you probably know which books are... Trent	08-18-2004 03:46 PM Trent	0	54
Starter question Hello all! This is my first on this newsgroup, because I am starting my adventage of MS SQL Server 2000 Enterprise. I have just installed this... Kamyk	08-18-2004 03:30 PM Kamyk	2	78
Range query This query returns only those starting with A and B. Why? SELECT name FROM mytable WHERE name BETWEEN 'A' AND 'C' Rathtap	08-18-2004 02:38 PM Ross Presser	3	101
Century date conversions Hi, I'm trying to load date fields into SQLServer using DTS, but the format of the raw data is the number of days since 1 Jan 1900. How do I convert... Helsop	08-18-2004 09:40 AM Kapil S	2	53
Automatically create ODBC connections Hello everybody! I'm using the 'Data Sources (ODBC)' program that comes with windows to create the odbc connections I need. Although that is quite... Johnny Ljunggren	08-18-2004 09:40 AM Johnny Ljunggren	2	59
ON DOMAIN AND NOT ON DOMAIN Hi all, i have a strange problem: i work with SQL Server 2K (back) and Access 2K (front). When i create a mdb file with sqlserver linked tables... RavieR	08-18-2004 08:41 AM RavieR	0	61
memory We add RAM to a Cluster server SQL 2000 box. I need to re-configure the SQL Server memeory. What is the best pratice? Do I have to shutdown,... Shawn	08-18-2004 04:31 AM Simon Hayes	1	93
Is there such a thing as too many relationship? Hi, I have a corporate database with about 60 different tables that spans manufacturing, accounting, marketing, etc. It is possible, but unwieldy,... H Cohen	08-17-2004 07:13 PM Michael K Campbell	4	77
Problem creating indexed views with linked servers Hi, I have a problem, maybe someone can help me. I'm traing to create a view with a Linked Server This query works great: select id, descr from... Ariel	08-17-2004 05:26 PM Erland Sommarskog	1	93
Re: User Defined Function: Convert String value of Table to Table Object On Tue, 17 Aug 2004 08:51:44 -0700, Erik Grob (MCP) wrote: Others may know better than I, but I don't think you can make this completely... Ross Presser	08-17-2004 04:04 PM Erik Grob	1	67
Selecting ONLY records from one table having ALL data contained in other table (GROUP BY?) Hello everyone, Small and (I think) very simple quesiton;-) which makes me creazy. Let's say I have two tables listed below: T1 ==== IDX ==== 1 Matik	08-17-2004 03:13 PM Mateusz Marzec	2	58
Need help with designing a query Hi All, I have a table below and I want to design a query to pull all the members from the TABLE into a Query Result and into a single column... Jimmy Tran	08-17-2004 02:07 PM Ross Presser	1	55
ANN: Protect T-SQL script source code with dbLockdown (special pricing) Ecatenate is pleased to announced SPECIAL PRICING on dbLockdown leading up to our release of dbLockdown 1.5 for SQL Server 2005 'Yukon' Using... Simon Train	08-17-2004 11:24 AM Simon Train	0	49
ANN: Protect T-SQL script source code with dbLockdown (special pricing) Ecatenate is pleased to announced SPECIAL PRICING on dbLockdown leading up to our release of dbLockdown 1.5 for SQL Server 2005 'Yukon' Using... Simon Train	08-17-2004 11:24 AM Simon Train	0	60
Storing all stored procedures in one database to minimize different connection strings In order to minimize the number of connection strings I have to use to access different databases on the same Sql Server, I was considering storing... Minh Tran	08-17-2004 09:23 AM Minh Tran	4	64
Check SQL Database offline Hello, I am trying to check the integrity of SQL database. The 'problem' with SQL server is that it's fixing the DB automatically after restore so... Moti	08-17-2004 08:26 AM Simon Hayes	1	69
DB Growth Issue I have done this experiment on one of the tables. There is table called build havinf nvText Field with large no of records. I want to drop... Harcharan Jassal	08-17-2004 05:35 AM Simon Hayes	1	66
Help with more Advanced functions I have been able to get several basic databases to function both in playing around and functional ones on the web but they have all been pretty... Houston	08-17-2004 04:52 AM Simon Hayes	1	59
Return two rows from one rows data I know this table is designed wrong for what I am doing but I hope I can do it. I have a table like this. Prod_A_Jan, Prod_A_Feb, Prod_B_Jan,... George	08-16-2004 10:33 PM Anith Sen	2	59
help with linked server on sql2000 hello, I'm trying to create a linked server from an SQL2000 to a Unify ELS (very old, odbc is version 1) database on SCO unix. The odbc driver is old... pheonix1t	08-16-2004 04:48 PM Erland Sommarskog	4	80
copy two table hi, How copy two table between two database? copy 1 table1 to 2 table2 1 - cursor number, 2 - cursor number, table1 - sourse table table2 -... ja	08-16-2004 07:06 AM Hugo Kornelis	2	62
Convert table using DTS Hi, how to: using dts convert row in table to column. i have table: col1,col2 b1 , 1 b2 , 2 b1 , 4 b3 , 3 b2 , ... tolo	08-16-2004 06:42 AM Simon Hayes	1	65
sintassi per Creare un file .cub a partire da un cubo mssql Sto usando vb6 per creare un file .cub a a partire da una query: LOCATION= d:\Test.cub; SOURCE_DSN = "Provider=MSOLAP.2;Data... Mego	08-16-2004 04:33 AM Mego	0	81
track all changes hello, I was wondering how to track all changes on tables by using some sort of a history table. What i would like is a generic history table where... Ezekiël	08-16-2004 03:43 AM Erland Sommarskog	1	63
Joins versus relationships If a database has relationships establshed between all of the tables via primary and foreign key constraints, why isn't is possible to make a SELECT... H Cohen	08-15-2004 07:14 PM Steve Kass	4	75
upgrading hard drives, best way to back up and restore SQL I'm formatting my mirrored drives and installing a third drive for raid 5 to add more space. I have backup exec. Can anyone tell me the best way to... Ned Hart	08-15-2004 06:54 PM Ned Hart	3	59
Problem with FILENAME as @variable Hi. I am trying to create a database based on variables from xp_regread. Somehow I can´t pass @dBDir as FILENAME. I get the following error-message... Michael	08-15-2004 05:23 AM Michael	2	57
Drop Index on System Tables SQL SERVER 2000 System let's you alter the system tables and add indexes. However, it won't let you drop the index afterward. Anybody know how to... Kevin Haugen	08-15-2004 04:35 AM Erland Sommarskog	4	71
One column is nullable on the composite key Hi All! I would like to have a composite PK on 3 columns, one of them is null CREATE TABLE TableA ( ColA int NOT NULL , ColB int NOT NULL , ColC... Andy	08-14-2004 05:11 PM Erland Sommarskog	3	63
performance question Hi , long time I didn't ask any questions And now I am back. I have a huge query that looks like that select emp.name, a.field1,... inna	08-14-2004 05:08 PM Erland Sommarskog	2	83
compact No one answered in another group, please help. Using access 2000 /msde I know how to compact the access project file (.adp), there's a menu... JIMMIE WHITAKER	08-14-2004 03:48 PM John Bell	1	104
TSQL command to call .sql files I have several .sql files with schema/data changes to be applied to our current database. Is there a way to create a TSQL script that could be... dynoweb	08-14-2004 03:12 PM ParrotRob	2	92
permissions with sql server tables Hello, I need some help with implenting the following: I recently migrated from access to sql server and i now i want to use maintainable... Ezekiël	08-14-2004 11:01 AM Dan Guzman	3	59
Inserting / Updating LongText Field using WriteText? Hi, I'm trying to store large strings to a database, so am using the text field type (LongText). I have used this before when storing the html of a... Iain Porter	08-13-2004 06:24 PM Iain Porter	5	89
Less than, equal to Operator question Hello everyone, I'm not a database guru so I'm sorry if this is a dumb question but here it goes... I have this sql query that I'm trying to run... Jeremy Howard	08-13-2004 05:49 PM Hugo Kornelis	4	75
SQL Server table changes log Hi, How can I find out when a particular table structure (design) was last modified? I want to find out whether the creation and modification date... Surajit Laha	08-13-2004 11:39 AM Simon Hayes	1	66
NULL and MAX Query Hi I have a table called Orders with columns OrderId, ItemReceiptDate and itemnumber. Sample Data is given below: OrderID \| ItemReceiptDate \|... Muzamil	08-13-2004 08:10 AM Muzamil	8	65
SQL Query Help-- Order By Clause Hi I want a simple select query on a column-name (smalldatetime) with values dislayed in desc order with null values FIRST. i.e. Select orderdate... Muzamil	08-13-2004 08:03 AM Muzamil	7	67
SQL Join Statement problem ( 1 2 ) Hi, I have the following SQL statement which is pulling a few details from a database. As you can see, there is only the one table from which i am... kieran	08-13-2004 07:13 AM kieran	13	112
Linked Server from SQL-Server 2000 to Oracle 8.1.7 We have a linked server, which worked fine, but we have just changed the collation sequence, in SQL-Server, from SQL_Latin1_General_CP1_CI_AS to... wotan	08-12-2004 08:59 PM Daniel Morgan	3	99
Less than, equal to Operator question Hello everyone, I'm not a database guru so I'm sorry if this is a dumb question but here it goes... I have this sql query that I'm trying to run... Jeremy Howard	08-12-2004 05:34 PM Jeremy Howard	0	57
How to catch an exception? Is there something like exception handling in T-SQL? For example, how to catch an error of convertion at this sample: CREATE PROCEDURE SP @param... Evgeny Gopengauz	08-12-2004 04:48 PM Erland Sommarskog	4	70
SP waits for a delete trigger? Hello to all, I have a small question. I call the SP outer the DB. The procedure deletes some record in table T1. The table T1 has a trigger after... Matik	08-12-2004 04:43 PM Erland Sommarskog	1	70
use db-lib to update database records How to use db-lib to update/insert database records without using SQL language. I want to change the value of the data individually without plugging... Carlo Chung	08-12-2004 04:40 PM Erland Sommarskog	1	67

Page 201 of 283

201

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off