Here is my SQL
When I run this it creates the Database OK but it can't find the newly created Database to add a table to it.
I can run just the Create Table code later and it works OK.
What do I nedd to do to refresh it
DougP, MCP, A+
Code:
USE master
GO
CREATE DATABASE CADTime
ON
( NAME = CADTime_dat,
FILENAME = 'c:\CADTime.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'CADTime_log',
FILENAME = 'c:\CADTime.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GO
Use CADTime '<<<<<<<<<<<<<< ERROR Here (can't find CADTime)
GO
CREATE TABLE CADTime
(
blah
blah
blah
)
When I run this it creates the Database OK but it can't find the newly created Database to add a table to it.
I can run just the Create Table code later and it works OK.
What do I nedd to do to refresh it
DougP, MCP, A+