Answer Questions

• hzwang IP addresses: when SQL assigned multiple which does processing?

  SQL 2005, 2000 Server SP4, IIS 5, .Net Framework 2.0 My SQL Server lives in two networks separated by a Netscreen firewall. From there the Netscreen allows the Server to talk to a well-guarded Sybase that is on the other side of the firewall. So I can ping the Server at one address 'A'- but the Netscreen routes the traffic to the Server at the address the server knows itself as 'B'. The Server can't ping A (the address the outside ...Show All

• Clerigo Query help - get last username?

  Hi, I hope this is the right place to post this. I am pretty much stuck but think I am doing pretty good so far as I am getting more and more into SQL using SQL Server 2000 here.   I want to be able to get the last username who replied to a topic. The "DateOfLastReply" works great, it gives me the last date of a reply to a topic so pretty much along with this, I want to get who it was that replied last. Any ideas so far, I have thi ...Show All

• reboard SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• roadmaster Cannot reconfigure UNION ALL task

  If you add a "Union All" task to your Data Flow the output columns get configured by the first input you connect to it. However, if you later want to modify the input columns on the inputs (perhaps after adding an upstream Data Conversion) there seems to be no way to get it to forget the original set of output columns. Ideally, there would be a button you can press to reset the output columns based on the earliest added input. At ...Show All

• Negyoshi Control flow drawing bug

  Minor issue here. But I just wanted to point it out. I think this is how to reproduce it. If I disable a dataflow task and run the package, after it is complete, but yet still in the debugger, reenable the dataflow task. When I close the debugger, the dataflow task is still shaded as if it were disabled, but it will execute on the next run. Close the package and re-open it and the work flow task is drawn correctly. ...Show All

• Winston connecting using "datasource=localhost"

  hi all, i'm running VS2003.NET with SQL2000 on XP. when i try to use "datasource=localhost" in my connection string- i get "SQL server does not exist or access denide". (local) works and "=myServer" (server name) works. my hosts file is as it should be. i'm trying to connect to the server on my machine. i use to have no problem with it in the past. i think it all went to **** when i changed my machine's nam ...Show All

• Geethanga Best Practice for retrieving last record

  Hi there, very sorry if this is the wrong forum to post this in. I want to know what is the BEST practice, the correct Microsoft way of doing this: basically, lets say I am inserting a new record into SQL. simple customer record: firstname lastname address city postcode password dateOfRegistration (SQL has this value and the default value is the getdate()) That's all very well. I want to know how I can get the r ...Show All

• jsmans Encryption and recovery on standby machine

  Hi there, to follow on my question in the other forum, I have a database with triple des encrypted columns Master key created, certificate and symmetric key using certificate. Values inserted into table (encrypted) Can select etc, all works fine. Back up and restore database on another server, decrypting the data results in NULLs being returned. Backed up and restore the master key, cerficate, etc but either it completes successfully ...Show All

• dave dave SSIS Sequence container,data flow task

  I am creating a staging database in which I am loading required tables from 2 different sources. I have 30 different tables to load from source 1 and 10 different tables from source 2. This is the way I am doing, in Control flow task I am using Sequence container and in that I included the data flow task, the data flow task has source OLD DB connection from where I select the table and then destination OLE DB connection where I load the data ...Show All

• Nick Lenting SQL92 syntax - Why is SQL2005 different

  This arose from trying to solve an item in Experts Exchange http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21627719.html See the item: SELECT X.* FROM ( SELECT A.*,B.Col1 B_Col1, B.Col2 B_Col2 FROM A,B WHERE A.col1 *= B.col1 ) X ---> Correct SELECT X.* FROM ( SELECT A.*,B.Col1 B_Col1, B.Col2 B_Col2 FROM A,B WHERE A.col1 *= B.col1 ) X WHERE X.B_col1 IS NULL ---> Broken (Returns 2 rows) ... My question(s) are: Why are the ...Show All

• QuetzalNeTGt CreateSubscription - Specify the Job Name or Get the GUID Job Name

  We're using the CreateSubscription method to schedule a report for automatic delivery, using SQL Server Agent. Everything is working great. But, we had a question (or two). Is there anyway to specify the name of the SQL Server Agent job that gets created when the CreateSubscription method is called If so, how If not, is there anyway to get the GUID job name back after calling CreateSubscription TIA ...Show All

• Rim van Wersch How to Create Rank column

  If I have a column like this value --------- 34 45 54 How can I write an expression to create corresponding Rank column. value   Rank -------------- 34        3 45        2 54        1 Thanks The rowcount() feature in RS as suggested above might be able to solve this, as well as the Top N i ...Show All

• crazylady Strange Deadlock issue

  Hi,    Before posting this thread, I have searched for answer in this forum.    But this case is a little bit different from the others.        In our application, we encounter deadlock on a single table.    Env: SQLServer 2000, SP4, ReadCommitted    One thread is trying to do this update sql:    "update resources_allocate set FromDate= , RepFromDate= , Res ...Show All

• Jorge MVP Express Manager download for RTM version of SQLServer Express

  Has MS updated the Express Manager tool for the RTM version of SQLServer Express It's a great tool and not having it causes so much pain (I have to use the command line tools!). Thanks in advance! I tried to install the client tools from SQL Server 2005 developer edition but the installer for this (after downloading another 2.8GB!) says components are already installed and cannot be upgraded (or message similar ...Show All

• Thottam R. Sriram Document Job Steps

  How can I script out the job steps along with the DTS, Sp or T-SQL code within the step. This info must be stored somewhere. How can I access it Hi, You can script out jobs, including their job steps, by using SQL Server Management Studio. In SQL Server Books Online, see the topic "How to: Script Jobs Using Transact-SQL (SQL Server Management Studio)" The URL within the Books Online browser ...Show All