Viewing 15 posts - 37,351 through 37,365 (of 39,511 total)
I think these must be set when the link is created. Can you edit the link (sorry not that familiar and too busy to dig through it).
Steve Jones
June 24, 2002 at 1:49 pm
AllyAnne,
NT Auth is nice in that the DBA group can be managed as it applies to the entire group. There are no password changes here either. If you use SQL...
June 24, 2002 at 1:45 pm
If they are the same server, then you have a problem. The SQL3 server sees master as c:\mssql\data\master.mdf (or something like this). If you then restored this master on the...
June 24, 2002 at 1:40 pm
SQL Server will not release the memory once it has allocated it because it expects that it will need it again. If you start other tasks on the server that...
June 24, 2002 at 1:31 pm
Thanks for the followup. I'd run a full checkdisk( requires a reboot) and make sure you have no low level issues.
Steve Jones
June 24, 2002 at 1:28 pm
Why? I think you need to restore the standby back to what it was. I didn't think that the master database went in a restore (in general). The server name...
June 24, 2002 at 1:25 pm
Tend to agree about format and fresh install. Too many things to break in an upgrade in place.
Steve Jones
June 24, 2002 at 11:13 am
I think you misposted. Users need and should have access to a database. Otherwise, what is the point. Not all apps can use stored procedures. Even if they do, a...
June 24, 2002 at 10:22 am
What version of SQL? If 2000, I think you can get around this. If it's 7 or below, I think you are screwed and would need to move the data...
June 24, 2002 at 10:17 am
You should be able to change it in VB. Are you running this in VB after changing it, or attempting to "save it"?
Steve Jones
June 24, 2002 at 10:13 am
Boot the Maintenance plan?
Don't like these are I have had similar issues (not this though) and no error messages.
There are quite a few scripts in the librar that duplicate this...
June 24, 2002 at 10:11 am
I thought 7 included the deubgger as well. Perhaps not.
I have used Sylvan-Faust's tool as well as the regular one. Pain in the A** to get the DCOM working...
June 24, 2002 at 10:09 am
synched with the server. We have determined (Another thread) that this takes some time when the system time is changed, so I suspect that the SQL Server "checks" the system...
June 24, 2002 at 10:07 am
One more comment here. I just got a new job, which required MCSE2000 or MCDBA. At least in the requirements listed. I got the job, but I do have to...
June 24, 2002 at 10:05 am
Use Andy's suggestion. Do not give out sa rights except as a test, and then immediately revoke them.
Steve Jones
June 24, 2002 at 10:00 am
Viewing 15 posts - 37,351 through 37,365 (of 39,511 total)