b_boy,

Warning:

With the Office 2007 family of products, you *may* have some issues with Visio 2007 being able to communicate with SQL Server 2005 pre Service Pack 2 (9.00.3043).

SQL Server 2005...

b_boy,

A few Questions:

Are you using Visio to Reverse Engineer an existing database, or designing a database?

What version of SQL Server are you using? (IE: 8.00.2187, 9.00.1399.06, etc.)

I...

J,

Can you provide us the column list of the spreadsheet system you currently are using?

In my environment, I use a mix of built-in procedures like sp_helpdb and the custom script...

J,

I use this to keep track of the Version and Edition on all of our SQL Server systems.

Written for use in both SQL Server 2000 and SQL Server 2005!

Happy Coding!

--...

Brendan,

My best resource for SQL Server Service Packs is from a page provided by http://www.sqlsecurity.com.

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

In the SQL Server 2000 column there is a listing for SP...

dspain,

You could install a SQL Server 2000 instance as well as a SQL Server 2005 instance on the same physical server.

The major drawback is that you have 2 SQL Server...

ryno,

Keep in mind that the SQL that is executed inside the OPENQUERY is parsed by the 'Microsoft.Jet.OLEDB.4.0' driver which is different than T-SQL. Meaning that you must use MS...

Osman,

Can you please give us a little more information to work with?

What version of Oracle is the target database?

What version of the Oracle client are you installing on the SQL...

mdoll,

can you please run a couple of queries and post the results for us?

-- SQL Server 2000 and 2005

-- Help on the linked server:

1)

EXEC sp_linkedservers

2)

EXEC sp_helpserver

3)

-- SQL Server 2000

select *...

The latest publicly available Service Pack for SQL Server 2000 is "Pack 4 build 2187".

http://support.microsoft.com/kb/916287/

The Database Version will show as "8.00.2187"

I use the chunk of code below for...

If you haven't already, you will need to apply SQL Server 2005 Service Pack 2 to your SQL Server instance.

SQL Server Service Pack 2 adds "awareness" for Office 2007 (Office...

You may be experiencing BUG #: 469097 (SQL Server 8.0)

See:

FIX: An "Error 17883" error message may be logged, and SQL Server 2000 or SQL Server 7.0 may stop responding...

I found a reference that *may* help. It references making a connection to an Alchemy database with an ODBC Connect string.

http://www.captaris.com/DeveloperProgram/forums/thread/12743.aspx

Remember that you need to have the...

isa,

The only way to backup the MDB file is to make copies of the MDB file itself, BUT you have to schedule a time for all users to be out...

Roxanne,

Based on this MSDN article "Troubleshooting (SQL Server 2000) Error 7303"

http://msdn2.microsoft.com/en-us/library/aa226395(SQL.80).aspx

... it looks like you will have to tweak your sp_addlinkedserver or sp_addlinkedsrvlogin settings.

Try changing your @srvproduct value...