Viewing 15 posts - 46 through 60 (of 498 total)
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
June 1, 2004 at 1:56 pm
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....
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
June 1, 2004 at 1:41 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
June 1, 2004 at 1:00 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
June 1, 2004 at 12:45 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
May 19, 2004 at 1:39 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
May 19, 2004 at 1:03 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
May 18, 2004 at 12:01 pm
You should be able to create a DB project in VS 6.0. Look under "Other Projects" when you create a new project.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
May 18, 2004 at 10:28 am
Add "For Read Only" at the end of the cursor declaration...
DECLARE @c cursor
SET @c = cursor FOR
SELECT * FROM Foo
FOR READ ONLY
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
May 18, 2004 at 10:25 am
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
May 17, 2004 at 4:08 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
May 17, 2004 at 3:48 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
May 17, 2004 at 3:42 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
May 17, 2004 at 1:55 pm
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
,...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
May 17, 2004 at 1:45 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
May 17, 2004 at 1:08 pm
Viewing 15 posts - 46 through 60 (of 498 total)