Using DMO to Execute a Job
Using DMO to execute a job is a powerful technique that is easy to apply. This article by Andy Warren has all the code you need to do it!
2001-05-22
5,332 reads
Using DMO to execute a job is a powerful technique that is easy to apply. This article by Andy Warren has all the code you need to do it!
2001-05-22
5,332 reads
The case where one has to send the results of a query to a text file comes up quite often. This quick tip will show you how to output the results of a query to a text file.
2001-05-21
11,932 reads
Your database design should be impervious to this documented behavior of the ADO delete method. Be one of the first five members to give a compelling reason why not, and take a dollar from starving columnist Sean Burke.
2001-05-21
3,324 reads
An interesting database option which is hidden from Enterprise Manager in SQL Server 7.0 is offline.
2001-05-21
9,709 reads
You cannot do a proper tuning job on SQL server in two minutes, but you can get a good idea of how well a server is set up. This article will show you how to quickly evaluate the efficiency of memory usage on your server.
2001-05-21
10,018 reads
VMWare is a software product that is great for testing new ideas without having to purchase and install a separate machine.
2001-05-21
4,331 reads
A review of the SQL Server 2000 Black Book from the Coriolis Black Book series.
2001-05-18
4,601 reads
In SQL Server 7.0 Data Transformation Services (DTS), dynamically configuring packages was difficult. With the aid of a new Dynamic Properties task in SQL Server 2000, this assignment is easy.
2001-05-18
12,218 reads
This article by Andy Warren provides an introduction to some of the fixed database roles and things to consider when using them.
2001-05-17
4,699 reads
These are some stories that show the downside of everyone having cell phones.
2001-05-16
1,797 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
Comments posted to this topic are about the item Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers