Answer Questions

• Donaghy ORDER BY, only orders by the first character?

  Hi, I am using a stored procedure that is databound to a dropdownlist. The stored procedure works fine, aside from the fact that the ORDER BY only sorts the list of items using the first character in the cell. E.g. The numbers 1, 20, 100 and 200 would be ordered as follows: 1 100 20 200 clearly i am doing something wrong and i apologise if it is a stupid question, but could anyone please offer me some help Thank you, Shep I have never used Visual Web Developer but in a quick tour of the web site I don't see anything about creating objects in a database. You may have to use an editor in your database. Hi, thanks to everyone for their help, in the end i have resorte ...Show All

• Chyna440156 Moving my SQL Server to another computer

  I will moving my SQL Server to another server. The plan is to stop SQL Server copy database file to a temp netwokr location, Switch off this server. Configure the new server with the same name and IP, install SQL to the same paths and service pack to the same level (SQL 2000 sp3). Then start and stop the SQL server. Once stop I will then copy the old database file over the new ones. I know in general this works as I have doen this many times before expect this time round there is a replicaiton database which is new, I am expecting this will work the same but has any one else tried this before Unfortunately, you have to disable the publication before you can detach and move the database. BTW ...Show All

• akin_l Runtime temporary table in SQL2000

  I am trying to create a runtime temporary table at SQL2000 server in my VB 6.0 program. However, I am keeping getting "object not found" error from my program when I trying to issue a SELECT or INSERT statement in my program. Can anyone shows me how to do it properly. I thought I can create a temporary table with a # prefix as a table name. Am I correct Help is very much appreciated. John Tsoi John, Can you paste the code that you are using to perform this task. The temp table you are creating are only accessible on the connection on which they were created. So it might be the case that you are using another connection to perform the select. Are you using ADO What provider are y ...Show All

• Vaassu File System Task Error - Process in use

  Hi, In the integration services package i'm working on i connect to an excel database and have two data flows which deal with two work sheets in the excel spreadsheet. The data flows do some transformation and then write the data out to a SQL database (two differnet tables). This is all working great however what i want to do once both data flows are complete is to move the directory which contains the current file that is being looped through. At present there is a foreach loop going through a number of directories. I have tried to implement the File System Task object to move the directory but get the following error: [File System Task] Error: An error occurred with the following error message: "The process cannot access the file be ...Show All

• ron nash File Groups

  Hi everyone, While creating our database in only one disc(C or D), suppose that we create more than one file group in order to group our data files. However, in this situation; I wonder that whether it brings any benefit or advantage to us. Also, I wonder that why we always have to put our data file into separate file group if we use separate discs for data files. Is not it allowed to use only one file group even if we use separate dics Would you explain these to me Thanks Hi, First of all, thanks for your all replies and thanks for spnding your time for my questions. I think that I finally kept the idea about the efficiency and high level performance which I want to demonstrate. For instance, suppose that we recall some records ...Show All

• Eric66 Question about MAX()

  I have a table which has case numbers and version numbers. The same case number has different version numbers. I was wondering if there was a way to select all the case numbers with the highest version numbers. Pretty much what I am looking for is as follows: TABLECASES: CaseNumber VersionNum 1234 1 1234 2 1234 3 3567 1 3567 2 Upon running my query..I want something as follows: CaseNumber VersionNum 1234 3 3567 2 Can sombody point me how to construct the query..thanks SELECT CASENUMBER, MAX(VERSIONNUM) FROM TABLECASES GROUP BY CASENUMB ...Show All

• NeedSomeAnswers How do I add an ODBC connection data source as a Data Flow Source

  I have set up a new connection as a connection from data source, but I cannot see how to use this connection to create my Data Flow Source. I have tried using an OLE DB connection, but this is painfully slow! The process of loading 10,000 rows takes 14 - 15 minutes. The same process in Access using SQL on a linked table via DSN takes 45 seconds. Have I missed something in my set up of the OLE DB source / connection Will a DSN source be faster Thanks in advance ADG How do you know that the slowness is in the OLE DB sauce component and not in the destination component How are you setting up the OLE Source component Providing a query would be faster than selecting a table from the dropdown list. ...Show All

• Allen Razdow Connection String Encryption for SQL Server Mobile

  I'm seeking suggestions on how to go about encrypting a database connection string in the compact framework. It's something that I thought would be relatively straight forward as I've accomplished it without much difficulty in the full framework, but I'm stuggling to find a solution. I've been trying to implement a solution using public/private key asymmetric encryption using the RSA provider. I've essentially been trying to encrypt the connection string once on my development machine so that I can include both the encrypted connection string value and public key in either code or an external file. I'd then keep the private key out of harms reach. The problem I've encountered in doing this is that that RSA provider seemingly only allows ...Show All

• js123 How do you search for textvalues with wildcards in xml?

  What I want to do is search for a text string inside a xml tag using my own wildcards. For example: The following xml is stored in a column in the database. < MetaData > < MetaFields > < MetaField Id = " 20 " Key = " x " > erwrw </ MetaField > < MetaField Id = " 23 " Key = " x " > Foxvalue </ MetaField > < MetaField Id = " 24 " Key = " x " > adsas </ MetaField> < MetaField Id = " 25 " Key = " x " > Varde1 </ MetaField > </ MetaFields > </ MetaData > How can I search the xml to see if any of the /MetaData/MetaFields/MetaField values contains Fox* In xquery there is ...Show All

• AtomSoft2k5 create dymanic dts

  i can writing dynamic dts package . but not working. code is here : Public goPackageOld As New Package Public goPackage As Package2 Public Sub RunDTS() Dim goPackage As Package2 goPackage = CType (goPackageOld, Package2) goPackage.Name = "DTS3" goPackage.Description = "DTS package description" goPackage.WriteCompletionStatusToNTEventLog = False goPackage.FailOnError = False goPackage.PackagePriorityClass = CType (2, DTSPackagePriorityClass) goPackage.MaxConcurrentSteps = 4 goPackage.LineageOptions = 0 goPackage.UseTransaction = True goPackage.TransactionIsolationLevel = CType (4096, DTSIsolationLevel) goPackage.AutoCommitTransaction = True goPackage.RepositoryMet ...Show All

• Don Cameron Connectivity Portal (WIKI)

  Hi All,   Wouldn’t it be nice to have a single portal to check the list of data sources SSIS can connect to Like, if and how SSIS can connect to SAP/Oracle/DB2/SQL Server/etc along with what to expect from that connection, such as 64-bit support, fast data load option, scalability, etc   The know-how around connectivity in SSIS has particularly been challenging to structure in terms of gathering and reaching all sorts of connectors and data sources out there.   The challenge is due to two main reasons:   Microsoft does not have central command/control on connector developers, and the connectivity story for SSIS has mainly been the support around ADO.NET, Ole DB and ODBC libraries. Since ...Show All

• Melissa H. Mirroring for certain tables from the database in sql 2005

  Can I know is it possible using database mirroring for only certain tables from the database, not for the whole database in sql server 2005. Hopefully able to get any assistance here. Thx alot. Best Regards, Hans Hi Jerry, sorry for bothering you again. Can I ask some questions regarding the connection for the database mirroring. Actually I did post a thread here and hope can get any assistance from you. If can, I prefer to share/discuss the problem for solving this scenario which is the Error 1418 through messenger. Hope to hear from you soon. Thanx a lot and have a nice day, Jerry. Best Regards, Hans oic. thanks for the information. :) ...Show All

• Eric F Crist How to create sproc with unlimited number of parameters?

  We have this kind of thing in C#, and I know the sp_executesql (or something like that) does it too. How do you create a stored procedure that has certain known parameters, followed by any number of additional parameters For example, you may have one that's called in any of these ways: exec my_sp @ID, @text, @P1, @P2 exec my_sp @ID, @text, @P1, @P2, @P3 exec my_sp @ID, @text, @P4, @P39087, @P2 I can't find a syntax in the docs that really accommodates this. Thanks in advance for your help! Is something like this what you are looking for   This defines a procedure with M required parameters and N optional parameters: create procedure dbo.xample    (    @pm_required ...Show All

• Cory.Isakson Lock page in memory setting in SQl 64 system

  Hi All, We know that locking page in memory setting is recommended to set in SQL 64 system. The purpose is used to avoid memory pages in Sql address will not be OS paged out. It is a little confused that if the memory pages of sql cannot be paged out after setting lock page in memory. Then the memory used by SqL will increase forever. If the physical memory is limited, it will obviously caused the memory pressure of the system eventually. How does the 64 bit sql manage his Buff pool in such scenario Will it be paged out Thanks in advance Thanks. you mentioned "when the low memory notification is set SQL Server reduces memory usage." However, (in 64 bit environment), since the page is locked in memory at that tim ...Show All

• Gordon F This Schema prefix drives me crazy...

  Hi, I have created a new user in my database called "acm", I also created a new schema called "acm" as well, the "acm" user is its owner, and the default schema for "acm" user is the "acm" schema. I also created a login called "acm" (surprise surprise) and set its default database to "mydb" database. In "mydb" database I have a table "mytable" that is owned by "acm". In my connection string I am using "acm" as the user, but when I do: "select * from mytable" I get error ("bla bla object bla bla"), when I use "acm" as a prefix for the table name it works fine... What do I miss My connection ...Show All