Does anyone have any information on the trace flag 1903? I have been instructed to add it as a startup parameter and cannot find any information...
A local domain group was created and added to an SQL 2005 instance. It was then given permissions to a DB. Users in this group cannot connect to the...
I heard a rumor the Mainstream support for SLQ 2000 was going to be extended beyond 4/2008. Has anyone else heard this? Can someone direct me to a...
I hve 4 instances running on one node of a two node cluster. When I look at task manager on the active node I see that one instance is using 5gb (of...
In the instructions to install SSIS on a cluster MS mentions creating an IP resource. http://technet.microsoft.com/en-us/library/ms345193.aspx "Add...
I have a named instance running on a cluster. The cluster service uses one account and the SQL service uses another. When I put the instance into...
I have a cluster with 15 instances. None have had the min/max memory set. Should it? I was watching the memory usage and saw where one very active...
I am trying to find out information about the Extended stored procedure: XP_EXEC. I've just learned a vendor is calling it and I am concerned about...
I was doing some testing on the impact of the cluster account and removed it from an instance. Now the instance is offline and I cannot get it back...
I will be changing the private IP on a SQL 2000 clustered instance. I would prefer not to take the instance down if it is not necessary. I read...
I read the cluster service account needs to be in the public role at a minimum in a cluster environment. I removed the account from the instance...
New to reporting services I created a datasource and generated a model. I click on the Report Builder icon in the web page and when Report builder...
Is it possible to rename a cluster that is hosting an instance of 2005. The virtual server name and the instance name (default) will remain the same....
I am working on removing the BUILTINADMINISTRATORS account from our instances. I had read that the cluster service account required public access to...
When a value is assigned to a variable I see where an N is used at the front. For example: SET @FirstNameVariable = N'Amy' What is the N for?...
when a customer needs to have the production environment duplicated in development the DBA creates a full backup of the database and copies the file...
Separate names with a comma.
