Try this:

DECLARE @sql0 nvarchar(4000)

SET @sql0 = 'sp_rename ''' + @TableName + ''', ''IsActive'', ''COLUMN'''

EXEC(@sql0)

You need to double up the quotes if you need the resulting statement to have quotes...

Hi Srini,

Does this give you what you need?

select name from master.sys.syslogins

Jenny

That was the entire table - it's a small reference table I was using to test the connectivity.

Thanks for any testing you are able to do - I have limited...

I am using a 64-bit SQL Server and the 32-bit driver wasn't showing up as a linked server provider. When I installed the 64-bit driver then it appeared in the...

Yes - a stacked bar chart is a type of chart, created using the chart control.

Is there another type of chart I can use for this purpose?

Hi,

Sorry it's taken me a while to get back to this. We had a work-around using a 32-bit server but the client is wanting to use 64-bit for all servers...

Is service broker enabled?

See http://msdn.microsoft.com/en-us/library/ms189959.aspx for more info.

I'm not familiar with the sp_SQLSMTPMail stored procedure - is there a reason you need to use this rather than Database Mail (since you have SQL 2005)?

We had the drivers installed from here: http://www.oracle.com/technology/software/tech/windows/odpnet/64-bit/index.html

Once this was done, I was able to access a new linked server provider in SQL Server, namely OraOLEDB.Oracle, which I...

Hi,

Thanks for the feedback. My client is keen on using Microsoft products, at least initially, as they probably already have the required licenses under their volume licensing agreement.

Ihor - unfortunately...

Have you tried setting the DataElementOutput property of the textboxes in the header row? You can do this for a single text box by using the right-click Properties dialog, Data...

Hi Bob,

We came up with another way of doing this, calling the IS_MEMBER function with EXECUTE AS each domain username. I think your solution would be more flexible though so...