I've got a diagram that links a dozen or so tables - lines everywhere. Looks neat, but it would be a heck of a lot clearer to follow if I could say...

Patrick Molloy

08-26-2003 10:57 AM
Sue Hoegemeier

Hello, Our project involves a lot of data transformation, processing and matching operations on multi-versioned data sources (physical tables) -...

Eyal Lanxner

08-26-2003 10:33 AM
Eyal Lanxner

I have an application that sends mail using triggers on a spesific table. When I execute the master..xp_sendmail procedure from QueryAnalyzer it...

Robert Vabo

08-26-2003 02:48 AM
Robert Vabo

Hi Bill, I noticed that you have posted the question titled"Can I create a link server from an Access Database?" in the...

Bill Nguyen

08-25-2003 10:25 PM
William Wang[MSFT]

Hi, I am working on sql server 2000. It happened few times to me now, one of my database maintenance backup job failed to delete the old...

JJ Wang

08-25-2003 07:12 PM
JJ Wang

Hello Groups, Have a question regarding high availability solutions. Scenario:

Tam O'Shanter

08-25-2003 05:28 PM
Tam O'Shanter

I want to send emails by using SQL Mail. I have configure my sql server 2000, and the mail is working by using both xp_sendmail and...

peter

08-25-2003 05:25 PM
Keith Kratochvil

Hello: I am a new to SQL and I have inherited a SQL 2000 database (Enterprise Edition) that has a few hundred tables. I want to know which tables...

Brennan

08-25-2003 05:22 PM
Brennan

For the past few days I have been getting errors in EM. When I try to edit a table I get an ODBC communications link error. I get this from a...

joe@noemail.com

08-25-2003 03:46 PM
Gene Grant

For enity design etc. has anyone used the software (CASE Studio 2) provided by Charonware? www.casestudio.com/enu/defalut.aspx Thanks Earl

Earl Arbuckle

08-25-2003 12:04 AM
Earl Arbuckle

I have an XP box with SQL Server 2000 Developer installed. I connect to my server instannce and then load a SQL text file. When I try to save it or...

Darryl Jewett

08-23-2003 02:39 PM
Darryl Jewett

Hello all, I need read the log sql server what tool use? thanks

gino

08-23-2003 02:22 PM
W.Riechmann

Hi You only problem seems to be that OEM should be in quotes! Try: bulk insert test from 'D:\temp\test.txt' with (codepage='OEM') John

John Bell

08-23-2003 10:03 AM
John Bell

How can I do to copy database on SQL server7.0 that create at home to do next at office? I Used Import/Export ,but it did not work.

Nuttiwan

08-23-2003 07:36 AM
John Bell

Hello All, I can I use a SELECT INTO TempTable statement without giving System Administrators rights to the user (Windows Authentification). If...

Brad Gilbert

08-22-2003 03:55 PM
Brad Gilbert

http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp -- Carlos E. Rojas SQL Server MVP Co-Author SQL Server 2000 Programming by...

Carlos Eduardo Rojas

08-22-2003 02:40 PM
Carlos Eduardo Rojas

I'm looking for an MSSQL feature or 3rd party tool (or simple script) that dumps all the structure of the databases, tables, and columns into some...

Philipp Lenssen

08-22-2003 10:39 AM
Andrea Montanari

Please HELP. How do you compute time differnce in hours and minutes between two dates. I run SQL SErver 2K,SP3 on WIN 2k SP3 CLUSTERED. Regards

Olutimi

08-22-2003 09:54 AM
Brian Moran

Jasper, Do you know if the Reporting Services Beta is still on schedule to start in September, and to release by the end of the...

James Radke

08-22-2003 07:39 AM
Michael Shao [MSFT]

This may be a stupid question but.... We have setup a VPN wan connection to a remote site. I want to register a sql server at the other end...

Phil

08-22-2003 06:28 AM
Phil

Can you connect to the server using Query Analyzer or OSQL tools? -- Dejan Sarka, SQL Server MVP FAQ from Neil & others at:...

Dejan Sarka

08-22-2003 01:42 AM
Dejan Sarka

I'm using the SQL Server 2000 and have 4 datebase on it. But the transaction log file size about 4GB, how can I clean up. (because they make the...

Sunny

08-22-2003 12:38 AM
lindawie

Mike, I own both Red-Gate and AdeptSQL. The Red-Gate product is so slow it's almost unusable. AdeptSQL is unbelievably fast. In fact, Red-Gate...

Largo SQL Tools

08-21-2003 05:38 PM
Largo SQL Tools

Me again. Is there a query to copy the data in a table in a database on one server, into a table on another server? I know I can just do "Import",...

Kyra

08-21-2003 02:45 PM
Tom Moreau

I'm trying to install only enterprise manager on a terminal server that has MDAC 2.7SP1. When I do the client only install, it tries to install...

Shawn

08-21-2003 09:18 AM
Shawn

We are in the process of converting an Access db to SQL and would like a listing of the tools available with SQL 2000. Our current sw vendor...

Lisa

08-21-2003 03:51 AM
Steve Troxell

Hi All, There are 2 database residing in one single server currently. We are planing to take up this 2 database to different server in same...

Sachi

08-20-2003 08:12 PM
Greg Obleshchuk

I am attempting to run a VBScript via a scheduled Job that checks for the existance of a text file on a network share and deletes it if present. ...

Ken Schram

08-20-2003 04:49 PM
Ken Schram

Hi all. Can anyone point me to some example code or a precompiled extended stored procedure that I can use so that an SQL trigger can call a web...

Paul

08-20-2003 08:48 AM
SriSamp

Hi Billy If you want them as diagrams I suggest you use the Diagrams tool in Enterprise Manager - expand Databases, expand your database, and open...

Tim

08-19-2003 08:36 PM
Greg Obleshchuk

Is there any way to see when a stored procedure was last called or run? I'd like to clean up a database that was set up before I took over and I need...

Rayne Bair

08-19-2003 08:34 PM
Greg Obleshchuk

greetings - have a 'pre-live' or 'about to go live' application, and have recently noticed a curiosity. in all cases but one, my '***.MDF' files are...

BillC

08-19-2003 04:33 PM
Tom Moreau

Hello All Does anyone know a good tool for stress testing a SQL2000 server. I see there is a 'database hammer' utility in the reskit - has anyone...

Jeff Johnson

08-19-2003 04:26 PM
Jeff Johnson

You might check the character length once the data is replaced. If it is not working, it's a bug. This is typical for values that are too...

Lance Delano[MSFT]

08-19-2003 03:47 PM
Lance Delano[MSFT]

Any local temp tables (ones created as #something) are automatically dropped when the batch is done. If you use a CREATE TABLE Tempdb..xxxx the...

Andrew J. Kelly

08-19-2003 10:50 AM
Jay

How can I get an alert (an email would be fine) if the SQL Agent stops on a remote server? Is it possible to get a local server to monitor the...

Tim Kingston

08-19-2003 05:18 AM
Tim Kingston

1. I am trying to figure out how I can get more memory, I think my memory is low. Every now and then, I will get the square that pops up saying my...

Sherry

08-18-2003 01:15 PM
Art Ringler

Korsuas, Why not post that script here http://www.ag-software.com/SQLServerScripts.asp Greg "korsuas" <member35768 (AT) dbforums (DOT) com> wrote

Greg Obleshchuk

08-17-2003 08:43 PM
Greg Obleshchuk

Ricardo Lopez Celani (rlopez (AT) unisolutions (DOT) com.ar) writes: The best option may be to script the database, and a build a new one with...

Erland Sommarskog

08-17-2003 03:33 PM
Erland Sommarskog

Dean. A New Zealand based company - www.sqlservices.com were exhibiting their SQL Server admin services at the Australian TechEd this week. I met...

Greg Linwood

08-15-2003 08:47 PM
Greg Linwood

DTS wizard would probably be easiest, or if you can wipe out the destination data, just do a backup of source database and restore it on...

Ray Higdon

08-15-2003 08:47 PM
Ray Higdon

Greetings, I've been doing some Profiler traces and found that many of the table scans happen primarily on non-clustered indexes. For example,...

Paul

07-08-2003 03:10 PM
Paul

I have heard about these 3rd party tools for SQL Backup and was wondering if anybody has compared the 2 or even if there are better tools out there...

FR

07-08-2003 01:34 PM
FR

Sounds like a video driver issue... "Vivek" <naikvivek (AT) hotmail (DOT) com> wrote

Aaron Bertrand - MVP

07-08-2003 01:25 PM
Aaron Bertrand - MVP

Thanks. I had heard of the RedGate tool at a local SQLServer user's group meeting. Have you used it? Is it expensive? We have used a high end...

glennf

07-08-2003 12:53 PM
Richard Ding

I am installing it over the network, and I dbl click the auto run.exe which gets me to the start up instalation page. I then dbl click install and...

Bob

07-08-2003 09:44 AM
bob

HI, I need to know what is MS Distributed Transaction Coordinator. Thanks in advance. Deda zheng

dzheng

07-08-2003 09:22 AM
Russell Fields

I assume that you mean edit the data in the table. Are you using constraints or trigger managed FK references? If so, then your solution will need...

Russell Fields

07-08-2003 09:19 AM
Russell Fields

hi to all, i do not know if this is already answered,i checked the messages and i did not find this problem again. So, i have Sql Server 2000 in an...

anthony boudouvas

07-08-2003 05:38 AM
anthony boudouvas

i'm trying to get messages from sql server to appear in english. at the moment you just get and ole error. the server and the clients are set to...

Shaun Buckley

07-08-2003 04:56 AM
Tibor Karaszi