Viewing 15 posts - 5,386 through 5,400 (of 6,105 total)
I believe SP2 is the same way. It replaces executibles and runs scripts...
K. Brian Kelley
July 2, 2002 at 10:48 am
From PerfMon: Number of pages used for miscellaneous server purposes (including procedure cache).
In addition to Steve's questions... Do you have a lot of stored procedures? Are they complex? Are any...
July 2, 2002 at 10:38 am
Most backup software, unless equipped with an agent specifically for SQL Server is unable to back up database files because they are typically held open by SQL Server.
Most of the...
July 2, 2002 at 9:01 am
Can you post a sample of the code?
K. Brian Kelley
July 1, 2002 at 9:36 am
PostgreSQL doesn't have as many features. SQL Server cannot be run natively on a linux platform. Linux platforms, however, can connect to a running SQL Server. MySQL is an alternative,...
July 1, 2002 at 9:35 am
Can you post the numbers sans the actual table name?
K. Brian Kelley
July 1, 2002 at 9:09 am
We tend to use a single account in production, though we've had as many as 40 servers online at the same time. But we do that for identical permissions...
June 14, 2002 at 1:03 pm
I'm much like Steve. I've got SQL 7 and SQL 2000 editions both running on my workstation (256 MB of RAM, 933 MHz). No real issues and I...
June 14, 2002 at 12:59 pm
There is a bug in SQL Server 2000 where shared locks in a transaction are held until the end of the transaction. It's fixed in SP2.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q300412&GSSNB=1
K. Brian Kelley
June 14, 2002 at 12:57 pm
We only use named instances in our clusters. The named instance is required for an active/active cluster (can only have one default instance, and it can run on either...
June 14, 2002 at 12:49 pm
What you need to do is create another database file, except where it has "PRIMARY" change it to another name. This creates a different filegroup. Then, when you...
June 13, 2002 at 7:46 pm
Run sp_who2 from Query Analyzer and that should show you all processes, to include system processes.
K. Brian Kelley
June 13, 2002 at 5:43 pm
This sounds more like a deployment question then. Are you deploying to the users' workstations or through another means such as Terminal Services/Citrix? In either case, they should...
June 13, 2002 at 5:00 pm
Viewing 15 posts - 5,386 through 5,400 (of 6,105 total)