You can script any job and check the script to see how to schedule a job or read in BOL about sp_add_jobschedule

Adi

Notice that you are using 2 different data types in your query. In one of them you use ASCI character, and in the other one you are using Unicode....

Why would you want to shrink all files on the server? Shrinking files is not a good habit:-). Shrinking the data files will cause fragmentation problems. Shrinking...

Differential backup can work with all recovery models, so I don't think that switching recovery...

I think that when it comes to clustered index, it treats the leaf level different then none leaf level. The leaf level’s space is considered as the data’s...

Lowell (10/6/2010)

---

anything long term

you'll need to put something in place to audit the tables or trace all sql statements.

For example if you create a server side DML trace ...

I have to admit that I don’t agree with ALZDBA’s opinion. It is important to know and realize what clustered index does and how dropping it and\or creating it...

If you think that the problem is that SQL Server is using to much memory and doesn’t leave enough memory to the OS, then you can limit the server’s memory...

I don’t think that anyone here will be able to give you the solution. We don’t know how big the tables are, how many inserts you make, how many...

Your post is not very clear. When you use keys to encrypt data, the data is stored as binary (or varbinary). If you don’t use any encryption at...

When you execute a dynamic SQL, you need to use parentheses around the variable that stores the dynamic SQL. Also I don’t think that you need to specify that...

You can use the undocumented procedure sp_MSforeachdb and query sys.objects in each database and check the create_date and modify_date columns. Here is an example (that I didn’t check, so...

SQL Server 2005 or later supports try catch block. Before SQL Server 2005 the only way to have some kind of error handling was to check the value of...

It is worth mentioning that although...

There is a very good reason that functions are not supposed to modify the data in the permanent tables. Let’s assume that for a minute that we could modify...