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 strongm 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. MDCrab

    any way to override content?

    Hi, someone has intercepted the password to my Exchange Server mailbox. this same person has access to the Brightstor backups for our company. i fear that my privacy is going to be compromised. Does anyone here have any ideas how I can stop this from happening? the potential loss i face...
  2. MDCrab

    Linking Servers between Companies

    Lonnie, Re: VPN, I don't see what the difference is. The source database has to be opened up on the firewall. This invites hacking, malicious requests.
  3. MDCrab

    Linking Servers between Companies

    it's possible, but dangerous. The network engineer of the company that has the source server has to open up their firewall to enable this. That enables nasty people/nasty bots to try to hack into the source server.
  4. MDCrab

    Connecting to 2nd database - not an option

    SQL has a concept of "user mappings" that might be important to you. Basically, each database has a list of users that can access it. You may need to add this woman as a user to the database in question. Also, if you want to change the default database that a particular login sees, change the...
  5. MDCrab

    can't set the log file to unrestricted growth

    Hi, I'm happy to report that I've made a breakthrough and my problem appears to be resolved. Here are the steps I took: 1. I unattached the database in question and renamed the log file. Then I reattached the database. This created a new log file. 2. with the new log file I am able to...
  6. MDCrab

    can't set the log file to unrestricted growth

    Hi Jay, It is a user DB. It isn't used by a 3rd party app or tool. I created the structure. I populate it with a series of insert statements. The insert statements are called by an ASP script which connects to the database. thanks.
  7. MDCrab

    can't set the log file to unrestricted growth

    Hi Jay, Sorry for the delay in responding. I was off for nearly a week. The database size is 2.6 GB. The log file (i.e., LDF file) is only 20 MB. The total storage space free is 268 GB. So, we've got plenty of room for this database. I went to the database and right-clicked on the name...
  8. MDCrab

    can't set the log file to unrestricted growth

    Hi Jay, I'll respond to your questions when i return to the office in a few days. thanks.
  9. MDCrab

    can't set the log file to unrestricted growth

    hello, I've got an insert statement that keeps failing when I call it from a SQL 2005 stored procedure. (This insert statement attempts to put 22,000 records in a table.) After I try to call the stored procedure, I check the SQL logs for information. It tells me: "Autogrow of file...
  10. MDCrab

    verifying backup devices

    Hi Denny, I appreciate the reply. I've been slammed recently so I haven't had a chance yet to try your remedy. thanks.
  11. MDCrab

    verifying backup devices

    Hi Denny, I'm afraid to use the the 'alter database modify file' command on our production database. The database has the correct name in SQL Enterprise Manager. The MDF and LDF files are also appropriately named. It just doesn't have the right Physical_Name when backups are made. If that's...
  12. MDCrab

    verifying backup devices

    Denny, Yes, the Physical_Name that shows up when I query the sys.database_files is the incorrect file name that keeps on showing up when I do "restore filelistonly" on the backups. thanks.
  13. MDCrab

    verifying backup devices

    Hi Denny, I just made a backup of one of our key databases. Then I did a restore filelistonly on the backup I created. This backup also has the wrong PhysicalName. I expect that the PhysicalName will be the name of the database file. So, if I had a database named: c:\program...
  14. MDCrab

    verifying backup devices

    Hi Denny, thanks for the suggestion. I did a filelistonly on the backup device and the PhysicalName is again, wrong. However, when I view the "database" name for the device it shows the correct database. I deleted the backup device and created it again. Then I ran the job that writes to it...
  15. MDCrab

    verifying backup devices

    Hello, I'm the SQL DBA and one of my responsibilities is verifying the SQL backup devices (that I have configured). We're running SQL 2005. One method I've been using is to run a query similiar to this in the Management Studio's query analyzer: restore filelistonly from...
  16. MDCrab

    returning MySQL output params from stored procs

    Hi Tsuji, I appreciate the reply. I found the answer last night. I was about to post it here, but you replied before I could do so. Regarding your command object solution...it doesn't work. That's because if we keep the "OUT" directive in the parameters of the stored procedure, that abysmal...
  17. MDCrab

    sql script file comments

    there are also block comments; e.g., /* set v = 5; set h = 3; */ -- doesn't get executed. btw, two dashes by themselves don't produce a comment. You need the space after them. --not a comment -- is a comment.
  18. MDCrab

    returning MySQL output params from stored procs

    Hello, i really appreciate the help i just received on a related subject: http://www.tek-tips.com/viewthread.cfm?qid=1504745&page=1 I've got a new question. From VBScript, how does one call a MySQL stored procedure and retrieve output params? I created a MySQL stored procedure: PROCEDURE...
  19. MDCrab

    calling MySQL stored procedures from VBScript

    Hey Tsuji & Ingresman, i'm very pleased to report that it now works. I get back: 05.01.0005 as the driver now. The connection string needed to change to: DRIVER={MySQL ODBC 5.1 Driver}; ... thanks so much for the help. I can't say enough about how great this forum is. thanks,
  20. MDCrab

    calling MySQL stored procedures from VBScript

    Tsuji, you wrote: "...Go to control panel and under system info, there is an odbc info. Click it out and look for the MySQL driver build. Specific attention is on the minor build. Even with MySQL 5.0, the driver is an independent downloadable update. You can even blindly download the latest...

Part and Inventory Search

Back
Top