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 SkipVought 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. smileydba

    Terminal Server question

    Simple question, but cant find the solution. Trying to change the Default Security Access from Administrator access to user access. Problem is, someone in our department changed the Terminal Server access from User Access to Administrator Access and now only administrators can log on. I cant...
  2. smileydba

    Citrix Presentation Server 4.0 and Windows Server 2003/SP1

    is there a known issue regarding PS4.0 and Windows 2003 Server/SP1????? Im seeing more problems on this board and on my clients when it comes to Service Pack 1 for Windows 2003. Has anyone else had issues regarding PS4.0 and W2003S /SP1???? Rob W.
  3. smileydba

    Citrix Metaframe 4.0 license problem

    Yeah, did hostname on the server, and copyed it strait to the website, and over to License server. Now the Citrix Licenses are conflicting with the Microsoft Licensing. :o( Rob W.
  4. smileydba

    Citrix Metaframe 4.0 license problem

    Man, installed Citrix Presentation 4.0 on our Windows Server 2003 Server (Terminal Server). First, we continue to have license issues, ever after downloading the license keys and loading up the key to the License Server. Im still having problems with the Licenses. Certain users are able to...
  5. smileydba

    Reusing RAID once a replacement Controller comes in

    Server: IBM eServer ok, our DC crashed, and with it, all three drives went with it. System is Raid 5, no spare (i know). We trouble shooted the issue down to the controller, because when we move two of the drives to any other slot, they show activity and opperational, but you put them back...
  6. smileydba

    Reusing RAID once a replacement Controller comes in

    Server: IBM eServer ok, our DC crashed, and with it, all three drives went with it. System is Raid 5, no spare (i know). We trouble shooted the issue down to the controller, because when we move two of the drives, they show activity and opperational, but you put them back into there slots...
  7. smileydba

    Mirrorings - Changing Drives to bigger drives

    Howdy all, Quick question. We have a client who has software mirroring. We are about to update and install newer and bigger drives. They currently have 2 18.2GB SCSI drives. We will be replacing them with 2 36.2GB drives. Now, is there a way that we can BREAK the mirror, take one old...
  8. smileydba

    HELP!!!! Moving data from one database..table to another

    And if someone mentions BCP, please enlighten me on what I need to add to make it work. Rob W.
  9. smileydba

    HELP!!!! Moving data from one database..table to another

    Ok, My issue is that, I want to move data from the old database..table to my new database. the problem Im running into is that, I need to create a script that compares the two tables from the two databases, and based on that, if there is a match, dont do anything, but if there isent a match...
  10. smileydba

    Moving data from one database to another

    Ok, if that is done, how would I write up the Update statement to where the old data(the data that was passed over by the old database) would be deleted instead of the new data? Rob W.
  11. smileydba

    Moving data from one database to another

    Also, basically, dont want any duplicates or the old data over writing the new data. Rob W.
  12. smileydba

    Moving data from one database to another

    Another Newbie Q Old Database-->table/data--->Move into new database--->table So basically, what we want is basically, the old database has some data we want to move to the new database. But here is the kicker, the new database already has data in the table we want to move data to. So...
  13. smileydba

    Is it possible to grab a ANSII file and do a update via TSQL

    There is more then one value, such as, xyz, 123, abc, 123 rst, 456, def, 789 So lets say, there is a file on the desktop called update1.sql, in this ANSII file is data to update a table called items Server Desktop --> update1.sql --> Query Analyzer(TSQL)-->Table(items) I know I can do this...
  14. smileydba

    Is it possible to grab a ANSII file and do a update via TSQL

    Is it possible in TSQL to be able to grab a file on the server and do a update to a particular table. Say, for example, there is a ANSII file on the desktop, and I need the TSQL to grab that file and update a table. Is there a query that can do that (possible SP or trigger) Rob W.
  15. smileydba

    Doing a ALTER and/or porrible UPDATE for a comma delimited......

    Newbie question, Problem - Customer has a Unix system that spits out a ANSII file, and I already imported this into the MS-SQL database. The problem is that I need to add a additional value to the datatype to a column in a table (easy enough, do a alter table, alter column). Here is the kicker...

Part and Inventory Search

Back
Top