The DBCC SHRINKFILE EMPTYFILE would only help in removing the data from the current file but it wont help in spreading the data into multiple files. If you need that...

From the Logs seeems that the server has all the problems of the world !!!!!!!

Your main problem is the AV(access violation) hapenning within SQL server and when the internal Sql...

I am not really sure but have you tried the CONTAINS and FREETEXT functions. They might be of help.

The entry for the instance name looks to be incorrect.  I think SQLBill typed it by mistake.

The correct entry should be something like

INSTANCENAME="FHDP1IRMPA01\RPMS"

i.e. machinename\instanceName

Ok Guys.

 The problem that you were facing was not because of the paging but because there the server was under the virtual memory pressure. One of my sugestions is...

Hello Dana,

 The DBCC UPDATEUSAGE will refresh the linked list of the pages for particular tables and hence it is not required that the users be logged out of the system....

I believe this is not the real error. Can you please paste the complete errorlog please ?

Hi Brian,

I think I understand what you are trying to do and think that it is not possible without creating different filegroups.

 YOu cannot control on which file wihtin a filegroup...

Also , as far as I know the O.S. versions (win 2K and win2k3 cannot be different). You need to understand the basics of clustering -- It means that the...

NO way it is possible to have a cluster with one node as 32 bit and other as 64 bit.

 remember that the SQL clustering depends on the windows clustering and...

Suggestions :

take backups of the system databases. Also user databases if possible.

It seems that your program requires a SQL express edition called as KBMSS. you might have to install the instance seperately (if your application does not do it by itself)....

YOu can start applyingthe SP4 when the database is being accessed, but remember that the SQL server will be restarted multiple times by the SP4 setup programm and hence the...

the error clearly indicates that it is a permissions issue.

Check if the account that you are using to connect to the remote server has and INSERT permission on the table...

I dont think there is a direct way to get that, Because jobs are basically used for scheduling purposes. At the background what it does it executes SQL statements.

 Hence...