I went to Enterprise Manager to examine database table ... Highlightlighted desired table, right clicked ... went to Open Table / Return All...

Ellie

07-16-2004 12:49 AM
Ellie Warther

I have a table that I can no longer make design changes too, remove altogether, or view all rows for. Enterprise manager just hangs. I can do a...

Andrew Jones

07-15-2004 03:20 PM
Andrew J. Kelly

I have a statement in a stored procedure as follows - which works a dream. BULK INSERT cashpost FROM...

Andy Willis

07-15-2004 07:01 AM
Darren Green

I have a most serious issue with the Enterprise Manager Designing views I created using SQL Query Analyzer. When I write my views I write them...

Micah Miller

07-14-2004 05:23 PM
Jasper Smith

Hi, I notice cpu traffic in my SQL server, and I run sp_who2 to find out what is going on. My two main databases are axapta and etime. The etime...

dimitris

07-14-2004 12:10 PM
Peter Yeoh

I have a CMDEXEC job scheduled which simply has a single step to run a BAT file. The BAT file has a single line as follows: "c:\program...

Andy Willis

07-14-2004 10:06 AM
Jasper Smith

Hi, I have a SQL 2000 db with 140 tables. I want to export all tables to textfiles. If I use Tool | Export data I only can export one table...

PO

07-14-2004 07:30 AM
Hari Prasad

Hi, I have a very large table that holds all the ledger transactions. Its the number 1 table that gets hit when posting invoices, etc, etc. It...

dimitris

07-14-2004 02:59 AM
Mark Allison

Does anyone know of a utilty that i can use to open and view the transaction log file.

Emil

07-13-2004 05:05 PM
Darren Green

In message <5B663073-F620-48FC-9EE8-FEC9F476FB3E (AT) microsoft (DOT) com>, RKN <RKN (AT) discussions (DOT) microsoft.com> writes You can call...

Darren Green

07-13-2004 05:02 PM
Darren Green

I have configured a Send Mail Task to send me an email when the job is completed. This works fine when I manually run the process, however when I...

Roger Settle

07-13-2004 04:57 PM
Darren Green

Using Query Analyzer and a select statement, how do you convert a date-time field to a date field? Thanks

Charles Allen

07-13-2004 03:51 PM
Charles Allen

Hi I am facing a problem with SQL adapter. I have my solution running at production and it critically needs a solution. I am using SQL adapter to...

Imran Ramzan

07-13-2004 07:33 AM
Imran Ramzan

Hi All I have SQL Data Base . I am using asp application to access this Data Base. I want to create a script to generate Data Base on other...

F@yy@Z

07-13-2004 07:04 AM
Keith Kratochvil

hi, work on sql server 2000. I have serveral dbs that are either 'full' or 'simple', their tran-logs have lots of empty space in it due to...

JJ Wang

07-12-2004 09:43 PM
Andrew J. Kelly

hi, I have a sql server 2000 DTS package, that selecting yesterday's data from one of our vendors database (Advantage platform) into our sql server...

JJ Wang

07-12-2004 07:30 PM
JJ Wang

Use SQL Profiler, select the Show Plan Statistics event under the Performance heading. This will show you the execution plan of each query that SQL...

Narayana Vyas Kondreddi

07-12-2004 07:25 AM
Robert Klemme

I'm trying to create a job to backup to a network drive. The following SQL does not execute successfully: USE master EXEC sp_addumpdevice 'disk',...

mike

07-11-2004 12:31 PM
matrixcd

Enterprise Manager has a query builder interface, I personally prefer Query Analyzer. Just find a table right click it and select query and there you...

mark baekdal

07-11-2004 12:21 PM
mark baekdal

hi All I want to export my mssqlserver 2000 database with all relation ship and all default value and all data save in sqlserver Database (I want to...

khurram alam

07-11-2004 07:13 AM
Hari Prasad

I downloaded the latest sql best practice tool. when I start to analyze the database, i got a lot of exceptions. I checked my target database. it is...

brian zhou

07-09-2004 06:26 PM
brian zhou

I only have the demo version of this but it is very good for what it does, may be a bit pricey though. See...

Mike Perry

07-09-2004 04:50 PM
Mike Perry

I have a server that until yesterday had SQL 7 on it, and it ran okay. However, after upgrading from SQL 7 to SQL 2000, I have one job that...

Goober at christianDOTnet

07-09-2004 03:52 PM
BB

I can't start Distributed Transaction Coordinator (MSDTC) I have following entries in event log Event Type: Information Event Source: MSDTC Event...

Shimon Sim

07-09-2004 07:22 AM
Shimon Sim

I'm having a problem with Query Analyzer. When I close a Query window that had been opened from a saves .sql file, QA stops responding. This used...

Glenn Adams

07-08-2004 11:34 AM
Steve Kass

If I run a profile into a table or onto a disk other than the system disk, why does the system disk run out of space??? Does Profiler store data in...

PeteB

07-08-2004 05:34 AM
Narayana Vyas Kondreddi

Anyone know of any simple tool or script out that that allow me to track changes to a certain table in the database and alert it in the event...

Richard

07-08-2004 03:51 AM
mark baekdal

We sometimes get very large databases that we want to cut down to use for testing. The information is all related to a central accounts table. The...

Jason Madison

07-07-2004 05:06 PM
Jason Madison

On Mon, 21 Jun 2004 00:18:48 +0200, Gert E.R. Drapers wrote: Thank you for responding! The only time it fails is when it's sending the Maintenance...

Joe Wells

07-07-2004 08:39 AM
Gert E.R. Drapers

Is there a way to restore a database only have the .mdf and .ldf files and not having a .bak Anthony

Anthony

07-07-2004 07:33 AM
SqlJunkies User

Hi, My BPA says that my virtual log files are 206 and recommended number should be 200. How can I do that? thanks

dimitris

07-07-2004 07:28 AM
Andrew J. Kelly

Hello everyone, I need to convert Access 2000 dbs (just tables) to SQL 2000. I am in the process of learning how to work with tables...

Gustavo

07-07-2004 07:27 AM
Gustavo

Thanks Hari. I will re-run the cycle with that setting. A mundane question about news group posting - I am using the Microsoft Newsreader. How can...

NormR

07-07-2004 01:58 AM
NormR

Hi, Is there a way to suspend logging for a SQL database? I have a very large script that is restructuring a fairly large database (10GB) that...

NormR

07-07-2004 01:08 AM
Hari Prasad

Newbie question., so hope I write it so it makes some sense?!?! SQL 2000 sp4. database (backend for our companies business system...) Have setup...

Carole Thompson

07-06-2004 03:07 PM
Carole Thompson

Hi everybody, I am using sql mail for sending emails. i am facing a problem regarding sending of mails. I have configured sql mail correctly, but...

nomi

07-05-2004 11:20 PM
Steve Kass

Using the SQLServer job scheduler, just wondering if it is possible to call a stored proc in a job step using Type Transact-SQL and then save the...

Amelia

07-05-2004 10:10 PM
Sue Hoegemeier

Is there a way to remove blank space padding from around my result set sent to a text file using osql. I can only seem to find a column_width...

Amelai

07-04-2004 10:31 PM
Amelia

When trying to configure SQL Server security at the column level I ran into a problem: if I assigned column-level security through Enterprise Manager...

Stefan Cuypers

07-04-2004 08:17 AM
Stefan Cuypers

how do I run sp_attach. I found the command line arguments that are needed, but where do I type this in? Is it in Enterprise manager somewhere or...

adoyt

07-03-2004 02:22 PM
John Bell

Change Manager Version 1.2.0.0 Fixed - Check constraints now included in diff - Error in case sensitive comparison when comparing the same table...

Bryan Oliver

07-02-2004 09:11 AM
Bryan Oliver

Speed SQL IDE and Speed SQL IDE Pro Version 1.4 Features -Added- Current Activitiy Monitor -Changed- Code Snippet/Template/Auto Correct area...

Bryan Oliver

07-02-2004 09:10 AM
Bryan Oliver

I am a newbie at this but I am a quick learner. I am trying to setup a maintenance plans for both my Local and Sharepoint instances of SQL 2000 SP3. ...

Paul

07-02-2004 07:28 AM
Paul

I believe that is was just a developer at MS who forgot to put in an ORDER BY in one of the stored procedures that is used when presenting this...

Tibor Karaszi

07-02-2004 01:43 AM
Tibor Karaszi

Hi! Is there anyway to see when a SQL Server database was last accessed? /Johan

Johan Dahlgren

07-01-2004 12:54 PM
Steve Thompson

Hi, I need an answer on this as quickly as possible! My SQLSERVERAGENT says it has started. But when i go to check the backup and maintenance jobs...

James G

07-01-2004 11:59 AM
Hari Prasad

Corrected date? -- Keith

Keith Kratochvil

07-01-2004 09:27 AM
Keith Kratochvil

don't think this is possible but bouncing in here just in case. I have a list of Servers already registered in Enterprise Manager - want...

Andy Ball

07-01-2004 05:08 AM
Andy Ball

I'm running a local instance of SQL Server 2000 and Client Tools, patched to SP3 with Hotfix 0876. When trying to rename a stored procedure in a...

David Poirier

07-01-2004 04:13 AM
David Poirier

Trying to find any documentation for the calls in the SQL Debugger so I can connect to it myself. MSSDI98.DLL and sdiclnt.dll are the two main dlls...

Bryan Oliver

07-01-2004 12:56 AM
Bryan Oliver