In other words 'Guru'

???

Are you sure on this?

Extending the examples from BOL

IF OBJECT_ID('get_sales_for_title') IS NOT NULL

DROP PROCEDURE get_sales_for_title

GO

CREATE PROCEDURE get_sales_for_title

@title varchar(80), -- This is the input parameter.

@ytd_sales int OUTPUT, -- This...

Can you post your code along with the *error* you get and what the result should look like?

That was also my thought that the trigger wouldn't compile at all because of this typo(?)

Never mind

Okay

Create a new exe-project in VB with a DriveListBox, DirListBox,FileListBox and an Image control

Add the following code

Private Sub Dir1_Change()

File1.Path = Dir1.Path

End Sub

---

Private Sub...

Would this work?

USE Northwind

GO

CREATE PROC proc_test

@Region varchar(30) = NULL

, @City varchar(30) = NULL

AS

SELECT

CustomerID

, CompanyName

, ContactName

, ContactTitle

, Address

, City

, Region

, PostalCode

, Country

, Phone

, Fax

FROM Customers

WHERE...

Good point Chris.

I bet they have sold Standard Edition to my company with the promise that it is ready for clustering. Fools are...

I don't think I yet qualify for grasshopper.

What would you suggest instead?

I know you can "edit" your post. Noel, can you try to "delete" 2 of the 3 posts? or maybe at least edit them to loose thier contents?

Not only can...

I forgot, when scaling out I would start with an own filegroup on a separate disk for that table.

I would start at the very basic with reviewing the table design. You can't get good performace on a poorly designed table. Next would be the indexes (especially the clustered...

Being acquired by Oracle is not necessarily a good thing. And successfully is not equal to good.

But who am I to judge on this?

Sorry Rob, I didn't mean you, but rather put it in here as a general remark. I admit my remark was ambiguous.

No way that I know of.

At least I can't find my favorites in the registry or some file in the BOL directory.

But I would love to be mistaken on...