Viewing 15 posts - 46 through 60 (of 95 total)
First, thanks for the reply.
I have three tables under a view. This view selects few columns from each table. I would like to given select permission & update permission...
March 11, 2009 at 5:57 am
well! there are methods were you can expose a stored procedure using web services & so on...so i was wondering if any body used any of these features...logging on to...
February 27, 2009 at 1:14 pm
1. first place the database design was done to have these fields, at this moment we are not in a position to re-evaluate it hence I'm trying to find a...
February 19, 2009 at 1:58 pm
it is web-based & each user doesn't have separate connections. they use a shared connection string but each user would be given a separate username (application specific & not sql...
February 19, 2009 at 1:11 pm
the application cannot pass any such values (the application is already built & we just do configuration). it default to getdate(), & current sql user used to update the record.
February 19, 2009 at 12:58 pm
i dont want to be handled by application or user as there are possibilities some users may not know in the future they have to update the audit fields hence...
February 19, 2009 at 12:45 pm
there are no stored procedure. this is performed by the application. I was wondering if there are any other way to control this in 2005 by the database itself like...
February 19, 2009 at 12:43 pm
I fixed this issue. It looks like when you create an object from DTS.Package2 & try to execute it, somehow it corrupts the memory or keeps running something in the...
February 6, 2009 at 9:42 am
as per the above sample code the update views works with multiple tables when columns from one table alone is updated in single statement.
But, what I'm not sure is whether...
January 28, 2009 at 3:33 pm
ok. my problem is my Table A has 10 columns & Table B has 20 columns. And, its a one to one relationship from Table A to Table B.
In my...
January 28, 2009 at 11:58 am
I dont understand the part "Planning". Can you please help me out here.
Whether inner join or any other join would work if this is not going to be a partitioned...
January 28, 2009 at 11:09 am
I performed the following sample & found that a view can have multiple tables but while performing updates you can use only columns from a single table. Pl. see the...
January 28, 2009 at 9:39 am
Yes. The code has been migrated to .net now. We are debugging this since yesterday & couldn't able to find the reason. We make a call to create a dts...
January 22, 2009 at 2:14 pm
also, this code cannot be imported into dts as it is return in vb. It is creating instance of DTS.Package2, DTS.Connection2, & so on....
January 21, 2009 at 10:09 am
Viewing 15 posts - 46 through 60 (of 95 total)