Most likely yes. But I have never tried. Let me know.

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

What I amn sure Steve means is the users should not have any rights or access on MSDB. Jobs and such run under the context of sysaccount or SQLAgentExec so...

You will need to rebuild it on the NT4 server in debug mode so you can get an idea of why. Most likely you called some other com object that...

Well, now the next logical thing I would think then is can we add a link submission area Steve, browkn down into specific areas of relationship like your article basically...

This is an error message that comes directly from from the application (it is a C++ message based are trying to initialize a COM object). If you are getting the...

I just enjoy a challenge. Glad to here that was it in one failed swoop.

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

To restore the master you have to start the server in Single User mode not just the database. See BOL "Restoring the master Database from a Current Backup" for details...

I don't believe it is possible for many reasons including path to remote machine, permission, etc. However you could if you have experience or get someone else to write an...

Actually baring the missing ' from the end (which I bet you have) this message is coming from the OS Command Prompt. Open a command prompt and type PATH. Make...

This should do the trick.

SELECT UID, [DATE], VALUE

FROM smpTbl

INNER JOIN

(

SELECT UID, MAX(DATE) AS MAXDATE

FROM smpTbl

WHERE [DATE] < '3/13/02'

GROUP BY UID

) AS smpBase

ON

smpTbl.UID = smpBase.UID AND

smpTbl.[DATE] = smpBase.MAXDATE

What happens is...

No what Steve was saying is that you cannot use a TSQL statement to do this, you have to go in EM and turn it own, then EM will rebuild...

From BOL:

quote:

---

Installs only the client relational database management tools. Included in this option are the client tools for administering SQL Server...

First if your data is coming the DTS or Import wizard use a query to define what is coming from your remote source using the SELECT DISTINCT method, if there...

I don't believe a replication source can be a none SQL server database. You can however use DTS and schedule it to pull the data periodically.

"Don't roll your eyes at...

You would need to do something like

SELECT col1 AS DataX FROM tblX

UNION ALL

SELECT col2 FROM tblX

UNION ALL

SELECT col3 FROM tblX

UNION ALL

SELECT col4 FROM tblX

But the problem is the order will...