Functionally this doesn't matter - both double quotes and brackets are valid delimiters for database objects when the QUOTED_IDENTIFIER option is ON. See BOL:

http://msdn.microsoft.com/en-us/library/ms176027.aspx

I'm guessing the behavior is due to...

Run perfmon on your SQL Server and switch to the "View Report" view (Ctrl-R). Right click and select "Add Counters". Under the "Thread" Performance object select the counters for "%...

Assuming the scripts are all in the same directory....you can use the DOS "FOR" command to iterate through each file and call osql to execute each of them. Something like...

You can use netsvc.exe to control services remotely. It's part of the Systems Management Server install or Windows Server Resource Kits.

This KB article describes the tool in more detail:

http://support.microsoft.com/kb/140378

Kendal Van...

This is a start that you can build on...it'll show job names, enabled\disabled state for the job and schedule, and the schedule.

Kendal Van Dyke

http://kendalvandyke.blogspot.com/

[font="Courier New"]use msdb

GO

SET NOCOUNT ON

GO

declare@job_name sysname,

@job_enabled bit,

@schedule_enabled...

Has BUILTIN\Administrators been denied access to anything specifically?

I presume you have another admin level account (like sa or the DAC) that you can use to check all of this out...if...

More information is necessary to understand what's going on here:

- What's the recovery model of the database?

- What kind of backups are you doing and how often are you doing...

If you can live with up to 24h of latency in your copied database and your daily differential backups of your primary server are small maybe you could consider a...

Have you considered creating an indexed view that does the summarization for you? You can replicate the indexed view to your Reporting Server as a table. If a thousand rows...

Is your rebuild script\plan trying to rebuild an indexed view? If so you need specific session options set when the connection is made:

SET ANSI_NULLS ON

SET ANSI_PADDING ON

SET ANSI_WARNINGS ON

SET ARITHABORT...

If you're using SQL Server 2005 this query will show you the size of nonclustered indexes (both used and reserved) by table in GB:

SELECT

OBJECT_NAME(partition_stats.object_id),

SUM(used_page_count) AS used_page_count,

(SUM(used_page_count) *...

FYI I'll be more than happy to provide the scripts I wrote for both SYDI and SQLH2. Send me a PM with your email address if you're insterested.

Kendal Van Dyke

There are two free tools that will do this for you:

SYDI[/url] is a free VBScript that writes a substantial amount of system information to XML files. You can bulk insert...

Red Gate's nice but the last time I took at look it documented at the DB level and not at the Instance Level, thereby leaving out some pretty important information...

Yes, they'll run together just fine. Make sure you have enough memory, processor, disk space, etc. (no different than running mulitple instances of either product). You'll also need to keep...