This is available with ORACLE why not microsoft give such an kind of feature to us.

How come you will be able to query your server when its not running. You are using a SQL query to find the status of the server its ok if...

Its not always a good idea to limit the memory used by SQL server with the amount of RAM that you have in the server(2GB). Allow SQL to handle memory...

You can script the users and the object level permissions with the generate script option that is availbale default in SQL 2000. This will script all the necessary permissions for...

You want the transfer the object within the network or outside. Whats the size of the file that you want to transfer.

With proper permissions and firewall settings FTP would be ok else think for other solutions.

Permission problem check if you have necessary permissions to the file or the resource you try to access. BTW if xp_cmdshell is not enabled you should be getting an error...

It is possible with specifying other as the delimiter option and the using - as your delimiter.

You have the option RESTORE VERIFYONLY that can validate the backup taken.

Those are from Physical Memory.

Total Server Memory (KB), tells you how much the mssqlserver service is currently using. The second counter, SQLServer: Memory Manager: Target Server Memory (KB)...

cross post. This question has been already answered previously.

Is your sql server instance an named instance? The remote connections error you get is when the remote connections options is not opted in configuration manager.

It was a typo. Read as

Default system schemas can't be altered or modified.

So got the caught. You are using NTLM and this problem occurs hwen usiong NTLM because of HOPPING issue. Better force ans use Kerebros authentication or use sql user id...

SP3a support ends at 10, July 2007 and SP4 at 10, April, 2008. Extended support for these till 2013.