Viewing 15 posts - 37,291 through 37,305 (of 39,456 total)
I've done this, but populated a table with the valid business days. Then sum this up. Don't forget that holidays can be business or country specific, so accounting for this...
June 24, 2002 at 2:29 pm
Sorry, I midread. the instances threw me.
Try running SQL Setup and choosing "Rebuild master"
Steve Jones
June 24, 2002 at 2:28 pm
as andy said, create a batch or .CMD file. In it do a "net stop mssqlserver" and a net start mssqlserver (or whatever the service is named).
The NT AT or...
June 24, 2002 at 2:27 pm
Haven't seen any issues either. Can you give us some more info (browser, os, versions, connection, etc.)
You can email if you do not wish to post (sjones@sqlservercentral.com).
If you have issues,...
June 24, 2002 at 2:26 pm
Cheapest I have used?
I use my pushFTP process to move the database backups every 15 minutes from production to the QA server. Once a week I restore the QA server,...
June 24, 2002 at 2:24 pm
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
Viewing 15 posts - 37,291 through 37,305 (of 39,456 total)