Viewing 15 posts - 121 through 135 (of 154 total)
quote:
Hi,this approach is better because you don't have a static reference to SQLDmo. So there is no problem with the interfaces. It's...
July 12, 2002 at 9:48 am
quote:
This code should work better as you don't need the reference to the object loaded for it to workdim oapp as object
Set...
July 11, 2002 at 11:23 pm
thx - i tried it and here's what i get ...
Elapsed: 85.1875
Elapsed: 85.1875
Elapsed: 89.57813
running your code. i'm hitting a sql2k server on local...
July 10, 2002 at 8:33 pm
great, thanks
Brian Lockwood
President
LockwoodTech Software
July 10, 2002 at 7:13 pm
quote:
Answer should be yes to all.Andy
http://www.sqlservercentral.com/columnists/awarren/
ok thanks - you've been a great help
Brian...
June 29, 2002 at 11:25 am
quote:
Thats correct. All the "2" objects have additional SQL2K functionality. They've preserved the original interface so that existing code didnt break.Andy
June 29, 2002 at 9:49 am
ok - here is one ... (this issue was my problem)
what is the difference between SQLDMO.Database2 and SQLDMO.Database.
Using Database UserDefinedFunctions are not exposed but using Database2 they are.
Can...
June 28, 2002 at 8:33 pm
I can say that case-sensitive databases have been one of the biggest hassles at LockwoodTech. We roll out an app. which bombs on a customer's PC who has a...
June 26, 2002 at 9:19 pm
quote:
This works using 2000.80.532.0Dim oServer As SQLDMO.SQLServer
Dim oDB As SQLDMO.Database2
Dim oFunc As SQLDMO.UserDefinedFunction
Set oServer = New SQLDMO.SQLServer
oServer.LoginSecure = True
oServer.Connect "higapp4"
Set oDB =...
June 21, 2002 at 11:54 am
quote:
Try UserDefinedFunctions Collection of the database object - SQL2K only of course.Andy
http://www.sqlservercentral.com/columnists/awarren/
thanks -...
June 21, 2002 at 7:44 am
quote:
What IS the best programming language for SQL Server? As this thread points out, everyone is going to have their own opinion...
June 13, 2002 at 7:06 pm
quote:
Maybe I am confused, the names are very easy to see how they relate directly to SQL from C#. Maybe I am...
June 12, 2002 at 10:14 am
VB.NET vs C# cartoons
http://www.angrycoder.com/article.aspx?cid=12&y=2002&m=2&d=25
http://www.angrycoder.com/article.aspx?cid=12&y=2002&m=2&d=18
Brian Lockwood
President
LockwoodTech Software
June 4, 2002 at 12:49 am
quote:
quote:
but there are other variables - commercial, employee related (what they want to do),...
June 3, 2002 at 7:36 pm
quote:
I tend to agree with Antares. Having VB.NET support inheritence, real classes, etc. there is not a substantial difference from c#. Personally...
June 3, 2002 at 7:24 pm
Viewing 15 posts - 121 through 135 (of 154 total)