You're welcome.

Hope you get it to work.

It really depends on what you are planning to do with this database and how the storage is.

My typical settings are something like this.

MDF Initial Size = 100

LDF Initial Size...

This piece of the stack trace is self-explaining:

System.Net.Sockets.SocketException: No such host is known at

System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)

It says host unknown.

I see at least three problems in you code:

1. Your trigger assumes only one record was modified. It's not guaranteed to be so.

2. You use the NOLOCK hint, that could...

It depends on the licensing model you choose to implement.

You can go Server + CAL or per processor.

Last EE we bought (1 processor license) was around € 42.000

Short answer: yes, just type

CREATE PROCEDURE someProcedure AS

BEGIN

your code here

END

Long answer: I suppose you already have tried this and you have issues, so, go on...

This usually happens when your transcations escalate from local to distributed and you don't have XACT_ABORT set to ON.

Have you checked that?

Looks like a network problem. Is the SQLAgent machine the same as SSAS?

Duplicate post, removed.

I see something on the "description" field, but it doesn't get displayed in the thread view. It gets truncated on the forum view, but I see the first few words...

Have you tried opening that UNC path from the database server?

I don't see that working: "\\serverip\h:" should be something like "\\serverip\h$". Even better, it should be a different share from...

Horrible match. Looks like the "world champions" have disappeared.

Just a few notes:

1. Killen should be named...

Yes, it's no problem.

You can use the SQL Express SSMS to connect to any edition.

Formatting and indenting is fundamental.

Using a formatting tool can help a whole team sharing the same formatting standards, which is something that makes the effort even more meaningful and...

GilaMonster (6/18/2010)

---

Lynn Pettis (6/17/2010)

---

Don't you love it when some one PM's you for help? Just deciding if I should help, post it for others as well, or just ignore...