Sounds like total nonsense to me.

Transactional replication reads from the transaction log. Of course SQL Injection is possible through your original application, then replication will apply any change to...

I'm not sure if it's possible like that, but it's certainly not the recommended way.

When you're having replication between different versions, the Distributor should always have the highest version....

Which ServicePack are you using?

On my SP2 machine I have Database Roles on top of the list. I don't have any machines available with a lower version so can't test...

You need to use dynamic sql in order to do this

DECLARE @ULOGIN sysname

DECLARE @sql nvarchar(500)

SET @ULOGIN = 'TESTER'

SET @sql = 'ALTER LOGIN ' + @ULOGIN + ' WITH PASSWORD...

As I said before I don't know exactly which fix but you should get the cummulative package SQL2000-KB916287-v8.00.2187-x86x64-ENU.exe

Steve,

the issue with the view was exactly the same, that unless the derived table...

Ali,

I did a quick test

First on SQL 2000.2187 (incl. cumultaive Hotfixes), all queries return the expected result.

Second on SQL 2000.2039 the results are like you said.

Then I rembered an...

This should do the job:

SELECT OBJECT_NAME(d.parent_object_id) AS tablename,

d.name ...

You can add AS from Add/Remove Programs in Control Panel. Select MSSQL Server 2005 and then click Change. But depending on which Service Pack level your server is you might...

As Paul already wrote, the big question is what is wrong with your current server.

If you uninstall SQL 2000 and makea new 2005 install, you need to recreate all...

Sounds like the users are part of a windows group. Check in Active directory if the group has been removed.

dtproperties stores the information for database diagrams. Internally it's a system table and public by default has access to all system tables. That's why the permissions are set like they...

You could create a new table with the desired layout, when insert all records from the original table, drop the old table and rename the new one to the original...

This is the service pack for 64-bit Itanium version. Your select @@version result shows an Intelx86 version. So you have the wrong...

Martin,

you could try using the CHARINDEX function.

IF CHARINDEX (' ', postcode) = 5 ...

Markus