vaughanSkyblue's Q&A profile

• SQL Server get records after executing a stored procedure

  Hi All, I have a Execute SQL Task I get some values from a table onto three variables. Next step in a DFT, I try to execute a stored proc by passing these variables as parameters. EXEC [dbo].[ETLloadGROUPS] @countRun = , @startTime = , @endTime = This is the syntax i use, in the parameters tab of the DFT I ensured that all the parameters are correctly mapped. When I run the package, it executes successfully but no rows are fectched. I tried running the stored proc manually in the database, and it seems to work fine. Am I missing something here Please Advice Thanks in Advance Hi Jeff, My whole idea is to query a table, get three values onto three variables, pass these values to ...Show All

• Visual C# Creating a solution without creating a directory

  I've looked around for a workaround to this - but when you create a new blank solution in my current configuration of VS 2005, I cannot create it without the solution being placed under a directory of the same name. The checkbox to avoid this operation is disabled . I'm really annoyed by this and I'm tired to moving .sln files out of the directory and deleting it - does anyone know how to tweak this Andy Hi, The checkbox is only valid if you create a new project. When creating a new project, you can specify if the solution must be in a higher directory. There is no real way to create a solution without creating a folder. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium ...Show All

• Visual C++ How to know the Number of Bytes allocated to a Pointer.

  Hi Friends..... Is there any function to know the number of bytes allocated to a pointer. Ex: foo() { int *intList = NULL; intLIst = (int *)malloc(sizeof(int) * 10); freeList(intList); } freeList(int *intList) { /*How to collect the total number of bytes allocated for intList*/ free(intList); } Thanks.... No, there isn't. When you pass a pointer to an array of characters to a function, also pass the number of elements. void foo(int* array, int len) {   for(int i = 0; i < len; i++)   {      // do something with array[ i ]   } } int main() {    int buffer[200];    ...Show All

• Visual C# how to get value of finite element?

  If i want to get 5 in this example: /item/<slash:comments>5</slash:comments>, just using: XmlNode xnd = doc.SelectSingleNode("/item/slash:comments"); ...then.... xnd.innerText; i had tried "/item/comments" and "/item/slash:comments", neither of them works fine.how can i get 5？ oh,cannot find forums for xml/xpath, I assume then that "slash" is a namespace.  In that case you are in for a world of hurt.  The XPath parser requires that if you are going to parse documents with namespace prefixes then you must first define all the namespaces for the parser and then you must ensure that all queries for all elements use all the namespace pre ...Show All

• SQL Server Compatibility Level SQL Server 2000 (80)

  Hallo Everyone, I have an SQL database that I need to detach from an SQL2005 server and reattach to an SQL 2000 database. I tried to set the Compatibility level from SQL Server 2005 (90) to SQL Server 2000 (80). This did not work Any ideas Nigel... You can not backup on SQL2005 and restore on SQL2000. However you have other options: * Script the database from SQL2005 to SQL2000 * Use the full version of SQL Server 2005, install as separate instance * Use the free SQL Server 2005 Express edition, install as separate instance * Creating a linked server from SQL2000 to SQL2005 should work Thanks, Peter ...Show All

• Software Development for Windows Vista Conexant Audio Drivers for x64b2

  Anyone have a generic that'll work with the failed conexant audio driver Microsoft, I know you guys can take 10 minutes and code one. ;p When you boot up your computer press f8. Select load unsigned drivers and enter. Your sound should work. You will need to do this every time you boot up. It's the only way I have found to make the sound work on my HP dv8213cl laptop with Vista beta 2 build 5384. I hope this will help you. ...Show All

• SQL Server Missing Data Mining provider in Management Studio Linked Server definition

  I'm trying to define a linked server using Microsoft OLE DB Provider for Data Mining Services. MSDMine data provider is missing. Do you know where I can get this Thanks in advance. I'm have a Xeon 64bit proc. using SP2. And had installed: SQLServer2005_ADOMD_x64.msi, SLQServer2005_ASOLEDB9_x64.msi,SQLServer2005_OLAPDM_x64.msi, and SQLServer2005_XMO_x64.msi. The OLEDB provider for Analysis Services 2005 (which should be used for Data Mining) is MSOLAP, not MSDMine. MSDMine is the old AS 2000 provider. Some details on executing queries in SQL, with a linked server, can be found in this article (Executing predictions from the SQL Server relational engine): http://www.sqlserverdatamining.com/D ...Show All

• SQL Server Bug?? Transfer SQL Server Objects Task - error when copying Views

  I'm trying to copy data over using a Transfer SQL Server Objects Task however I get problems trying to copy over views. I get the similar error (pre sp1) when using import/export wizard and copying over views. Now with SP1 the views just don't transfer. I'm transferring from SQL 2005 to SQL 2005. The error I get is: Error: 0xC002F363 at Transfer Data (NEW), Transfer SQL Server Objects Task: Table "vw_XXXX" does not exist at the source. Task failed: Transfer Data (NEW) I know the view exists at the source because: A) I can select it in the Views List Collection within the Transfer SQL Server Objects Task B) I'm using the view on the source Somehow the views are not transferring. Anyone have any ideas ...Show All

• Smart Device Development Problems with Cursor.Current

  Hi world! This is my first message. I'll try to be the most precise as possible. Configuration Compact Framework 1.1 Symbol and Qtek smartdevices Studio 2003 I call this function (placed in a module) from some Forms and Clases and Modules     Public Sub Change_Cursor(ByVal blnShowWaitCursor As Boolean)         ' Application.DoEvents()         System.Windows.Forms.Cursor.Show()         If blnShowWaitCursor = True Then             System.Windows.Forms.Cursor.Current = Cursors.WaitCursor         Else      ...Show All

• .NET Development Parser Error

  Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Could not load type 'VBNetUpload.WebForm1'. Source Error: Line 1: <%@ Page Language="vb" AutoEventWireup="false" Codebehind="WebForm1.aspx.vb" Inherits="VBNetUpload.WebForm1"%> Line 2: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> Line 3: <HTML> Source File: F:\arun\Easy_Upload\vbnetupload.aspx Line: 1 Am Trying to upload a file to the web server. How to resolve this error Plz rep me.. ...Show All

• SQL Server Smorgasboard of Encrpytion questions !

  Answer whatever part(s) you can! 1. "EncryptByKey" is commonly used to encrypt data but what is it Is it an extended stored proc or a .NET assembly or seomthing else 2. What are the minimum permissions needed for a user to encrypt\decrypt data (I'm testing encryption as the DBO and that's great for me but not good in practice) 3. The use of a MAC table is a great idea when one wants to search a single column of encrypted data. Can this idea be extended to handle multiple encrypted columns 4. Is this correct: JOINS on encrpyted columns (I hope we don't need to do that often!) would be handled using the approach mentioned in 3) 5. The t-sql funciton HASHBYTES is a hash function. Is CHECKSUM also a ha ...Show All

• SQL Server data in sqlserver is not case sensitive

  I am facing problems as the data in sqlserver is not case sensitive. The data in parent key may be capital/lower case and the same data in the child table may be lower/capital case. While migrating the data from sqlserver database to other databases(like oracle) its giving error as the data not found in parent key, though the data found in parent table . This is just because the case sensitive in oracle. But according to my knowledge its better if the sqlserver also supports data case sensitive. Take a small example Need a table to store all the alphabets in a table the table structure is CREATE TABLE [dbo].[ALPHABET] ( [Alphabet] [varchar] (1) NOT NULL , [Description] [varchar] (50) NOT NULL ) GO The data is ...Show All

• Smart Device Development Bar Menu

  Could somebody tell me why After modified Menu in the resorces editor The change wasnt display in my smartphone this is using 2005 compiler. Also there was the same thing happen in EVC4 using SHMENUBARINFO there was no menu in he menu bar.. Thanks in advance Hi, I am not sure about the problem here, since I know that SHMENUBAR works with Smartphone and we don't have any such known issues. I think there may be some confusion about the way we are supposed to use the menus with smartphone. Please have a look at 1st image here; I have tried to illustrate the layout of smartphone style (RCDATA/SHMENUBAR) toolbars. http://avinashprasad.spaces.msn.com/photos/   Hope this hel ...Show All

• SQL Server Initializing a Merge Subscription Without a Snapshot bugs

  Hello guys, We have customers that are using web synchronization. Could you, please tell us when service pack for the bugs, discussed in thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=689428&SiteID=1  will be reliazed What replication participants should apply the service pack in a configuration where Subscriber (MS SQL 2005 Express)  gets synchronized with Publisher/Diustributor (MS SQL 2005 Standard)  Thanks.  Alexander. Alexander, there is no service pack that address the problems mentioned in the thread. As mentioned in the thread, we are trying to encourage customers not to use No Sync menthods when they can. However if you need to use it and are encountering blocking ...Show All

• SQL Server <Error> The process could not be created for step 1 of job *** (reason: A required privilege is not held by the client)

  We are deploying SQL 2005 SSIS packages into production, they work well when run manually. But getting this error when running from SQL agent jobs using a proxy, the proxy account is using SSIS account user(not sysadmin) as the principle. Executed as user: ***. The process could not be created for step 1 of job 0xC92B73399BDE6544B741931C36B0C80D (reason: A required privilege is not held by the client). The step failed. We are aware of this is relevant to account users and privilidges, but couldn't figure out what is exactly wrong. Some suggestion will be appreciated ^_^ Steve Thanks, Dan. We had a password problem also but now use DontSavePassword and a config file. The problem is ...Show All