Check out sp_update_schedule in BOL.

Can you post the exact SQL you are executing? And the definition of the stored procedure being called?

You may want to check out this article, http://www.sqlservercentral.com/articles/Security/65169/. Here is another older article that may still apply as well, http://www.sqlservercentral.com/articles/Installation/cannotgeneratesspicontext/929/

What are the indexes on the table?

Have you tried this:

SELECT

tb1.tar_fileno,

CASE

...

What is the exact error message?

Odds are you can probably get all your data in one query and do it in one report without the subreport. That will be...

GilaMonster (2/20/2009)

A government office? That explains everything!

Did anyone notice the one he started this morning?

http://www.sqlservercentral.com/Forums/Topic661280-338-1.aspx

Full outer joins on what appear to be...

Ha Ha, that's a good one.;)

Sorry, you can't create server level roles.

Try searching the script library on this site. Here is one that will identify foreign keys:

http://www.sqlservercentral.com/scripts/foreign+keys/64333/

This might get you started on the others as well.

Here's a search for Primary...

No you did not do anything wrong. I had forgotten how the IIF statement is evaluated. I think it is evaluating the Substring for both the If and...

Bob,

I don't disagree. I was thinking that you would use the INFORMATION_SCHEMA.COLUMNS table to only add columns to the WHERE clause that allow nulls. The only way something...

You would do something like this:

Imports System.Data.SQLClient

Dim cnSQL as SQLConnection = New SQLConnection(ConnectionString)

Dim cmdSQL as new SQLCommand

' if you want to return results using a datareader then you need a...

Is it possible that getting no data is the correct result?

Not that I am aware of.

You can lookup each of the set statements in Books on Line to get full definitions

Sets the connection to use ANSI standard NULL handling. This basically means...