USE inside a stored proc

• rajesha

  SSC-Addicted

  Points: 412

  More actions

  March 28, 2003 at 1:46 am

  #175339

  How can i use the USE inside a stored proc.

  i want to change the dbname using the use command inside a sp.how can do that

  exec 'USE'+@dbnname()

  is not working can anyone help me...

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  March 28, 2003 at 2:02 am

  #452434

  You should be able to use

  @DBName + '.dbo.Table'

  Crispin

  Why don't you try practicing random acts of intelligence and senseless acts of self-control?

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!