Schedule *transaction log* backups and you'll be fine.

If it's 2005, EXECUTE AS, or (and in 2000) you could schedule it, and it'll run as the Agent.

No, SOX is not technology related - it's process related. You need to interpret the Act into a requirement for an application. Then you need to figure out...

/3GB PAE and AWE are all 32-bit architecture workarounds.

64-bit architecture will address upto 1024GB without fiddling about.

You've put a variable in line 3, where you want a column name.

Before further advising, this looks like a bad way to do things. Can you explain the logic and detail of what you're trying to achieve?

I think it's safe to assume this won't be a production environment

You could multiboot, but it's a serious pain, a better solution would...

Hi,

Basically the above is an example to show the idea of CTE's;

It shows simply how to refer to a nested query through a CTE.

Even simpler would be to say;

WITH cte_alias...

Right, first off forget AWE and PAE - you only have 4GB memory. These features are to support memory beyond 4GB, remove any configuration settings you have for these features.

The...

How are your nodes connected, and how far apart are they?

You have enabled RDC connections. I would think you want to enable connections to SQL over TCP/IP.

Open SQL Server Configuration Manager > Network Configuration > Protocols > Right click...

Results are starting to show in the History section of my Vue profile.

No I dont, but if I were doing it I wouldn't try to do it that way in any case.

If the data isn't available any other way, I would seperate...

Use Insight Manager - comes with all HP servers.

1 named

2 no

3 yes