select @@version

It was mean Remote Command Service, a nt4 technology allow administrator run command-line program remotely.

On the same line:

wshremote object of wsh can run scripts on remote machines.

If your can service...

Declare @TableName Varchar(1000)

DECLARE TOP10DATA_Cursor CURSOR FOR

Select Distinct SO.Name "Tables"

   From SysObjects SO

    Where (SO.id Not In (Select rkeyid From SysReferences) And SO.id Not In (Select fkeyid From SysReferences))

    And...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlsg/html/msdn_msterra.asp

Not work, even workaround described in article 300272 did not work.

use master

go

exec sp_renamedb 'pubs', 'pubsnew'

go

select * from pubsnew.dbo.authors

go

exec sp_renamedb 'pubsnew', 'pubs'

go

Remote Access service on back process server may help.

It works for me.

Here are steps for verification:

Create table, view, function as described on source server.

Create DTS package on source server.

  define source and destination server connections (both sql server...

Can you sample it?

PSS ID: 300272

http://support.microsoft.com/default.aspx?scid=kb;en-us;300272

discribes a similar case, it was fixed under sp1.

Hide server check box on TCP/IP Properties of SQL Server Network Utility

It's bitwise operation.

& for bitwise AND

64 = binary 1000000

status&64=64 is checking if status column has that bit(s) been set.

Refer BOL for detail info on bitwise operators.

admin in database is dbo. No to the question.

One way for limited access is Encryption.

use sp_executesql to passing @PassedDate.

Here is the modified code:

DECLARE @FixedFilterData VARCHAR(255)

DECLARE @PDate DATETIME

DECLARE @strSQL NVARCHAR(1000)

SET @PDate = GETDATE()

SELECT @FixedFilterData = FixedFilterData FROM dbo.Table1

SET @strSQL = 'SELECT *...

Try

select * from sysobjects where name = '_hypmv_0'

xml to a temp table, sql comparison and select result out.