Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 WITH EXECUTE_AS not working for sproc.
 Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

MuadDBA
Aged Yak Warrior

USA
628 Posts

Posted - 07/31/2013 :  16:27:14  Show Profile  Reply with Quote
I have the following sproc which is trying to gather information from the plan cache, but it fails when executed. Relevant information: POL_SSV is a SQL Server login with VIEW SERVER STATE permission.

ALTER PROCEDURE [dbo].[Sproc_Execution_Plan_Get]
(
 @Stored_Procedure_Name VARCHAR(200)
)
WITH EXECUTE AS 'POL_SSV'
AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

-- Purpose: Return execuction plan in XML to help our partners with performance tuning

Declare 
 @Stored_Procedure_Specific_Name VARCHAR(128),
 @Plan_Handle VARCHAR(75)
 
SELECT @Stored_Procedure_Specific_Name = SP.Stored_Procedure_Specific_Name
FROM Stored_Procedure AS SP
WHERE SP.Stored_Procedure_Name = @Stored_Procedure_Name
 AND SP.PUN = 685563--CAST(PARSENAME(SUSER_NAME(),1) AS INT)

--THIS IS WHERE IT FAILS!!!
SELECT @Plan_Handle = CP.plan_handle
FROM sys.dm_exec_cached_plans AS CP
CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) AS st
WHERE OBJECT_NAME(st.objectid,st.dbid) = @Stored_Procedure_Specific_Name


One thing to note: I have tried using "SETUSER" on this DB (which is SQL 2008 EE), and I get the following error:
Setuser failed because of one of the following reasons: the database principal 'POL_SSV' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

However, the server principal and database principal exist, have access to the database, and there is nothing special that should prevent them from being impersonated. I get this error no matter what user I try to impersonate.

visakh16
Very Important crosS Applying yaK Herder

India
52326 Posts

Posted - 08/01/2013 :  03:00:42  Show Profile  Reply with Quote
which account are you executing the procedure from? yur own logged in account?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

MuadDBA
Aged Yak Warrior

USA
628 Posts

Posted - 08/01/2013 :  07:51:41  Show Profile  Reply with Quote
The goal is to have an end user account be able to execute it, but it fails when executing it using my account, which is a sysadmin level.
Go to Top of Page

troubleshootingsql
Starting Member

3 Posts

Posted - 08/01/2013 :  09:15:30  Show Profile  Reply with Quote
Have you tried something like this:
alter PROCEDURE [dbo].[Sproc_Execution_Plan_Get]
(
@Plan_Handle VARCHAR(75)
)
AS
SET NOCOUNT ON
execute as login = '<use which has view server state privs>';
select * from sys.dm_exec_cached_plans

Amit Banerjee
www.TroubleshootingSQL.com
www.facebook.com/TroubleshootingSQL
http://twitter.com/banerjeeamit
Go to Top of Page

MuadDBA
Aged Yak Warrior

USA
628 Posts

Posted - 08/01/2013 :  09:59:59  Show Profile  Reply with Quote
When I try it with an SA account, it works. However, when I try it with a user account, I get: Msg 15406, Level 16, State 1, Procedure Sproc_Execution_Plan_Get, Line 11
Cannot execute as the server principal because the principal "POL_SSV" does not exist, this type of principal cannot be impersonated, or you do not have permission.
Go to Top of Page

troubleshootingsql
Starting Member

3 Posts

Posted - 08/01/2013 :  10:16:21  Show Profile  Reply with Quote
The non-sysadmin login should be mapped as a database user in which the stored procedure exists.

Amit Banerjee
www.TroubleshootingSQL.com
www.facebook.com/TroubleshootingSQL
http://twitter.com/banerjeeamit
Go to Top of Page

troubleshootingsql
Starting Member

3 Posts

Posted - 08/01/2013 :  10:56:50  Show Profile  Reply with Quote
Sequence of events:
1. Create a plan_admin login and grant it view server state priv
2. Create a retrieve_plan login and grant it impersonate priv on the plan_admin login
3. Create the procedure to fetch the plan using the EXECUTE AS LOGIN priv in a user database
4. Create a database user for both logins in #1 and #2
5. Grant execute permissions on the procedure created in #4 to retrieve_plan user

The above works in my case

Amit Banerjee
www.TroubleshootingSQL.com
www.facebook.com/TroubleshootingSQL
http://twitter.com/banerjeeamit
Go to Top of Page

MuadDBA
Aged Yak Warrior

USA
628 Posts

Posted - 08/01/2013 :  13:26:47  Show Profile  Reply with Quote
Thanks Amit. I was trying to avoid having to grant specific permissions to several hundred logins by using this sproc. With the GRANT IMPERSONATE requirement, it does not seem like that is possible, which is unfortunate. I might as well just grant VIEW SERVER STATE to all 200 users.
Go to Top of Page

Lamprey
Flowing Fount of Yak Knowledge

4614 Posts

Posted - 08/01/2013 :  13:47:21  Show Profile  Reply with Quote
I'd sugges that you don't (and shouldn't) do it by user. Rather you should set up a Database Role. You assign that role permissons in the DB. Then you can either add the users to that role or create a security group in Windows/Active Directory and use that to manage access.
Go to Top of Page

rhein
Starting Member

9 Posts

Posted - 12/17/2017 :  03:01:33  Show Profile  Reply with Quote
<strong><a href="http://www.polo-sales.com/sv/">moncler sjal internetbutik","prefixWrap":0,"src":"moncler shawl online store","relation":[],"result":""},{</a></strong><br><strong><a href="http://www.polo-sales.com/sv/moncler-tillbeh%C3%B6r-c-9.html">moncler mode.","prefixWrap":0,"src":"Moncler fashion boots","relation":[],"result":""},{</a></strong><br>[b][url=http://www.polo-sales.com/sv/]hög kvalitet moncler rockar.","prefixWrap":0,"src":"high quality moncler coats","relation":[],"result":""},{[/url][/b][b][url=http://www.polo-sales.com/sv/]moncler tillbehör för kvinnor","prefixWrap":0,"src":"Moncler accessory for women","relation":[],"result":""},{[/url][/b][b][url=http://www.polo-sales.com/sv/]Moncler jackor för män[/url][/b]Moncler Män Jackor Outlet Sale US Dollar Euro GB Pound Canadian Dollar Australian Dollar Jappen Yen Norske Krone Swedish Krone Danish Krone CNY --> Valuta US Dollar Euro GB Pound Canadian Dollar Australian Dollar Jappen Yen Norske Krone Swedish Krone Danish Krone CNYKategorier[url=http://www.polo-sales.com/sv/moncler-kvinnor-rockar-c-2.html]Moncler Kvinnor Rockar[/url][url=http://www.polo-sales.com/sv/moncler-nyanl%C3%A4nd-c-6.html]Moncler Nyanländ[/url][url=http://www.polo-sales.com/sv/moncler-barn-c-8.html]Moncler Barn[/url][url=http://www.polo-sales.com/sv/moncler-kvinnor-jackor-c-3.html]Moncler Kvinnor jackor[/url][url=http://www.polo-sales.com/sv/moncler-kvinnor-v%C3%A4star-c-5.html]Moncler Kvinnor västar[/url][url=http://www.polo-sales.com/sv/moncler-m%C3%A4n-jackor-c-1.html]Moncler Män jackor[/url]<a class="category-top" href="http://www.polo-sales.com/sv/moncler-m%C3%A4n-v%C3%A4star-c-7.html">Moncler Män västar</a>[url=http://www.polo-sales.com/sv/moncler-mens-coats-c-4.html]Moncler Mens Coats[/url][url=http://www.polo-sales.com/sv/moncler-tillbeh%C3%B6r-c-9.html]Moncler tillbehör[/url]Utvalda - [url=http://www.polo-sales.com/sv/featured_products.html] [mer][/url][url=http://www.polo-sales.com/sv/moncler-kids-long-dunjackor-pink-outlet-p-146.html]Moncler Kids Long dunjackor Pink Outlet[/url]<a class="sidebox-products" href="http://www.polo-sales.com/sv/moncler-kids-long-dunjackor-pink-outlet-p-146.html">Moncler Kids Long dunjackor Pink Outlet</a>SEK 3,046 SEK 2,184Spara: 28% mindre[url=http://www.polo-sales.com/sv/moncler-red-mock-collar-zipper-och-slash-m%C3%A4n-jackor-p-76.html]Moncler Red Mock Collar Zipper och Slash män jackor[/url][url=http://www.polo-sales.com/sv/moncler-red-mock-collar-zipper-och-slash-m%C3%A4n-jackor-p-76.html]Moncler Red Mock Collar Zipper och Slash män jackor[/url]SEK 4,542 SEK 3,101Spara: 32% mindre<a href="http://www.polo-sales.com/sv/moncler-brun-mock-collar-och-slash-short-m%C3%A4n-coats-p-59.html"><img src="http://www.polo-sales.com/sv/images/_small//moncler108/Moncler-Mens-Coats/Moncler-Down-Brown-Mock-Collar-And-Slash-Short.jpg" alt="Moncler Brun Mock Collar och Slash Short Män Coats" title=" Moncler Brun Mock Collar och Slash Short Män Coats " width="130" height="130" /></a>[url=http://www.polo-sales.com/sv/moncler-brun-mock-collar-och-slash-short-m%C3%A4n-coats-p-59.html]Moncler Brun Mock Collar och Slash Short Män Coats[/url]SEK 3,771 SEK 2,661Spara: 29% mindre <a href="http://www.polo-sales.com/sv/">Hem</a> :: Moncler Män jackorMoncler Män jackorFilter Results by: Produkter startar med ... A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0 1 2 3 4 5 6 7 8 9Visar [b]1[/b] till [b]24[/b] (av [b]29[/b] produkter) 1[/b] <a href="http://www.polo-sales.com/sv/moncler-m%C3%A4n-jackor-c-1.html?page=2&sort=20a" title=" Sida 2 ">2</a> [url=http://www.polo-sales.com/sv/moncler-m%C3%A4n-jackor-c-1.html?page=2&sort=20a][Nästa >>][/url] [url=http://www.polo-sales.com/sv/moncler-beige-mock-collar-zipper-och-slash-m%C3%A4n-jackor-p-217.html]Moncler Beige Mock Collar Zipper och Slash män jackor[/url][url=http://www.polo-sales.com/sv/moncler-beige-mock-collar-zipper-och-slash-m%C3%A4n-jackor-p-217.html]Moncler Beige Mock Collar Zipper och Slash män jackor[/url]Moncler Mode Beige Mock Collar Zipper och...SEK 4,652 SEK 3,092Spara: 34% mindre[url=http://www.polo-sales.com/sv/moncler-black-and-claret-cap-zipper-och-slash-m%C3%A4n-jackor-p-279.html]Moncler Black And Claret Cap Zipper och Slash Män Jackor[/url][url=http://www.polo-sales.com/sv/moncler-black-and-claret-cap-zipper-och-slash-m%C3%A4n-jackor-p-279.html]Moncler Black And Claret Cap Zipper och Slash Män Jackor[/url]Moncler Black And Claret Cap Zipper och...SEK 3,358 SEK 2,386Spara: 29% mindre[url=http://www.polo-sales.com/sv/moncler-black-cap-zipper-och-slash-m%C3%A4n-jackor-outlet-p-1.html]Moncler Black Cap Zipper och Slash Män Jackor Outlet[/url][url=http://www.polo-sales.com/sv/moncler-black-cap-zipper-och-slash-m%C3%A4n-jackor-outlet-p-1.html]Moncler Black Cap Zipper och Slash Män Jackor Outlet[/url]Moncler Black Cap Zipper och Slash Män...SEK 3,514 SEK 2,679Spara: 24% mindre[url=http://www.polo-sales.com/sv/moncler-black-cap-zipper-och-slash-m%C3%A4n-jackor-outlet-p-94.html]Moncler Black Cap Zipper och Slash Män Jackor Outlet[/url][url=http://www.polo-sales.com/sv/moncler-black-cap-zipper-och-slash-m%C3%A4n-jackor-outlet-p-94.html]Moncler Black Cap Zipper och Slash Män Jackor Outlet[/url]Moncler Black Cap Zipper och Slash Män...SEK 3,844 SEK 2,642Spara: 31% mindre[url=http://www.polo-sales.com/sv/moncler-bright-green-h%C3%B6g-krage-kort-slim-m%C3%A4n-jackor-p-303.html]Moncler Bright Green Hög krage Kort Slim Män Jackor[/url][url=http://www.polo-sales.com/sv/moncler-bright-green-h%C3%B6g-krage-kort-slim-m%C3%A4n-jackor-p-303.html]Moncler Bright Green Hög krage Kort Slim Män Jackor[/url]Moncler Bright Green Hög krage Kort Slim...SEK 3,303 SEK 2,312Spara: 30% mindre[url=http://www.polo-sales.com/sv/moncler-bright-purple-h%C3%B6g-krage-korta-varma-m%C3%A4n-jackor-p-331.html]Moncler Bright Purple Hög krage Korta Varma män jackor[/url][url=http://www.polo-sales.com/sv/moncler-bright-purple-h%C3%B6g-krage-korta-varma-m%C3%A4n-jackor-p-331.html]Moncler Bright Purple Hög krage Korta Varma män jackor[/url]Moncler Bright Purple Hög krage Korta...SEK 2,918 SEK 2,092Spara: 28% mindre[url=http://www.polo-sales.com/sv/moncler-bright-purple-short-m%C3%A4n-jackor-med-mock-collar-p-2.html]Moncler Bright Purple Short män jackor med Mock Collar[/url][url=http://www.polo-sales.com/sv/moncler-bright-purple-short-m%C3%A4n-jackor-med-mock-collar-p-2.html]Moncler Bright Purple Short män jackor med Mock Collar[/url]Moncler Bright Purple Short män jackor med...SEK 3,753 SEK 2,661Spara: 29% mindre<a href="http://www.polo-sales.com/sv/moncler-claret-mock-collar-zipper-och-slash-m%C3%A4n-jackor-p-80.html"><div style="vertical-align: middle;height:250px"><img src="http://www.polo-sales.com/sv/images/_small//moncler108/Moncler-Mens-Jackets/Moncler-Down-Claret-Mock-Collar-Zipper-And-Slash.jpg" alt="Moncler Claret Mock Collar Zipper och Slash män jackor" title=" Moncler Claret Mock Collar Zipper och Slash män jackor " width="180" height="180" class="listingProductImage" id="listimg" /></div></a>[url=http://www.polo-sales.com/sv/moncler-claret-mock-collar-zipper-och-slash-m%C3%A4n-jackor-p-80.html]Moncler Claret Mock Collar Zipper och Slash män jackor[/url]Moncler Claret Mock Collar Zipper och Slash...SEK 2,615 SEK 1,807Spara: 31% mindre[url=http://www.polo-sales.com/sv/moncler-claret-mock-collar-zipper-slash-och-fickor-jackor-p-103.html]Moncler Claret Mock Collar Zipper Slash och fickor Jackor[/url][url=http://www.polo-sales.com/sv/moncler-claret-mock-collar-zipper-slash-och-fickor-jackor-p-103.html]Moncler Claret Mock Collar Zipper Slash och fickor Jackor[/url]Moncler Claret Mock Collar Zipper Slash och...SEK 2,633 SEK 1,826Spara: 31% mindre[url=http://www.polo-sales.com/sv/moncler-korta-varma-gr%C3%A5-jackor-med-mock-collar-och-slash-p-230.html]Moncler Korta Varma Grå jackor med Mock Collar och Slash[/url][url=http://www.polo-sales.com/sv/moncler-korta-varma-gr%C3%A5-jackor-med-mock-collar-och-slash-p-230.html]Moncler Korta Varma Grå jackor med Mock Collar och Slash[/url]Moncler Korta Varma grå män jackor med...SEK 3,340 SEK 2,422Spara: 27% mindre[url=http://www.polo-sales.com/sv/moncler-m%C3%A4n-kaki-jackor-med-dragkedja-och-fickor-p-361.html]Moncler Män Kaki jackor med dragkedja och fickor[/url]<a href="http://www.polo-sales.com/sv/moncler-m%C3%A4n-kaki-jackor-med-dragkedja-och-fickor-p-361.html">Moncler Män Kaki jackor med dragkedja och fickor</a>Moncler Män Kaki jackor med dragkedja och...SEK 3,835 SEK 2,835Spara: 26% mindre<a href="http://www.polo-sales.com/sv/moncler-mock-collar-och-slash-claret-varma-m%C3%A4n-jackor-p-306.html"><div style="vertical-align: middle;height:250px"><img src="http://www.polo-sales.com/sv/images/_small//moncler108/Moncler-Mens-Jackets/Moncler-Down-Mock-Collar-And-Slash-Claret-Warm.jpg" alt="Moncler Mock Collar och Slash Claret Varma män jackor" title=" Moncler Mock Collar och Slash Claret Varma män jackor " width="178" height="250" class="listingProductImage" id="listimg" /></div></a>[url=http://www.polo-sales.com/sv/moncler-mock-collar-och-slash-claret-varma-m%C3%A4n-jackor-p-306.html]Moncler Mock Collar och Slash Claret Varma män jackor[/url]Moncler Mock Collar och Slash Claret Varma...SEK 3,000 SEK 2,028Spara: 32% mindre[url=http://www.polo-sales.com/sv/moncler-mock-collar-zipper-slash-och-fickor-gr%C3%B6na-jackets-p-48.html]Moncler Mock Collar Zipper Slash och fickor Gröna Jackets[/url][url=http://www.polo-sales.com/sv/moncler-mock-collar-zipper-slash-och-fickor-gr%C3%B6na-jackets-p-48.html]Moncler Mock Collar Zipper Slash och fickor Gröna Jackets[/url]Moncler Mock Collar Zipper Slash och fickor...SEK 3,156 SEK 2,266Spara: 28% mindre[url=http://www.polo-sales.com/sv/moncler-mode-h%C3%B6g-krage-slim-brown-m%C3%A4n-jackor-p-62.html]Moncler Mode Hög krage Slim Brown Män Jackor[/url][url=http://www.polo-sales.com/sv/moncler-mode-h%C3%B6g-krage-slim-brown-m%C3%A4n-jackor-p-62.html]Moncler Mode Hög krage Slim Brown Män Jackor[/url]Moncler Mode Hög krage Slim Brown Män...SEK 2,808 SEK 1,918Spara: 32% mindre[url=http://www.polo-sales.com/sv/moncler-mode-m%C3%A4n-jackor-med-mock-collar-och-slash-p-382.html]Moncler Mode män jackor med Mock Collar och Slash[/url]<a href="http://www.polo-sales.com/sv/moncler-mode-m%C3%A4n-jackor-med-mock-collar-och-slash-p-382.html">Moncler Mode män jackor med Mock Collar och Slash</a>Moncler Mode män jackor med Mock Collar...SEK 3,257 SEK 2,211Spara: 32% mindre[url=http://www.polo-sales.com/sv/moncler-m%C3%B6rkgr%C3%B6n-fur-krage-och-zipper-m%C3%A4n-jackor-p-221.html]Moncler Mörkgrön Fur krage och Zipper Män Jackor[/url][url=http://www.polo-sales.com/sv/moncler-m%C3%B6rkgr%C3%B6n-fur-krage-och-zipper-m%C3%A4n-jackor-p-221.html]Moncler Mörkgrön Fur krage och Zipper Män Jackor[/url]Moncler Mörkgrön Fur krage och Zipper...SEK 3,771 SEK 2,679Spara: 29% mindre[url=http://www.polo-sales.com/sv/moncler-orange-h%C3%B6g-krage-zipper-och-slash-m%C3%A4n-jackor-p-265.html]Moncler Orange Hög krage Zipper och Slash Män Jackor[/url][url=http://www.polo-sales.com/sv/moncler-orange-h%C3%B6g-krage-zipper-och-slash-m%C3%A4n-jackor-p-265.html]Moncler Orange Hög krage Zipper och Slash Män Jackor[/url]Moncler Mode Orange Hög krage Zipper och...SEK 3,688 SEK 2,496Spara: 32% mindre[url=http://www.polo-sales.com/sv/moncler-popul%C3%A4ra-mock-collar-och-slash-coffee-m%C3%A4n-jackor-p-104.html]Moncler Populära Mock Collar och Slash Coffee Män Jackor[/url][url=http://www.polo-sales.com/sv/moncler-popul%C3%A4ra-mock-collar-och-slash-coffee-m%C3%A4n-jackor-p-104.html]Moncler Populära Mock Collar och Slash Coffee Män Jackor[/url]Moncler Populära Mock Collar och Slash...SEK 3,386 SEK 2,285Spara: 33% mindre<a href="http://www.polo-sales.com/sv/moncler-red-mock-collar-zipper-och-slash-m%C3%A4n-jackor-p-76.html"><div style="vertical-align: middle;height:180px"><img src="http://www.polo-sales.com/sv/images/_small//moncler108/Moncler-Mens-Jackets/Moncler-Down-Red-Mock-Collar-Zipper-And-Slash-Men.jpg" alt="Moncler Red Mock Collar Zipper och Slash män jackor" title=" Moncler Red Mock Collar Zipper och Slash män jackor " width="180" height="180" class="listingProductImage" id="listimg" /></div></a>[url=http://www.polo-sales.com/sv/moncler-red-mock-collar-zipper-och-slash-m%C3%A4n-jackor-p-76.html]Moncler Red Mock Collar Zipper och Slash män jackor[/url]Moncler Fashion Red Mock Collar Zipper och...SEK 4,542 SEK 3,101Spara: 32% mindre[url=http://www.polo-sales.com/sv/moncler-silver-fur-krage-och-slash-m%C3%A4n-jackor-p-258.html]Moncler Silver Fur krage och Slash män jackor[/url][url=http://www.polo-sales.com/sv/moncler-silver-fur-krage-och-slash-m%C3%A4n-jackor-p-258.html]Moncler Silver Fur krage och Slash män jackor[/url]Moncler Silver Fur krage och Slash män...SEK 3,147 SEK 2,477Spara: 21% mindre[url=http://www.polo-sales.com/sv/moncler-slim-m%C3%A4n-jackor-med-ljusa-r%C3%B6da-och-mock-collar-p-118.html]Moncler Slim män jackor med ljusa röda och Mock Collar[/url][url=http://www.polo-sales.com/sv/moncler-slim-m%C3%A4n-jackor-med-ljusa-r%C3%B6da-och-mock-collar-p-118.html]Moncler Slim män jackor med ljusa röda och Mock Collar[/url]Moncler Slim män jackor med ljusa röda...SEK 2,808 SEK 2,037Spara: 27% mindre[url=http://www.polo-sales.com/sv/moncler-slim-m%C3%A4n-jackor-med-mock-collar-p-293.html]Moncler Slim män jackor med Mock Collar[/url][url=http://www.polo-sales.com/sv/moncler-slim-m%C3%A4n-jackor-med-mock-collar-p-293.html]Moncler Slim män jackor med Mock Collar[/url]Moncler Slim män jackor med Mock Collar ...SEK 3,028 SEK 2,349Spara: 22% mindre[url=http://www.polo-sales.com/sv/moncler-svart-mock-collar-och-zipper-m%C3%A4n-jackor-p-305.html]Moncler Svart Mock Collar Och Zipper Män Jackor[/url][url=http://www.polo-sales.com/sv/moncler-svart-mock-collar-och-zipper-m%C3%A4n-jackor-p-305.html]Moncler Svart Mock Collar Och Zipper Män Jackor[/url]Moncler Svart Mock Collar Och Zipper Män...SEK 2,707 SEK 2,101Spara: 22% mindre[url=http://www.polo-sales.com/sv/moncler-svart-mock-collar-zipper-och-slash-m%C3%A4n-jackor-p-70.html]Moncler Svart Mock Collar Zipper och Slash män jackor[/url][url=http://www.polo-sales.com/sv/moncler-svart-mock-collar-zipper-och-slash-m%C3%A4n-jackor-p-70.html]Moncler Svart Mock Collar Zipper och Slash män jackor[/url]Moncler Svart Mock Collar Zipper och Slash...SEK 3,009 SEK 2,211Spara: 27% mindre Visar [b]1[/b] till [b]24[/b] (av [b]29[/b] produkter) 1[/b] [url=http://www.polo-sales.com/sv/moncler-m%C3%A4n-jackor-c-1.html?page=2&sort=20a]2[/url] [url=http://www.polo-sales.com/sv/moncler-m%C3%A4n-jackor-c-1.html?page=2&sort=20a][Nästa >>][/url] [url=http://www.polo-sales.com/sv/index.php]Home[/url] [url=http://www.polo-sales.com/sv/index.php?main_page=shippinginfo]Shipping[/url] [url=http://www.polo-sales.com/sv/index.php?main_page=Payment_Methods]Wholesale[/url] [url=http://www.polo-sales.com/sv/index.php?main_page=shippinginfo]Order Tracking[/url] [url=http://www.polo-sales.com/sv/index.php?main_page=Coupons]Coupons[/url] [url=http://www.polo-sales.com/sv/index.php?main_page=Payment_Methods]Payment Methods[/url] <a href="http://www.polo-sales.com/sv/index.php?main_page=contact_us">Contact Us</a> [url=http://www.outletmonclershop.com/]MONCLER STORE[/url] [url=http://www.outletmonclershop.com/]MONCLER WOMEN JACKETS[/url] [url=http://www.outletmonclershop.com/]MONCLER MEN JACKETS[/url] [url=http://www.outletmonclershop.com/]MONCLER KIDS[/url] [url=http://www.outletmonclershop.com/]MONCLER COAT[/url] [url=http://www.outletmonclershop.com/]MONCLER VEST[/url] [url=http://www.outletmonclershop.com/]MONCLER BOOTS[/url] [url=http://www.polo-sales.com/sv/moncler-m%C3%A4n-jackor-c-1.html][/url] Copyright © 2012 All Rights Reserved. [b][url=http://www.polo-sales.com/sv/]moncler sjal internetbutik","prefixWrap":0,"src":"moncler shawl online store","relation":[],"result":""},{[/url][/b][b][url=http://www.polo-sales.com/sv/moncler-tillbeh%C3%B6r-c-9.html]moncler mode.","prefixWrap":0,"src":"Moncler fashion boots","relation":[],"result":""},{[/url][/b][url=http://guccimessengerbags514.webs.com] blog [/url][url=http://fakeiwcwatch74.webs.com] [/url][url=http://monclersale44.webs.com] About polo-sales.com blog [/url]
Go to Top of Page
   Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000