When you say you experience problems under heavy load, do you see some type of error message to indicate it's not working? Have you tried slowing down the load test...

Evil Kraig F (11/29/2011)

---

I think you're over-thinking it SQL-Dude.

Think more like this:

CREATE TABLE Bldg (BldgName VARCHAR(20) NOT NULL CONSTRAINT PK_Bldg PRIMARY KEY CLUSTERED)

-- Floor is a SQL Function and keyword

CREATE...

michael.french 172 (11/29/2011)

---

I would model the three location entities with dependant relationships similar to Example #2.

The top two entities are Buildings and Computers as both are entry points to the...

Sean Lange (11/29/2011)

---

Option 2 is by far a better model than option 1 but it still is not quite right. You still have redundant data.

Building in the base. Everything comes...

Evil Kraig F (11/29/2011)

---

I'd personally approach it via the second method, at least for the primary build, but I wouldn't associate room to floor and building, I'd merely associate it...

Yeah that helped, thank you. I can lookup the DMV's thanks!

That was exactly the example I was looking for THANK YOU! I was having a hard time finding an example that shows how to reference the Attribute Name.

I've resolved my issue by following this Microsoft Blog.

http://blogs.msdn.com/b/sqlfts/archive/2009/12/03/did-you-know-that-sql-server-2008-provides-the-ability-to-create-a-custom-dictionary-of-special-terms-to-be-indexed-as-is-i-e-at-t-into-the-ftindex.aspx

One of the root issues is that the word breaker DLL's shipped with 2008 were not the latest version.

I will give this a try and let you know, thanks!

Here is a text file I used as an example with the code that fails upon BULK INSERT.

I tried it with the code that Lowell left and it fails to...

Too bad... I was hoping I was overlooking something obvious. I keep looking at the syntax for "BULK INSERT" and the options in Books Online but nothing is...

Something like this?

CREATE PROCEDURE [dbo].[sp_Myproc]

AS

WHERE 1=2

BEGIN

SELECT convert(NULL AS varchar(850)) AS column1

END

Select....

It should return one row that could be as large as 850 characters.

I tried that way but it didn't like the temp tables in the stored procedure. I tried to copy the text of the procedure and use it as a...

That's not a long term solution since you will want the server to start up normally after all this. Looking at the event logs it had trouble registering the...

Perry Whittle (1/30/2011)

---

vadon97 (1/29/2011)

---

2011-01-28 16:03:58.06 Logon Error: 18461, Severity: 14, State: 1.

2011-01-28 16:03:58.06 Logon Login failed for user...