Search results for query: *

Hi all, I am inserting into a remote table and need to get the identity value that was last created i.e. insert into [RemoteServer].[RemoteDatabase].dbo.[DB](num) values(1) declare @id int set @id = @@identity select @id This is returning NULL for the identity value but works fine if I run it...

Hi all, I have just started to try and implement DDL auditing triggers in SQL Server 2005 and get a Distributed Transaction error when inserting into a remote audit table. Part of the error reads: 'Cannot acquire a database lock during a transaction change. An error occurred during the changing...

Hi all, I am trying to use the UPDATETEXT functionality across a linked server and am not sure if it is possible e.g. This is BOL syntax: UPDATETEXT table_name.column_name @dest_textptr 0 NULL table_name.column_name @src_textptr I need to reference a column on a remote server: UPDATETEXT...

Hi all, I hope someone can help me with this as I am completely stumped. I have a DTS package that uses an activeX script to loop through a bunch of files in a folder. The data in the files is then inserted into a table. When running the DTS package from Enterprise Manager is runs perfectly...

Hi all, I have a TextBox and am trying to pass it's value to a SQL Server procedure specified in an asp:GridView. The GridView works fine if I put in a default value but doesn't seem to pick up the form value, in fact after running the profiler there is no call to the procedure at all. The...