Adding secondary file path

• appalaraju_k-596051

  Old Hand

  Points: 383

  More actions

  January 12, 2011 at 1:59 am

  #230283

  Hi,

  I want to apply this changes to my database.can anyone help me!!

  DECLARE @name1 VARCHAR(50)---Instance name

  DECLARE @path VARCHAR(50)----path for temp db

  DECLARE @fileName VARCHAR(256)----File name for destination

  DECLARE @temp varchar(50)

  set @temp='data\'

  DECLARE @ temp1 varchar(100)

  set @temp1='tempdb'

  SET @path ='t:\'

  declare @name char(100)

  set @name= cast(( select SERVERPROPERTY('instancename')) AS char)

  set @filename=@path+@name1+'\'+@temp+@temp1

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  January 13, 2011 at 3:33 am

  #1272906

  What are you trying to do? What are the errors that you get?

  What is your actual question, because I don't see any.

  By the way, there is a space between @ and temp1, causing your code not to build.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  July 17, 2014 at 5:16 am

  #1730200

  broywin (7/17/2014)

  ---

  Long Path tool, will help you for sure. Try it....

  I hope he found his solution 3.5 years ago 😉

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP