SQL Maintance plan
Hi, Posted in the SQL mailing list but haven't heard anything, so figured I would try here. Hope some one can help with exporting a maintance plan from a MS SQL 2005 database. The servers are isolated. I need to be able to get a file on a CD to move the plans from one server to the other. I have found: Open SQL Server Management Studio Select File | Connect Object Explorer Change the Server Type to Integration Services and connect to the server Expand Servername (Integration Services) | Stored Packages | MSDB | Maintenance Plans Right Click on the Maintenance Plan and select Export But this only seems to let you export from/to servers you can contect at the same time thru SSMS. I don't see a way to save/export to a file. Is there a way to export the plan(s) to a file? Thanks Rodney ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288966 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: braindead duh!! moment with db
Don't know why you are getting the ds or Is. But a few things I would do are: Alias one of the designerIDs or remove it from the SELECT. Scope the vars #getItems.itemid##getItems.designerid#, something might be in designerid from another scope. Do a of the query and see what is in the recordset. See if you have ds in the recordset before you are outputting the data. If you have ds in the recordset from the then I would go back and run the query in the database and look at what is in the tables. -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Friday, August 31, 2007 3:10 PM To: CF-Talk Subject: RE: braindead duh!! moment with db Yes, it was abbreviated. And, yes I'm tired. I should have stated designerID not designerName? here's a snippet (MUCH IS CUT OUT) SELECT items.itemID, items.categoryID, items.itemTypeID, items.designerID, items.designerItemCode, items.itemName, items.itemDescShort, items.itemPrice, designers.designerID, designers.designerName, designers.designerNameWWW, designers.isActive, designers.hasDescriptionPage FROM items, designers WHERE items.designerID=designers.designerID -- #itemID# -- #designerID# I ought to get a list of numbers -- 77 -- 20 -- 78 -- 20 Etc.. Instead I get -- 77 -- d -- 77 -- d -- 78 -- d -- 78 -- d -- 78 -- d If I ran the query width itemTypes (changed the tables and fields) and put in itemTypeID instead of designerID I get a list with an i instead of a d. Go figure!? I swear these queries worked before! :-) ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287558 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DoD CAC authentication
Mike Very basic: When you go into IIS(what we use) and make the selection to accept/require certificates. You will then get the CGI.Cert_subject variable filled in ([empty string] when not accepting client certs). We broke this out into for variables we use: Cert_name, Cert_number, Cert_type,Cert_CACType mailto:[EMAIL PROTECTED] Sent: Monday, July 30, 2007 2:05 PM To: CF-Talk Subject: DoD CAC authentication I'm thinking of using CAC to provide a means of authenitcating users to a role controlled application. I've found little to cover this on the web over basic IIS "accept client certs" and wonder if anyone in community has worked on something similar. Best, Michael Miller ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286887 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4