varchar(255)

Hi,

Now i get

Msg 240, Level 16, State 1, Line 1

Types don't match between the anchor and the recursive part in column "Dim_CostCentre_Desc" of recursive query "HierarchyBuilder_Cte".

Hi I get this error

Msg 205, Level 16, State 1, Line 1

All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their...

SELECT TOP 1000 [Dim_CostCentre_SK]

,[Dim_CostCentre_BK]

,[Dim_CostCentre_ParentBK]

,[Dim_CostCentre_Desc]

FROM [BI_Blueprint_EDW].[dbo].[Dim_CostCentre]

----------------------------------------------------------------------------------

Dim_CostCentre_SKDim_CostCentre_BKDim_CostCentre_ParentBK ...

Cheetah (9/21/2011)

---

Just do another restore with the "Move file" option. Alternatively you can do a restore from any other DB backup, just to get the database back to a usable...

this was the final script fyi

Select a.Name0, b.Operating_System_Name_and0, c.FileVersion, c.filepath

FROM v_GS_SYSTEM AS a

INNER JOIN v_R_System AS b

ON a.ResourceID = b.ResourceID

INNER JOIN v_GS_SoftwareFile as C

ON a.ResourceID = c.ResourceID

...

Hi,

Thanks for all the effort guys.

Apparently the other reason for this was that One machine had different pathes which it had the software installed so where i just looked...

Hi guys this script displays duplicate machine name because it is possible that 1 machine may heve 20 patch levels installed. Now i dont want that, i want to see...

hi,

When you setup a cluster then the node added to the cluster gets recorded somewhere on the registries, so you need to first remove node from cluster and all the...

hi,

i ow get the error

Msg 8985, Level 16, State 1, Line 1

Could not locate file 'wsDatabaseName' for database 'master' in sys.database_files. The file either does not exist, or was dropped.

Hi,

thanks guys, i am indeed trying to shrink databases that are 8500mb BECAUSE i have already checked the sizes and i have about 30 Databases of that size so that...

Do you actually want encryption of the backup or just prevent unauthorised restores?

Both.

Guys what i am actually trying to achieve is to avoid .bak files from being restored elsewhere by someone who got access to the backup file. So column level encryption...

Hi,

i read it too and i am following it each step of the way. Thanks Grant.

Hi Guys,

Thanks for Input. @ Geaorge i do not want to use a script for backups.

I will have a look at Redgate product.

Thanks again guys