Do the variable declare outside the cursor..

CEWII

Directly from WIKI:

http://en.wikipedia.org/wiki/RAID

[edit] Operating system based ("software RAID")

Software implementations are now provided by many operating systems. A software layer sits above the (generally block-based) disk device drivers and provides an...

I want to make an additional point as well. This user has already shown that they can't be trusted even with a single connection, so another poster had a...

You could do it with a LOGON trigger, but you would need to be very careful..

You could set the trigger to look at all connections and only allow one connection...

streinm2 (5/12/2010)

---

So.... something like this?

declare @updatestatment =

N'UPDATE Unit_SRC_PopSupplies SET Supply_Type_Key = @supKey

...

As a good practice ALL objects should be qualified by owner. This helps with compilations as well as executions. The DB engine doesn't have to think about who...

Picking out a particular job in profiler may be difficult.

You said you couldn't find that job's run information in history. That indicates 2 possible issues to me,...

I don't have my scripts right now but I usually use two. The first is a truncate script that simply executes a: TRUNCATE TABLE tablename

against all tables, that takes...

After quick look at that site it seems that it collects data from other sites and aggregates it.. Not sure though..

CEWII

Changing the SA password will help find those things..

In my environment we set the SA password to some value that is generated randomly and never displayed, so no one knows...

You'll have to do it with dynamic SQL, I don't believe there is deferred named resolution for scripts.

CEWII

I don't have a link but I think you might find something in WIKIPEDIA. Also, the biggest one off the top of my head is performance, hardware RAID provides...

I see you deleted and recreated, good, that was going to be a suggestion of mine.

I had another thought, is there activity on any of the downstream tasks,...

My guess is that IF it is an error then it is an "edge case", where a very specific set of events have to take place and if ANY of...

What comes to mind is that each tool has its strong points.. You can just select a tablename from a list BUT you take a performance hit to do...