niceSQL is a nice-to-have tool for developers. the application you develop logs the sql statements, that often are big and very complex, to a file,...

ingehalv

10-27-2003 09:15 AM
ingehalv

New Tools (SQL-Project-Install, NT-EventLogDisplay) http://members.chello.at/otmar.pilgerstorfer/opsoftware/optools/

10-27-2003 06:41 AM

I have SQL 2000 on windows2000 machine. When i try to open Query Analyzer, it donot open and nothing happens on the screen even i donot get any...

jammyg

10-26-2003 01:37 PM
jammyg

I have a corrupted Db Log file and cannot be attached to the system tables! Is there a repair tool to repair corrupted/damaged Db log...

Microsoft News

10-25-2003 09:11 AM
Dejan Sarka

Help needed to debug a malfunctioning SQL Stored Procedure ? Is there anytool available for the purpose ?

Tanveer Malik

10-25-2003 03:23 AM
Vinodk

Is there a way to place linked tables (from another linked server) into the database diagram in enterprise manager? thanks in advance

m

10-24-2003 11:14 AM
m

Hi All I am trying to run a batch file from a Scheduled Task in SQL.... the batch file runs fine until it has to call another application (any...

Ratimics

10-24-2003 08:12 AM
Tom Moreau

Is it possible to get value from a PS in an Update ? Example Update Mytable Set MyValue = Exec MyPS Thanks !

mb

10-24-2003 06:01 AM
Tom Moreau

From the command line, ">dtsrun /S sqlserver\sqlcluster /Udts_runner /Ppassword /Npackage_name" works great. From Query Analyzer, I use "EXEC...

Gunny

10-23-2003 09:21 PM
lindawie

Hello Developers, can anybody help me with indexing Html-Text in ntext- Fields. I Could not change the field-type into image, so i can't use the...

Stefan Bokler

10-23-2003 11:29 AM
John Kane

I am trying to allow certain developers to run SQL Profiler traces against specific databases on the server -- but only those specific databases. ...

Adam Machanic

10-23-2003 09:46 AM
Sue Hoegemeier

We need to convert a few simple apps from MS Access to SQL2K. I know how to get the tables into a DB, but how do we deal with the MS Access forms...

David Knapp

10-23-2003 09:27 AM
David Knapp

Hi I am trying to Backup my SQL server using the VDI (Virtual Device Interface) APIs I have the capability of creating and mounting snapshot. I have...

moozar

10-23-2003 04:37 AM
moozar

Hi, I have evaluated Spotlight on SQL server and DB Artisan. I found Spotlight more fancy and DBArtisan good. Have any one of you evaluated any such...

MNS

10-23-2003 02:32 AM
MNS

SQL Server Guru's, I have been told that there is a "strict" document or procedure which details the exact steps which must be performed to...

darin_melin@storagetek.com

10-22-2003 05:25 AM
Dejan Sarka

Hi, I am trying to recover a damaged mdf file. Is there any tool or service that can scan or look at the file and fix it. Any help would be...

Randy

10-22-2003 05:23 AM
Dejan Sarka

I am trying to delete a second log file in SQL Server 7. My database has two .mdf files and two .ldf files. When I try to drop the file using ALTER...

David Thayer

10-21-2003 01:26 PM
nduckste

How obtain Reporting Services Beta 2?

laki

10-21-2003 12:37 PM
Jasper Smith

How obtain Reporting Services Beta 2?

Laki

10-21-2003 11:45 AM
Laki

I have registered for the SQL Server 2000 Reporting Tools Beta2. Does anyone know how long it takes to get approved? Thanks, Neal...

Neal Boxrud

10-21-2003 09:36 AM
Michael Shao [MSFT]

I have the following problem: When the enterprise manager is open, around 60 seconds the pc freezes for about 10 seconds. We are using SQL server...

Tom van Gessel

10-21-2003 08:45 AM
Clive Challinor [MSFT]

When trying to restore a SQL 2000 backup, I get the following message: The media set for database UTILITY has 2 family members but only 1...

John Jakubowski

10-21-2003 08:34 AM
Clive Challinor [MSFT]

Hello! Id'like to know if there is a translator to pass a query from Access to a view of SQL. Thank's Marianne

Marianne Novello

10-20-2003 02:46 PM
Lance Delano[MSFT]

Hi I need to delete a single record from a table in a database. However there are records in other tables referencing it and records referencing...

Martin

10-20-2003 02:15 PM
David Knapp

Although some don't like them, you can setup a maintenance plan through enterprise manager. it is very simple to setup, if you require more...

Ray Higdon

10-20-2003 01:13 PM
Ray Higdon

Two scheduled jobs on our SQL 7 server have been running fine every night for months. Today they seem hung with status of 'Performing completion...

Jane P

10-20-2003 10:13 AM
Michiel Wories [MS]

Hello, I have a Windows 2003 Enterprise server, acting as the primary domain controller, with a default and one named instance of SQL Server 2000,...

Mark Molinari

10-20-2003 10:06 AM
Michiel Wories [MS]

Hi there, We recently had an issue where our server application (which communicates with SQL Server using DBLIB) got into a strange state, and...

Chris

10-20-2003 09:51 AM
Kalen Delaney

Hello This is possible to make migrate all the users of a SQL7 towards anotherSQL 2000 Thank

mb

10-20-2003 08:21 AM
Tom Moreau

Is there one knows the tool similar or better then Benchmark Factory for SQL server from Quest software ? Here's link for information on Benchmark...

Manesh Patel

10-20-2003 06:37 AM
Manesh

I need to copy a table but just the table structure, not the data. (If there's no easy way to do that then copying the whole table will work and...

10-20-2003 05:48 AM
el.c. - myLittleTools.net

How can I profile the activity of a single table. SQL 2000 SP3a on Win2K SP2. I have tried using the ObjectID from sysobjects and it returned a...

TVO

10-20-2003 12:52 AM
Greg Low \(MVP\)

Whenever I right-click on a database maintenance plan on one of our SQL Server 2000 boxes and select 'properties', the properties dialog for...

The Badmail Man

10-19-2003 07:05 PM
The Badmail Man

I have a database on a MSSQL Server 7 running on a Windows NT machine. This database works the last 4years with no problem. The database file is now...

manolo_perrakis@mail.gr

10-19-2003 04:09 AM
manolo_perrakis@mail.gr

I have SQL Server 2000 on WIN2k Advanced Server And I have a Database Consists of:- 1-Single Database File . 2-single transaction log file. I have...

Ahmed Nour

10-18-2003 04:46 AM
Vinodk

I just installed the beta 2 product and it looks fantastic, Finally an alternative to crystal. Is this the right newsgroup for posting questions...

Toby Riley

10-17-2003 11:10 PM
Bill Cheng [MSFT]

Hi, I have a MSSQL Server 2003 installed on a 64 bit Itanium box. I am having problems accessing the registry keys associated with the MSSQL server...

sarab

10-17-2003 12:02 PM
sarab

Hello, I have problems when I export a query to a file. This file is used for other application (C++) and this file is send via FTP. The problem is...

Oswaldo

10-17-2003 12:01 PM
Oswaldo

When trying to execute the statement 'Bulk Insert...' with UNC path its reporting the following error- 'Could not bulk insert because file...

BlckHlDev

10-17-2003 08:13 AM
rosario

Hi, We have MS SQL Server 2000 SP 2 and it seems that there is a bug in SP_Help in that it reports the size of nvarchar fields as double what they...

Tony Robson

10-17-2003 08:04 AM
Dejan Sarka

Just recently upgrade to XP and found that the child windows within enterprise manager do not contain the toolbars that appeared under 2000. The...

George Pate

10-17-2003 06:21 AM
George Pate

I am running a client version of SQL Server 2000 (Build 2195,SP4) on my W2k desktop. Using Enterprise Manager, I am attempting to very simply import...

iamwesty

10-17-2003 03:00 AM
iamwesty

Hi Chris I did some research on this topic and found that this is a known issue with Clusters. The snmpagent component was written to connect only to...

Nick Schueler MS

10-17-2003 12:03 AM
Nick Schueler MS

One workstation we have is not allowing any server to be registered for OLAP services. Others registered fine after installing the SP3a service...

Kory

10-16-2003 08:44 PM
Ray Higdon

I asked a couple of week ago about how to use DMO to do a RESTORE with the MOVE option. Allan M. thankfully responded and told me to use...

Paul Paiva

10-16-2003 06:31 PM
Paul Paiva

Hi, I have the same problem. Here is my situation. I have a Windows 2003 Enterprise server, acting as the primary domain controller, with 2...

Mark Molinari

10-16-2003 02:38 PM
Mark Molinari

Is this the correct forum for backup and recovery questions?

KP

10-16-2003 12:26 PM
Andrew J. Kelly

I have SQL Server 2000 on WIN2k Advanced Server And I have a Database Consists of:- 1-Single Database File . 2-single transaction log file. I have...

Ahmed Nour

10-16-2003 10:51 AM
Andrew J. Kelly

Seemingly randomly, I get an error when trying to run commands with ISQL against SQLServer 2K: Incorrect syntax near 'ÿ' If I copy the text of the...

Brad Wood

10-16-2003 09:18 AM

Hi Can SQL 2000 tools be installed onto a Windows 95 machine? When I try to run the install, the only option available is the client...

Jono

10-15-2003 10:13 PM
Jono