Here is the command line parameter fix for adding replication/other components on cluster environment.

*******************************************************************

C:\Software\SQL 2005 STD\Standard_x86\Servers>start /wait setup.exe /qb VS=SQL1 INSTANCENAME=SQL1 ADDNODE="xxxx1,xxxx2" GROUP="GROUP 0" IP="xxx.xx.xxx.xxx,Public" ADDLOCAL=SQL_Replication ADMINPASSWORD=xxxxx INSTALLSQLDIR="C:\ Program...

Use full text

Full-Text Indexes can query binary formatted data (Excel data, Word

documents, etc.)

Hi,

Look at the job performing the backup and disable it.

Hi,

I've installed without any problem.

Install it on the machine that has the instance, if you want to update the administrative tools of the second node, you must install it...

I have had databases in compatibility mode 80 in SQL Server 2005 without any problems.

I do this with my suppliers.

Restore a copy of the production environment to the test environment.

Then run some scripts to delete data or change data.

Try this.

http://servername/reports/Pages/Folder.aspx

To delete a filegroup, you must first delete the file associated with the filegroup.

ALTER DATABASE [your database] REMOVE FILE [filename]

GO

ALTER DATABASE [your database] REMOVE FILEGROUP [filegroupname]

GO

Sorry,

select case when indexes.type_desc in ('HEAP','CLUSTERED')

...

Try this script.

select case when indexes.type_desc in ('HEAP','CLUSTERED')

...

With this script you can see the objects that belong to the filegroup.

use

GO

SELECT

fg.data_space_id, fg.name,

ObjectName = OBJECT_NAME(p.object_id), p.index_id

...

Hi,

He launched the query and the result is immediate.

Check Activity Monitor to see if there is any process blocking.

For the needs you require, I would use SQL Server native.

Look at this.

http://databases.about.com/od/sqlserver/ht/trace.htm

I think it is, because the agent who performs the sending of mail. Try to monitor the service agent.