I know how to access different tables on the same server by prefixing
the table with the database name.  Is there anyway to prefix the
server name to link two tables across servers?  Thanks.

I need to add the service contracts sold every month and I do it using the
following expression, however I get an error (Cannot perform an aggregate
function on an expression containing an aggregate or a subquery.) and I don't
understand why. Can someone tell me how to solve it?

I have a developer request to extract script of the temp table that he
created in tempdb through SMS how would we do that
If I have created the temp table…
SELECT ‘Usernae'[Name], 32 [Age]

Are there any tools that can transfer database and it's content from
SQL Server Standard version to SQL Server Express database?
I tried to backup database in SQL Server Standard and then restore it
into SQL Server Express but it didn't work. Are there any tools that

I have one simple query joining two tables with left outer join on 3
fields and using MIN on two fields. These two tables have lot of data
about 3 mil in total. I am trying to migrate db from MS Access to SQL
2005. I get about 689000 rows in SQL Server, vs 863000 rows in MS

I have a (big) table which is not normalized, but for i need at the
moment i think
that's no problem. Indeed, what i would like to do is to select the
name field and

We have SQL Server 2000 on virtual machine (slowly). We run a pair of
stored procedures from ADO.NET 2.0 (WebService):
- first procedure: insert into table A a data row with correlationID
- next procedure: search for inserted record in tab A by

1. Is there a tool within SQL Server 2005 that allows me to create ER
diagrams, fields' attributes, etc and then converts these to tables?
2. Could you point me to a URL that allows me to download (trial version) of
Visio For Enterprise Architect?

I get the following error when i try to update a table with the a
trigger (trigger script below),
"Error Message: The row value(s) updated or deleted either do not make
the row unique or they alter multiple rows(3 rows)"

I have a table DEFINITION with this content:
def_id     game_id      generaldef_id       definition
========================================
1             1                  1

Are there any RAD apps to speed up one-many db application development that
are worth considering?
Thanks
Regards

I have a query which works fine when hardcoded which is as follows
SELECT     SchemaFields.SchemaID, SchemaFields.ObjectClass,
SchemaFields.ObjectType, 'New' AS ActionType, DataQuery.Count
FROM         SchemaFields LEFT OUTER JOIN

I have table an MSSQL table (I only now postgresql good) so I ask you
for help.
CREATE TABLE events (
    e_works    INT,

I am trying to generate a formula field in MSDE 2000...
The query is:
SELECT
   SUM(b.Qty)

I'm trying to get all records that are 7 days pass duedate
(fieldname)
Select * from Library
where duedate > getdate()