shuzi (8/18/2009)

---

sorry for the confusion.

Management Studio provided the overall server info, we don't want anyone be able to access it. Some persons just need to know the database structure,...

This is a little simpler and will work with any date range.

select

*,

Days ...

Try this:

start c:\test.bat

Have you considered using developer edition on your development server?

Restore the database from the last full backup using the NORECOVRY option, and then apply the transaction logs to roll forward to the point in time that you want to...

Political problems usually do not have technical solutions, so it sounds like your manager is just postponing a fight that is certain to happen eventually.

Another thing to consider is that the file share server you are backing up to might not be able to handle the IO load.

I have seen cases where the backup...

Robert.Smith (8/10/2009)

---

...The US Patriot Act, for example, left those of us outside the US scrambling to ensure that no private or confidential data was being stored on servers in the...

It seems like a lot to send over the network for a large datacenter; we have enough issues just getting them from disk to tape every day.

I took a quick...

It is 32-bit x86, so use the x86 version of the service pack.

Might as well use sp3, unless you have a reason not to.

How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server

http://msdn.microsoft.com/en-us/library/ms143799.aspx

uciltas (8/4/2009)

---

Yes I have done this before manually from SSMS and then from query window.

I just did it again now.

AWE is checked in SSMS

Here is the result after running your...

Do you have AWE enabled in SQL Server?

What does this show when you run it from a query window?

exec sp_configure 'show advanced options',1

go

reconfigure

go

exec sp_configure 'awe enabled'

The following seems to work OK just using a single derived table.

Create and load test data:

-- Create test table

create table #t

(

PKintnot null identity(1,1) primary key clustered,

field_Abigintnot null,

field_Bbigintnot null

)

--Load random test...

David Korb (8/3/2009)

That's why we need to set up a gatekeeper system like the medical,...