If you just used copy/paste on what Raghavender posted, then you told the SQLCmd tool to execute a single query (listing all data from one of the AdventureWorks tables) and...

You can use EXEC sp_changedbowner to change the ownership.

(In fact, that is probably exactly what the SSMS UI does when you click those buttons).

First, be careful with the UI options in Management Studio. Some of the dialogs that pretend to select from a view actually read the underlying definition and then connect straight...

No, there is not.

Or do I need to do...

To give a user generic rights in a database, the easiest solution is to add them to a fixed database role. E.g. database_reader can read all tables, database_writer can modify...

Consider...

Not tested but I guess this would work:

1. Add the user to the model database. New databases are created as a copy of model so I expect the user to...

Yes, you are right. I did not think about XML.

If you need to return data in unpredicatable and ever changing form, then XML is a good tool. But remember that...

Hi Lee,

Based on the plans you posted and the query text (thanks for catching my mistake with the update / union clash!), I can see the following:

Based on the available...

I am sorry to hear that the CLR aggregate does not support the newer windowing extensions. But you are right that this invalidates the idead and that it makes no...

sandesh_krishnan (1/5/2016)

---

More details .....

I have a T-SQL query provided by users of our data, which goes after multiple tables and generates an output. There are multiple queries similar to...

Lowell (1/4/2016)

---

Can you modify the procedure, since you cannot use openquery?

sounds like a one procedure to rule them all situation, not the best way to do things.

I would modify the...

The best way to troubleshoot dynamic SQL is to add PRINT @SQLString just before the EXEC or sp_executesql statement. That way you can look at the SQL that was submitted,...

As Scott mentions, an OR in a query makes it almost impossible to get a seek. But a rewrite can help you get two seeks instead of one scan -...

When you restart the services, Tempdb is dropped and created fresh, based on its default settings. Have you verified the size of tempdb immediately after the restart? If it was...