Use this Code

EXEC sp_changeobjectowner 'tablename', 'user or role'

Note:

Use sp_changeobjectowner to change the owner of an object if the security account that owns the object has to be dropped but the...

No Ritesh it is not possible. Vice-Versa is possible!

Hi,

Try this Management Studio --> Server Objects --> Linked Servers --> Double click Linked Server Name --> Catalogs --> Click any database --> Tables

Are...

Hi,

Are you able to expand linked servers in Management Studio and list the Tables?

To whom are trying to say? 😀

So of all the Maths posted here 150 GB Seems to be the highest... This sounds like a good value... Whether it will be OLTP or OLAP?

Friends,

I was curious in getting the world's larget SQL Server implementations and after googling there is detail about only one...

Implemented by : Microsoft & Unisys

Instance...

You can do that...

Try to backup to a dedicated volume only for backup which does not hosts Data files or tempdb...

Use options available in backup command to increase...

Hi,

Make MS-DTC to run with "NT Authority\NetworkService" in both the source and destination servers.

Please refer to solution 2 and 3...

Sam,

As said above, DB Id 6 refers to User database. You can check this url for details on latch wait types.

Here goes explanation for...

You can use this command and built some alerts

DBCC SQLPERF(LOGSPACE)

Any body having similar kind of videos which will gives an idea about Scale-out can share here or that forum... It will be useful.

One big thing to note is that architecture matters. SQL Server isn't enough (nor Oracle, nor more hardware, etc.) Think scale out early, even if you don't do it, consider...

So Steve is tracking MySpace Closely? Welcome back after holiday!

Michael,

260 new users/day is current registration scenario. Any site will have bulk registrations only when site...

You are right! Only by experimenting one can proove capacity. People are under estimating SQL because it is not experimented in this kind'a large scale implementations.

May be Microsoft need to...