I am working with a SQL 2000 database from a piece of legacy software and I'm finding that table structures have changed and the views haven't been...
Thank you for the information!
I have a new SQL 2000 Server I'm about to roll into production. My IIS web server (ASP.NET Application) will be communicating with the SQL server....
I am setting up a new server with SQL 2000 and Windows Server 2003 R2. It is an Intel dual quad-core processor system with 8 gig of RAM. Should I...
I have heard that if I put 64 bit Windows Server 2003 on my SQL server, I will have to also upgrade my web server (that reads data from the SQL...
In the next 10 days my new sql server should arrive. It will be running Windows Server 2003 and SQL 2000. The server has 8 Gig of RAM and I would...
The reason I'd like my VB app to do the DTS, is because the VB app has to know exactly when the DTS is done doing it's job, so that it can begin...
Can I execute a DTS package from a VB application or would it have to be scheduled? It would be ideal if my VB code that does the nightly...
We have an application that performs nightly calculations on our data, and then stores the results in a set of tables in the database. The overhead...
I forgot to mention that these servers are both running SQL 2000 Enterprise Edition with Service Pack 4.
I don't remember having this problem in the past, but recently our production server takes a long time to compile stored procedures. FYI, the server...
My server is offsite at a cybercenter and I want to monitor it with Performance Monitor from a computer here in my office. I can't get perfmon to...
Thats a cool solution Frank. I've never dipped into that spt_Values table before. I assume those values and that table are there for other reasons....
I have a temp table used by a stored procedure that contains some dates and values. I have a begin date and end date for a period of time and I need...
I agree that the better solution is to fix the nightly calculations, but since I'm the only developer/dba here and everything is top priority (as...
I want to be able to limit my nightly number crunching routines to acting on only data that has changed since the previous run. In order to do this,...
All databases are in use at the same time by different users. Depending on how a user logs in to the application, they get connected to a different...
We have 10 databases that get nightly calculations done on them. The routine that does it is a vb.net application that reads data from 8 large...
I recently set up a test database server to setup on a client site. It was very similar to our production server except that the processor was...
I know this is an old thread, but I wanted to say thanks to Frank... That little script was something I was searching for.
Separate names with a comma.
