Search results for query: *

Thanks Mr Denny We had the web server setup to talk to a SQL server 2000 database in mixed mode. (Worked OK) When we setup the database for windows authenication only(for added security) the web access fails with an error message that states the reason as not associated with a trusted SQL...

In looking around the usergroup I found this reference to various setups of firewalls and SQL server access. Is there a way of tightening up security if you only have one DMZ with a web server that is talking to an internal SQL server?(b) With SQL there are a few schools of thought... there is...

I want to add new PC's to our network. The PCs can join the domain and appear in active directory searches, but do not appear in Network neighbor hood and can not be managed remotely. This a very small network with only the two server acting as DC and application servers, with SQL server 2000...

We are currently in the process of developing our own application. (I believe they use VB.net) We use MSSQL-2K server for our DBMS. All our clients will come in over the internet to run reports, queries and view data. I am new to the database admin side of things. I will just have to monitor...

Does any one know where I can find info on expected performance of a server and application with databases? Such as how many databases and client accesses should you put on one server? etc. given # of processors, speed, memory, disk info etc. example I use MS-2k with MSSQL-2k on 1 IBM xSeries...

Thanks I see it there(msdb) Should be OK now. Will add: USE MSDB GO Thanks again CXO

thanks do i run this from Query analyzer? I treid it and it fails at the UPDATE sysjobs Line Is it possible that there is a another function or same function as sysjobs with another name? I could not find sysjobs anywhere. thanks again Chris Ormstrup

I am running windows 2000 server and MS SQL server 2000 standard. I have recently renamed my servers and joined a different domain. Things are working well except that my maintenance plans had to be recreated and the when I try and delete old jobs under the SQL server Agent. it informs me that...

Can you do log shipping with SQL server 2000 standard edition?

I have a 4 Gig system partition that is filling up with stuff. I have 700 MB left, when I started out with over 1.4 GB spare space. This partition is supposed to be fairly static, but is growing anyways. Does anyone have any pointers on how to ID files that can be removed or cleaned up. Such...