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...
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...
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?
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.
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,...
I am getting an event 7000 when trying to start MSSQLSERVER service (Cannot find the specified path. It is not a clustered environment. I did have...
Currently on one of my servers, I have sp_sendmail registered and I am using that to send mail via SMTP. There is an application that is making a...
I ran the commands to rename the TEMPDB data and log file. Alter database tempdb modify file...... Then I stopped and restarted the service. In...
I am trying to setup a DSN entry to connect to a cluster. The SQL Server IP is .244 The cluster IP is .182 The virtual IP is .180 I tried setting...
I added disks to the server. Now I am adding them to the SQL cluster. 1) I added them as a resource. When I try to add SQL Server as a...
I created a new table and performed an update on a database. When I checked the datetime stamp on the mdf file, it was never updated. When does the...
We are looking for a way to update the mdf/ldf files without updating the database. I know the "touch" command does this, but I was wondering if...
I am running the following command to script out the master DB. That should include logins from the sysxlogins table. After the script runs (no...
Separate names with a comma.
