Viewing 15 posts - 76 through 90 (of 154 total)
from one of my developers:
"Those flags handle different rights sets.
SQLDMOScript_DatabasePermissions:
Rights for creating objects: CREATE/DROP/ALTER statements
and BACKUP/RESTORE
SQLDMOScript_ObjectPermissions
Rights for data access: SELECT/UPDATE/DELETE/INSERT/EXEC statements
It is only my supposition because...
November 18, 2003 at 7:52 am
thx for reply. we'll check it ourselves and let you know if we find out anythings
Brian Lockwood
LockwoodTech Software - value added SQL tools
November 18, 2003 at 7:31 am
Brian,
this is generally a good review but I question the characterization of the product as a "steal". The price posted on Lumigent's website is "starting at $10,000" with a...
November 5, 2003 at 9:50 am
Brian,
Generally good review - but this point is no longer true as of 10/2003
"Viewing the transaction log (only product on the market that can do that) "
There is another product...
November 5, 2003 at 9:27 am
this author has made a compelling argument and one I am excited to see written. I think it's time more people challenged the conventional wisdom that XML should be...
October 7, 2003 at 8:42 am
quote:
Glad to see you are reviewing comparison tools again. Unfortunately, your reviews on the subject seem to be sadly one-sided.Obviously, Red-Gate's...
September 14, 2003 at 9:04 pm
thx for reply. i'm waiting for some more info. from user and see if i can get to the bottom of it
Brian Lockwood
LockwoodTech Software - value added SQL tools
May 8, 2003 at 9:35 am
it was posted back on 2.20.2003. Andy has a link to it above.
"Finding and ignoreing Big Bad Tables"
I did a search on "Big Bad Tables" but could not find...
April 18, 2003 at 12:00 pm
thx a lot. i searched far and wide for that thread.
Brian Lockwood
LockwoodTech Software
April 18, 2003 at 10:25 am
thx much for the help. i already pulled this code and went back to system tables.
i appreciate the help though.
Brian Lockwood
LockwoodTech Software
April 9, 2003 at 8:29 am
i tried a few ways but same behavior.
(to clarify - you have to compile the app. first - behavior isn't exposed during VB runtime)
there is an item method to the...
April 8, 2003 at 7:41 pm
no - this code does not directly cause a GPF. If that were the case I could have isolated it very easily. It indirectly makes the app. unstable...
April 8, 2003 at 6:54 pm
how about this for an alternative ...
Dim sqlView as View
Dim qry As SQLObjectList
Set sqlView = objSQL.Databases(1).views(1)
Set qry = sqlView.ListColumns
the only problem is what is the syntax to iterate though the...
April 8, 2003 at 4:01 pm
here is some additional info from one of my developers
===========================
I have tried "sp_MSdependencies NULL, 3, NULL, NULL"
on both sql7.0 and sql2000. It has worked normal.
But if you have a problem...
March 27, 2003 at 11:51 am
thx for reply.
when I run sp_helptext on SQL7 I get the 4 params
create procedure sp_MSdependencies
@objname nvarchar(517) = null,
@objtype int = null,
@flags int = 0x01fd,
@objlist nvarchar(128) = null
as...
March 26, 2003 at 11:03 am
Viewing 15 posts - 76 through 90 (of 154 total)