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: GysE
  • Order by date
  1. GysE

    Public Role Privileges

    Thanks a million.
  2. GysE

    Public Role Privileges

    I would like to know if it is possible to remove or delete user accounts from the PUBLIC Role. As far as I know all users will be assigned to Public Role.
  3. GysE

    SQL2000 attached to SQL7

    I thought so. Thanks for the conformation!
  4. GysE

    SQL2000 attached to SQL7

    I would like to known if it is possible to "attach" the .MDF and .LDF of a SQL2000 database to a SQL7 database. We want to do certain process on a SQL2000 database. After we took the database off-line, we want to take these .LDF and .MDF to a SQL7 database and use them with SQL7 server. I...
  5. GysE

    Communication Link Failure

    Please, I need Help!! Lately we are getting a Communication Link Failure with certain Applications that are connecting to our Databases. I feel the message cannot tell you exactly where/what the problems are. We checked the SQL Server and everything looks fine. I'm the DBA and needs to give...
  6. GysE

    Upgrade wizard SQL 6.5 to SQL2000

    The wizard creats the database structures, loginId, etc. Up to here everything seems fine. On the Export Import step I am getting the following error : Error return from function CreateFile in file CnvPipe.cpp Line=143 rc=5 Msg=Access is denied. This process uses named pipes and I assume...
  7. GysE

    MSDE Database Size Limitation

    Hi, Is there a limitation on the size of a MSDE SQL database? I think there is a limitation of about 4 GB per database, but I'm not sure. Please Help Thanks
  8. GysE

    SQL - Backups

    Is it possible to make a SQL backup straight to a mapped drive? All drives I can see if physical drives. Please help
  9. GysE

    SQL - Backup Procedure

    Hi, We have to implement a backup procedure for a fairly big (50GB) SQL database and we come up with the following. Note, data is critical for the business: Full Backup - Sunday night. Differential Backup - Every evening, except Sunday night. Transaction Log Backups - Hourly, except during a...
  10. GysE

    Database Maintenance Plan

    What is the correct order to schedule a database maintenance plan? I want to include the following option: Optimization, Integrity and Complete Backup. What will happen if the one process overlaps with next of previous process? I assume the SQL Agent will take care of it. I would like to...
  11. GysE

    How are NULL values stored

    We want to know what the impact of NULL values is on physical space sizes on the disk. Is there any documentation to prove when you got an INT value and you store a NULL value in there that it will still take up 4 bytes.
  12. GysE

    SQL - Error on Enterprise Manager

    Thanks for the replay karluk. I have stop and start the sql on the server. No luck! I have reboot the server. No luck! Thanks for the reference to the problem. I will look there.
  13. GysE

    SQL - Error on Enterprise Manager

    I'm getting the following error on my Enterpise Manager: "An Unexpected error happened during this operaion." All I want to to is to OPEN TABLE and then RETURN ALL ROWS from a table via Enterprise Manager. I will get this message when I want to open any table, even from different...
  14. GysE

    SQL - Service Packs

    Is it necessary to install service packs on a pc with only Client-Components installed? On SQL 7 and/or SQL 2000. It makes sense on Server-Side, but what about Client-Side?
  15. GysE

    Searching SQL Servers

    I'm new as a DBA for a big company. I must do an audit to see how many SQL servers are there in the company. I know about the facility where you register new SQL servers to click on a button and you will get all the active SQL servers. But this option does not give you a list of all servers...
  16. GysE

    SQL - DBCC TRACEON

    Can anybody please help me with the following. I'm new as a SQL dba and on one of our servers I'm getting the following in my SQL logs. It happens about every 10 to 15 seconds. DBCC TRACEON 208, server process ID (SPID) 166. What does TraceOn 208 means? If the trace is switched on, are you...

Part and Inventory Search

Back
Top