|
ANN: Free Query Analyzer Tool 1.7.1 released
yohz Software is proud to announce a new release of our free tool for SQL
Server and MSDE databases, Query Analyzer Tool (QAT). QAT was designed to
assist users in optimizing queries, and it's core feature is it's ability to
display query plans in a hierarchical manner and saving those plans for
future compari ...
Tue, 21 Sep 2004 00:25:24 +0800
|
how to calculate bandwidth requirement for client-server applicati
I am writing a client-server desktop application.
Front end is developed in VB
Back end database is using SQL 2000
The project is being developed using Classes.
The application will be accessed by 1,000+ users using a Virtual Private
Network to connect to the SQL database.
How to I calculate the Bandwidt ...
Mon, 20 Sep 2004 04:59:06 -0700
|
This is only a test
This is only a test.
Bram S.
support@geticasoftware.ro ...
Mon, 20 Sep 2004 13:45:17 +0300
|
moving sql server
Is there a tool awailable that can help me move databases, DTS packages and
logins from server A to server B?.
best regards
Trond
...
Mon, 20 Sep 2004 09:56:57 +0200
|
Parameters and characters in OSQL
Posted - 09/17/2004 : 11:00:58
--------------------------------------------------------------------------------
Hi
I just started to work with MS SQLSERVER 2000 and his utilities and I have
some problems with osql. I proccess queries write in files using the -i
argument and lead the output to a fil ...
Sun, 19 Sep 2004 23:59:02 -0700
|
SQL Server 2000 SP3a Setup Error Message
Has anyone seen the following in the sqlsp.log file? If
so, how do I get around it so I can install sp3a?
10:41:37 Access authenticated
10:41:37 C:\sql2ksp3\x86\BINN\osql.exe -Slpc:YOUR-
9NYHWKOJ2Y -n -b -d master -o
C:\WINDOWS\TEMP\~sqldb0.txt -i
C:\WINDOWS\TEMP\SqlSetup\Bin\dbverify.sql -Usa -P"
10 ...
Sun, 19 Sep 2004 08:53:57 -0700
|
TRN file question
Hello to all,
Could someone help me with this sql newbie question.
I am a bit confused with LDF and TRN files. Can someone explain what files
are what? I thought the LDF where the log files, and then I hear the TRN are
the transaction logs. I see a lot of TRN files on our server, and I'm not
sure if I can dele ...
Sat, 18 Sep 2004 19:13:31 GMT
|
SQL Documentation Tool
Is anyone aware of a tool that I can use to do a dump of a database, listing
the tables, fields, data types, sizes, etc.?
BV.
...
Fri, 17 Sep 2004 11:57:12 -0400
|
Upgrade 6.5 to 2000
I am trying to upgrade 6.5 to 2000 anyway that I can. However, I do not see
the upgrade wizard in any of the menus. Is this because I'm using Sql Server
2000/Standard Edition? Do I need Enterprise Edition to see the wizard?
Apologies for the ignorance. My primary area of expertise is Oracle Apps.
What I wan ...
Fri, 17 Sep 2004 06:49:05 -0700
|
sql server 2000 tracing profiler Exception Messages
I have the following messages on sql server 2000 tracing profiler :
Error: 16955, Severity: 16, State: 2
Error: 16945, Severity: 16, State: 1
I have sp3 a installed too also
----------------------------------------------------------------------------
----
The code correct in vb application, and my cod ...
Fri, 17 Sep 2004 09:38:13 +0300
|
DB2 LINKED SERVER
Could anyone who has successfully set up a DB2 database as a linked server
in SQL Server 2000 please instruct me on how to do so? I have a Microsoft
DB2 ODBC connector set up, but can't get it to work with the Microsoft OLE
DB for ODBC driver. Is this possible, or do I have to purchase the MS Host
Integration S ...
Thu, 16 Sep 2004 21:33:11 GMT
|
SQL and sending Job failures...
Can SQL job maintenance jobs exec store procedures upon
job failures.
I would prefer not installing outlook or oulook express
on my servers for this ftask. I know smyp is available,
but have to know if the failure of a Maintenance job will
or can kick off a stored Procedure.
...
Thu, 16 Sep 2004 11:59:45 -0700
|
Database Change Log
Is there any way to see what jobs and or changes have been
made to a database. Not the data itself, but things like
indexes, statistics, DB settings, or outside/automated
jobs? I know I can run a trace to see real-time actions,
but I'm interested to see what may have happened overnight
or yesterday. An ...
Thu, 16 Sep 2004 09:53:02 -0700
|
Yukon tools?
Hello,
I wouldve posted this in a Yukon group, but i didnt see any on msnews that
were named either with Yukon or 2005 so im posting it here.
I downloaded the SQL Server 2005 Express beta 2 last night, and was a little
baffled when i installed it and there were no tools with it... no Enterprise
Manager, ...
Thu, 16 Sep 2004 08:57:08 -0400
|
unexpected error while use osql.exe to excute serials of sql files
now we try use osql.exe to excute serials of sql files orderlly,
the error "Invalid object name" apprear occassionally,
however, if use the tool "Query Analyzer" in SQLSever 2000 to exute the file
manually, no error apprears.
what is the problem with it??? how to solve it?? thank you! ...
Thu, 16 Sep 2004 04:55:02 -0700
|