Hi,

You can check out the actual size of the tempdb using sp_helpdb 'tempdb'. If it is not negative you dont have to worry and tempdb goes on increasing...

Hi,

I think you are having different obdc versions installed on different machines and try to upgrade to the latest version. And I think you can check...

Hi,

Can you execute this sp_configure 'remote admin connections', 1;

And DAC port is assigned dynamically it trys to connect using TCP on port 1434 and it is failing...

Hi Nikhil,

You have to first understand first sp_msforeachdb works. It initially executes for master database and sends the output and goes for next database and executes...

Hi,

You must be having some idea on the time taken for each job to get completed on your server. Suppose if a job executes for 20 mins...

Hi,

In the msdn site they are just setting the file offline not the filegroup. Are you sure you are doing the same.

Thanks

Chandra Mohan N

Hi Steve,

I think permissions are not set correctly for the account you are using for sql server. Whenever you start your machine I think the sql...

Hi,

Can you please check the event viewer and error log and post on this.

Thanks

Chandra Mohan N

Hi,

Yes you can implement clustering in virtual environment. But its not recommended for production environment. I recommend using Microsoft Virtual Server 2005 for implementing clustering. I...

Hi,

I got the solution. I was adding it as a normal disk instead of SCSI disk.

Thanks

Chandra Mohan N

Hi,

Open the registry editor and check out the instance name HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Microsoft Sql Server and try to connect and check out the installed instances. It seems you had...

Hi,

Please check in the event viewer what is the error. I think you can find out what actually might be the reason.

Thanks

Chandra Mohan N

Hi,

If the current one is a default instance. Install another named instance and reboot the server and try to uninstall both using the arpwrapper.exe

Thanks

Chandra Mohan N

Hi,

Try to uninstall the sql server 2005 using arpwrapper.exe located in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap

arpwrapper.exe /Remove

and reboot the system and start installation again.

Thanks

Chandra Mohan N

Check out whether you are able to ping the server from the dos command. If you are unable to ping the remote system from your server then add an entry...