Recent content by JohnBates

Thanks, I will post in that forum. Didn't know it existed.

Hi experts, I want to analyze, inventory only 1 Windows server. If I install the Microsoft Assessment and Planning Toolkit onto that server, can I configure it to perform an assessment of only that server? (I DONT want to collect info for all servers on out network) Thanks, John

Thanks to everyone who offered ideas. And especially to Symplogy and vacunita. The gist of these posts seems to point me in the direction of a laptop. I was hoping the smaller, more portable devices would be a viable option. But I may also want to install MS SQL Server database software and I...

This may not be the correct forum for my question but hopefully someone can offer some advice. It's time to replace my desktop/PC. Could an iPad or a Tablet be a good substitute for a PC? I would need to use MS Office, browse the Web with Firefox or IE. Also would need to be able to remote into...

Thank you, Dave. I got it.

Hi experts, I'm moving a SQL server database from one 2008 Server to another 2008 Server. The database uses a login which is not a domain account but rather ServerName\AccountName. I have not come across such a login in the past but I will need to create that login on the new server. I'm in...

Ok, I resolved this. By selecting the footer area, then pressing Alt-F9, it recomputes the page numbers. We can close this post. Thanks

Hi experts, I have a page footing that contains a derived page number. But after I deleted a page of text, the last page number shows "4 of 5" but should be "4 of 4". How can I get Word 2003 to recalculate the page numbers? Thanks, John

The Linked Server connection is working fine. we can close this post. Thanks, John

This should be easy but maybe I have forgot a lot about version 2000. On a 2000 instance, I created a linked server to a 2005 instance on another server. The Linked Server uses a very restricted SQL Server login. But I am not able to test the connection on the 2000 server because I cannot...

Thanks King James Version. So if simply opening, whether anything got changed or not, updates the last modified date - that will meet my needs. I have the same database name in multiple folder paths - that's what triggered my question. John

I think I know the answer and I think it is 'No' but why not ask the experts. Is there any way I can determine when this Access 2003 database was last used? Other than the obvious steps like checking the last modified date for the data and log files? Thanks, John

Thankyou Skip and Blue. Your ideas worked. I'm retrieving the names of databases on 50 SQL Servers. It just makes sense and helps to be able to insert the database names across, beside the server name. John

.... more info if it helps. I'm copying the values from a SQL Server pane, then pasting into the Excel sheet. I have Excel 2003 Thanks, John

Thanks, Skip. I was hopefull but all I see are Paste As: Unicode Text OR Text