I don't have time right now to try this out, but you might start by looking at publishing the chart as a report part and see if PPT can link...

For starters, you will be purchasing copies of each edition outright. There is no licensing/cost break on upgrading from the free Express edition.

Next, you are best off contacting Microsoft...

Thanks! I figured, and told them as much. Was totally shocked that these guys would risk the contention.

It all seems to be working better now. Changed the...

I would look at this link for details:

http://msdn.microsoft.com/en-us/library/ms345102.aspx

The short of it is that these logins are not intended to be server access logins. Rather the corresponding certificate or key...

Without a sample schema and data I can only make a guess at it. But here is an idea to start with:

DECLARE @btype int = NULL;

SELECT A.sid, A.name, A.values,...

In my experience, I get better connectivity to SQL 2008 (and 2005) using the Native Client. There have been times that using the older SQL ODBC driver simply would...

SINGLE_USER allows any single user with permission to access the database.

RESTRICTED_USER is the one that limits access to sysadmin, dbowner, or dbcreator.

As far as I know the driver would come from your backup software vendor. Most have addons that access SQL Server.

I would check with them for an update.

Why not save the trouble of trying to make a script work properly by using ALTER DATABASE SET SINGLE_USER statement?

This will allow only one user at a time to access...

Can you provide a real example?

If a hard coded value is not an option, can you convert all possible CASE results to INT?

I am not sure what advantage this would have. What is your business rule or use case that would call for this?

Storing a SOUNDEX is simple and can be...

Good catch Michael!

Try this:

SELECT

CASE WHEN ROUND(18.00,2) = CONVERT(INT,18.00) THEN

CONVERT(INT,18.00)

ELSE

18

END

SELECT

CASE WHEN ROUND(18.01,2) = CONVERT(INT,18.01) THEN

CONVERT(INT,18.01)

ELSE

18.01

END

Note the lack of decimals...

Are you talking about single-user access?

Hadn't thought of that yet. Will probably use your additions to the script just in case.

Thanks!

Wow! That did it! I knew it was simple, but just couldn't wrap my head around it.

Still learning about things like CROSS JOIN and CROSS APPLY!

Thanks a ton...