Search results for query: *

Hello everyone, I have written a stored procedure which inserts into tables on a linked server. The statement runs fine from Query Analyzer, but when I tried to save it in a stored procedure, I get the following error: Error 7405: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS...

Awesome! Thanks for the help!!

Hi, I'm trying to query a table on a remote server. In Query Analyzer I type: select * from BRM-ML123.dbname.dbo.table and receive the following error: Inccorect syntax near '-' The dash seems to be giving me trouble. Any advice?

That sounds great, but can you give me a tip on how to create a linked server?

I'd like to create a trigger on a table in db1 that is located on server1, that will insert a row into a table in db2 on server2. Something like: insert into svr2.db2.dbo.table2 .... Anyone have any ideas?

Hi, I am running SQL 2000 and have a table with an index (PK_oca_lu_print_job_1__12) on the primary key column (id). I used DTS to copy the table to another database on another server but the index did not come with it. This causes my inserts to fail. Can anyone tell me how to copy the...

Thanks! That worked great!!

Hi, I'm sure this has been done before so... I have 5 and 9 digit zip codes stored in a database without any hyphens. I would like to insert one when necessary. Some of the zip codes are not well formed, in that case I would like to do nothing. i.e. 12345 => 12345 1234567 => 1234567...

I have Crystal Enterprise 9.0 installed on server1 (Windows 2000/MS SQL2000). I created server 2 (Windows 2000/MS SQL2000) and would like to move the CE90 database from Server 1 to Server 2, and then decomission server1. I need an exact copy, w/ object ids the same, etc... Import doesn't do...