I've wanted to achieve the same thing but unfortunately my research lef me to believe this was not possible. File and filegroup backup/restores seem very focused on recovery and...

Don't know if this helps but it's an excellent article on a related subject

http://www.sqlservercentral.com/columnists/mcoles/soundmatchingandaphonetictoolkit.asp

Adam,

I think the suggestion is based upon the idea that within a query execution plan there are times when the query processor must do iterations over resultsets between tables to...

I think this comes down to the type of user and the units of work involved. Let's assume we're talking about physical users (not service end points) in which...

Tim,

I'm working on a project which had a similar problem and I ended up writing my own SSIS custom data source. This consumed the file(s) and spat out a...

Also, just found this which is a series of technet articles covering (in more details, and almost certainly better english) the approaches I touched on

http://www.microsoft.com/technet/security/guidance/identitymanagement/idmanage/P3ASPD_1.mspx?mfr=true

In short yes, it is possible but there are a number of approaches.

1) Use integrated security/windows authentication and add the impersonate="true" switch to the web.config file. You will also...

Andy,

I think this may come down to personal preference and agreed standards. Perhaps a little like the naming convention discussions I'm sure some people will have much stronger views...

We also use files only. It's easier to manage versions etc with your source control product of choice (SourceSafe, Subversion etc).

Robert,

I'm not sure I understand your responses.

Yes, if the check constraint references a linked server and the other server goes down inserts or updates will fail, but surely this is...

Although Robert's correct in that there's no built in way to enforce this there are a couple of workarounds.

1. Create a trigger on the table to be updated which checks...

I'd create a table and use a between join like below

CREATE TABLE Semester

(

SemesterName varchar(50),

StartDate smalldatetime,

EndDate smalldatetime

)

INSERT INTO Semester VALUES ('2006 Winter', '2006-01-01', '2006-02-28 23:59')

INSERT INTO Semester VALUES ('2006 Spring', '2006-03-01',...

I don't think sql:variable is supported in XQuery modify statements. The only way I can get it to work is with dynamic sql as follows. Not exactly pretty...

This might help

http://www32.brinkster.com/srisamp/sqlArticles/article_33.htm

I wouldn't use FLWOR to generate the tabular view as you don't need the iteration capability. You'd be better off using OPENXML similar to the following:

DECLARE @XmlDocument xml,
@DocHandle int,
@ErrorCode...