As GSquared as said, you can specify the lock type with a locking hint in the select statement. Something like Select x from table with (updlock). This statement...

Have you tried sending the email as plain text instead of HTML to see if that works?

Like you said it sounds like an Outlook issue. Can you send the...

Is the job doing performing multiple actions in a single step? If so I'd break out each action in it's own job step and then SQL Server Agent will...

You should check out the Scripts section here at SSC and you may find something. Here is a link to a script I posted that gets Foreign Keys and...

I'm not sure what you are asking and I don't think any of the other viewers do either which why you have not gotten any responses. Take a look...

anjali.vishwakarma (9/24/2008)

---

Using WITH(NOLOCK) with select statement...what are the pros and cons of it ? Does it have any effect on performance ? when we should use it and when...

There's a custom component out there called the Trash Destination that you can download and use. Available here.

I find this to be one of the failings of SQL Server encryption. My personal opinion is that you should handle encryption in the application, I know you don't...

The first place to look is in the SQL Server Configuration Manager to see if SQL Mail is enabled.

Second see if there is a MAPI client (Outlook) installed on the...

Glad some of the stuff I read about and give a whirl can be helpful. Every time I think I know what you need to know about SQL Server...

You would need to pass parameters by name. Like this:

code]

Exec tableA_upd @id = 1, @col1 = 'Test'[/code]

Leaving any unchanged parameters out.

I also assume that you have the value(s) on...

About 6 months ago I posted a question asking about update procs and if I should require all the params or go the IsNull route and the consensus on that...

I don't think Full Text search is useful in this...

I was wondering the same about the clustered index or the heap (some people still don't always have a clustered index). That's why I mentioned that it might be...

In the first code example you are required to pass all the parameters to the stored procedure so the web code would pass all the parameters and it updates all...