Its a good question. I have just asked the same question regarding the data type changing at any point and I am waiting for an answer. This is a new...

Can anybody tell me why when in ssms and looking at the properties of the datafiles using the GUI it shows the old filename and not the one from the...

however....

i just found this query from Gail Shaw

SELECT DB_NAME(database_id) AS DatabaseName, name AS LogicalFileName, physical_name AS PhysicalFileName

FROM sys.master_files AS mf

and that reveals the correct physical files.

I'm slightly confused here...

it returns the old file paths - not the new one !

yes Im definetely looking at the Physical file name and not the logical one. I have noticed that the logical file names are the same on both the Widgets_copy and...

Thanks very much. For some reason where I work they are saying that in the past backups have broken things...not sure what they have been doing historically.

Thanks for confirmation though.

I think I have now fixed this. I right clicked in the control flow, selected 'variables' and changed the values in there. Now the connection manager opens up with the...

Ok Not sure if i'm doing this right. I created a new Project, then right clicked it, selected 'Add' - 'Existing Package'.

The package opens up with some errors and warnings,...

No. I just copied the file from my email to my desktop and opened it from there by selecting Open/File....

Is this not the way to do things ?

yeah I have made a note of that comment from Gail and tried something different.

I found this approach to be quite helpful

http://www.sqlservercentral.com/articles/Administration/2582/

good script..thanks very much 🙂

yes it is being executed from a job and the config file is set on the 'Configurations' tab - the same as it is on the other servers.

just in case anybody has the same issue.......rebooting allows sql server to 'see' the new cpu even though the link in my original post says a reboot is not needed....

Hi thanks for all the replies.

I was trawling through the internet and found something the same as the last post.

When I right click in control flow area and select 'Package...

So when I click on the properties of the job, then click on the Steps menu I see the Job step list.

There is 1 step in here. When i click...