We definitely can't test the scripts. Barely enough time to get the editorials, QODs, etc. Even if we did test them, we wouldn't be able to test them exhaustively.

We are...

No moderators on the site. The volume was too heavy to let someone be responsible for looking at them.

That is a good idea...

Yelena,

A truncation actually does free up space inside the log file to be used again. It does not free up space on the drive.

Jeff that is cool and I'm glad to be back.

And I'm not that thrilled with the tractor or mower as a "gadget". They're more tools, requiring me to do work....

Actually while he's the person that's doing well at Sun, I think he's the type of person that Microsoft needs. I'm not sure Steve Ballmer is that person and with...

What happens? check the Windows and SQL logs when it fails.

This:

create table MyTable (roomtype varchar(4), amenity int)

go

insert MyTable select 'R001', 1

insert MyTable select 'R001', 2

insert MyTable select 'R001', 3

insert MyTable select 'R002', 1

insert MyTable select 'R002', 2

insert MyTable select 'R002',...

What does the job do? What does datapump task 1 do?

Shrinking is bad.

Paul Randal, PM for the storage engine, says you should never shrink the data file unless you think you'll NEVER need the space.

http://blogs.msdn.com/sqlserverstorageengine/archive/2007/03/28/turn-auto-shrink-off.aspx

I found this: http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-11/0296.html

A good way around this is to run it as a job, like every few minutes or whenever, and then store the results in a a...

Definitely some type of network problem, but why use IP address? You should use an internal or even external FQDN, DNS name for the server. It will give you more...

What's being copied out is the query you run, so just run that in Query Analyzer to see what's going out. As for in, it's the source. If you're not...

Forums are up. If you've got Vista, issues, maybe you can post them there.

None of the answers is valid. Profiler works on SSRS just like any other query.

Good points Rick and I definitely picked a place where you could have issues. A third location doesn't help if the primary goes offline from both for some reason. It...