MS Outlook yes, Outlook Express no.

Take a look at xp_readmail in Books Online.

To answer your question 'Not Really'. Microsoft does produce Visual SourceSafe that you can tie into SQL Server which allows you to version control stored procedures, but that's all.

Check out...

You should only use the "WITH (nolock)" query hint when you are not concered about the quality of the data.

When nolock is used it is possible to read data from...

Glad to be of service.

imackenz is correct. The problem is with the base64 encryption used by Reporting Services. It is supposedly going to be fixed when they release the product later this month.

The length that the lock is held would depend on a number of variables. Number of users, size of table, quality of hardware, etc...

I've had it happen to me. The...

One of the main reasons to avoid 'select ... into' with temp tables is that it can cause blocking in Tempdb.

I'm presuming this is running via a stored procedure and you pass in the criteria using a parameter.

That being the case you would need to validate the passed parameter before...

Try

select * from tab1where fld1 like  like 'Ph[[](L'

Note the use of [] to enclose the wildcard character in the data.

Yes that is it. Look at "Pattern Matching in Search Conditions" in Books Online.

When you use the LIKE operator you need to include a wildcard character in the criteria.

EG: select * from tab1 where fld1 like 'Ph[(L%'

This will return all rows where fld1 begins...

We don't have any means of determining what has changed in the Progress database unless we check every field in every record. This would substantially increase the time it takes...

Does the one package import all these files?

Take a look at the following article

http://www.sqldts.com/default.aspx?246

The filename is assigned to a global variable in step 4 of the example code. You...

Firstly you would store the file name in a global variable. Is this package loading multiple files or just one file?

For the transformation click the destination column and create a...

You could add an ActiveX Script task that check the properties of the datapump task. This way you'll not only get a count of the rows processed but also the...