I have been asked to adjust the full-text master merge so it occurs at a different time of day. It is my understanding the master merge happens...
I have a SQL Server 2005 active/passive cluster which has the quorum drive on a partitioned SAN LUN. I want to fix this and get the quorum drive on...
Does anyone have a good t-sql script to quickly delete several hundred databases?
I want to keep track of the processes that show up in sp_who2 as suspended. Is there a way to write a query against system tables to count and keep...
I'll give that a try. Thank you Mohammed. Michael Herfkens Herfkens Enterprises, Inc. michael@herfkens.net
I am just wanting an easy way to know when a user has made a change to a table, stored procedure, view, or index. I am aware that I can go look for...
Does anyone have a script that will find schema changes? I want to create an alert that will send me an email when a user makes a change to the...
This is one of my last attempts. I have looked at this so long now I know that even if the error is simple and right in front of me I'm going to...
It still doesn't give me what I need. I need the ability to apply a wildcard to the database name. I can narrow down the name close enough with the...
Thanks Madhu, I'll give it a shot in the morning. Michael Herfkens Herfkens Enterprises, Inc. michael@herfkens.net
I need to be able to write a script to perform actions on a database and I need to be able to hand off the script to another user who might not run...
WONDERFUL!!!! Thank you alzdba!! I hate working with the registry so your script is invaluable to me. Happy Holidays. Michael Herfkens...
Is there a stored procedure or does anyone know an easy query that will return the accounts running the different services for SQL Server? I want to...
I am setting up server side tracing to find performance problems but I am running into a space problem. I have the trace setup to grow to 512MB and...
I am looking for a SQL script or a software package that will let me see the CPU utilization and memory used by individual SPID's on a database...
I can create an index with the same name. So I guess they are only entries in the sysindexes table. But why didn't they go away when the table was...
I have a large number of indexes that were created on temporary tables. The temporary tables were deleted by a scheduled SQL job but the indexes are...
The problem I am running into now is that this database was created by restoring a backup of a replicated database. Now I receive the following...
I have a large database that I am having difficulty shrinking the log files with. Is there a way to use T-SQL to purge the log files so I can get...
Recently I upgraded a couple of my SQL Servers to run on Windows Server 2003. They are both SQL Server 2000 SP3a Enterprise Edition that have been...
Separate names with a comma.
