We are also trying to find training materials for the 70-450 exam. Apparently MS Press does not have any training kits yet...any idea if there is one in the making?

Thanks!

You can create an SSIS package to export the data out of the database and then schedule that SSIS package within a job. Hope this helps!

Thank you for the response...and yes they require case sensitivity..augh!

I was also wondering if there are any known issues with having two instances in a clustered environment (active/ passive)?...

I am having a similar issue...we installed Project Server 2007 last month and the 'DeleteExpiredSessions' job that came along with it runs every minute. We've noticed that our CPU utilization...

Thanks Ken...this is working. I ran the query after creating the function and it ran for over 2 hours until I stopped it, but it is working for the records...

Thanks, but not working - I still can't get all the comments into one record. I'm not that good at tsql and I can't seem to get it right. Do...

Thanks! I can work with this and get what I need.

Ok- I think I understand now. The dates on the form are for registration only and price during those time periods. Sorry about the confusion.

Thanks for the reply Steve. I've printed off this form, but there is no where on the form to check off that you would like to attend the conference on...

Think you can use this query to get what you need.

select SERVERPROPERTY('LicenseType'), SERVERPROPERTY('NumLicenses')

You can use what Aaron has posted as your first step in your backup job and use this script as the second step to clean up old backups. This one...

Have you tried selecting (type - operating system command) cmdEXEC and in the command window put just "C:\Project.exe" ? I think that might work.

I had the same problem with multiple owners in one database. I replaced the following statement:

DECLARE tables CURSOR FOR

SELECT TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE = 'BASE TABLE'

With this and it worked great:

DECLARE...

Thanks a lot. I just tried it and it works great!

I'm still having some trouble with my backups. I know I can't keep multiple days using a backup device, but shouldn't I be able to script it? I'm using this...