USE [master]
GO

DBCC TraceON (1807)
GO

ALTER DATABASE [DATABASE] ADD FILE 
( NAME = N'TESTING', 
FILENAME = N'J:\TESTING_Archive.ndf' , 
SIZE = 3072000KB , 
FILEGROWTH = 10%) TO FILEGROUP [TestAnother]
GO

Msg 5133, Level 16, State 1, Line 2
Directory lookup for the file "J:\LIFT_Data_Archive.ndf" failed with the operating system error 3(The system cannot find the path specified.).
Msg 5009, Level 16, State 8, Line 2
One or more files listed in the statement could not be found or could not be initialized.

exec master.dbo.xp_cmdshell 'NET USE J: \\DEV223\c$\DataFiles /user:disney\lizaguirre NotTheRealPassword /persistent:yes'


ALTER DATABASE [SandBox] ADD FILE 
( NAME = N'TESTING', 
FILENAME = N'J:\TESTING_Archive.ndf' , 
SIZE = 3072KB , 
FILEGROWTH = 10%)
/*
Msg 5110, Level 16, State 2, Line 1
The file "J:\TESTING_Archive.ndf" is on a network path that is not supported for database files.
Msg 5009, Level 16, State 8, Line 1
One or more files listed in the statement could not be found or could not be initialized.
*/

DBCC TraceON (1807)

ALTER DATABASE [SandBox] ADD FILE 
( NAME = N'TESTING', 
FILENAME = N'J:\TESTING_Archive.ndf' , 
SIZE = 3072KB , 
FILEGROWTH = 10%)
/*
Command(s) completed successfully.
*/

EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO

exec master.dbo.xp_cmdshell 'NET USE.......