Changing current database

[LARiot]

Hi,

I'm trying to set the current database to Dev.

Using this:

SET DATABASE TO Dev;

Getting this:

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'DATABASE'.

The code I use is copied from the msdn page exactly as they have save for the database name of course.

Any help is appreciated.

-Nima

 

[gmmastros]

try:

Use Dev

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

Instead of this code use

USE myDatabase

 

[LARiot]

Hey it worked.

Thanks

-Nima