CompareDBs is a free tool for Windows that compares two SQL Server database schemas and produces a side-by-side display of the differences. -...

Paul E Collins

06-18-2004 04:34 PM
Paul E Collins

I hope this is the correct news group to post this to, if not could someone please advice me as to a better choice. We are currently releasing V1...

J Prescott Sanders

06-18-2004 07:02 AM
Robert Klemme

my disk was bad.I found the data files from the disk. but the data files maybe have a problem. Can not Output the data. so who can tell me how to...

kingbobo

06-18-2004 06:45 AM
Manisha Gupta

Hi, yes, we're looking for a deadlock and not having a lot of success. What I want to know is how to use trace flag 1204 and related flags...

Adrian Parker

06-18-2004 03:01 AM
Mingqing Cheng [MSFT]

The SQL Server client tools installation installs BCP.exe. -- Keith "Yossi H" <hergass (AT) yahoo (DOT) com> wrote

Keith Kratochvil

06-17-2004 11:20 PM
Mingqing Cheng [MSFT]

I'm trying to extract some data to files to insert into an oracle table and I'm having difficulty in getting the date formatted so that oracle can...

Ptaz

06-17-2004 09:24 PM
Andrew J. Kelly

Query Analyzer Tool (QAT) functions similarly to the standard Microsoft SQL Server Query Analyzer application. The main feature of QAT is that it...

Peter Yeoh

06-17-2004 11:42 AM
Peter Yeoh

I want to move meta data between two copies of the same database running on different machines. I do most of my work on one machine, but sometimes...

Charlie Calvert

06-17-2004 10:10 AM
yaniv cohen

I am using profiler to monitor a remote sql server. When I select a trace template, all fields included in that trace are visible. The extra fields I...

Franky

06-17-2004 08:06 AM
Sue Hoegemeier

I am building a report using the SQL Reporting Service. In this report I have a Textbox that needs to display a HTML that is stored in a table. Right...

Michael

06-15-2004 09:38 PM
Michael

I am trying to use Windows Performance monitor to find trouble areas of our sql server. When I run perfmon.exe I do not have a SQLServer object from...

Tim

06-15-2004 01:23 PM
Steve Thompson

I am trying to use the sql reporting services and I cannot figure out how to use scope parameters I created a report with various information about...

yovys

06-15-2004 10:06 AM
yovys

Hi! How can I use BCP without installing SQL Server on the machine? Thanks in advance Yossi H.

Yossi H

06-15-2004 07:02 AM
Yossi H

Re: osql -i test.sql -e -b -r 1 > temp.log I intend to use osql to submit a bunch of SQL scripts from a batch file. If the SQL script has an...

Randy

06-14-2004 04:55 PM
John Bell

I am getting an error: MMC cannot open the file C:\program files\Miscorosft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. This may be...

Ken Rinaman

06-14-2004 02:09 PM
Ken Rinaman

yohz Software is proud to announce the release of MiniSQLBackup 1.6.8 for SQL Server 2000. MiniSQLBackup is an application that compresses...

Peter Yeoh

06-14-2004 01:24 PM
Peter Yeoh

I am executing BCP within a web application. SQL Server client is not installed on the web server there although we have copied the BCP.exe and...

Robert Complusman

06-14-2004 12:15 PM
John Bell

Hi Here is my store procedure. The below code is not giving error at all when dts fails. Can any one please help me how to trap xp_cmdshell dtsrun...

Admin

06-14-2004 11:54 AM
John Bell

hello, i have sbs2003 premium and I have some problems with SQL tools. When I get properties on my database application is colose. In Event Viewer i...

G0zER

06-14-2004 10:52 AM
John Bell

Hi, I'm trying to export and import one big table in sql server 2000 using bcp. Original table has 7,416,000 rows, and after I bcp out this table...

OJ

06-13-2004 07:17 PM
Erland Sommarskog

Profiler works successfully for a local development database I ran on XP Professional, but I have problems when I try to close the current profile...

ChrisRath

06-11-2004 02:54 PM
ChrisRath

I have a trace file that I captured from my production server that I want to replay on my dev box. The database on dev is a restore of the...

Kevin3NF

06-11-2004 10:41 AM
Kevin3NF

I have replayed profiler trace and some locks occured. The replay didn't respond for an hour or so untill I killed blocking process. On production...

Svetlana

06-11-2004 02:31 AM
Svetlana

Hi! When I try Attach a DB I have this error: Error: 3624 Location: recovery.c:2440 Expression: seenCKptEnd SPID: 51 Process ID: 1344

Joao Pinto

06-11-2004 02:29 AM
David Rairigh

Hi I am having problems backing up my transaction log. The destination for the backup is not on the actual server that the log is on, but another...

Andrew Marks

06-10-2004 11:42 PM
Hari

Hi All, Sql Server 7. OS NT server 4 When i select generate script option in EM for ddl script. I am getting below error. error 5: create file error...

haseeb

06-10-2004 07:50 PM
Andrew J. Kelly

I work for a software development company and was wondering if it would be possible to create custom "Best Practices" for the Analyzer. For example...

Earl G Elliott III

06-10-2004 06:18 PM
Jasper Smith

How do I input a blank but not NULL value into a varchar parameter during sproc debugging? It seems that no matter I typed ('') / '' or leave it...

Leonard Poon

06-10-2004 03:42 PM
Morgan

Does SQL Server 2000 have a documentation tool similar to the one in MSAccess? Any help is greatly appreciated.

Greg Smith

06-10-2004 01:19 PM
Wingenious

I am a Lotus Notes app dev and we are considering running SQL Server as a secondary option. I am having trouble finding out exactly what application...

Streets

06-10-2004 12:41 PM
Kevin3NF

Hello, Is there any alternative to Enterprise Manager? All links will be appreciated. Thank you, 3Dimka.

Dmitriy Bessmertnyy

06-10-2004 09:58 AM
Martijn Tonies

Can I created a job that I can send to my Service Delivery group to run on the Production servers? I'm a developer and don't WANT access to PROD, but...

B.W.

06-10-2004 05:39 AM
Christian Kleinerman [MS]

Hi, I have downloaded and run hte analyzer, but the result I get have lots of exeption errors that contain the message: Error while executing the...

dimitris

06-10-2004 05:34 AM
Christian Kleinerman [MS]

Execute this in Query Analyzer: SELECT CONVERT(varchar(8),0x0131) as A, 'X' as B You will get the expected results if you choose "Results in text",...

Razvan Socol

06-10-2004 01:27 AM
Razvan Socol

I need to automate multiple FTP puts. Can this be done via DTS and if so, how? Thanks.

Gary

06-09-2004 10:48 PM
Sue Hoegemeier

while trying to connect to the sql server database in Query Analyzer I get the following error message' timeout expired ' after trying to connect for...

Vinny Vinn

06-09-2004 03:26 PM
Vinny Vinn

MP 1603 is a fatal error. Usually something very basic went wrong (reading a system folder, temp folder, accessing registry, etc). Can you retry...

Christian Kleinerman [MS]

06-08-2004 11:21 PM
MP Wong

hi, I have a sql server 2000 database which has only one file and one file group (primary). This file has grow to be over 40 gig, I want to have...

JJ Wang

06-08-2004 08:32 PM
JJ Wang

I have a table with the following information col1, col2, part, desc, cost, retail, quant. The destination table has the following: id, part,...

Dennis Burgess

06-08-2004 06:28 PM
Hugo Kornelis

I'm installing the latest version of BPA and seem to have run into an issue. I've uninstalled the app and deleted the old BPA database, and...

Steve Carroll

06-08-2004 03:35 PM
Steve Carroll

Hi. I made an alert that will email me whenever someone causes error 18456 to be raised... My thinking behind this is that if anyones trying to...

Jeigh

06-08-2004 03:11 PM
Tibor Karaszi

Hi I need to view a log of all SQL scripts that were RUN in Sequel Server. Is It possible to view some type of a log, which will show me the...

AQ Mahomed

06-08-2004 12:56 PM
Hari Prasad

I'd appreciate if someone would take a look at the parameters on the Service Manager shortcut in the Windows Startup menu. I had deleted the...

Fred Chateau

06-08-2004 11:08 AM
Fred Chateau

H The SQL Server Online documentation referes to the Query Designer (Visual Database tools) How can I start the Query Designer and the other Visual...

Michael Brugger

06-08-2004 03:54 AM
Tibor Karaszi

Ok, I have created trace files, saved them as sql scripts, that they look like that: SELECT "PJID" ,"EMPLID" ,"PROJID" ,"CATEGORYID" ,"QTY"...

dimitris

06-07-2004 09:49 PM
dimitris

Hi people, Does anybody know how to instal a Client SQL Tools on a Windows 2003 Server. I am trying to install it but when I select "...

rose

06-07-2004 03:50 PM

I have just installed and ran the BPA. The documentation says that you can print reports but I do not see a "print" button at the bottom of the...

Dan

06-07-2004 03:34 PM
Christian Kleinerman [MS]

Hi, I know that in Oracle there is a trace script that you can start right before the user runs a query (tracestart) including the id and...

dimitris

06-07-2004 02:24 PM
Jasper Smith

I used code in a vb6 application to attach a database to MSDE, but I get an error that says "Login failed for user 'sa'. Reason: Not associated with...

Daniel

06-07-2004 10:28 AM
Rand Boyd [MSFT]

Recently we migrated our application from SQL7.0 to SQL 2000 and a new Server machine. Since then, the NTUserName datacolumn in the trace files is...

Ravi M

06-07-2004 03:41 AM
Ravi M