In some cases this is where using an XML parameter works really well. You can simply have the calling application build the XML string with all the parameters you want...

I've never noticed this but then I always have a distributed transaction running when I'm reading XML. I have never had a problem with a transaction count when doing this....

Dinesh,

Now that you have it working I would highly suggest you turn this into a stored procedure instead. Then you can raise an error if the insert fails for some...

Jim,

In this type of situation I would make sure that all my objects are scripted out to a file. Then I would create a script that would be something like...

Did you read the link(http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx) that Frank posted? It should give you all the information you need to know for using Blobs. Also if I remember correctly ArcTools has...

I think in this case Lumigent's Log Explorer is the only way to get the data back. Since there is no full backup prior to this she can't simply do...

Very nice article Steve. It's also very similar to the way I work. All of my objects are scripted out. I have a DB Project in VS .Net that I...

You should be able to create a DB project in VS 6.0. Look under "Other Projects" when you create a new project.

Add "For Read Only" at the end of the cursor declaration...

DECLARE @C cursor

SET @C = cursor FOR

SELECT * FROM Foo

FOR READ ONLY

yogi<< why is that?Is it incase sql server changes the way that they store syssobjects in the future?>>

Exactly. I know that I have read there were changes to the system tables...

The best way is to create scripts for each object and simply store the scripts in VSS. I personally use a database project in Visual Studio to hold the scripts...

I use ALTER TRIGGER and put a Return statement before any active TSQL. Then when I'm done I just remove the Return statement.

If you need to do this on...

Have you tried using a normal join using the fully qualified table name for the linked fox pro tables?

select a.*, b.*, t1.f1, t1.f2, t2.f3

from SomeLinkedServer.RemoteDBName.dbo.sometable1 a

    JOIN SomeLinkedServer.RemoteDBName.dbo.sometable2 b ON a.xyz...

Although it is a good idea not to use the system tables the sysdepends table holds the information you are looking for. Consider the following...

SELECT DISTINCT ObjectName = so.name

    ,...

In effect they are the same as you stated. However you will never have a situation where you mistakenly forget to put "Local" on your declaration and end up with...