|
|
|
Install "default instance" of sql server 2005 after named instance
already installed
Thu, 17 Sep 2009 12:18:15 -0700
Good day,
My product installs SQL Server 2005 as a named instance.
One of my clients other software packages needs to install to the default instance. It won't install to a named instance.
Do I just stick the SQL Server media in and install another instance, leaving it at default this time?
Would this re ...
|
ANN: 50% discount on Upscene's LogManager Series (Database Auditing
Solution)
Thu, 17 Sep 2009 10:35:30 +0200
Hello,
we are running a 50% discount offer on all of our LogManager products,
including the Unlimited Bundle license for VAR deployment scenarios, for
two weeks.
Our LogManager series is a proven logging/auditing suite supporting
InterBase, Firebird, MSSQL, Advantage and NexusDB, used by customers in
over ...
|
SQL Server Agent entries in Profile Trace ?
Tue, 15 Sep 2009 10:15:34 -0700 (PDT)
Does detailed steps (job) activities for SQL Agent jobs get logged
step by step in the SQL Profiler Trace output (or file if specified)?
I did see an Agent entry for the scheduled start date/time for my job
but nothing further.
I know about the SQL Agent Log, but wondered if the Profiler Trace
could give deta ...
|
SQL Image Viewer 2.5.0.134 released
Tue, 15 Sep 2009 13:03:13 +0800
SQL Image Viewer helps you retrieve, view, convert and export images and
binary data stored in SQL Server, Firebird, MySQL, Oracle, SQLite, and
various ODBC-supported databases (e.g. DB2 and PostgreSQL).
It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF,
and recognises the following ...
|
SQL scanning tool
Mon, 14 Sep 2009 02:02:46 -0700 (PDT)
Does someone know a tool similar to fxcop for SQL ?
i.e. a tool that could scan SQL code (stored procedures/functions +
data model) to find possible design, performance, and security
improvements.
Database Tuning Advisor could be used for indexes and partition
improvement but I'm looking for a tool that wou ...
|
SQL server 2005 Manament studio
Fri, 11 Sep 2009 08:04:01 -0700
I am using SQL server 2005 Managment Studio connecting to a SQL 2000 server.
The OPENROWSET command will not work. When I use SQL Query Analyzer, the
command works fine.
This is error I recieve from Mgmt Studio:
[OLE/DB provider returned message: Could not find installable ISAM.]
OLE DB error trace [OLE ...
|
Import Truncation Error - Please help
Thu, 10 Sep 2009 22:15:01 -0700
Hello. I'm using SQL 2008.
I am at my wit's end. All I'm trying to do is import data into a SQL table.
No matter what data type I try (varchar, nvarchar(max), ntext) it's no use.
I get the same truncation errors and the import halts.
I've tried importing from Excel, text, Access. No use. Am I to assu ...
|
|
|
Import and Export Data ERROR with big number of RECORDs.
Mon, 7 Sep 2009 21:56:02 -0300
Hi All
My first post on this list.
I am using the Import and Export Data (32-bit) to made a import from
Firebird, all seems work fine but when i importa a table with more than 100
000 records i got this error.
TITLE: SQL Server Import and Export Wizard
------------------------------
Column informati ...
|
SQL 2005 Management Studio Missing Drives
Sat, 5 Sep 2009 04:57:01 -0700
I am in SQL 2005 Management Studio under account that is an administrator on
the Windows 2003 R2 server.
I can't see my local H: & T: drives when I attempt to do backups or restores.
How can I make them available for use in Management Studio? ...
|
SQL 2000 Enterprise Manager on Win 7
Thu, 03 Sep 2009 11:00:29 +0100
I don't if this is just my installation but...
I've just moved my workstation to Win 7 Ent (x86) and installed SQL 2000
Dev + SP4. Whenever I attempt to create a new table via Enterprise
Manager I get an error with the MMC snap-in message. The event viewer
shows the following:
Faulting application ...
|
|
|
