We are currently in the process of moving the company servers to a new network domain. We currently have both the old and new domains on the network...
There is a very useful article on this site, by Ashish Kumar Mehta regarding the Resource Governor;...
As MS Sharepoint administrators will know; MS Sharepoint installs a named instance of <servername>OFFICESERVERS on SQL Server 2005 Express, if no...
I usually answer posts here, but for a change I have a question....[;)] I have noticed that it is possible to attempt a SQL Server login, using an...
I have a SQL Server 2005 instance that hosts a database for Microsoft Sharepoint used internaly by our company staff. The log file is approaching...
Is it possible to script a database (object structures, triggers, stored procedures) at regular intervals using a SQL Agent Job ? My specific...
If an instance of SQL Server 2005 has been installed as "Windows Only" authentication, can it be changed to "Windows and SQL Server" authentication...
I have a two-node active/passive cluster, SQL Server 2000 64-bit on Windows 2003. I wish to install SP4 on this cluster. I know that there is a...
Example: CREATE TABLE [dbo].[DFtemp] ( [abcd] [varchar] (100), [idkey] [int] ) ON [PRIMARY] GO I then insert values: insert dftemp values ('',1)...
How is "SQL Agent Mail" different from "SQL mail"? http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sql64/in_introduction64_7xo2.asp...
I have added a SQL Server 2000 32-bit server as a Linked Server to my SQL Server 2000 64-bit server. I have set the Security Context as the SA user...
I have recently configured a SQL Server 2000 EE 64-bit active/passive 2-node cluster on two servers running Windows 2003. The hardware is identical...
I am running SQL Server 2000 EE (with SP3a) on Windows 2000 Advanced Server with the /PAE /3GB OS boot parameters. My server has 8GB of physical...
My server is an Intel KOA, 4 x 700 Mhz Xeon CPUs, 8GB ram, dedicated SQL Server. The OS is currently able to see all 8GB. My SQL Server is...
My SQL Server is configured to only truncate the log during a transaction log backup. The log file autogrow option is enabled (true) I recently...
I am attempting to create a user login that can view all the jobs of the SQL Agent, including the Job History and Job Properties, using the...
Both Service Pack 3 and Service Pack 3a for SQL Server 2000 failed during installation on one of our servers, both times while running script...
My understanding of SQL Server databases is that the data and log files have a fixed size that does not change unless the data files have been...
I am attempting to distinguish redundant/obsolete user tables and user objects in a large SQL Server 2000 database that has expanded over time. I...
Separate names with a comma.
