Visit http://www.red-gate.com/

Extremely cool product suite.

I've not used VB6 against a SQL database for a while, but you can't use refresh to process a different query.

I used to open a connection at the beginning of...

Just qualify the database in the FROM clause.

SELECT Col1, Col2

FROM TestDB1.dbo.MyTable

SELECT Col5, Col10, Col7

FROM DifferentDB.dbo.AnotherTable

Run the queries and you'll be querying the databases without the need to change the database...

From Enterprise Manager, right click on SQL Server Group and choose New SQL Server Registration and follow the wizard. This will allow you to navigate the other SQL Server...

You soon learn to work out which trains are less crowded and at what times the newer trains with air conditioning leave the station!

The older trains with no air con...

I catch a train, so no...

However, should I decide to drive in one day then I would imagine that getting into Piccadilly Circus in the West End of London at...

I guess I was being optimistic in hoping for 6 points as well as a promotion and a bonus!!

Just checking the obvious.

With regards to the imported data - Do all the fields specified in the WHERE clause contain data? Just wondering if some fields don't contain anything...

Check...

Hey,

Can you update/delete imported records from Query Analyser?

Can you give an example of an imported record and one which was created (a select from the table would be good) and...

Mani Singh (7/1/2008)

---

Check SQL Server Integration SErvices in installed in the services window.

In SQL Server configuration-> click on SQL Server 2005 Services and check to see for SQL Server Integration...

I guess the easiest way is to to the Start - Programs - Microsoft SQL Server 2005 and then look for SQL Server Business Intelligence Development Studio.

Also check Add/Remove programs...

I generally hide under the desk and pretend it doesn't actually exist :w00t:

Are your production servers up 24/7? Do you have any downtime in the evenings or weekend?

If so, can you bring the services down then? I know you are...

Hi John,

If your worried about databases not starting up, take a backup of the master and msdb databases.

If they don't start, you have a backup from which to restore to...