Hi,

As you increase the amount of SQL Server memory, ensure that there is sufficient disk space to grow the operating system’s virtual memory support file (Pagefile.sys) to accommodate additional...

Thank you alzdba for this great help

Hi,

Have you changed the Boot.ini file to make sure that it uses the available memory

Hi

Did you try to create partitioned views. It will automatically do the direction

Cheers

Thanks David for that info.

Did you explore the possible reasons

1. You are not using Local systems account on any server

2. You have a trust relationship properly established

Hi Chris,

Thanks for the update

Hi,

It's part of Hardware details ask your vendor about it. Try to find it from regeistry

Hi,

You need to revoke the permission for all objects except the one you want him to see. With what kind of login is he connecting via EM. 

Hi,

You can also disconnect any users who have open connections to the server by using the ROLLBACK IMMEDIATE command. You can't use Enterprise Manager with this command; you must use...

Hi,

What is the account with which SQL server(MSSQLSERVER ) is running. MSSQLSERVER must be running with a windows account which has got sufficient rights on the destination server. 

Use

exec master.dbo.xp_cmdshell...

Hi,

Have you set 

DBCC traceon(7300)

to get some trace info from SQL Server. It may produce some useful results, showing u at least one property that you did not set or provide. ...

Hi,

ALTER TABLE Test_tbl ALTER COLUMN Name

            varchar(50) NOT NULL

will take the default collation

I don't think so. Because the status field in the sysdatabase field will be set when we specify this option. BOL says

Hi,

Did you try using derived tables

select B.BotName

From

(SELECT BotName, COUNT(BotName) AS N

FROM   dbo.SiteHits

GROUP BY BotName) as A Cross join

(SELECT BotName,...