check to see that the SQL Service account has valid permissions to access/write to these locations. Add the required login(s) to these 2 Folders/locations.

check the SQL Server Service Account and it is running under?

Make sure this Security account has valid permissions/credentials setup.

Try this:

sp_msforeachdb 'USE [?] select ''?'' as db_name, ''table_name''=object_name(i.id) ,i.indid

,''index_name''=i.name ,i.groupid

,''filegroup''=f.name ,''file_name''=d.physical_name

,''dataspace''=s.name from sys.sysindexes i

,sys.filegroups f ,sys.database_files d

,sys.data_spaces s

where objectproperty(i.id,''IsUserTable'') = 1

and f.data_space_id = s.data_space_id

and f.data_space_id = d.data_space_id

and f.data_space_id =...

Does the application user have restrictive permissions, Do you use the same login as in the application to login to SSMs and Check.

vidhya is correct.. As Simple as it gets in 2 Words.

so did you get it right?

WE had issues with MDAC 2.3 when we upgraded some ACCESS Databases over to SQL 2005 and also Clients sometime RUn reports off Access 97(Still). So we Decided to upgrade...

Due to spending constraint in the ORG i Work, we have to have all components installed on one BOX, so we have SSRS/SSIS/ENGINE/SSAS/BROWSER(Ofcourse) installed on a SINGLe INSTANCE of SQL...

Index maintenance : Includes checking out the Fragmentation of INDEXES using DBCC SHOWCONTIG : http://msdn.microsoft.com/en-us/library/ms175008.aspx

REBUILD Indexes includes rebuilding the Fragmented Indexes, which you can view either by the...

Yuo already know the BROKER is not CLUSTER Aware, so you have to isntall it on both the nodes.

you Need to Broker ofcpourse for the REMOTE clients to Communicate with...

Check the JOB Owner and also check the SQL Agent Service is Undder under. Use a Domain Account with Sufficient privileges to run the SQL Agent Service account.

Try to select all the Option in Logging, if it doesnt write anything..

If it appears Deseected, try going to Control Flow Windows and RightClick in the window in empty Space...

Do you write a ErrorLog or something from the SSIS Packages and JOB Likewise, this will help in squaring into the RECORDS, Tasks failing strategies.

Do People ever refer to BOL First.

Can you post the result of ::

select counter_name, cntr_value / 1024.0 / 1024.0 as GB, *

from master..sysperfinfo

where object_name = 'SQLServer:Memory Manager'

and counter_name in ('Target Server Memory (KB)', 'Total

Server Memory (KB)')

Also...

use "Ping Hostname" and see if you can Figure out the IP Address: then

"ping -a IPAddress"

or "Ping -t IPAddress"

or do a "route print"

:to go to the DNS and the...