I'm not good enough to do it all in one shot, so I copy Sean's results into a table, then compare the rows against the previous rows.

select * into test...

Yes, I remember mutex from OS class oh so long ago. Couldn't think of the term. Thanks for that.

What is nice about an Access project is that it has a natural connection to SS so you can always just reference CodeProject.connection. But if it's an mdb, you can...

If it's a database file instead of a project file, it's not any more complicated. But let me ask this: why send your data through parameter calls of a SP...

If your Access file is an adp connected to the SQL Server database, then just use VBA like this:

Dim rs As New ADODB.Recordset

rs.Open "EXEC [usp_MyProcedure] " & ID, CodeProject.Connection

If Not...

ok, let's try from another angle. type this in a query window in SSMS and execute it. let me know the response.

alter table [table_name] add primary key ([column_name])

of course, replace...

Set the PK in SSMS. When you reopen your Access project it should reconnect and recognize the PK.

blackwell (1/31/2011)

---

What has me puzzled is that I can create new sql server tables in access and edit them fine but, when i import them via the import tool, I...

Use SQL Server Agent to make jobs to run your queries.

http://msdn.microsoft.com/en-us/library/ms189237.aspx

For the sake of my OCD, combine the two inserts in the trigger:

ALTER trigger [dbo].[InsertJoinWebsiteEVS]

on [dbo].[Members]

for insert

as

SET NOCOUNT ON

insert into EVSActions ( Membership, EVSActionTypeID, ActionDate )

select

Inserted.Membership,

case when Inserted.bitUser_MonthlyOptIn = 1...

If there are optional foreign keys in your main table, then left join. This should get those values:

select t.CNSTransID,

t.DataSource,

t.UserID,

CAST (t.ExternalFileDate as DATE) ExternalFileDate,

t.ExternalFileIdentifier,

t.OrgSysTransID,

s.HiNetMajor,

t.HiNetMinor,

t.SettleCurrCode,...

This article was posted earlier this week:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

I guess I should be clearer. The trigger is breaking when concatenating the msg with the @Last_Login_Date, so I wrapped it in a CAST. You didn't see that error because...

I think your trigger is erroring out. Run this to update GSquared code:

ALTER TRIGGER LastLoginDate ON dbo.users AFTER update

AS -- first error fixed here

--//ColumnName

DECLARE @Last_Login_Date datetime, @msg varchar(500);

IF EXISTS

...

Your query can't get any simpler for better performance. But HowardW has a point, why use the subselect at all?