RookieDBA's Q&A profile

• SQL Server GetDataDrivenSubscriptionProperties vs GetSubscriptionProperties

  Is there a similar method for Data Driven Subscriptions like there is for plain subscriptions ListSubscriptions. I would like to get SubscriptionID for use with the GetDataDrivenSubscriptionProperties just as I do for GetSubscriptionProperties. When I execute GetSubscriptionProperties for Data Driven Subscriptions there is no array of Subscriptions. Here is an examole of the code which I execute using rs.exe: Sub Main() 'Dim rs As New ReportingService() 'rs.Credentials = System.Net.CredentialCache.DefaultCredentials Dim DRPlan As DataRetrievalPlan Dim extSettings As ExtensionSettings Dim desc As String Dim active As ActiveState Dim status As String Dim eventType As String Dim matchData As Str ...Show All

• .NET Development TcpListener

  Hi. I'm trying to make a simple application which receives data from a local host and displays it. Everything works fine upto the point where it's supposed to connect to theclient. However, when I type in whatever I want to send, I keep waiting for it to come back...an eternity thingy. Heres the code: using System; using System.Collections.Generic; using System.Text; using System.IO; using System.Net; using System.Net.Sockets; namespace MyTcpListener { class Listener { public static void Main() { TcpListener server = null ; try { Int32 port = 9000; IPAddress localAddr = IPAddress .Parse( "127.0.0.1" ); server = new TcpListener (localAddr, ...Show All

• SQL Server Full Cached Lookup with Parameters

  Parameterized queries are only allowed on partial or none cache style lookup transforms, not 'full' ones. Is there some "trick" to parameterizing a full cache lookup, or should the join simply be done at the source, obviating the need for a full cache lookup at all (other suggestion certainly welcome) More particularly, I'd like to use the lookup transform in a surrogate key pipeline. However, the dimension is large (900 million rows), so its would be useful to restrict the lookup transform's cache by a join to the source. For example: Source query is: select a,b,c from t where z=@filter (20,000 rows) Lookup transform query: select surrogate_key,business_key from dimension (900 M rows, not tenable) Ideal Lookup ...Show All

• SQL Server insert or update statement depending on existance

  hi, i have a table bill defined as follows:(relevant fields) billidall billid reference pono amountFC type example 123 1 r3 ca1 100 amount 123 2 r3 ca1 10 vat 123 3 r3 ca1 20 duty 995 4 rc1 ca2 500 duty 521 5 ref1 ca2 400 amount now i have a table in my program having values.: 123 31 r3 ca1 990 amount 123 22 r3 ca1 99 vat 123 34 r3 ca1 20 duty 995 45 rc1 ca2 500 duty 111 66 re4 ca2 642 amount notice that billid is my pk. i need a way to mayb ...Show All

• Visual Studio Team System Team Project Creation error - TS to Sharepoint bug? assistance required!

  Running the TS 6 month trial edition - everything seemed to install ok. when trying to create a team server project from VS.NET 2005 wizard: Event Description: TF30162 (Sometimes TF30170): Task " SharePointPortal " from Group "Portal" failed Exception Type: Microsoft.TeamFoundation.Client. PcwException Exception Message: Client found response content type of 'text/html; charset=windows-1255' , but expected 'text/xml'. The request failed with the error message: System. ArgumentOutOfRangeException : Ticks must be between DateTime.MinValue.Ticks and DateTime.MinValue.Ticks On the Team Foundation Server, can access the Team Web Site, the SQL Server Reporting Services Web site, but not the Sharepoint admin site ! ...Show All

• Windows Forms datagirdview paging support

  How is use datagridviewpaging I need document and code.How do u use paging Hello, I m going to paging a gridview in Asp.net 2.0. I set AllowPaging = "true". But it automatically generates 2 page no. (1 2). How can I edit that page numbers Cheers, Etlon ...Show All

• Audio and Video Development Dynamic Metafiles

  I'm looking to stream dynamically generated WVX metafiles. For instance, the metafile would contain a playlist that does this: 1. plays a 30 second clip (commercial) 2. plays a selected movie The only way i have found to do this is to create individual metafiles for each movie. is there a way to send a variable such as movie location to link it to the file on the mms:// server Thanks, Jonathan Try posting your question here: http://www.microsoft.com/windows/windowsmedia/community/newsgroups/WindowsMedia/default.mspx dg=microsoft.public.windowsmedia.server&lang=en&cr=US ...Show All

• Windows Forms Window shrinking on restore.

  I'm using Visual C# 2005 Express to make a windows forms application. The application works fine but when I added some user settings to keep track of the window size and position, the window shrinks to no size when the window is restored. If I start the application, resize the window, and close it, it will remember its size and position on restart. When I minimize the window and then restore it, however, it briefly returns to it's original size (a fraction of a second) and then resizes itself to have no client area at all. I can then manually resize it to it's original size. What is going on Thanks for any help. Bob Hi, It's difficult to know without any code. Can you post all your code involved with resizing t ...Show All

• SQL Server Path of Tasks

  Hi, no results during my search of the web, maybe one of yours can help. Is there a possibility (during design time is OK) to find out, which TaskHost is before and after a CustomTask (by wiring in ssis-designer) and which type of wire it is (Error, Finish, Success). Maybe the order of executables is providing this information, when there are no props or methods (and i found none), but then you don't know anything about the type. Any ideas Thanks Hi, but there is no possibility to check via Validate(). Is there a possibility to tell a task in designer, that it has been connected or unconnected. And from this point to have access to the PrecedenceConstraints-Property / TaskHost ...Show All

• Windows Forms Datagrid Cell Keypress

  VS 2005 windows unbound datagridview I want to ensure that only numeric values are entered into a datagridview cell. Is there anywhere to put a keypress event in a cell The Regex is a way, maybe not good enough here. hehe The link does provide some information. There are lots of events out when you move from cell to cell: cell leave(old cell) cell validating/ed (old cell) cell endedit (old cell) cell enter(new cell) cell beginedit(new cell) So it's a great ease for users to validate their input data. ...Show All

• Visual Studio Team System tf checkin not working while tf add does work??

  Hi, I am working on an MSBuild project and i am having the following problem: i have to add files to the Team System Source Control, so i need to perform the following actions: 1- Add files to Source Control. This step works perfectly: <Exec Command='tf add /recursive /noprompt "D:\BRP\System\Wsdl\Generated\*"' WorkingDirectory="C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\" /> 2- Check in my files in source control. Does NOT work. <Exec Command='tf checkin /recursive /noprompt /override:"Overriden from MSBUILD" "D:\BRP\System\Wsdl\Generated\*"' WorkingDirectory="C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\" /> I get the typi ...Show All

• Windows Forms Browser Control Questions.

  Hi again everyone! I am working on a project for my school and it is a web browser, I have figured out the address bar, go button, refresh, back and forward but for the life of me can't figure this out. When the end-user clicks a link that opens in a _new window it opens an internet explorer window. Is there anyway to catch this and open up let's say another form with a browser control on it For example Form1 (Main browser) user clicks link that opens a new window Form1 spawns Form2 and Form2 loads the webpage vs internet explorer. Is this possible Check the NewWindow event for the WebBrowser control. There isn't much you can do, other than setting the e.Cancel property to True. Which would be an ...Show All

• Visual Basic Selecting data from datalist control

  Hi all I am having problem in selecting the data from my datalist. Here is teh sample code < asp:datalist id="dlAttrName" runat="server" > < ItemTemplate > < asp:LinkButton ID="lbSelect" Runat="server" CommandName="Select" style="display:none">Select</asp:LinkButton > < %# Container.DataItem("attrDef1")% > </ ItemTemplate > </asp:DataList> Private Sub dlAttrName_ItemDataBound( ByVal sender As Object , ByVal e As System.Web.UI.WebControls.DataListItemEventArgs) Handles dlAttrName.ItemDataBound         If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then ...Show All

• Visual C++ cant check to see if a string contains certain data

  erm got a slight problem with my program and i cant see the problem...any help please here is my code: private : Void NextQuestion( Void ){ // Seed random number generator with date and time DateTime moment = DateTime::Now; Random^ randNumGen = gcnew Random( moment.Millisecond ); // Create variable for random number Int32 intQuestNo = 0; // Get a number between 0 and the number of words in the array intQuestNo = randNumGen->Next( strQuestionsarray->Length ); // Use random number to select a question strQuestion = strQuestionsarray->GetValue(intQuestNo)->ToString(); // Check to see if question has already been added to the string. If not, add the number to the string so it cannot be ...Show All

• Visual FoxPro Copy File Error in Visual FoxPro 7?

  When a COPY File Command is executed and a space is in either a folder name or a file name, the instruction is unable to handle it. I have tried a technique to put in " quote marks in the manner '"<path><filename>"' but then it gives me a syntax error. Is this a bug or am I entering the full path and filename wrongly If this is a known bug, is there a patch for it If not, how do later versions of VFP do with this "bug" if your using the macro are you using &cPath make It (cPath) it will work e.g. cPath = "C:\Program Files\My App\Out Put\Some file.xls" COPY TO (cPath) TYPE XLS AndyKr   method as to work, the thing is that u have not mentioned that your using ...Show All