sure: here's the same databases as a new backup, but placed on a disk with sector sizes of 512:

hope this helps!

CodeTestDBs-512.zip

this is a view that I create to show me all the extended properties:

CREATE VIEW VW_CURRENT_EXTENDED_PROPERTIES

AS

SELECT

'' AS...

easy peasy!

The error could be on my side, or maybe something is different on my backups that you should double check against.

!edit!

something i was thinking: my 2008/2008R2/2012 backups are...

tried your code, and it doesn't work on all situations;

it found SQL2005 as version 611 just fine, but only that for me.

For others(i have all on my dev machine), it...

if the view "dbo.myview" references any objects in another database, a linked server or a schema different than dbo, then that's breaking the cross database chain.

you said it was referencing...

you could also consider a server side trace, with a filter on the HOSTNAME property to match the machine you want to watch

the problem with that is it's possible to...

SSIS has a Transfer logins Task as...

Microsoft provides a downloadable query named...

inside a cursor, that's normal; what you want to do instead of print is raise a low level error inside via RAISERROR the cursor so you can see things...

you could place GO statements between each command, but you still have to manually ignore the errors...makes it hard to determine which are "ignorable" errors and which are real.

instead, consider...

gary.p.heath (3/6/2013)

---

I am trying my best to get my head around SQL Server but seem to be going around in circles. Everything I google is either way too complicated for...

excel automatically treats anything that looks like a number as a number, dates as dates, etc

I believe you'd have to change you report of the data to explicitly place a...

grab it again; i edited it and retested it on my machine, it seems to work now.

this is what i would use to review the trace:

--SELECT * from sys.traces

declare @TraceIDToReview...

as far as i know, you cannot alter a user defined type.

you have to remove references to it, drop it, recreate it with a new definition, and then re-establish the...

there's a couple of ways to tackle this, but it depends on what the focus is:

if you want to absolutely prevent the login from UPDATE, you'd create a group,...