-> sp_msforeachdb "DBCC updateusage('?')"

-> rebuild all the indexes

-> update stats of all the tables :EXEC sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN' <-- you can specify the sampling if you need...

Its running perfectly fine in 2005 .

Run it in single line and not in multiple lines .Secondly , while copying it might change the single quote to something else (a...

Oh , you took that liberty as well ...sorry I am out of answers ....

try this my friend :

WITH Numbers(Number) AS (

SELECT 1

UNION ALL

SELECT Number + 1

FROM Numbers

WHERE Number <= 99

)

SELECT * FROM...

:-D;-)

Modify that colume :

CREATE TABLE [dbo].[ChangeLog](

[LogId] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,

[DatabaseName] [varchar](256) NOT NULL,

[EventType] [varchar](50) NOT NULL,

[ObjectName] [varchar](256) NOT NULL,

[ObjectType] [varchar](25) NOT NULL,

[SqlCommand]...

select name,modify_date from sys.objects where type ='P'

Yes you need to have :

x64 version of SQLExpress 2008 and x64 version of OS .

To rebuild and reorganize all the indexes in all the databases :

1) create the SP attached in all the databases

2) execute this command :

sp_msforeachdb "exec ?.dbo.Rebuild_reorg_index"

generally as a rule of thumb we rebuild indexes having fragmentation more than 30% and and reorganize if the fragmentation is below 30% .

to find the fragmentation > 30% for...

I have also copied 2 files with this reply if you want to follow .You need to add the witness steps if you follow those scripts which is simple.

STEPS...

I have also copied 2 files with this reply if you want to follow (its without a certificate and works fine .You need to add the witness steps if you...

Filestream is verymuch supported in SQL Express.But you need to have it on a 64 bit server .Even if you have 32 bit version of SQL Sevrer on a 64...

also try using openquery .

basically , you conection string you are using seems incorrect .

I used the following and it worked

sp_configure 'Ad Hoc Distributed Queries',1

reconfigure with override

EXEC sp_addlinkedserver ...

-> Make sure the named pipes and TCP/IP protocols are open (SQL Server Configuration Manager).

->Make sure that the SQL Browser service is runing .

-> Make sure the server allows the...