Duplicate Post.

All replies here: http://www.sqlservercentral.com/Forums/Topic1032840-1292-1.aspx

Abdul Walele (12/9/2010)

---

I have created several databases in an instance in SQLServer 2008. I want to change the dbowner to 'dbo' instead of myself. How do I do it? What...

sqlrocks79 (12/8/2010)

---

Hi

Could anyone please provide me a script (not stored procedure) for finding the avg index fragmentation for all the user databases in an instance ? Actually I...

Ask the sysadmin to provide you account with sufficient permissions to make backups/select.

Pinal Dave has a great tutorial on Table Partitioning...

http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table/

Initial thoughts would be, you dont have access, but please could you provide more information?

do you have sufficient access, what type etc...

Congratulations, I'm writing 13th Dec....

Hold thumbs.

Hi guys, could we get some comments on the today's QOTD please?

Need some more senior input.

I beg to differ.

Yes, ok, you cant by default right click and select Create (although there is a very nifty add in available to do this).

But what about creating a...

Speak to you windows server admins, they can create a DNS forwarding...

pradeepniitdln (11/16/2010)

---

plz give me good suggestion for create a databse design for social networking site like orkut.. howmuch the table, what's type of relationship beetween tables....

I...

Same here, no issues so far.

KcV (11/16/2010)

---

Hi all,

can anybody say that

how can i use IN and LIKE both togather in same query and same field ?

select * from pe where yno in like (

'%85452-1',

'%29212-2',

'%61954-1',

'%34483-2')

above...

There are so many hints, and would take up pages.

All hints are not always applicable...

GilaMonster (11/11/2010)

---

Not expected to work. Has...