Hi I came across this while searching on google, we are looking into automating an inventory of our ever changing environment.

The SSIS package and Powershell script. Where are these attached....

Thanks Gail, will do 🙂

Hi David thanks for this awesome tool,do you have any updates for this tool or planning any perhaps?

thanks for the info Simon 😉

Thanks 😀

Hi David, awesome update!

I don't see the final .zip attached on the article though :hehe:

Thanks Grant, that is what I got as well, thought I was missing something but thats for confirming my findings 😀

+1 Grant

right click (on your local SSMS), run as a different user (domain account)

In Case someone needs info ...

Moving SQL_TEST datafile from 'E:\MSSQLData\SQL_TEST.ndf' to 'K:\MSSQLData\SQL_TEST.ndf'

USE master;

GO

ALTER DATABASE SQL_TEST SET OFFLINE;

GO

ALTER DATABASE SQL_TEST

MODIFY FILE (NAME = SQL_TEST, FILENAME = 'K:\MSSQLData\SQL_TEST.ndf');

GO

--Move the file to...

Thanks for advice , will try to avoid this but will test on a DEV DUMP db I have. Fortunately this was on QA and not PROD ... :hehe:

Hi guys thanks for the prompt response but I didn't explain clearly what happened ...

My bad ...

The storage engineer stopped the SQL service ...

created the new LUN ...

he physically moved...

lol too many :hehe:

I think the OP should maybe shed some more light to get rid of these assumptions

Using the DOB to verify the century is an option

an update

After investigating MS SQL 2005 tools was installed on the server. It ‘looks’ like MS SQL 2005 was installed on this server and then removed but the tools stayed...

transactional replication is also an option if the Server B database is only for reporting purposes

well then you got a starting point ...

Run a SQL trace (not for hours just for those specific problimatic queries) and get the Dev's to execute all or some the...