No worries, it happens at times.

I like to use the script by Narayana Vyas Kondreddi to copy database...

SQL-KV (5/7/2009)

---

Dear Experts,

Iam facing issues on server memory utilization and many other.

If i check the activity monitor i can see many number of users (ex:80 user processes) in sleeping...

I wrote an article on using the Blocked Process Report on here last year that you might take a look at if you are on SQL 2005/2008.

http://www.sqlservercentral.com/articles/Blocking/64474/

It will capture blocking...

Microsoft provides some stored procedure to do this in a scripted operation that can be found on the following link:

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=TransferLogins

a good primer on how to do this using SSIS is...

Bob Hovious (5/11/2009)

---

Thanks, Steve.

I agree, Roy.

You are an unbeliever, Johnathan?

Glad to see you're thinking ahead, Alvin.

Hey Lynn, do you think we'll make 5K this month?

P.S. ...

PaulB (5/11/2009)

---

Your statement contradicts what Microsoft documentation,...

There is no doubt that separating your logs and data files is a best practice. However, if you want to know if you are having bottlenecking/performance issues from not...

I can't believe that this thread is still around and kicking.

I don't usually resurrect old threads like this, but I happened on this one while doing some other research, and thought I'd comment.

In SQL 2008, you can query the asynchronous_file...

PaulB (5/7/2009)

---

My fault, I'm sorry.

I was relying on my experience on previous SS versions; looks like SS2K5...

I was somewhat taken aback by this as well. It certainly isn't how I would have expected this to work, especially since in SQL 2000 it worked the way...

The login has to be the database owner, not just a member of the db_owner role, but the actual database owner for the database to show up in the object...

One thing I don't see listed here is that VIEW ANY DATABASE is granted to the public role by default when you install SQL Server, so you would have to...

mrlucmorin (5/5/2009)

---

Jonathan,

The use case is quite simple.

When a row is inserted/updated/deleted to the OrderDetails table, if any of the row refers to an Item that is defined as a Kit,...

If you can post your specific problem in detail here, I would bet that we can probably offer you some suggestions as to the best fit solution to your problem.