HERE YOU GO..

USE test

GO

CREATE VIEW spt_fallback_db AS SELECT * FROM master.DBO.spt_fallback_db

GO

USE test

GO

CREATE VIEW spt_fallback_dev AS SELECT * FROM master.DBO.spt_fallback_dev ...

Yes, I tried that but did not work..

I figured out the issue. I think this is how we can do that.

EXEC Foundation_SMF..sp_executesql N'CREATE VIEW POP_PEERDEF_ALL_SERVICES AS SELECT * FROM Foundation_1002250720.DBO.POP_PEERDEF_ALL_SERVICES'

Thanks for you help.

Hi Carl...

I tried that too before. You cannot create view specify the name of the database as prefix

Here is the error.

'CREATE/ALTER VIEW' does not allow specifying the database name as...

I tried another command EXEC SP_EXECUTESQL @sql and getting following error.

Msg 111, Level 15, State 1, Line 1

'CREATE VIEW' must be the first statement in a query batch.

------------------------------------------

DECLARE...

I think I cannot use GO because varable which I am using will go out of scope.

USE Foundation_SMF

GO

CREATE VIEW POP_PEERDEF_ALL_SERVICES AS SELECT * FROM Foundation_1002250720.DBO.POP_PEERDEF_ALL_SERVICES

GO

USE Foundation_SMF

GO

CREATE VIEW EPI_COSTS_CPT AS SELECT * FROM Foundation_1002250720.DBO.EPI_COSTS_CPT

GO

I added char(13) also but no success..

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'GO'.

Msg 111, Level 15, State 1, Line 2

'CREATE VIEW' must be the first statement...

I tried that but still getting an error..

Acutally, Filegroup restore does not need to kill the user connection. Database can be online while doing file group restore.

When I was doing restore there was no user connected to...

Nope, I am not restoring primary file group. I am taking copy only backup. When I created new test database and took the backup and then restore file group it...

Yes, You are right..Thanks man..

Thanks Jason..

I don't have a control on the creation of Database because it's a 3rd party tool so when database gets created, it will use the default primary filegroup and...

Looks like it is little bit tricky when we move the existing data to the same file group. I did move existing data to different file groups but neve did...

Great.. That's what I want.

Thank you guys.