I like to keep an idle SA or SysAdmin session open.

If things seem like they are locking up, try

Select * from master..sysprocesses with (NoLock)

and work out...

Oops! I just remembered...

A known limitation of CREATE LOGIN is that the login name has to be a literal.

Thus, you will have to use dynamic SQL to parametize...

geedeearr (3/10/2008)

---

Hi All,

This should be simple but I seem to be playing with my mental blocks today. In the following Create Procedure I receive an "Incorrect syntax near '@NewPassword" referring...

molecule_kaab (3/10/2008)

---

Thanks, all

Actually I want to keep track for security and navigation

I want the admin can tell who do what transaction and

he can find that it's possible that the...

Loner (2/7/2008)

---

The cleansing routine is done during the ETL process. After the data loaded into the dimension table, it is not guaranteed that no one would delete it....

RonKyle (3/10/2008)

---

I suppose that for some downloads there would be no change to the dimension tables, but I haven't had that experience. There are always new dimension facts to...

As Robert said look at the query plan(s). Specifically, you want to compare the query plans that work to the one that does not work.

Let us know the results,...

Markus2006 (3/10/2008)

---

I'm working on application that uses BCP to copy data between servers and I encountered few problems that maybe someone could help me with.

1. One of the tables that...

glad we could help.

Nice. I will keep this one.

swlakshmi (3/9/2008)

---

thanks. But this query works only to modify one column. I need the query to modify more than one column at a time. Please send me the query to...

Chuck Bevitt (2/7/2008)

---

My question is, when the data warehouse database is implemented in SQL Server 2005, is there any point to adding SQL Server foreign key constraints between the fact...

By far the most important tip on Cursors is: Avoid them as though they were leprosy.

I don't think that you get this capability until SQL 2005.

All of the answers offered are incorrect.

The correct answer is