Not exactly sure that base_schema_ver is. Since BOL says it is reserved for internal use, I guess I might not consider using it, since it use might change. ...

Note that when you delete and recreate a object the schema_ver gets reset to 0 and then starts incrementing again with every change.

Gregory Larsen, DBA

If you looking for SQL Server...

ETL stands for Extraction, Transformation and Loading (ETL).

A few years back around 4 now. I worked on a proof of concept using a tool called ETI Extract by Evolutionary...

I'm thinking about changing my mode of operation to use only NT network shares from QA to see if the problem disappears.

Gregory Larsen, DBA

If you looking for SQL Server Examples...

If you want to change the owner of an object you can use the sp_changeobjectowner store procedure to accomplish this.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out...

I use the method of keeping track of the last crdate and schema_ver to identify when things are changed.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my...

Here is another way provided you don't have to pad with to many zeroes.

http://www.geocities.com/sqlserverexamples/string4.htm

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Thank you for both these. I will do some more testing soon if I can find time.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website...

Both ran relatively the same length of elpased time, but I should do the test with statistics IO on.

Also isn't there a command I need to run test to...

Your query worked fine, thank you for the code. I also solved my problem using the following:

select c.stat_date, c.session_count from

(select b.stat_date, a.session_count

from (select convert(char(7),stat_date,111) as Year_Month,

...

I have thought about the top 1, but am not sure how they might be used to return one row per month. Note my data has many months worth...

I misread you original post as MDB, and not MDF. I'm guess an MDF file is most likely a SQL database file.

Try this:

sp_attach_single_file_db @dbname='<Replace with your DBName>'

...

Should be able to create a SQL DB, and then import all the tables from the Access database using the DTS import wizard.

Gregory Larsen, DBA

If you looking for SQL Server...

There is a script at: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133

to move logins

You can script the jobs, and operators in EM.

Don't know how to script of move the linked servers, although you should...

This sounds like good advice. Are you currently using this software?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples