Thanks for the update and glad it appears to be working.

And kudos again for using SQL Server at UCF!

You don't need the ELSE clause. If the parameter is not null, it's value will be already assigned.

Do you care which 4000?

You could insert 4000 PKs from the patient table into some new table, then set up a replication that filters based on those PKs. Or copy...

You might run PRofiler and filter based on the db, table, or some other object that you think is involved. Or just run it and then stop it when you...

Try this: http://www.sqlservercentral.com/articles/Integration+Services/61619/

I think this is a distributed transaction problem. Is there any reason you have it wrapped in a transaction there? Any error should throw a rollback anyway.

Does it complete? Could...

Almost went to Earl for an old car, but couldn't bring myself to do it.

We're POTS here (With DSL riding along). Still find uses for the line, especially as so...

clustered keys and primary keys have nothing to do with each other. the PK can be clustered or non-clustered and if someone thinks it's always clustered, either he doesn't understand...

I think you mean W2K3 Enterprise and SQL2K5 standard

http://msdn2.microsoft.com/en-us/library/ms171001.aspx

You'd need self joins to join each table based on the date.

so

select a.model

, b.modeldate '3 weeks'

, c.modeldate ' 2 weeks'

...

from modelhistory a

...

backup the database, restore it, then for each table you need to decide what "first" is. There's no order by default in SQL Server.

ms_foreachtable is a stored procedure that...

Please give us a clue here.

Worst case, set up a Windows Scheduled Task if you can't get SQLAgent to work.

Run isql -E -Q"backup database xxx to disk='c:\mybackup.bak' with init"

Feel...

No, it should be there. Haven't seen this at all. What's the build on SQL Server? select @@version

I haven't managed AX, but I did admin a Dynamics site about 5 years ago. Some of this may or may not apply.

We removed "sa" from Dynamics even though MS...

Changes occur immediately if you save them. It is possible to add them and not save them.