I guess it's the always thinking and always curious human nature that is the driving factor behind this. If you say that something is not supposed to be done, the...

Hardy21 (9/14/2010)

---

If any service is connecting to your database on timely manner than stop that service. Because your database is currently in Single user mode, if that service is connecting...

Interesting take on social networking, Steve. I personally don't use any social networking features (except participating in forums on sites like Microsoft community pages, BeyondRelational, SQLAuthority, SQLAloha and SSC :)...

Rahul, please follow the entire discussion from page# 1, and I am sure you will...

SKYBVI (9/14/2010)

---

@ nakul

What do you mean by all users or some?

I just see the sql server logs and I find this error happeneing every minute

I also checked the aliases on...

I am leaning more on the human error phenomenon.

The first question is whether this is happening to only a few users or to all requests being handled by the production...

In my opinion, the sa account's password must be as complex as possible - and as less used as possible. For non-emergency work, the DBA's Windows login must be added...

The trigger is on the table specified after the...

Hello!

Thanks for the quick response.

By any chance are there any READ-ONLY filegroups in the database?

http://support.microsoft.com/kb/934713

Completely generic - no CAST/CONVERTS...

DECLARE @MyTable TABLE (MyNumericVal VARCHAR(100))

INSERT INTO @MyTable VALUES ('50.10-'),

...

Hello!

The first things I would check for are:

1. During the restore, are the DB files being created on disk? (i.e. monitor the folder where you are restoring and see if...

da-zero (9/14/2010)

---

Nice question about the transaction basics. As I'm reading the self-paced training kit for the database developper certification, this was a really easy one for me, as it is...

Hello!

The goal of this question was to have a deeper understanding of how SQL Server behaves, and not making the questions harder. Emphasis is therefore on the fact that if...

Hello!

Thank-you all for your kind comments and feedback.

I am sorry that a few of you did have some trouble trying to get the code running on your servers. I...

Robert, I believe the key is to treat the groups individually. Therefore, when Group 1 from "a" is being evaluated...