:w00t: Posted Monday, January 21, 2008 2:29 AM

You can create a view like this...

CREATE VIEW VW_XYZ

AS

SELECT COL1, COL2

FROM (VIEW1_DEF) V1 -- SELECT query for View1

INNER JOIN (VIEW2_DEF) V2 -- SELECT query for View2

ON V1.SOMW_ID = V2.SOME_ID

It will...

Carolyn S. White (12/27/2011)

---

I have the opposite problem. I have a user and I want to to be dbo. sqlserver 2008 R2

The user is in the administrator's group in...

SELECT 'Simplicity' as Work_Policy

The only disadvantage with power shell is it’s a new language in its own. It’s new learning curve. 😀

Viewing Information About Backups

http://msdn.microsoft.com/en-us/library/ms188653.aspx

Sean Lange (12/27/2011)

---

Dev (12/27/2011)

---

Sean Lange (12/27/2011)

---

Thanks Roy. I just hope the OP realizes how important it is to not run this in production. The first time I ran...

Sean Lange (12/27/2011)

---

Thanks Roy. I just hope the OP realizes how important it is to not run this in production. The first time I ran this on a production box...

There is connect item on it (or similar). This is what Microsoft suggested on that...

There are three things to check.

First is the capacity of the server, for sql server,...

Add another line in your stored procedure.

SELECT @SourceId, @Table -- Assuming Main Query returns One Row

Loops are equally bad as cursors. You might only save few milliseconds (or microseconds).

It gives me immense pleasure to declare that I am able to capture a very precious moment in SSC 🙂 (enclosed here). I acquired proficiency level ‘Default Port’ today &...

hxkresl (12/27/2011)

---

I think I will answer my own last question. The answer is that usually a sproc would not be used to update multiple tables at one time, however...

LOGON triggers will get triggered at each login attempt. It will not be good for on performance grounds.

Setting up securities on network (firewall) is a good idea. Why don’t you...

The default recovery model is FULL but I (& many prefer) it in Simple recovery model for system databases except Model Database. SQL server use Model database as template for...