Did you ever get an answer on this one?
I have created a performance alert to fire when the Log file reaches 80% full. I noticed that when you create the alert, you must select a database...
I need to write a script that select specific user databases and changes the recovery mode from Full to Simple. If anyone has examples of this that...
We are trying to take an already built SQL 2005 cluster and install a SQL 2000 instance. When we go to run the 2000 install, after the popup to add...
Has anyone seen issues when running a DB freeze, where it hangs the databases? We are using EMC timefinder to backup databases to a mount host. The...
We are using BMC Patrol version 3.6 and are not using KMC
I am looking for a list of events that my BMC Patrol agent should check for on the SQL Server. I am currently alerted on failures to the SQL...
It needs to be in a SP because the job runs via Control M. It needs to send a return code of 0 back to Control M once the job completes.
I am not a TSQL programmer, and I am looking for an example of a loop that checks the sysjobhistory table for the successful completion of a job. The...
Is it possible to have a SQL 2000 instance and a SQL 2005 instance on the same server?
THanks so much for the help. Using the server name instead of the IP worked. So what is the resolution for this if I need to be able to map to an...
I was able to connect using named pipes. I have never used ICMP before, what is the syntax at the command line to test?
I am trying to create an ODBC connection from serverA to serverB. I can ping serverB from serverA and visa versa. But I cannot successfully create...
Anyone have any information on running a SQL Server Agent job from a command file. It is actually going to be ran via a job in Control M.
Thanks so much, this is exactly what I need!!!!!!
Actually, I know the syntax on how to create.....what I need is code examples on how to use a parameter file to pass in to build the DB. Eg. Each...
I am looking for script examples that can create a database based on sizes, names etc in a parameters file. I understand this would most likely...
Is there a way to determine whether a database is in hot backup mode? I know in Oracle you query the V$ system tables. What is the equivalant in...
I am looking for examples on how to automate creating a database using a .cfg file for parameters. For example, cfg file contains database name,...
Path is correct. We have a cold backup.....and it was apparently up for almost a week before it was powered down. I am wondering if that is the...
Separate names with a comma.
