Apprently they did quite a few updates from the original BOL for SQL 2K that make it more usefull.

"Don't roll your eyes at me. I will tape them in place."...

You are 100% sure that 'mark@allisonmitchell.com' is already in the database and active is 1 for it. Check you data to be sure, otherwise so far I cannot see a...

Can you show where you pull the data in, I ran you snippit here and when I supply a large string myself I get no problems with the output. Want...

Normally if it is the underlying tables it barks the table name instead this specifically is referring to the SP itself and execute. Also try revoking the users right to...

Ok first see right click on SQL Server Agent in EM and choose properties then see which startup account both are on. If they are both using system then you...

Sounds to me lik the permissions/access are not setup for SQL to be able to access the share itself. Remeber when you access a remote data source that SQL is...

Does it give any error, or exactly what occurrs?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

quote:

---

First, I was using Dreamweaver UD and it don't like the code. It was told I must have a SELECT statement or...

When you say right click stored procedure method, are you talkign about the properties screen, works like most etxt apps, just press CTRL+A to select all then right click and...

This came from SQL 2000 BOL update version on the SQL downloads section "Creating a Failover Cluster" or can be found on MSDN here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp where you can find more...

Have you tried this from another Enterprise Manager on another machine to make sure it isn't the install on the machine you are currently trying from. If does not cause...

Also try logging in as SQLAgentExec to make sure it is not some problem with it's permissions as it has control of the DTS package.

"Don't roll your eyes at me....

Sorry I find no reference for sp_mergemetadataretentioncleanup anywhere, nor on my servers. Can you post where it came from or the correct name. Also if you are not sure about...

Yeah, new toys...I am gonna have to play with these.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Microsoft hasn't made any version changes since, I think, Oracle 7x was released, may have been earlier. I think the issues is Oracle is not willing to lincense them the...