Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JohnBates
  • Content: Threads
  • Order by date
  1. JohnBates

    Microsoft Assessment and Planning Toolkit - Analyze only 1 Server?

    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
  2. JohnBates

    Want to Replace PC with iPad or Tablet?

    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...
  3. JohnBates

    Understanding a Local Login Which is (ServerName\userName)

    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...
  4. JohnBates

    How to Correct Page Number in Word 2003 Doc

    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
  5. JohnBates

    Linking to SQL Server 2005 from 2000

    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...
  6. JohnBates

    Last Date Access Database was Used

    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
  7. JohnBates

    Excel How to Insert Values ACROSS not Down

    Hi everyone, This is Excel 2003. I will be manually pasting values into a worksheet and I need those values to be inserted in cells across, not down. Is there a way to set my worksheet to enable this? Thanks, John
  8. JohnBates

    Installed SQL Server 2005 Driver but it does not appear in Driver List

    hi everyone, On this SQL 2000 machine, I installed the SQL Server 2005 driver (sqljdbc_1.1.1501.101_enu.exe) Seemed to install fine. However, when I go into ODBC Data Sources, the 2005 driver does not appear in the "Drivers" column. The SQL Server 2000 driver is still there, but no 2005...
  9. JohnBates

    How to MOVE Files Having a .msg extension

    Hi experts, In my 2005 package, I need to move files that have a .msg extension AND are > 30 days old (based on the last-changed date) to a certain folder. The source and sestination folder names are fixed. Is it possible to do this in a File System Task .... or will I need a ForEach Loop or...
  10. JohnBates

    Moved App from PC to Server - Now How to Run App from PC?

    Hi server pros, To get better security, I have moved some app software from a PC to a 2003 Server. Also moved the SQL Server databases. I can get everything connected and working on the server... But I'm struggling with how the user can run the app/exe, which resides on the server, from their...
  11. JohnBates

    How to Print/Show Contents of a Variable

    Hi experts. This is a very elementary question about VBscript. When I'm running this in Debug mode, I want to display the value of the sMonthName variable. Dim curDate As Date Dim sMonthName As String Dim iMonth As Integer curDate = Now sYear = DatePart(DateInterval.Year, curDate) iMonth =...
  12. JohnBates

    Configuring the Lock Pages in Memory feature

    Hi everyone, I have a database server running on Windows 2003 Enterprise OS (NOT 64 bit) I want to use the Large Page Support or 'Lock pages in memory' feature. The database service runs as the 'Local System' user. My problem is that when I attempt to specify the Local System user to enable...
  13. JohnBates

    PAE Physical Address Extension

    hi experts, On 2 Windows 2003 ENTERPRISE SP2 servers, I have added the PAE switch to the boot.ini file to enable PAE. On the 32 bit server, which has AMD dual-core processors, the system properties show 'Physical Address Extension'. But on the 64 bit server, which has the Intel Xeon...
  14. JohnBates

    Please Check my SQL Stmt

    hi experts, Can you find my mistake? Thanks ** This finds 6,170 duplicate records and inserts them, works fine: INSERT INTO dbo.FLIGHT_DATA_FACT_EXACT_DUPLICATES SELECT AIRLINE_CODE, CARRIER_CODE, FLIGHT_DATE, FLIGHT_NUMBER FROM dbo.FLIGHT_DATA_FACT GROUP BY AIRLINE_CODE, CARRIER_CODE...
  15. JohnBates

    Outlook 2003 - Pasted Error Message Boexes appear as a blank box

    Hi experts, I hope I can describe my problem. I have Outlook 2003 When someone sends an email containing, for example, an error message - in the body of the email (not as an attachement).... all I see is a balnk box with a red X in the corner of the box. This happens with emails sent from...
  16. JohnBates

    Maintenance Plan - Causes Log to Become Full

    hello, This is SQL Server 2005 SP2 For this database I have the max log size set to 14 GB (actual size of the data file is 32 GB) Until yesterday the log had never become full. The size was 2 GB before starting the Plan I ran the same maint plan that runs every weekend but this time it filled...
  17. JohnBates

    DB in Simple Recovery Mode but TLOG still becomes Full

    Hi everyone, This 2005 database is in Simple recovery and I need to delete approx 1 million rows from a table. The max size for the trans log is set to 5 GB and I cannot increase it becasue no more space is available on the drive. I shrink the log down to 50 MB and run this block of code...
  18. JohnBates

    A Report of Failed Logins

    hi experts, This is 2005. I have enabled auditing of failed logins. The failures are logged into the SQL Server logs. I'm interested in how some of you automate the reporting of failed logins - I'm not looking for an Alert - I need to produce a quarterly report for auditors. I do not have any...
  19. JohnBates

    Excel Chart Not Sorting Correctly

    Hi experts, I have a pivot table with chart (Excel 2003). The chart presents a bar-graph of database sizes as of a certain month. So 2 data columns: size and date - these are pulled from a SQL Server view which has a key on the date column desc The chart is fine except for the graph bars are...
  20. JohnBates

    2008 Enterprise Backup With Compression

    hi all, I'm experimenting with the Compression feature in 2008 Enterprise. My 20 GB database backs up to a 3.4 GB .bak file when I specify With Compression. That's about 1/5 the original size. Articles I read said to expect about a 1 to 3 ratio. **Will the size of the compressed backup file...

Part and Inventory Search

Back
Top