- Does the SQL agent have access to pick up the files?

- What account are you using?

- Is the file set to read-only?

gregory.hill (7/24/2009)

---

I work for a company called SQLAlert that produces a lightweight monitoring product of the same name. The product runs stand-alone on one-or-more servers with load balancing and...

jamie (7/24/2009)

---

Running SQL Spotlight. I like that you can define what to get notified on, create custom queries, and also how you can go back in time through the...

GRE: Nice...

Report builder itself is for novice users (with the exception of formula's - but anyone with Excel exp can pick these up pretty quickly).

IMO, keep report builder simple for end...

Hi

I use the idera product.

IMO it is one of the good one's. Plus it has a number of other tools that are extremely useful (SQL Safe - backup compression/encrpt).

-...

http://www.devx.com/codemag/Article/36397

http://www.silicusblogs.com/kb/software-development-platforms/dotnet-software-development/a-comparative-analysis-of-sql-server-reporting-services-and-crystal-reports.html

Hi

Have you tried the link below...

http://www.hopeasp.net/hopeasp.net/post/2009/01/09/SQL-Server-Agent-Unable-to-cast-object-of-type-e28098SimpleObjectKeye28099-to-type-e28098JobObjectKeye28099.aspx

This works ok in 2005

select *

from tempdb..sysobjects

where name like '#tablename%'

or just use

where name like '#%'

You will need to installed SQL 2k SP3 (as stated in the link).

Within each SQL Server instance you can set the Min/Max memory. Make sure you leave enough the OS...

Hopeful enough infor in the link below

http://mattiasgeniar.be/2008/07/16/installing-sql-2000-and-sql-2005-on-the-same-server/

Nice script that I use...

http://sqlfool.com/2009/02/view-sql-agent-jobs-tsql/

As matt has stated you need to add "FailoverPartner=ServerB" to your connections string (assuming your using OLEDB).

Matts link show with diff values for other providers.

This also is the same for...

What does SELECT @@SERVERNAME return?

You could also try added it manually (from BOL)

EXECUTE msdb.dbo.sysmail_add_account_sp

@account_name = 'AdventureWorks Administrator',

@description = 'Mail account for administrative...

Try

SELECT (SELECT name FROM sys.dm_exec_sql_text(sql_handle) a JOIN DATABASENAME.sys.all_objects b ON a.objectid = b.object_id),

(SELECT substring(text, stmt_start/2,

...