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...

Warren Wright

04-12-2004 03:26 PM
Simon Hayes

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...

Smith

04-12-2004 02:59 PM
Simon Hayes

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...

Lauren Quantrell

04-12-2004 02:57 PM
Simon Hayes

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

Lauren Quantrell

04-12-2004 02:49 PM
Simon Hayes

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...

Jevon

04-12-2004 02:45 PM
Simon Hayes

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'...

John Dalberg

04-12-2004 12:37 PM
John Dalberg

Hi there, I am trying to make an OLAP cube on a table having two columns (datetime, Number_of_times_an_event_occured). My dimension is time and I...

Kasp

04-12-2004 11:39 AM
Kasp

For the following table we've written an update trigger : CREATE TABLE . ( IDENTITY (1, 1) NOT NULL , NOT NULL , NULL , NULL , NULL , ...

vsgore@indiatimes.com

04-12-2004 04:43 AM
vsgore@indiatimes.com

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...

Karen

04-11-2004 10:42 PM
Karen

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...

Ghazan Haider

04-11-2004 12:41 AM
mountain man

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...

Stephen Bishop

04-10-2004 08:58 PM
Martin

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...

Martin Feuersteiner

04-10-2004 05:04 PM
Martin

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...

Kevin Frey

04-10-2004 01:18 PM
David Portas

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...

Rob Wahmann

04-10-2004 11:50 AM
Rob Wahmann

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...

Vineet Bisht

04-10-2004 03:32 AM
Steve Jorgensen

Hi My user has put ' with editable place and then press enter so this same way put text information with ' string into database. When I try tu user...

Qwiati

04-09-2004 08:01 PM
Qwiati

Hello, I have been trying to solve this problem for a couple of weeks now with no progress. I created a package that works when it runs from my...

Rowan

04-09-2004 06:00 PM
Rowan

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)...

Steve Morris

04-09-2004 12:33 PM
rimaty

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...

Mike

04-09-2004 12:23 PM
rimaty

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...

Saiyou Anh

04-09-2004 10:53 AM
Steven Wilmot

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

abracad

04-09-2004 02:27 AM
Hugo Kornelis

Hello I was wondering if someone could help me out with something. With the following rows: agnt_num supv_num meet_num strt_dt strt_lvl ...

Bill

04-09-2004 02:22 AM
Hugo Kornelis

SELECT * FROM organization WHERE (departmentID = divisionID) AND (divisionID = branchID) AND (branchID = sectionID) AND (sectionID =...

reneecccwest

04-08-2004 10:57 PM
reneeccc west

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...

Darren Jensen

04-08-2004 10:03 PM
Darren Jensen

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

Saimon

04-08-2004 08:26 PM
Dan Guzman

I found that SQL Server (I'm working with 2000), when doing SELECTs like: SELECT * FROM Table WHERE key='xxx' first puts a lock (shared) on the...

Alex Drobyshev

04-08-2004 07:16 PM
Alex Drobyshev

Using SQL2000, I cannot get a DTS working based from VB Transformation DTS below. Data originates from MS Access database and gets imported onto SQL....

BFord

04-08-2004 05:58 PM
BFord

Anyone encounter differences between SQL2K EE and SQL2K Dev Editon? FAILS ----- Machine_A <-- JDBC --> Machine_A\SQL2K_Dev_Ed..db Error:...

LB

04-08-2004 11:25 AM
LB

Hello, How can I record certain type of querys ? I would like to record delete command sent to a specific database, and using a specific login...

Eduardo

04-08-2004 03:17 AM
Simon Hayes

I am new to SQL Server 2000, I am looking to set up some type of loging on out test database. I need to track what table are hit when a record is...

Daniel Kubicek

04-08-2004 03:14 AM
Simon Hayes

Hi, I'm getting errors when trying to run a query over linked servers that works fine on a single server. The error text that comes up in QA is as...

Roberto :-

04-08-2004 03:06 AM
Simon Hayes

Hi all, I have a problem trying to generate the u/m list of customer. I am trying to generate a list of customer whoes last commence date is jan 04...

The Blob

04-08-2004 02:22 AM
Kevin Frey

Hello SQL and Crystal Reports friends, I am trying to make a report and need some help please. It is a helpdesk database. Jobs are logged, and...

Helpdesk Man

04-07-2004 05:47 PM
Helpdesk Man

Is there a keystroke such as "CTRL-N" that would allow me to have multiple .SQL files open at once in SQL Query Analyzer? I feel like I am "jumping...

Brian

04-07-2004 03:07 PM
Brian

I came to know that the locking behaviour of sql 7 and sql 2000 is different when creating objects.So we can use select into with large resultsets...

Ajay Garg

04-07-2004 01:34 PM
Ajay Garg

Hi, sorry for such simple question: I've just generated my first cube in MS-SQL server 2000 cube editor and need to copy it to Excel. But I cannot...

Martin Mrazek

04-07-2004 12:54 PM
Martin Mrazek

Hi all, I need sone help on generating a SQL statement i had 3 tables now Customer Invoice

The Blob

04-07-2004 12:47 PM
Joe Celko

I have a text field (called TreeNode) that contains node identifiers for a dynamic tree on a web page. For...

Calan

04-07-2004 11:13 AM
louis nguyen

When a web application becomes overloaded with traffic, one can offload it by load balancing and clustering the front end web servers. What...

Shabam

04-07-2004 08:06 AM
Simon Hayes

Hello group. I have an issue, which has bothered me for a while now: I'm wondering why the column statistics, which SQL Server wants me to create,...

Jesper Jensen

04-07-2004 07:12 AM
Simon Hayes

does anyone know if there is a way to generate an insert script based on the records in a table? I want to distribute the contents of a couple of...

Sjaak van Esdonk

04-07-2004 07:08 AM
Thomas

Hello, Is there a query or a method that can return the list of all the indexed words in a column that has been full-text indexed in sql server 2000?...

Jay

04-07-2004 07:05 AM
Simon Hayes

Hello I am running a SP from the SQL Server Agent, the job has one step that looks like this. exec q_spr_inlevextsystem This job fails with the...

Matt

04-07-2004 06:29 AM
Matt

Hi, 1. my server configurations: remote network: sql server 2000 (srvrR1) local netwerk: server1 - sql server 2000 (srvrL1) server2 - sql server...

Jan

04-07-2004 05:05 AM
Jan

Can you give me the step-by-step procedure to setup some alerts in SQL 2000 to get pager or email notification once the : 1- SQL Server (service) is...

Frank

04-07-2004 04:58 AM
Simon Hayes

stevesusenet (AT) yahoo (DOT) com (Steve) wrote in message news:<6f8cb8c9.0404061129.1960014 (AT) posting (DOT) google.com>... The output of PRINT...

Simon Hayes

04-07-2004 03:50 AM
Simon Hayes

Hi All, I have a database that is serving a web site with reasonably high traffiic. We're getting errors at certain points where processes are...

M Wells

04-07-2004 03:33 AM
Simon Hayes

I am trying to BCP some data collected with performance monitor into SQL Server. Here is the table that I'm trying to bulk copy into: create table...

Patrick Shroads

04-06-2004 07:47 PM
Patrick Shroads

Hello, We maintain a 175 million record database table for our customer. This is an extract of some data collected for them by a third party vendor,...

Warren Wright

04-06-2004 06:25 PM
Kevin Frey

Hi. I am trying to automatically backup transaction log when error 9002 happened. So i have created appropriate job and alert to catch this error. I...

Igor Solodovnikov

04-06-2004 04:07 PM
John Pollins