You know, it will be a fairly large undertaking to setup all of the scripts, but after they are all setup you shouldn't have to touch them. Seems like...

I have never seen that capability. You would have to come up with some way to create dynamic SQL, but not sure if that can be done.

Also, sounds risky....

Thanks! Didn't even notice that. Was simply taking what he had and adding the ideas to it.

Check out this article. It should help.

http://www.sqlservercentral.com/articles/T-SQL/70482/

Or the Express version that specifically states "with Database Tools".

Oh yeah, that is most likely the issue.

It is a pain to select the PK for every table when linking in Access. I would strongly suggest you create the...

Sorry, totally brain dead.

Accidentally posted twice.

It is possible that the issues I ran into were corrected in the RTM release of R2. However, I can't vouch for that.

I ran into the issue while authoring...

Exactly what is the error you get when running the queries?

If you missed creating PKs on SQL Server or did not verify them during the linking process, you will get...

Try this:

select pass_fail_indicator, CONVERT(nvarchar(10), modified_date, 101), DATEPART(hour, modified_date)

from unit_status

where station = 'LG01-TIDASSGN-03'

and pass_fail_indicator = 'P'

and modified_date

between to_date('08/18/2010 08:00:00','mm/dd/yyyy hh24:mi:ss')

and to_date('08/18/2010 15:00:00','mm/dd/yyyy hh24:mi:ss')

ORDER BY modified_date, DATEPART(hour, modified_date);

Without...

For simple, I like Steve's idea.

If you need to search the entire database often for strings that may or may not be an employee name then you may want to...

I would suggest you look at using EXECUTE AS in the stored procedures and functions. That is assuming that the devs only have execute access to the procs and...

Is it possible that the view has permissions for a specific user type in the CRM system for security reasons? If so, you may want to get your user...

Uninstall the SQL Server 2005 SSMS (Client tools), and install the SQL Server 2008 version. SSMS 2005 is only backward compatible.

The SQL 2008 version can connect to SQL 2005.

This may or may not work. Typically, each edition adds something to the DB that cannot be used by a lower edition. MS says they are required by...