Sean Lange (9/24/2012)

---

Are you trying to audit when a given sourcefile was used to update a specific server? The way you have this coded you can only ever update a...

Yes, thanks for the article Paul.

Is there actually an easy way to check the output from DBCC CHECKDB?

I currently scan the SQL log using xp_readerrorlog for the DBCC output info,...

Hi Paul,

Been working on a similar script myself - I use RESTORE FILELISTONLY to get the...

No problem!

Editing the css files is fine, but I don't think the web pages themselves are so editable.

Wouldn't the report name still be the same for each run though?

Not exactly what...

I don't think you can modify RS in that way. The report name's visible on the page anyway?

Use DBCC SHRINKFILE with the EMPTYFILE option to move all data out, then use ALTER DATABASE to delete the file.

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

GSquared (9/14/2012)

---

Gazareth (9/14/2012)

---

They are equivalent, but I don't think you can mix the two types of join in the same query.

It's the where clause that's causing the difference in the...

SQL Kiwi (9/14/2012)

---

The comma form parses correctly if you list Worker second:

Select M.name, F.name, B.name

From Role F, Worker M

LEFT JOIN Worker B ON M.superiour=B.nr

Where M.Role = code

It might be a...

GSquared (9/14/2012)

---

Interesting. Under most circumstances, the two are semantically and functionally equivalent. But in this case, it can't parse the query correctly. I get a "Can't bind...

They are equivalent, but I don't think you can mix the two types of join in the same query.

It's the where clause that's causing the difference in the results, not...

It does equal 6! At least, that's my excuse.

Mac1986 (8/30/2012)

---

If I copy the backup file on to the local machine , I can restore it successfully. But that now how our jobs are designed. This restoration is one...

Like the idea Luis. Far as I can tell, it assumes the newly generated Id's are sequential?

You can also create linked reports from one master report that you deploy once to the report server.

Although, you're quite restricted on what you can do with default parameters this...