Sql 2005 Trigger - Newbie

Jul 10, 2006

I have two tables "Inventory" and "Product". User creates a product then assignes inventory to that product.
The product table and the inventory table both have the same two fields, "GDS" and "prodID" and both share the same field and value of ProductID.
I'm trying to create a trigger for the Inventory table so when the Inventory table has an update or insert,
the values from Product.GDS and Product.prodID values go into the Inventory's record for Inventory.GDS and Inventory.prodID

I an having problems with the trigger as this is my first attempt in creating a trigger.
I have the trigger on the Inventory table and this is what I so far which does not seem to be working, any suggestions (thanks0:


Code:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER TRIGGER [inv]
ON [dbo].[Inventory]
AFTER INSERT,UPDATE
AS
BEGIN
SET NOCOUNT ON;

Update Inventory
Set GDS = i.GDS, prodID = i.prodId
From Inserted i
Inner Join Inventory inv ON i.ProductID = inv.ProductID
END

View 3 Replies


ADVERTISEMENT

Trigger Problem - Newbie

May 27, 2008

 I will try and simplify my problem. Lets say I have 4 columns in a table some with valuesID  Description  TotalCost Labor1   blahblah        50.00     Null2  Blah              75          183  moreblah       80.1       Null I then do an update where labor is null. What I want my trigger to do is add labor to total cost.I don't know what approach to take as I have no idea how to get at the total cost value for each row as its labor value is being updated.Can anyone point me in the right direction. Thanks, Bill 

View 3 Replies View Related

Reference For Newbie On Trigger And Store Procedure

Jan 10, 2006

hi, good day, i new in trigger and store procedure, can someone please suggest some advice and reference material in order to mastering trigger and store procedure ? thank you

View 1 Replies View Related

Newbie In SQL Server 2005

May 20, 2007

Good day. Is there any version of SQL server 2005(not include Express Edition) same as SQL server 2000 Personal edition ? I am planning to install new SQL server 2005 in my pc now. I am using Windows XP SP2 now. I tried to install to Entreprise Trial version, unfortunately it just works as client. Thank you in advance.


Regards,
Anson

View 3 Replies View Related

SQL Server 2005 Newbie

Aug 7, 2006

I am relatively new to SQL Server and I have 2005. I am developing a database with an Access ADP frontend. The development is taking place on my laptop running a separate instance of SQL Server. I am trying to put the database on the production server and I am not sure how to proceed.

My laptop is not part of the network so I need to create a file and then import it on the SQL Server instance running on the production server. I thought I could do a backup and restore, but apparently that is not working.

Any help would be greatly appreciated.

View 4 Replies View Related

Newbie: Sql 2005 Encryption --- Or Where Do I Put That Key?

May 23, 2006

I can encrypt columns in sql 2005 but where do I store the key to decrypt the columns?

I can store the key in the database (or server on which the database resides) but I think that offers little security. I could store the key on another server that the sql server accesses only upon startup (though I don't know exactly how to do that). Or I could store the key on a removable drive that is read (and only needed) when the sql server starts up.

What are your ideas on this matter?



TIA,



barkingdog

View 20 Replies View Related

Visual C++ 2005 (C++/CLI) - Newbie With ADO

Sep 13, 2006

Hi,

I've been working for about 20 years now with databases on other platforms but am at my first step with ADO. I created an application which is drawing as requested different forms on screen using GDI+, eventually DirectX. Now I'm at the stage of saving several infos into a Database.

For simplicity, I would like to use a database for which there is no need to install any other components. I thought of using Access Database but I realized that I'm unable to create it except from Microsoft Access which is not installed on my machine...

When programming with Clarion (SoftVelocity), apart interfacing with Oracle, any other files (ex: TopSpeed files) could be designed from within application designer and then created from scratch by resulting application. Considering this, is there any type of database that I can use and can be created/designed directly from within Visual Studio 2005?

My goal is that, if I distribute an application, I don't want my people to install anything else than simply install the resulting .exe file which should then be able to create by itself, when necessary, any database files it needs. Am I dreaming?

Thanks in advance,

Stéphane

View 27 Replies View Related

Newbie Question About SQL Server 2005

May 12, 2007

Hi, I have a very newbie question.I have been only developing websites locally on my computer (during my learning curve) and never actually put anything up in a server on internet, but I just bought a server from discountasp.net and an extra SQL 2005 Database.Now I need to put my database on that server (copy the local one) I know I have a connection string and username and password. But I really do not have any ideas how to do this.I would appreciate if you tell me where to start and what I should do at this stage.Thank you and have a good day. 

View 4 Replies View Related

MS SQL Server 2005 Newbie Tutorials Available?

Aug 29, 2006

I am trying to learn MS Sql Server and MS VB, ASP, .Net, etc., have installed SQL Server 2005 and Visual Studio 2005 on an XP Pro machine. I find fairly good MSDN help with VB & ASP stuff, but not with SQL Server. Can anyone recommend a good place to start, like online tutorials, or training, or even a good basic book that can show me how to create db’s, tables, load data, basic stuff like that?

View 3 Replies View Related

Install Help For SQL Server 2005 Newbie

Feb 28, 2006

I want to install SQL Server so at least the tables are stored on a D: drive rather than the default C: drive. If I can get the whole thing there, it would be best.

While installing S.S. the first time, I only came across one place to change a directory. After changing it, tables were still placed on the C: drive.

I am working with SQL Server 2005 Standard edition and using default settings, except for the directory of course.

Thanks for your help.

Steve

View 1 Replies View Related

XML Newbie: Sql 2005 Compliance To XML Standards

Nov 24, 2006

I was told that XML names must not start with the letters xml (or XML, or Xml, etc) But I was able to store such data in sql 2005. Any thoughts on this one?

TIA,



Barkingdog



View 1 Replies View Related

Sql Server Express 2005 Newbie: Bcp Utility

Mar 8, 2008

I'm trying to learn how to use the bcp utility... but I keep getting an error message that says:
SQLState = 08001, NativeError = 2Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].SQLState = HYT00, NativeError = 0Error = [Microsoft][SQL Native Client]Login timeout expiredSQLState = 08001, NativeError = 2Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
 The command i'm running is:
bcp territore.dbo.import in territorydata.csv -T -c
territore is my database name... and dbo i think is the owner name.
and the table is called Import
I don't know how to check the default settings to see if remote connections are enabled.  Any help would be appreciated.

View 6 Replies View Related

Newbie Question: WinApp Authentication To SQL 2005

Jan 5, 2007

I'm developing a small WinForms windows application (in c#). The application will communicate with an SQL 2005 server on the same network. I'm not able to use windows integrated authentication since the client users will not be members of the same domain as the SQL server.

The thing is, I want the program to Identify itself as the same user in the database regardless of witch user that is logging in. In other words, a separate SQL-access account. The complete end user authentication will be against credentials stored inside my database. In this way I will not have to create separate database users for each user.

This would be easy solved if I stored the common sql-server account somewhere inside the application, however I realise that it's not a good idéa. (The saved password will not be safe)

So, my question is: Is there some "best practise" way of solving this problem?

Regards Andreas

View 3 Replies View Related

Newbie Sql Server 2005 Question About Dimension

Jan 8, 2008



Hi ,
Can i make a dimension from only one table in data source views?
And is possible add dimension without Wizard?
Thanks a lot
Fabrizio

View 1 Replies View Related

Newbie Clr Vc++ Vs.net 2005 Setting Up To Call Stored Procedure

Aug 16, 2007

Hi,
I am using vs .net 2005, .net frameworks v3.0, vc++ 2005, clr, on vista
I am trying to write a c++ app to call a sql stored procedure.

the following code genrates an error trap and I don't know why:

String ^myConnectionString = "Initial Catalog=ncxSQL;Data
Source=ENVISION-MOD;Integrated Security=SSPI;";
SqlConnection ^myConnection;
myConnection->ConnectionString = myConnectionString;

Any words of wisdom?

View 4 Replies View Related

Newbie Here With A Newbie Error - Getting Database ... Already Exists.

Feb 24, 2007

Hi there
I sorry if I have placed this query in the wrong place.
I'm getting to grips with ASP.net 2, slowly but surely! 
When i try to access my site which uses a Sql Server 2005 express DB i am receiving the following error:

Server Error in '/jarebu/site1' Application.


Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:



[SqlException (0x80131904): Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.
Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735075
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360



Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
 
 This is the connection string that I am using:
 <connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;Initial Catalog=ASPNETDB;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
 
The database is definitly in the folder that the error message relates to.
What I'm finding confusing is that the connection string seems to be finding "aranga"s database.
Is it something daft?
 
Many thanks.
James 

View 1 Replies View Related

Newbie To Remote SQL 2005 Express - Need Roles/security Advice

Aug 30, 2006

Hi,I'm
building an asp.net website using web developer express and I have a
SQL 2005 express install on the same machine.  Using windows security,
everything works fine for development.Now I need to get it working at the client site, where the web server and SQL 2005 Express are on different machines.I'd
tried using windows authentication but that didn't work, probably
wasn't doing it correctly.  I'd like to try SQL Authentication, at least temporarily, since I
can replicate that on my laptop at home easily I think.I created a new SQL login but was really baffled by the screens showing roles and schemas, etc.   There's so many roles to choose from and wasn't sure if this new login needed to own any schemas. I
did turn on remote connections and mixed-mode authentication, the
probably now is my asp.net membership provider login page isn't
authenticating correctly, maybe my permissions are wrong on the
aspnet_.....  tables for users, roles, profiles, etc. Any advice?thanks,Bruce

View 3 Replies View Related

SQL Server 2005 Managment Studio Newbie: Can't See Stored Procedure

Oct 3, 2006

I just created a stored procedure in SQL Server 2005 management studio.  I went to my db and expanded the programmability folder then right clicked the stored procedures folder and created a stored procedure.  I saved the procedure as sp_getDistance in the default folder SQL managment studio picked.  Now when I went back to that stored procedure folder I did not see my stored procedure sp_getDistance, all that was there was the system stored procedure folder.  Did I save the stored procedure in the wrong place, or what did I do wrong.  I can't find the procedure anywhere, its just sitting in my My DocumentsSQL Server Management StudioProjectssp_getDistance.sql folder. Thanks,Kyle Spitzer 

View 1 Replies View Related

Newbie Question, Moving Data Between Sql Server 2000 And 2005

Jun 7, 2006

Hi,

I'm a newbie on SSIS and am trying to grasp my way through this.



I am trying to copy data from a Sql Server 2000 database to a simplified table in Sql Server 2005 database.



What I want is to move the data to a staging table, then drop the main
table and rename the staging table to the main table, to minimize the
down-time of the data. I can't get the workflow to work, because the
staging table has to exist when I run the package. I thought I could
use an "Execute SQL" task to generate the table before I would run the
task, but that doesn't work. Am I going about this the wrong way? Is
there an optimal solution to this problem so my data can be accessible
as much as possible.



Regards,

Atli

View 5 Replies View Related

Newbie Question: How To Move A Package From BIDS To SQL Server 2005

Feb 8, 2006

HI,

I have problems with executing packages in the SQL Server 2005 and before I go into the details I would like to check, if my workflow is correct.

Can someone explain me the best way to move a package from BIDS to a SQL Server? I would like to store the packages in the SQL Server.

In addition if I login to Integration Services with SQL Server Management Studio I can see in the folder "stored packages" my package but I cannot view the folder "MSDB". Ususally I receive an error message from the named pipe provider, that I could not connect to the server (I am using Windows Authentication and my login is an administrator on the SLQ Server box)



Thanks in advvance

Nobs

View 3 Replies View Related

Newbie Question- SQL Server 2005 Management Studio(how To Install SISS)

Nov 1, 2007



Hi all,

Im currently using SQL server 2005 Management Studio. I need to export files from SQL database to Access database.
But I dun think SISS is installed. Can anyone advise where to look for the file to install? Thks in advance.

Wee

View 5 Replies View Related

Need Help With Trigger Sql Server 2005

Oct 16, 2006

I am trying to create this trigger

CREATE TRIGGER User_Insert ON aspnet_users AFTER UPDATE AS
IF UPDATE (UserId)
insert into users (aspnet_user_id, username)
select au.userid, au.username
from aspnet_users au
where au.userid != users.aspnet_user_id;

Whenever the aspnet_users table has a new user added I want the Userid and username fields from that table inserted into the
the aspnet_user_id and username fileds of the users table.

when creating the trigger I get the following error..

Msg 4104, Level 16, State 1, Procedure User_Insert, Line 3
The multi-part identifier "users.aspnet_user_id" could not be bound.

View 6 Replies View Related

SQL 2005 : AFTER INSERT - Trigger

Jun 7, 2007

Is it possible to create a trigger in one database, that after aninsert, will update a database on a different server?If so, how would I do this?Thanks.Bill

View 1 Replies View Related

Email Trigger In SQL 2005

Jun 2, 2006

I am new to developing as will be evident from this post. Your help will be greatly appreciated.

I am developing an intranet for our company using ASP.NET with a SQL backend. I am currently working on a suggestion box form.

I would like to have an email sent to specific persons when a new entry is made in the suggestion table. I have been able to configure the trigger and generate the email (This was easy). Formatting the email has proven more difficult to resolve.

The format I would like is somewhat as follows:

F_NAME L_NAME submitted the following suggestion:

IDEA

BENEFIT

APPROVE | DECLINE

The items in RED are columns in the table and the Blue Underlines are hyperlinks to change the Status column in the table.

How can I generate the email to contain the data from the inserted record and in the above format.

Being new at this I only now how to send a static email advising that the entry has been made.

Any help creating the dynamic email form for this trigger will be greatly appreciated.

Lastly, what books are most helpful for SQL, ASP.NET, and VBScript referencing and examples?

Thanks

View 4 Replies View Related

SQL 2005 Server &&amp; CLR Trigger...

Oct 15, 2007

Hello,

I'm having problems with a CLR Trigger trying to get it to work with SQL Server... and i believe it is because permissions... basicly i want to make my trigger get the name of a newly created database and then look for
a table and then see if is empty... then add some rows... thats all...

I have set my databases as Trustworthy and also i have enabled the "clr enabled" parameter...
i mark my project as "Safe" in the Project properties... and it still doesn't work... do i need to
sign my project..? if so.. how?

i'm clueless...

Thank You.!




Code Block
'Table_1' table
- Unable to create table.
A .NET Framework error occurred during execution of user-defined routine or aggregate "Trigger1":
System.Security.HostProtectionException: Attempted to perform an operation that was forbidden by the CLR host.
The protected resources (only available with full trust) were: All
The demanded resources were: UI
System.Security.HostProtectionException:
at System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Assembly asm, PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh, SecurityAction action, Object demand, IPermission permThatFailed)
at System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Object assemblyOrString, PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh, SecurityAction action, Object demand, IPermission permThatFailed)
at System.Security.CodeAccessSecurityEngine.CheckSetHelper(PermissionSet grants, PermissionSet refused, PermissionSet demands, RuntimeMethodHandle rmh, Object assemblyOrString, SecurityAction action, Boolean throwException)
at System.Security.CodeAccessSecurityEngine.CheckSetHelper(CompressedStack cs, PermissionSet grants, PermissionSet refused, PermissionSet demands, RuntimeMethodHandle rmh, Assembly asm, SecurityAction action)
at Triggers.Trigger1()
.
The statement has been terminated.


View 3 Replies View Related

How To Call TRIGGER In VB.net 2005

Sep 26, 2007

i hav written a trigger in SQLEXPRESS DB but i dnt knw how to call in vb.net 2005...

View 2 Replies View Related

Does SQL Server 2005 Exsit The Trigger ?

Jan 15, 2007

When the database starts,I want to startup a trigger to do something,how can I do ?
I know there are two kinds of trigger in SQL Server 2005 ,one is DML trigger and the another is DDL trigger
Could you tell me ,Is there a trigger for database level in SQL Server 2005 ?
I know there is this kind of trigger in oracle .

View 3 Replies View Related

Sqlserver 2005 Trigger Error

Oct 17, 2007

hi.......
i create a trigger after delete which work perfactly fine on one sqlserver2005 machine but not at another.......machine having sqlserver2005
this trigger effect 15 tables from which i am deleting data...when trigger fires.....
now it cause following error when i fire ir on another machine
error source: .net sql client data provider
error message:maximun stored procedure,triggers,functions,or view nesting level exceeded (limit 32)
plzzzz give da solution.....its really frustrating me....
thanks in advance

View 5 Replies View Related

How To Save Trigger Into Table In Sql 2005

Dec 22, 2007

I have found the node for Triggers in SQL Server 2005's Management Studio and tried to create a 'New Trigger...' but when I save, it saves it to an .sql file but do not attach it to the table.What am I doing wrong here? I can't seem to attach it. And where is this Assisted Editor ...i can't seem to find it anywhere

View 2 Replies View Related

How Can I Debug A Trigger In SQL Server 2005?

Jan 10, 2008

Hello,I have a form in a web application. When I submit the form it inserts the record into the SQL Server 2005 database. I have an insert trigger. My question is how can i debug the trigger? the trigger then calls a CLR based stored procedure, again how can i debug this CLR stored procedure which gets called by the trigger. Thanks...kindly advice. 

View 2 Replies View Related

Sql 2005 Trigger Insert And Dbmail

Apr 23, 2008

I have a stored proc that inserts records into a table, gets the identity, and uses that identity on a .net webpage. The page retrieves that identity key and processes some stuff on the page.

Everything was working fine until I tried to enable sql mail with triggers. I wanted to double-check some stuff, so I requested an sql email be sent whenever an insert occurs on the table above. Here's what I think is happening --- please correct and/or help me out with a work around?

I use the stored proc to insert a record.
I select the @@identity.
The trigger fires but uses select to retrieve the latest insert - thereby replacing the @@identity number returned to the page?

If this is true, could I do something like the following in the original stored proc? Is this a good idea or bad idea?

BEGIN
Declare @myID as int, @myBody1 as varChar(200)
Set @myID=0
INSERT INTO table (fields) VALUES (@PID, more stuff);
Set @myID = SELECT @@IDENTITY As [Identity];
If @myID<>0
Begin
Set @body1='<br />pid=' + more stuff.....
Exec msdb.dbo.sp_send_dbmail
@profile_name='profileName',
@recipients='email@email.com',
@subject='Temp History Insert',
@body=@body1,
@body_format= 'HTML' ;
End
END

View 3 Replies View Related

Sql Server 2005 &#043; Row Level Trigger

Jul 18, 2006

hi
i want to know if row level trigger works with sql 2005.
because in 2000.. only statement level trigger was used.

Thks in advance.

View 3 Replies View Related

Sql Server 2005 &#043; Row Level Trigger

Jul 19, 2006

hi
actually i have a temporay table wich has four columns
say col_1,col_2,col_3,col_4.
so firstly i wud bulk insert from a text file wich mite contain thousands of rows.
then from this temp table col_1 and col_2 shd go to master_a.wich has an identiy column as primary key.
say id,col_1, col_2.

i will have another table detail_b where in there is a foreign key to the table master_a for id.
so it will have f_id, col_3,col_4.

so i am riting a trigger on master_a. so whenver row is inserted in master_a. coresponding id and col 3 col4 shd be inserted into detail_b.

For this in oracle we have row level trigger. where in for each insertion in master a .. correspoding trigger will fire but in sql 2000..
but i wud like to implemtn row level trigger..
can u hlep me out..

View 1 Replies View Related







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