Hi Pits,

Im not sure I follow you entirely, but here are some thoughts in general. One, you can replicate across domains without having a trust - you would have to...

John,

One of the things we like to here at SQLServerCentral is close the loop - could you post what you did to fix your replication problem? That way other readers...

I understand you'll be working the 10pm - 6am shift answering questions for our readers who are working late?

Andy

I use the same method Mindy outlines. Have not tried it in Interdev - I'll ask Leon, I know he has explored how Interdev and SourceSafe interact some. Looking through...

Brian,

There is no direct way in TSQL that I know of, you'd have to get the file name and either use xp_cmdshell or file system object to delete it. You...

8060 is all you can fit in a row. After that you have to use text or one of the other BLOB types. If you're exceeding this, you should probably...

Merge replication basically will take care of this for you, might want to explore how it uses identity cols to see if it will work for you. Having a key...

IMO, I dont think the file size matters at all. File groups really just give you a way to cross level your disk IO. In practice I think it makes...

Sorta. You have to use the software provided with the tape drive to get data on tape, it may be possible to use it from a batch file but normally...

I'd suggest trying dbcc checkdb first. If that doesn't help, it maybe that the mdf is corrupt. Try using another copy of it or restoring one from backup, then drop...

Hey Jon,

Here is my first attempt:

alter proc usp_GetSubsetOfOrders @BatchSize int = 10, @BatchesToSkip as int = 0, @OrderBy as varchar(100)='orderdate' as

--9/8/01 Andy Warren

--Alternate method of returning a subset of...

Sure. You just need a batch file that copies all your *.bak files over to the machine that has the tape drive. You could configure it to run as a...

I am currently running SP1 with no issues. I doubt that applying it will fix this particular problem, but you should plan (and test) to apply it.

Andy

Could you post what you've come up with so far?

Andy

Aliasing can be done several ways. Using the Server Network utility (or the client one as appropriate), entries in WINS or DNS. Probably you should use the first one.

I've run...