By default, SQL Server Express edition does not allow remote connections.

Look at the SQL Server Configuration Manager to turn on TCP/IP. And make sure the corresponding ports are open...

Believe it or not, a company I used to work for used Comic Sans as their official document template font...

Sorry for the topic hijack 🙂

These days the resume/CV is mostly being passed around as softcopy, so I use Arial as the lowest common denominator to preserve formatting.

royce.bacon (12/22/2010)

---

You can save quite a bit of space even without R2 compression. Set the folder where you backups are going as compressed. Then any file put in...

Yes, it is. For example:

SELECT DISTINCT

w.Client_Contacts,

COUNT(w.ApplNbr) AS "Application_Count"

FROM (

SELECT ApplNbr,

...

I have encountered this exact problem and have solved it.

This issue occurs if you create and edit a maintenance plan when connected as SA or any other SQL Server login.

You'll...

I have just finished retrying the procedure while running a trace as per Rick's recommendations.

The profiler did not pick up any Exceptions or User Error Messages at the...

Thank you all for your suggestions.

I have patched that instance of SQL 2005 to 9.0.4266 (post-SP3 CU6)

I will try that stored procedure again on Monday and carry out another profiler...

Thanks for the link, I see that the hotfix is for SP2.

The instance is at SP3 (9.0.4035). I'll check for any post-SP3 hotfixese in the same vein...

Thanks for the tip.

The stored procedure failed somewhere within this loop (it exists to help batch the update)

create table #scroll (row int identity(1,1), product_key int, store_key int, date_key datetime, max_transaction_key...

FYI in SQL 2005, you get the following tabs after right clicking and opening the Report Properties dialog:

General

Layout

Code

References

Data Output

But no Page Setup.

Under Layout tab you can change the...

This is my rough code that sort each character of the string. I'm sure there are many ways that it can be improved. You can encapsulate it into...

Jeff, your article pretty much states why I consider pivoting at the SQL level the "hard" way - in the sense that this should be ideally be done in the...

Since you have done the pivot the hard way, here's the equivalent to unpivot...

insert into Customer (customerName, product, qty)

select customer, 'Chair', ChairQty from Target

union select customer, 'Table', TableQty from...

The second "1" is just a constant. For example, if you do the following:

SELECT 1 FROM SaleOrderDetails

Then it will just return a single column with 1 in it, the...