This tag is specifically for the 2000 version of Microsoft SQL Server

learn more… | top users | synonyms

-3
votes
2answers
332 views

Restore single page of a database - syntax error

I'm trying to run this query RESTORE DATABASE dbname PAGE = '1:442' FROM DISK = 'C:\dbname.bak' WITH NORECOVERY but getting the error: Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ...
-4
votes
1answer
2k views

Can I create a view against a table on another instance? [closed]

I need to query a table from another SQL Server on a different server but same domain, but I am not sure how I will be able to do it. I tried the solution in this answer but it doesn't work for me as ...