Well you have limited options here presently, remember the SQLExpress is a replacement for MSDE 2000 version

So the techniques for administration/development is essentially the same as it would be for MSDE...

We use a tool called SourceControl 2003, not expensive and does the job well, worth a look i would say

Don't forget Fragmentation can increase the query time significantly if the data is not residing in the memory cache, as the disk IO operations wold be increased if table/s are...

Probably due to duplicate Notes.ini files (confusing the Driver), try lookin for duplicate notes.ini files, remove the old versions and try again.

also maybe look @ NotesSQL Authentication Manager (I don't use this but it may help if the problem is an authentication problem), you supply the notes.ini file etc..

I use 3.01...

Not Sure if this is any help.. I use File DSN as the ODBC connection and within the DSN under {Options} the NotesSQL Options I supply the UserName & PW..

Then...

This is one way of ruuning a DTS Package form the command line

DTSRun /S "(local)" /N "Package_name" /G "{09391365-4C6C-413A-8206-BF69C0A273FA}" /W "0" /E

Substitute "Package_name" with name of the required package

The...

Place the large columns as the first columns in your select stmts, i beleive there is a known bug relating to this

I would seriously consider some sort of cluster setup, for a number of reasons, but primarliy you could have multiple smaller (8-16 CPU) servers (if one went down then you...

Overall my largets DB is around 30GB (Transactionally) with one of the tables over 8GB on it'd own, it really depends on the overall Transactions.

Only had a couple of Problems...

Hello All Fellow DBA's and those waiting for their Chance, My DBA role is a global postition looking after multiple SQL7/2000 Servers with over 50+ DB's on a dozen Server's..'m...

Have U Tried enclosing the column Name in [column name] in square brackets.

quote:

---

Hello, I have a DTS package I can execute using...

Hello..

I always copy the files need via BCP first from Dest to source (local folder on Server where SQL is installed), then Run DTS Package using the local copied file.....

quote:

---

How about the DBA/data specialist role... Includes the areas of DBA`ing, Data analysis, Reporting, OLAP, Datawarehousing, general data evangelising

---

I currently use version 3.33.00.10749 informix ODBC Driver..works well..

When the right MDAC version is (installed).

Some MDAC versions do have issues with some of the informix drivers (i found out the...