Congrats Lynn!

I'm so glad you left the dark side and came back to your community!

Now you know how dark is the other side... don't cross the border any more!

Jim Murphy (8/6/2011)

---

Jeff Moden (8/5/2011)

---

Congratulations and I wish you nothing...

WayneS (8/5/2011)

---

Good luck! (I have to admit that I'm somewhat...

I'm officially out.

I'll never, ever be an employee again.

I'll punch my timecard for the last time in 1 minute.

Thanks for the table scripts.

Sample data is not in a readily consumable format (INSERT INTO OneOfYourTables).

We're still missing the expected output based on that sample data.

It's not that I want...

Glad you sorted it out.

Great, thanks.

Can you please provide:

1) Create Table scripts

2) Some sample data

3) Expected results based on your sample data ?

If in doubt, check the article in my signature line "get your two-cent...

Eugene Elutin (8/5/2011)

---

If you are talking about table where you are going to store personal details, then you shouldn't even think creating and validation the person names due to the...

Well, I find Ola's script very easy to use.

However, if he gets stuck, we can alway help, no? 😉

sp_readerrorlog can help you reading the SQL Server log.

More info here.

For what the Windows logs is concerned, you should probably narrow down the scope of the question. Which logs do...

It would have been very helpful to find the root cause, just in case it happened again.

However, glad you sorted it out.

Uh-oh! There's a campaign conflict on this thread...

Good luck for the award, Chris!

Saga... (8/5/2011)

---

I got task to Collate database. within same server.

I used this Query

Alter database DBname collate "collation_name"..

after executing it was showing Executed Successfully.

But there was no result...

Enable auditing of policies on the box and then check the event viewer. That would at least tell you exactly what permission was denied.