GilaMonster (7/23/2013)

---

It doesn't quite work that way. Sure, if the table you don't want restored is on a filegroup and you don't restore that filegroup, then the table's not taking...

I am able to reproduce the issue, and I note that it works if I attempt to bulk load the file from another SQL Server instance.

But what are you trying...

If your database hails from the SQL 2000, you should not be surprised to find procedures with correct settings, as Enterprise Manager in SQL 2000 had it wrong.

Oh, I've also caused an outage by adding a filtered index. But the system I work with a product and we make clear what we support and not. Turned out...

And same database?

sql.lanka (7/22/2013)

---

Thanks for your reply,but if all the data in single file vs splitting data in file groups by portioning which is better ? this is the reason i choose...

Is that the Filetable directory on the same server on a different one?

I would not lose sleep over that unless you really know that SET NUMERIC_ROUNDABORT ON is actually in sway in your organisation. The OFF setting is the default, and I...

Beside the tracing I suggested, things you could try is what happens when you move the SQL 2005 database to an SQL 2012 instance etc. But all that is time-consuming,...

If I understand this correctly, the view definition refers to a table on a third server, and the column you are having problem with comes from that server?

From what you...

So that is often the case in our professional lives: we are asked to produce something, but the person...

Whenever you hear such things turn a deaf ear to it. The only way to...

DECLARE @X XML = '<Movies>

...

To get an ordered output, you need to supply an...

I'm trying to find out all the possible outcomes if i drop and create the index?

If i get that, I can avoid...