Microsoft SQL Server Administration

Hi, everybody I've tried to connect to localhost\BAND in order to created database with sql server management. I looked for the solutions to the problem, but none of them seems to work. I allowed tcp/ip, canged the startup ...

Hi, I am trying to get the Index Usage Statistics report for a database in SQL2005 SP1 ENT (x64).  The SQL instance is on a MSCS cluster.  When I try to get the report, no data is returned, and the following is recorded in the ...

Hi, I have a situation where I had created a maintenance plan and edited the resulting job. I had to delete the maintenance plan and job. In SQL2000 I would delete the job first then the maintenance plan. I tried this is ...

Hello, I'm not kean on installing Exchange server 2003, but i want to run SQL Server 2000 on Win 2003 SP, is there any chance to implement SQL Server Mail with POP3 Service? regards Lanying ...

hi i am running sql server on a windows server 2003 machine and i need it to create an uptomatic feed from a query every single day and then product a csv and xls file.. does anyone know how to do this? ...

Hi, The below query is running slow in production. SELECT MIN(STMT_DATE)  as STATEMENT_DATE  FROM CALL_TB WHERE PHONE_ID = ??? CALL_TB table has three indexes. (1) primary key on CALL_ID (2) non-clustered index on STMT_DATE (IX_CALL_TB2)   (3) non-clustered index on ...

I did a major boo boo last night.  I have a remote server which is running SQL Server 2005 Express.  I wanted to install Active Directory and run it as a secondary DC.  Once I did that, I think it removed all ...

i want to run a CREATE PROCEDURE script.. i want to check after the CREATE PROCEDURE that the script is updated. how do i do this ? i was thinking along the following lines .... suggestions are welcome 1. do a IF EXISTS on object ...

The configuration of SQL server is 1. Windows 2000 server Standard version 2. SQL server 2000 standard 3. 3G memory 4. mainly run by IIS and SQL, sometimes word or excel triggered by IIS. i have allocated all the memory to the SQL server at Enterprise manager. ...