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!

  • Congratulations Chris Miller 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: *

  1. patrick118

    Maintenance plan logging or tracing

    I have a maintenance plan which fails. In the logfile I see the following message. Check Database Integrity (xxxxxx) Check Database integrity on Local server connection Databases: All system databases Include indexes Task start: 2011-08-08T06:00:05. Task end: 2011-08-08T06:00:05. Failed:(0)...
  2. patrick118

    SQL 2000 all db sizes

    I can sleep now. Thank you.
  3. patrick118

    SQL 2000 all db sizes

    the name field is the name of the filename it can be different from the name of the database
  4. patrick118

    SQL 2000 all db sizes

    maybe this is to much but getting the dbname in the ouput as well?
  5. patrick118

    SQL 2000 all db sizes

    Thank you. Completely solved the problem regards Patrick
  6. patrick118

    SQL 2000 all db sizes

    ...) insert into @filesizedb (dbid, dbname) select dbid, name from master.dbo.sysdatabases where (@dbname is null or name = @dbname) /* ** Now for each dbid in filesize, build the database sizes ** */ declare @curdbid smallint /* the one we're currently working on */ /* ** Set...
  7. patrick118

    don't get dhcp lease

    I installed the vmware player on windows XP. When I look at the networks i got 2 extra networks installed VMWARE Network adapter VMNET1 en 8 They both are DHCP lease but when i refresh my addresses they keep getting a range that is not on my network 192.168.92.1 and 192.168.109.1 they say...
  8. patrick118

    RMAN tool

    Not a very urgent question but does anyone know of a rman tool. Perhaps some shell over the oracle rman tool. Syntax checking etc. I can't seem to find one.
  9. patrick118

    system uptime

    THANX
  10. patrick118

    system uptime

    ...Set objWMIService = GetObject _ ("winmgmts:\\" & strComputer & "\root\cimv2") Set colOperatingSystems = objWMIService.ExecQuery _ ("Select * from Win32_OperatingSystem") For Each objOS in colOperatingSystems dtmBootup = objOS.LastBootUpTime dtmLastBootupTime =...
  11. patrick118

    recover tablespace until

    I allready thought that would be the answer i get. Thank you for answering. Well back to the studybooks and look at TSPITR
  12. patrick118

    recover tablespace until

    I'm testing a few things with recovery. I have a database 9.2 in archivelog mode. I made a cold backup of the entire database started the database and made some changes to the table in tablespace example. scn is now 55770 made some more changes and scn is now 55980 I set the tablespace...
  13. patrick118

    local system logon as sysdba

    I realize that and that is "sort" of the problem this is an internal windows account that you can't grant such rights to. But thank you for the post
  14. patrick118

    local system logon as sysdba

    I have a batch job like the following sqlplus /nolog @start.sql in the start.sql script it sys the following connect / as sysdba When i start it as an administrator works ok. When i schedule it it is automatically started as local system and then i get insufficient priviliges. I don't want to...
  15. patrick118

    restore single appointment

    Worked like a charm restoring to a test user. Thanks for solving the problem
  16. patrick118

    restore single appointment

    Hi I allready told the user NO!!! Go Away! Watch out what you delete then!!! But.....I am a nice guy so I still want to know. A dummy user is an option but that is a bit strange. You've got this great software and you need to restore the entire thing to a dummy/ But if it works it works...
  17. patrick118

    restore single appointment

    Hello, I use veritas 10 to backup my exchange 2003. Now a user comes in and asks me te restore an appointment she deleted. She doesn't remember exactly what it is about but she knows it is one for tomorrow. When i went to restore i can see only the subjects of all the appointments not the...
  18. patrick118

    OWA problem with different domain

    I got it working again. On virtual server i changed the properties of FBA to on and restarted everything and then back to off and now it is all working again. Really the reason i don't now but it had something to do with IIS and virtual server in exchange manager. Thanks for thinking with me...
  19. patrick118

    OWA problem with different domain

    Well i ckecked all the logs on the terminal server. Nothing in there. I then checked all the logs on the exchange server and i see the user gets logged on and then logged off allmost the same second.

Part and Inventory Search

Back
Top