Not sure why the customer did that but the default path for data and log files is under a folder named data in the installation path which can be re-configured...

Yes it is possible. Give the operators execute permission on xp_cmdshell and in the OS level for the account starting the sql server give act as a part of operating...

IS your script bringing out huge amount of data. If  this is possible i too have experienced such a situation with huge amount of data preffered to use QA than...

SQL Server recognizes name changes without any restart but for you since you have log shipping configured you need to check if there are any issues if so you can...

If you are not able to start sql services, then start sql services in single user mode and minimal configuration mode and then shrink the log file for model database.

Can you post us the hardware specifications. Also would like to know if the problem occurs in the server also or only if you use it from remote client.

You have posted in SQL 2005 forums thats why i said to use DB Mail feature. If 2000 you can get a procedure in this site the uses CDO messaging...

Yes you can use select * if you want to select all columns people say that you should specify the column names explicitly so that query optimizer can use the...

Yes even when fill factors are set rightly Reindexing/Reorganization has to be done periodically as fragmentation happens whenever data gets changed/added/removed. IN SQL 2005 ONLINE INDEXING can be done but...

Also can use select serverproperty('servername')

create table spacedetails (name varchar(100),totrows bigint,reserved varchar(30), data varchar(30),index_size varchar(30), unused varchar(30))

insert into spacedetails

exec sp_MSForeachtable @command1 = "sp_spaceused '?'"

select name,totrows, replace(data,'KB','') as 'Data in KB',

replace(Index_Size,'KB','') as 'Index Size in KB' ...

You will get this error if you have windows authentication mode set in your server and try to use sql server login to logon to the server. Change the authentication...

SYSADMIN fixed role will have all and any privileges in the server. Even if you explicitly deny an access to the sysadmin fixed role it doesn't take affect and the...

An user with dbo rights on the database can perform any changes to the database you have to decide it on whether or not to give the permission for a...

Check what is the default database for the user and check if he has permission on that database. I have seen this error when a user has been assigned a...