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...
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.
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.
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...
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...
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.
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...
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...
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...
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.
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...
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...
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...
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...
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.
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...
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,
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.