Sure... here are some screenshots with descriptions

I dug a little deeper and found that if the body width is 6.8" there are no extra pages in PDF / print layout....

Thanks Craig,

I'm a bit new to dimensional modeling and misunderstood a best practice. Rather than using views as source for dims and fact tables... use views of dims and...

Thanks Gail... for lifting my head above the weeds. I was totally ignoring disparate data types in my CASE. I modified both the view and the CASE in...

Was it worth it?

Just curious... was this some sort of challenge? Perhaps an assignment?

Not sure your goal was a repeatable, functional, efficient query, eh?

Assuming your query is returning only the two records you note, the CSV file is accurate.

Each record in your CSV is going to be separated by a carriage return....

Couple things...

1. What are you expecting as output? and

2. Can you post the query?

You could also exclude any records in your WHERE clause...

WHERE...

AND rm.room_desc IS NOT NULL

This would likely miss some records you would like to see, so getting rid of the...

Aha... great point re. version of client tools.

Here's one for ya... I applied a hotfix to my My SP2 server to fix an SSRS issue which brought the version to...

In my case the MP backup runs successfully; however, the SQL Agent job notes the error... Execute method on the task returned error code 0x80131904...

In many cases the Maintenance Plans...

Well, I looked through stored procs of interest to no avail.

My next step is to set up a server side trace during the time when the errors are...

Thanks... I was just searching for a way to search through all my stored procs. I will look and get back to this post.

Nick

Hmm... I'll check for third party tools, thanks.

Here is the full error from the log:

BackupMedium::ReportIoError: write failure on backup device '\\servernameremoved\sql bacups\BEACH\Amazon_backup.bak'. Operating system error 112(There is not enough space...

I believe you can "hard code" this in the Chart Properties.

Select the Chart...

1. Chart Properties

2. Data TAB

3. Select each data value

4. Edit

5. Appearance TAB

6. Series Style (button)

7. Fill TAB

8. choose...

Thanks Perry... should've trusted my instincts earlier.

Reformatted as NTFS and all is well.

Thanks again,

Nick

So in response to "Can I copy the backup file to the USB drive"

The answer is no. Windows throws an error "Cannot copy file xxxx: The Parameter...