RMO ERROR : No Signature Was Present In The Subject.

Jun 7, 2007

Hi !

I have such a message after trying to do replication with SQL Server 2005 using custom Business Logic Handler for a Merge Article (RMO Programming).

Message Replication-Replication Merge Subsystem: agent 'job' failed. No signature was present in the subject.

I am using C# with RMO, merge replication.

Any ideas ? How to solve this problem ?

Thanks.

View 2 Replies


ADVERTISEMENT

Signature Error

Jul 18, 2007

I'm putting together a demo for signing a stored procedure and I'm coming up blank as to why it is failing. Below is the code:



USE master

GO

--Create a pair of logins

CREATE LOGIN TestLogin WITH PASSWORD = 'P@55w0rd'

GO

CREATE LOGIN DummyLogin WITH PASSWORD = 'P@55w0rd'

GO

--Create a demo database

CREATE DATABASE SignatureDemo

GO

USE SignatureDemo

GO

--Create a low privileged user in the database

CREATE USER TestLogin FOR LOGIN TestLogin

GO

CREATE USER DummyLogin FOR LOGIN DummyLogin

GO

CREATE SCHEMA Test AUTHORIZATION DummyLogin

GO

--Create a dummy table and add data to it

CREATE TABLE Test.MyTable

(ID INT IDENTITY(1,1),

TestVal VARCHAR(10) NOT NULL)

GO

INSERT INTO Test.MyTable

(TestVal)

VALUES ('Test1')

GO

INSERT INTO Test.MyTable

(TestVal)

VALUES ('Test2')

GO

--Create a procedures to access test table

CREATE PROCEDURE Test.asp_Proc1

AS

SELECT ID, TestVal FROM Test.MyTable

GO

CREATE PROCEDURE dbo.asp_SignatureTest

AS

EXEC Test.asp_Proc1

GO

GRANT EXECUTE ON dbo.asp_SignatureTest TO TestLogin

GO

--Verify that TestLogin can not select from the table

EXECUTE AS LOGIN = 'TestLogin'

EXEC asp_SignatureTest

REVERT

GO

--Create a database master key

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'P@55w0rd'

GO

CREATE CERTIFICATE TestCert WITH SUBJECT = 'Test Certificate'

GO

--Sign the procedure, remove the private key, and backup to a file

ADD SIGNATURE TO Test.asp_Proc1 BY CERTIFICATE TestCert

GO

ALTER CERTIFICATE TestCert REMOVE PRIVATE KEY

GO

BACKUP CERTIFICATE TestCert TO FILE = 'TestCert.cer'

GO

--Create a user in the database mapped to the certificate

CREATE USER CertLogin FROM CERTIFICATE TestCert

GO

--Grant permissions to the user

GRANT EXECUTE ON Test.asp_Proc1 TO CertLogin

GO

--Verify that TestLogin can now select from the table (I'm still receiving an execute permissions error on Test.asp_Proc1 for some reason.)

EXECUTE AS LOGIN = 'TestLogin'

EXEC asp_SignatureTest

REVERT

GO

USE master

GO

DROP DATABASE SignatureDemo

DROP LOGIN TestLogin

DROP LOGIN DummyLogin

DROP LOGIN CertLogin

DROP CERTIFICATE TestCert

GO

View 3 Replies View Related

Error: Invalid Attempt To Read When No Data Is Present

Jan 3, 2008

I am getting this error even though there should be data present.  When I test the SQL statement in query analyzer, it returns 1 row.
<%@ Import Namespace="System.Data.SqlClient" %><%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Blog" %>
<script runat="server">Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim strConnection As String = System.Configuration.ConfigurationManager.ConnectionStrings("currentConnection").ToString      'currentConnection is defined in web.config and works when used in other pages on the siteDim dbConn As SqlConnection = New SqlConnection(strConnection)
dbConn.Open()
Dim strSelectCommandFirstEntry As String = "SELECT MAX(blogEntryId) as maxID FROM site_Blog"Dim cmdFirstEntry As SqlCommand = New SqlCommand(strSelectCommandFirstEntry, dbConn)Dim rdrFirstEntryData As SqlDataReader = cmdFirstEntry.ExecuteReader()Dim strFirstEntryData As Int32 = rdrFirstEntryData(0)       'error occurs here, i have also tried rdrFirstEntryData("maxID") with same errorrdrFirstEntryData.Close()dbConn.Close()
</script>
When debugging this code and stopping on this line:
 Dim strFirstEntryData As Int32 = rdrFirstEntryData(0)
rdrFirstEntryData has the following values:hasRows = True, FieldCount=1,  Item=In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.   and when i click the refresh button...Item = Overload resolution failed because no accessible 'Item' accepts this number of arguments.
I suspect that the note for "Item" is my clue to the source of the problem, but I don't know what it means.  Please, help.

View 2 Replies View Related

Error:Column 'FieldName' Is Constrained To Be Unique. Value '0' Is Already Present

Jan 18, 2008

Hi,
Can anyone help me?
when I am inserting a record to a dataset I am getting  Column 'FieldID' is constrained to be unique.  Value '0' is already present.
I have 2 fields in table like FieldID,FieldName where FieldID id is Primary key and identity column
I am not inserting any value to FieldID as it is identity column.
DataRow newDR= dbDataSet.Tables[strTable].NewRow();for (int i = 0; i < e.Row.Cells.Count; i++)
{ if ( e.Row.Cells[i].Key != "FieldID" )
{if (e.Row.Cells[i].Value != null)
{
newDR[e.Row.Cells[i].Key] = e.Row.Cells[i].Value;dbDataSet.Tables[ strTable].Rows.Add(newDR);
}
}
Some times it is woking fine with out any error............
 
thanks..

View 3 Replies View Related

Subject: BCM Install Error - Logfile &&amp; SQL Path Path &&amp; MSSQL.1?

Apr 16, 2008

When trying to install Business Contact Manager (BCM) for Outlook 2007, the setup failed and I was refered to a log file in my Local Settings/Temp folder. The log actually says that Business Contact Manager was installed sucessfully! BCM is supposed to install SQL Express 2005 as an instance or as instance if SQL Express is already installed. There is an MSSMLBIZ instance in Services..

Who can I send the Log File to for analysis and the fix feedback?

When I first went into Computer Management and clicked on Services and Applications in the left panel, the error message appeared "Snap-in failed to intialize. Name: SQL Server Configuration Manager CLSID:{CA9F8727-31DF-41D2-975C-887D84903967} This message diappeared when I clicked on Services and Applications again. Under Services, there are 3 SQL services - one is an application that was uninstalled 3-4 weeks ago and I disabled this service. The other 2 are: SQL Server (MSSMLBIZ) and the other one is SQL Server (SQLEXPRESS) When I tried to start either of the last 2, the message appeared: Services "Could not start the SQL Server (MSSMLBIZ) service on Local Computer. Error 3: The system cannot find the path specified. Under Program Files/Microsoft SQL Server/MSSGL.1 folder is mostly empty. So, it seems like the Path in the Registry is not valid and that nothing is being installed in the MSSQL.1 folder. If so, how do I fix this?

How do I get the BCM SQL instance to install and run properly? what do the messages in Services mean and how do I resolve these.

Thank you!

Gary

View 3 Replies View Related

Digital Signature

Oct 30, 2006

Hi I have created a Client/Server application. The Client connects remotely to the SQL 2005 server using thier unique user name and password.

The client application allows the users to update a form.

I need to add to the database a digital signature for that user when they update that form. This is intended to be a replacement for a physical signature that would appear on a paper form.

View 1 Replies View Related

Retrieving Digital Signature From Memory?

Apr 27, 2006

Would like to use the digital signature (i.e. PKI) from a smart card to authorize a PDF document. Is it possible to retrieve the PKI from Windows once its read in via the smart card using some sort of C++ or Java API call to apply it to the PDF form?

View 1 Replies View Related

Access To Table Blocked Signature Is Not Valid

Aug 3, 2007

I created sqlexpress database and .net app, everything was fine on my local machine.

When I moved the app to my server, I detached the database with SMSS express, moved the MDF file over along with the app files and I attached to the database with SSMS to make sure everything went over ok but when I try to open a table I get the error,


SQL Execution Error
Executed statement: Select x, x, x, x,x from tblFile
Error source: .Net SqlClient Data Provider
Error Message: Access to table dbl.tblFile is blocked because the signature is not valid.

I can open the stored procedures fine by choosing modify from the context menu.

Any ideas here?

View 1 Replies View Related

Nested Procedures &&amp; Using Signature Based Security

May 17, 2006

I am currently developing a project that requires a server level permission for one stored procedure (ALTER ANY LOGIN)

To this effect, I plan to create a certificate, sign the stored procedure with it, import the certificate into the master DB and assign privileges.

I also understand that modification to the code invalidates the signature (after all thats the point of signing something).

But what about user defined functions and stored procedures referenced by the signed procedure? Does SQL server follow the dependancy chain and include referenced procedures in the signature? Or does the privilege assigned to the certificate not apply when the nested procedure is executed?

If this is not the case couldn't a restricted database user just alter a nested stored procedure they have been granted ALTER access to and make themselves SA or something?

So to sum up, do you have to duplicate the functionality of otherwise nested procedures into a certificate signed procedure to protect server security?





View 3 Replies View Related

Stop Spell Check Of Outlook 2003 Signature

Jan 12, 2007

Hi All,



I have a user who's spell check always checks her signature - is there a way to prevent this? I know how to stop it on an individual email, but I want every email she creates to automatically NOT check the signiture file.

Running - Exchange 2003 and Outlook 2003.



Thanks!

View 1 Replies View Related

Transact SQL :: Ensure Code Non Regression By Keeping Consistent Signature For Procedure / Views And Function

Jul 28, 2015

In the 70-461 objectives it says: Ensure code non regression by keeping consistent signature for procedure, views and function (interfaces); security implications...I think I understand what this means in general. They want us to be able to create a view that will still be able to call the original data even if the table is modified.  In other words, the view table shouldn't easily be broken. ie, type a code that does NOT ensure non regression, then change the code so that it does ensure non regression. 

View 4 Replies View Related

You Must Enter A Subject

Oct 8, 2004

Question: Why is Graz a moderator on this forum? And on nothing else?



Brett

8-)

View 4 Replies View Related

SQL-CLR - Is It A Dead Subject?

Feb 15, 2008

Microsoft products that are doing well tend to have very strong communities around them, and I am starting to get a bit disappointed with SQL-CLR. This forum seems fairly light, the links int he FAQ are broken, and the official SQL-CLR blog has no update since 2006..

Taking all of that into account I am forced to wonder, Is this a dead subject?

I am not trying to say that the people in this forum are doing something wrong, nor am i claiming that no one uses SQL-CLR (i am a user, thats why im here). But I did want to get the opinion of the group here of where they think this concept stands.

I think SQL-CLR can really be a good tool in the chest for various scenarios. I am for one using it to have a generic SQL-CLR Stored Procedure that can analyze small sets of data and move it into various buckets depending on validation rules built into the code. So far its working very well, but I admit it has not yet hit production so only time will tell. (Performance is always a concern of mine)

Regards,

Dmitry.
http://blog.lyalin.com

View 5 Replies View Related

How To Use Variables In Subject Line

Mar 13, 2008

I would like to include some information in the subject line of a report subscription email. Right now the default subject line is something like "@ReportName was executed at @ExecutionTime". is there a way to use one of my report parameters in the subject? I tried something like "Thank you for your order @OrderNum", but that did not work.

Thanks,
Stuart Fox

View 4 Replies View Related

Automatic Email Subject

Sep 24, 2007



Good Morning,

I have created a varible in a report which displays as a text box i.e contains data like "LWD Apps 450" where the value will change each day. The report is emiled to a list of users, is there a way to automatically enter this value so that it is in the subject bar when the email is automatically sent??

Thanks in advance.

Steve

View 1 Replies View Related

Xp_sendmail @subject Appears In Body

Nov 12, 2004

My @subject in an xp_sendmail job is appearing in the email subject where it's supposed to, but also as the first line of the body. Does anyone know of a way to disable this behavior?

View 3 Replies View Related

Subject: Legal Question: Decompiling A DLL ?

Oct 11, 2007

Hey guys, I didn't know exactly where to post this, but I'm wondering what
the legal implications of decompiling a .DLL are ?

We are using SQL Reporting Services 2005 with the Excel Export option. The
problem is that our reports have a lot of hyperlinks on each page so we can
easly navigate all the reports, but when we go ahead and export the report,
all the hyperlinks get exported too; resulting in a file atleast 10x the size.

i.e we export a report and it results in a 20mb excel file, but once we
remove all the hyper links and save it again it drops down to a 500k file.

So I was wondering, what the legality was in decompiling the Excel
Export.DLL that comes with Reporting Services and removing the Hyperlink
export functionality ?


Thanks,

Raul

View 3 Replies View Related

Pass Paramenter In Subject Of Subscription Email

Sep 29, 2007

Hello there,

how can i pass my own parameter values in the subject of Subscription email?.for example i want to pass the employee ID in the subject.

View 4 Replies View Related

@ExecutionTime Date Format On Email Subject

Jul 4, 2007

Hi,



I created a report subscription windows form to talk to SSRS 2000 web services API. Everything is fine except the email subject '@ReportName was executed at @ExecutionTime' is always in American Date format.



Is there a way to customize the date format on the variable @ExecutionTime on the email subject?



Any help would be appriciated.





Thanks,



A

View 5 Replies View Related

Subject: How To Join A Table With Other (result) Tables ? Complex !

Aug 25, 2005

Here is the situation

Table 1 : tbl_documents

docIDdocName
1aaa
2bbb
3ccc

Table 2 : tbl_Rating

ratIDratingdocID
131
251
321
432

The queary I need is to display the result in this form. must be like this

docIDdocName Avaragerating
1aaa3
2bbb3
3ccc0

NOTE : For getting the average I used this queary “SELECT SUM(rating) As
RatingSum, COUNT(*) As RatingCount FROM tbl_Rating WHERE tbl_rating.docID =
tbl_documents.docID”

PLs help me ?

Thx

View 3 Replies View Related

Integration Services :: Dynamic Email Subject Line

Aug 6, 2015

I have the variable @Monthname defined as shown below:

(MONTH(getdate()) == 1 ? "January" : MONTH(getdate()) == 2 ? "February" : MONTH(getdate()) == 3 ? "March" : 
 MONTH(getdate()) == 4 ? "April" : MONTH(getdate()) == 5 ? "May" : MONTH(getdate()) == 6 ? "June" : 
 MONTH(getdate()) == 7 ? "July" : MONTH(getdate()) == 8 ? "August" : MONTH(getdate()) == 9 ? "September" : 
 MONTH(getdate()) == 10 ? "October" : MONTH(getdate()) == 11 ? "November" : MONTH(getdate()) == 12? "December":"")

By itself, it is working fine. I am attempting to have the @SubjectLine variable display the below:

CA - TFL for the month of August 2015

I am using the expression below in the expression builder:

"CA - TFL for the month of " + @[User::MonthName] +  (DT_WSTR,4)YEAR(GETDATE())

When evaluating the expression, I get the below (month is missing):

CA - TFL for the month of 2015

View 2 Replies View Related

Trigger :: Xp_smtp_sendmail :: Parameter Value In Message/subject :: Magic Table

Oct 23, 2007

OK so now I'm setting up a trigger to email info to different people based on values INSERTed into one of my tables. I'm using an IF statement to determine who I'm giong to send the mail to, but I don't really understand how to include the data (parameters) in my message. Thanks for any help. Here's what I have so far.





Code Block
ALTER TRIGGER [smallin].[trig_test]
ON [smallin].[DATALIST]
AFTER INSERT
AS
declare @rc int,
@post bit,
@pre bit
SELECT @post = [POST], @pre = [PRE] FROM inserted
IF @post = 1
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'ln.li@mydomain.com',
@FROM_NAME = N'Alert Mailer',
@TO = N's.mallin@mydomain.com',
@replyto = N'ln.li@mydomain.com',
@CC = N'',
@BCC = N'',
@priority = N'NORMAL',
@subject = N'This is post data',
@message = N'Goodbye MAPI and Outlook',
@messagefile = N'',
@type = N'text/plain',
@attachment = N'',
@attachments = N'',
@codepage = 0,
@server = N'exchange.mydomain.com'

ELSE IF @pre = 1
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'ln.li@mydomain.com',
@FROM_NAME = N'Alert Mailer',
@TO = N's.mallin@mydomain.com',
@replyto = N'ln.li@mydomain.com',
@CC = N'',
@BCC = N'',
@priority = N'NORMAL',
@subject = N'This is pre data',
@message = N'Goodbye MAPI and Outlook',
@messagefile = N'',
@type = N'text/plain',
@attachment = N'',
@attachments = N'',
@codepage = 0,
@server = N'exchange.mydomain.com'





View 5 Replies View Related

Send Mail Task - Would Like To Create Custom Subject Line

May 23, 2007

Hi,



I imagine this will be done through the use of expressions.



What I would like to do is this. When my package fails, it's set up to send an email using the Send Mail Task.



I would like to create a custom subject line that contains:

1.) Name of the package

2.) Name of the task that failed (if possible)



I am seriously wondering how I can do this.



Thanks much

View 1 Replies View Related

Are Sqlclr Stored Procs Subject To The Same SQL Execution Model As Other Sessions?

Sep 21, 2007

are sqlclr stored proc sessions running in the same SQLOS execution model (Running, runnable and suspended status, Runnable Queue and Wait List) as other types of sessions and therefore ending up in the same queues, contending for very similar resources (except maybe for memory type because of MTL's role) etc?...or do they get treated in a very different way?

View 1 Replies View Related

Table Design Question - Subject Matter Expert Database

Aug 8, 2007

I would like to create a database that keeps track of our companies subject matter experts. I have roughed out some of the tables. I would appreciate any feedback on if this is the right approach and if there might be any issues when I start writting a front-end (probably VB 2005).

What makes this interesting (at least for me) is that a subject has an owner and at least 1 "expert", possibly up to 3. Here is what I am thinking for tables:

tblEmployee

EmployeeID (PK)
LastName
FirstName
etc......
tblSubject

SubjectID (PK)
Description
tblOwner

SubjectID (FK)
EmployeeID (FK)
tblExpert1

SubjectID (FK)
EmployeeID (FK)
tblExpert2

SubjectID (FK)
EmployeeID (FK)
tblExpert3

SubjectID (FK)
EmployeeID (FK)



Does this make sense? Would I run into any issues when trying to display this on a form in VB?

Thanks in advance for any help!!!!!

Cal

View 8 Replies View Related

T-SQL (SS2K8) :: Retrieve Subject Wise Highest Marks List In A Table?

Jul 18, 2011

I have a requirement like, we are having two tables in our database.

Table names: student, marklist

Student table values:

id studname
------------------
1x
2y
3z
4a
5b

Marklist table values:

id maths physics English
---------------------------------
1506070
2706040
3508070
45010070
5906070

But my requirement is, I need to display the data "subject wise" highest marks for each student.

for example:

id name highestmark
---------------------------------
1 x English

View 9 Replies View Related

Reporting Services :: Change Subscription Subject On Report To Total Or A Field?

May 13, 2015

change the subscription subject on the report to Total or a field.

On the subscription Data Driven Subscription does not exist.

Is there any other way to fix it?

View 7 Replies View Related

Is RS2005's Matrix Data Region Feature Broken, Or Subject To Certain Limitations?

Dec 25, 2007

I'm consistently getting >10 minute render times in a matrix based report whose underlying query only takes 1-2 seconds to run in both RS's data tab and mgt studio. The bad render times occur in preview tab, Report Viewer and when requested from Report Manager. I believe most of the time being taken is RS's attempt to pivot and present the data.

I can run a homegrown query that pivots (with unknown number of cols) the data itself in under 4 seconds but would be concerned about mapping an unknown number of columns to a table region in RS.

The matrix I'm testing with is 67 columns across (just over 2 months of daily columns) and is supposed to be 207 rows long. There is no aggregation required by RS when it is pivoting the data because each intersection occurs at most one time in the query's result set. The number of data points actually being "bucketed" is around 13,800 values. Row headers consist of 3 columns.

RS is also cutting off the number of rows it is supposed to be showing. The number of rows cutoff seems to be 100% repeatable based on the date range chosen. RS doesnt tell me when it cuts off rows that should have been displayed. From what I can tell so far, it never cuts off columns.

The number of rows cut off seems consistent across designer's preview, report viewer and when requested thru report manager. The "run" command (exclamation icon in data tab) seems to always return the correct number of unpivoted rows, just as in mgt studio.

Are there known bugs and or limitations in RS's matrix data region feature? Are there some settings or workarounds that might make it work more to my liking?




View 13 Replies View Related

How To Insert A Row Only If It's Not Present

Apr 16, 2008

Hi,

I've been asked to find a way to insert a row only if it's not present. I want to make sure that test and insert are atomic, so I wrote the following test cases


-- CREATE TABLE t1 ( id int, val varchar(256) )

-- GO


-- Execute the following statements in one query window

IF NOT EXISTS(SELECT * FROM t3 WHERE id = 1)

BEGIN


WAITFOR DELAY '00:00:10'

INSERT INTO t3(id, val) VALUES (1, 'Query 1')

END

GO


-- Then execute the following statements in a second query window within ten

-- seconds of the starting the first query

IF NOT EXISTS(SELECT * FROM t3 WHERE id = 1)

BEGIN


WAITFOR DELAY '00:00:10'

INSERT INTO t3(id, val) VALUES (1, 'Query 2')

END

GO


When both queries are complete there will be two rows in the table t with id = 1.

1 Query 2
1 Query 1

Wrapping the code in a transaction does not change the result. Changing the transaction isolation level to serialable causes a deadlock, but otherwise the isolation level has no effect on the result either. Adding a WITH (TABLOCK) hint to the tests do not change the result.

Our clients use a mix of SQL 2000 and SQL 2005 so TRY/CATCH blocks cannot be used.

Any suggestion on how to do this?

Thanks

View 11 Replies View Related

The Given Key Was Not Present In The Dictionary

Feb 4, 2008



I'm developing a report which contains a number of matrixes which are ordered in a hierarchy which can be navigated using a document map. One of the matrixes contains a subreport containing a table which displays a description for the matrix and the corresponding document map label. This is working without problem already in the production environment.

Recently, after updating my machine with numerous updates and patches, this stopped functioning. I now receive the error message, "The given key was not present in the dictionary" when I run this subreport, either as part of the greater report or on its own.

I have seen the posting which recommends deleting the report.rdl.data files. This did not solve the issue.

The data and the dataset are both in sync. When I click the "Print layout" button when previewing the report in Visual Studio .Net 2005, I can view the data. This looks like a bug in the VS.NET 2005 report designer.

I am running SQL Server 2005 SP2.

Any help is appreciated.

Regards,
Bill Mueller

View 3 Replies View Related

Not Present On The Subscriber.

Dec 11, 2006

Hi all,

Publisher
SQL 2000 Snapshot publication timed to run at 23:00 daily All tables & views are published articles.Snapshot agent runs and creates a snapshot of all articles.

Subscriber
SQL 2005 Pull subscription set to run continuously Manually run the SQL agent job and I get the following error... 2006-12-11 15:04:35.687 Agent message code 20164. Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber.

I've tried creating the subscription database from a backup so I know all the tables & views exist and also tried just creating a blank empty database - same error.

There are no user stored procedures or functions in the database.

If I'm publishing all tables & views then why should the data & structure fail to load at the subscriber? Do I need two publications, the first containing the metadata and the second containing the data?

Thanks in advance
Dave

View 6 Replies View Related

Effectively Getting Data And Present It By Location

Jun 16, 2008

Hello. I have been challanged to build an application that keeps track of inventory and dates of every item that needs inspection on regular intervals. The original application was a .NET windows application and i have been tasked to "port" and improve it to a .NET C# web application.
The original database was in access and i have imported everyting to SQL and all the data is in a single table. So far the table is relatively small so i decided to keep the current database design.
What i need to do is to select all the items that are comming up for inspection in the comming months and present them. Each item has a uniqe article number (artnr) with the item name, category and location of the item. The location is the part i would like each items to be presented by. Basicly i would like to retrive artnr, name, type and present x number of gridviews or a sorted presentation where each item is shown inside each gw/whatever by location.
I also considered moving all locations to it's own table and connect it with a PK/FK to the prinmary article table but i dont know if this will help me or not. Basicly i have no idea how i would present the items by location where each gridview/somethign else is it's own location.
I could really use som help with how i can retrive and present the data so it is showed in the above manner.

View 1 Replies View Related

Cascade Deletions Of Children When FKs Present

Dec 8, 1999

Guys, could anyone tell me if MSSQL Server 7 has 'on delete cascade' option when creating a foreign key constraint or something similar to it. I'd really like MSSQL to remove all dependent records (child records) automatically from one table when I'm deleting a parent record from another record. I know that I can do it via trigger, but the FK constraint should be removed or disabled. I would really appreciate your help. Thank you very much.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved