r.hensbergen (3/23/2009)

---

I like these questions a lot more than making 'SQL puzzles', just by showing bad code. Your question is a typical sample of what I run into daily. Every...

bvaljalo (2/20/2009)

---

Your solution is exactly along the lines of what I was thinking was likely necessary to pull off what you're trying to do.

To be totally honest, I'm kinda thinking...

Yah... that's where I am now... using a cursor to fetch the first and last names from one table.. build dynamic sql to create the containstable function dumping the results...

We're not losing data doing this.

If the database is in a transactionally inconsistent state, sql won't attach it and we retrieve the logs as necessary. Out of the last...

Because that's what I was told to make happen. When I had to move 4000 databases, it worked great... this time I have less time to move about 200...

That's great, unless you want to recreate the log.

CREATE DATABASE [name] ON (FILENAME = [path to mdf]) LOG ON (FILENAME = [path to ldf]) FOR ATTACH REBUILD LOG

will give an...

Hoping somebody has an idea... I've been watching process monitor and there's not even an attempt to access the UNC that I can see in it... so something is irking...

HanShi (1/8/2009)

---

From the word ASSUMES I conclude that it is possible to use different collations on the server instances. Okay, the results will vary between the server instances, but that...

Again... the reason I did what I did was I couldn't come up with a way to run

DBCC CHECKPRIMARYFILE (N''' + @filename + ''',2)

Which gets the actual name of the...

I dunno if this qualifies as a weird case where you need a cursor or not.

Certainly if this could be done as one big set based query, I'd go for...

Yah that's pretty much what I did...

Put this in the maint plan before the tlog and differentials...

declare @cmd nvarchar(max)

declare @dbs sysname

declare csr_nobackup cursor for

select

a.[name]

from sys.databases...

I'd also like to point out that the link to BOL has this... which means there may be more than just the four...

That...

Depends on what part of it you...

MarkusB (12/15/2008)

---

Personally I would say all four answers are correct because you have the FORCEPLAN option which essentially is a query optimizer hint.

Even BOL talks about a query optimizer...

I also noticed this is not forward carrying and is only for one version of SQL 2000 CE...

This workaround applies only to the current release of SQL Server CE and...