>Hi All,
>
>Can I use TRUNCATE or DROP TABLE statement against a table on the linked server ?
>"TRUNCATE TABLE dsi11.testdb.dbo.test" statement is giving me the following error message:
>
>The object name 'dsi17.testdb.dbo.' contains more than the maximum number of prefixes. The maximum is 2.
>
>Any help would be appreciated,
>Daniel
You should be able to leave out the dbo prefix and will assume current user, which in this case would be dbo
e.g.
truncate table dsi11.testdb..test
Insanity: Doing the same thing over and over and expecting different results.