No error found to me. I copied the code from the attached doc file and it executed well...

Atif Sheikh

'On another network' means on another domain over the internet?

in this case you will be needing alot of netwrok configurations (probably VPN configuration) provided by your ISP.

GOD BLESS...

Well, most of the people here in Pakistan pronounce it as S Q L (each alphabet separate). 'Sequel' is also used, even I use this word for SQL but...

The solution of this is posted here...

http://www.tek-tips.com/viewthread.cfm?qid=308642

its some connectivity (networking) issue between client and the server

Atif Sheikh

Great series Brian... very helpful...

Atif Sheikh

Very Helpful Article.

Will work on it in detail in near future to use it according to my own requirements...

Atif Sheikh

Disable Statement accepts Database Name. The syntax is correct if the table on which you are performing Disable Trigger operation is in the dbo schema. But in this case, the...

Restarting instances will truncate tempdb BUT the drawback is the downtime. There are alot of examples where one cannot even think about restarting instance frequently. It is only...

nice stuff. Normally, people overlook the delicacy of the tempdb and its location. It must have the appropriate space to work, especially when you are creating and re-building indices. ...

How about this...

DECLARE @bb AS varchar(max)

SET @bb = 'USE [?]; PRINT ''?''; '

SET @bb = @bb + '

DECLARE @aa AS varchar(max)

SET @aa = ''''

SELECT @aa = @aa + case WHEN...

declare @sSQL varchar(5000)

set @sSQL = 'SELECT @iEp_E_Id=Ep_E_Id, @iEp_R_Id=Ep_R_Id,@iEp_Seccion=Ep_Seccion,@sEp_Nombre=Ep_Nombre From...

Table structures and Execution plans will give a better look.

I think I would have gone for Left Outer Join as I believe that it is faster than NOT In. Instead...

Try the following way...

SELECT @cnt = Count(*) From notes where note_date > '06/23/2008'

Select person_id, case @cnt when 0 Then 'Y' ELSE 'N' END From Persons

The solution might be different...

Hi Jeff..

I executed your script and, surprisingly, got an error. One of my databases was in the recovering status and raised error on that database.

So I altered your script a...

For SQL Server 2005, its simply

SELECT * FROM sys.objects

WHERE is_ms_shipped = 0

ORDER BY modify_date DESC

Atif Sheikh