Sp5; Any Problems Post Install?

SQLserver2005Express Post-install Problem

Hi

I have installed a single instance of SQLserver2005Express on a stand alone PC running WinXP Pro.

Do you always have to be logged in as a Windows [XP] administrator to work with SQL Server databases? Because when I'm not it SQLserver Management Studio won't allow me to open any database.

Also, do all databases have to be in the default data folder location [in my case this is: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData]? Because if I try and navigate to other databases I have in other locations using Management Studio they are not visible.

Any help gratefully accepted...newtWales.

SQL Server Install On A Post SP2 Machine

Today I attempted to install SQL Reporting Services on a box that only has the OLE DB driver for Analysis Services and the MSXML components; both of which are SP2.

When running the SQL Server 2005 install to install SSRS, I get an error:

"SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme."

This box has barely anything on it aside from ProClarity Analytics Server and the components I mentioned above. My only guess is that the SQL 2005 installer sees some newer components that are SP2 and it thinks they are beta? I know for sure I do not have any beta software on this machine.

Any ideas?

Post 2005 SP2 Install, No Script Component Can Be Edited.

Anyone starting to see "Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)" after installing SQL Server 2005 SP2 on x86 machines?  Second, how can it be fixed?

After installing SP2, the script component editor will not edit script components created in pre SP2 releases. (I also have Visual Studio 2005 SP1 installed). The script TASK editor will start, but when attempting to open a script COMPONENT in the VSA editor, a script component created for pre-SP2 packages, the following error dialog occurs.

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

This same error dialog has occurred on multiple computers, none of them are running Vista (rather Windows XP SP2). All of the pre-existent pre-SP2 script components have Precompile set to true as well, since they are intended for 64 bit machines.

Now, certain posts say, register DLLs in the following directories via:
for %i in (*.dll) do RegSvr32 -s %i.

C:Program FilesCommon FilesMicrosoft SharedVSA8.0common
C:Program FilesCommon FilesMicrosoft SharedVSA8.0vsa

One problem with these instruction is that the second directory doesn't even exist, however, a directory called "C:Program FilesCommon FilesMicrosoft SharedVSA8.0VsaEnv" does exist, which is perhaps what was meant. Even after registering the DLLs there, the script component editor will not open (erroring out after clicking the "Design Script..." button).

How To: Automatically Run A Script Post-install As Part Of Setup

I need to provide a media kit to other DBAs in my organization so that when they run the setup.exe it will automatically apply some "hardening" scripts that my team has written. We want it to be a seemless part of the installation process so that the scripts can be applied consistently across the organization.

Is there anyway to do this?

Unable To Identify Child Package Events Post SP2 Install

Pre-SP2, log events that bubbled up from child packages used to be prepended with "User:" (as documented in KB906563). It appears that this behaviour has changed in SP2, and only the Diagnostic event gets prepended with "User:". When I debug a custom log provider, the event names are now clearly not prepended on any other event type.

Is this a bug, or a breaking feature? Can anyone suggest a way to identify events that bubble up from child packages under SP2, now that this has changed?

Can't Execute Package From BIDS Solution Explorer Post SP2 Install

Yesterday, SQL Server 2005 SP2 was installed on our DEV Server (Windows 2003 SP1 x86) and now I cannot right-click a package in the Solutions Explorer window in BIDS and Execute Package. When I do, I get the following error

===================================

Object reference not set to an instance of an object. (Microsoft Visual Studio)

------------------------------
Program Location:

at Microsoft.DataTransformationServices.Project.DtsPackagesFolderProjectFeature.ExecuteTaskOrPackage(ProjectItem prjItem, String taskPath)

I know I could do this yesterday morning pre SP2. I've attempted this with a couple of different packages and solutions, so it is probably not a corrupt package (unless now they are all corrupt). I can execute in debug mode if I open the package first and then hit Start Debugging. However this is not always an optimal solution because I sometimes have many connected packages and sometimes what gets executed is not what is expected.

Your thoughts would be appreciated.

SQL Server 2005 Rendered Unable To Start Post SP2 Install. Help!

Hi can someone help me please? I browsed through the SP2 install feedback below, but it doesn't quite seem to fit what happened to my install. My .MDF and .LDF files for the system databases are in C:Program FilesMicrosoft SQL ServerMSQL.1MSQLData (I presume this is the correct location.)

I am the local administrator on this box.

I uploaded the .CAB file with all the logs onto www.sendspace.com if it gives you something to go on.

The only other thing of note is that it said there were two machines on the network and that I needed to change my machine name in the control panel when I installed. This doesn't seem right, as far as I understand the computer name is unique.

The SQL Server runs under the local system account, if that is of any use.

I attempted uninstalling and reinstalling the SQL native client MSI package in the hope it would be a simple fix similar to that chap further down the page, but that didn't help at all either.

.CAB file of installation logfiles is here: http://www.sendspace.com/file/7ihoet

kind regards
Jason




ERRORLOG starting SQL Server post failed SP2 install



2007-06-12 19:55:21.94 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2007-06-12 19:55:21.96 Server (c) 2005 Microsoft Corporation.
2007-06-12 19:55:21.96 Server All rights reserved.
2007-06-12 19:55:21.97 Server Server process ID is 5468.
2007-06-12 19:55:21.97 Server Authentication mode is MIXED.
2007-06-12 19:55:21.97 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2007-06-12 19:55:21.97 Server This instance of SQL Server last reported using a process ID of 5756 at 12/06/2007 19:36:35 (local) 12/06/2007 18:36:35 (UTC). This is an informational message only; no user action is required.
2007-06-12 19:55:21.97 Server Registry startup parameters:
2007-06-12 19:55:21.99 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2007-06-12 19:55:21.99 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2007-06-12 19:55:21.99 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2007-06-12 19:55:22.00 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-06-12 19:55:22.00 Server Detected 4 CPUs. This is an informational message; no user action is required.
2007-06-12 19:55:22.17 Server Address Windowing Extensions is enabled. This is an informational message only; no user action is required.
2007-06-12 19:55:22.33 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-06-12 19:55:22.57 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-06-12 19:55:23.60 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-06-12 19:55:23.63 Server Database mirroring has been enabled on this instance of SQL Server.
2007-06-12 19:55:23.72 spid5s Starting up database 'master'.
2007-06-12 19:55:24.07 spid5s SQL Trace ID 1 was started by login "sa".
2007-06-12 19:55:24.11 spid5s Starting up database 'mssqlsystemresource'.
2007-06-12 19:55:24.13 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-06-12 19:55:24.29 spid5s Server name is 'GBLOND088SQ8MSQL_CREDS_DEV1'. This is an informational message only. No user action is required.
2007-06-12 19:55:24.29 spid9s Starting up database 'model'.
2007-06-12 19:55:24.30 Server Error: 17182, Severity: 16, State: 1.
2007-06-12 19:55:24.30 Server TDSSNIClient initialization failed with error 0x34, status code 0x1e.
2007-06-12 19:55:24.30 Server Error: 17182, Severity: 16, State: 1.
2007-06-12 19:55:24.30 Server TDSSNIClient initialization failed with error 0x34, status code 0x1.
2007-06-12 19:55:24.30 Server Error: 17826, Severity: 18, State: 3.
2007-06-12 19:55:24.30 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2007-06-12 19:55:24.30 Server Error: 17120, Severity: 16, State: 1.
2007-06-12 19:55:24.30 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Post SP2-Hotfixes Fails To Install Database Services On Clustered Servers With System Dbs On Non-default Location

Hi,

We've had this issue for awhile, but I have not been able to find a resolution for this. We have 2 identical servers (hardware & software) set-up: IBM x3850-(88633RU) running Windows Server 2003 Enterprise x64 (5.2.3790 SP1 Build 3790 R2). Server A was running SP1 (Build 9.0.2047) on a 3-node active-passive-passive failover cluster. Server B was running SP2 + Hotfix KB933097 (Build 9.0.3152) on a 2-node active-passive failover cluster. Both these servers are heavily utilized, and when originally installed with these versions of SQL Server Enterprise 2005 experienced no issues during or post-install. The original install of SQL 2005 Enterprise on both these servers had the Cluster Group Selection "Data files" setting changed to "M:MICROSOFT SQL SERVER" so that all system dbs and binaries would be installed to that location. On Server B where SP2 had already been applied, the update was downloaded on May 1, 2007, well after the GDR issues which had been plaguing SP2 releases was supposed to have been resolved.

Our problems began the night when we tried to apply hotfix KB933097 on Server A, and cumulative update packages 1,2,3 on Servers A & B, as well as catch-up the same SP2 and hotfix packages on other non-clustered servers where default system db locations remained the same. On all servers other than Servers A and B, the installs proceeded smoothly and without issue.

On Server B, which was already running SP2 + Hotfix KB933097, we tried installing Cumulative Update Package 1 (Build 9.0.3161) on the primary node. The install proceeded until the following errors were encountered:

"[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission."

"[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_memory_grants', because it does not exist or you do not have permission."

After this, the setup finished with the message "Product: Microsoft SQL Server 2005 (64-bit) - Update 'Hotfix 3161 for SQL Server Database Services 2005 (64-bit) ENU (KB935356)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB935356_sqlrun_sql.msp.log."

We rebooted the server and tried several times to reinstall the hotfix as sa and as the database service account with full windows and sa credentials, each time with no success, and rebooting between retries. All other components were installed successfully. We were hesitant to try uninstalling the hotfix, since it was unable to be removed successfully in previous attempts. However, when I connected to Database Engine using Management Studio, I found that the version of SQL being reported was in fact Build 9.0.3161! Everything also appeared to be running properly.

I tried to to Google the answer, but could only find information as applied to SP1 when system dbs master and mssqlsystemresource were located on different locations (http://support.microsoft.com/default.aspx?scid=kb;EN-US;918695 ). I had already verified that all system dbs, including the ones mentioned, were originally and currently located together on M:Microsoft SQL ServerMSSQL.1MSSQLData.


Finally I contacted a fellow DBA who advised me to continue installing all the other hotfixes, and then compare all SQL files against other servers where the install succeeded to ensure all system files were updated correctly (matching file sizes and datetime stamps). Since we were depending on a fix in Cumulative Update Package 3 to fix a critical log-shipping security issue, I went ahead with the rest of the installs, getting the same error with each package, rebooting between each install.

We found after the final install that the mssqlsystemresource files in the M:Microsoft SQL ServerMSSQL.1MSSQLData

directory were in fact updated after each install with a new timestamp, and that all files in C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn matched on both file size and timestamp. The log-shipping security issue we were looking to fix also appeared to be resolved by the last update.

On Server A, which was running SP1 (Build 9.0.2047), we installed the same SP2 package as we had on Server B with no issue. We rebooted and then tried to apply the same Hotfix KB933097 (Build 9.0.3152) that had been applied successfully on Server B and found to our surprise that the same errors were being generated here as well. We continued to apply the rest of the hotfixes so that both servers matched software updates. Comparing the above directories showed that files seemed to have been updated, even though database services appeared to be not installed.

It looks like we now need Cumulative Update 5 hotfix package in order to deal with WMI alerting issues, but I'm afraid to apply it until we have a known resolution for the past errors.


Since this issue was supposed to be resolved by SP2, I'm not sure why these post-SP2 hotfixes should fail. It seems to me to be an issue of the directory location of the system files which is in question.

I can post the hotfix log files as well, if anyone is interested in seeing them.

Any help would be greatly appreciated. As well, does anyone have any idea when SP3 is scheduled to come out? I really don't like applying hotfixes which are usually untested for general purposes, and it seems Microsoft is delaying this in favour of releasing SQL 2008.

Refering To Distinct Values Post(My Other Post)

---------------------------------------------------------------
My Original Post
I have to query n table(NLRImports) using the Distinct keyword, to retrieve a set of ID numbers. ( "Select DISTINCT id_nbr from NLRImport" ).

Now i want to use those values i retrieved, to process the records in the table(NLRImports) 1 by 1. How do i use those ID no's i retrieved as Variables or parameters for my next query?? If this makes sense?
----------------------------------------------------------------

First, thanks for the response.... now here is what im trying to do.
I created a simple application in delphi to import information to a table in MSSql2005. This is some of the resulting columns...

date | id_nbr | account_nbr | sub_account_nbr | ... etc
-------------------------------------------------------------

Now there will be several entries with the same id no but on different dates, so i take it dates would rather be my pkey.

Then i need to take one person's entries(i work on id_nbr) and go thru all the entries taking the earliest date and comparing all the other entries for that person to the first date and select all the dates more than 19 days after the first date and less than 91 days from first date and place it in a new table.
I used cursor s and while loops to kind of get it going but i know that cursors are not really recommended use but the performance implications dont bother with this particular job.

What other ways should i be using to accomplish this?

thanks, i hope this is clear...

Post To A DB

Alright so here is what I am trying to do.
I have a form that someone fills out it has a text box as title, and a drop down box that is a category, and then a text area that is for their explanation.
On the back end I am using a stored procedure called sp_store_bkm. When I execute this it works just fine and puts the data that I put in it into the to table below is the  Stored procedure code:
ALTER PROCEDURE sp_store_bkm @oID nvarchar OUTPUT, @oTitle nvarchar(50),  @oCategory nvarchar(50), @obkmtext nvarchar(MAX)
 AS BEGIN INSERT INTO tbl_bkms(Title, Category, bkmtext) VALUES(@oTitle, @oCategory, @obkmtext)Set @oID=  SCOPE_IDENTITY() END
 
Now on my front end it comes up with an error in the lower left (erros on page). When I click on the error for details it seems like it is coming fromt he connection string. I cant find anything wrong with the connection string. Below is my code for the aspx page.
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Untitled Page" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<script>
function Submit2_onclick() {
Dim Connection As SqlConnection = "server=localhost;Database=BKM.mdf;integrated security=SSPI;"        connection.Open()        Try            Dim command As SqlCommand = New SqlCommand("sp_store_bkm", connection)             command.CommandType = CommandType.StoredProcedure            Dim oID As New SqlParameter("@oID", SqlDbType.Int)            oID.Direction = ParameterDirection.Output             command.Parameters.Add(oID)            command.Parameters.Add("@oTitle", title.text)            command.Parameters.Add("@oCategory", category.text)            command.Parameters.Add("@obkmtext", bkmtext.text)            command.ExecuteNonQuery()             Dim sOrderID As String = oID.Value }</script>
<form method="post">    <table cellpadding="10" style="width: 100%">        <tr>            <td style="width: 100px">                <span style="font-size: 10pt; font-family: Verdana">                Login ID:                     <br />                </span>                <asp:LoginName ID="LoginName1" runat="server" Font-Names="Verdana" Font-Size="10pt" ForeColor="Red" />                <span style="font-size: 10pt; font-family: Verdana">                <br />                <br />                Title:<br />                </span>                <input id="title" style="width: 374px" type="text" /><br />                <br />                <span style="font-size: 10pt; font-family: Verdana">                Category:<br />                </span>                <select id="Category" name="D1" size="1" language="javascript" onclick="return Select1_onclick()">                    <option selected="selected">Office Applications</option>                    <option>VPN</option>                    <option>WLAN</option>                </select>                &nbsp; &nbsp;                &nbsp; &nbsp;<br />                <span style="font-size: 10pt; font-family: Verdana">                    <br />                Your BKM<br />                </span>                <textarea id="bkmtext" style="width: 378px; height: 196px"></textarea><br />                <br />                &nbsp;<input id="Reset1" type="reset" value="reset" />                &nbsp; &nbsp; &nbsp;<input id="Submit2" type="submit" value="submit" language="javascript" onclick="return Submit2_onclick()" /></td>        </tr>    </table>    </form></asp:Content>
 
Please help.

HELP !!!!!! (just Below This Post)

Can you help me? I'm pointing on the thread just below this post (along with the other messages on the message board).

Hello--First Post & Already Need Help!

Greetings friends:

I am a student at DePaul University in Chicago, IL. We have a big db project tomorrow and I'm proud with the work I've done so far, I've designed my own db and tested it using queries and such. Pretty good for being introduced to SQL just a couple short months ago. Anyway, I've sort of run into a wall here. I need to have an attribute of a table be computed from others.

I'm working with 2005 Server Management Studio and I have found the computed column specification under the column properties tab. I know that I have to enter a formula, but I'm just not sure on what to do. I have a CHG_HOUR attribute in a table called "EXPERTISE" which signifies how much a consultant charges per hour, based on what he exactly does. I also have a JOB_HOURS attribute in a JOB table (that links my CONTRACT table to CONSULTANT). I want to basically give a formula that multiplies the CHG_HOUR from the EXPERTISE table by the JOB_HOURS in the JOB table. Any suggestions on how I might do this?

Thank you in advance for your response, and hopefully with more practice and courses, I can be the one helping people like me on these boards in a few years.

First Post

Just testing out this posting thing... Thanks!!Join Bytes!----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Post SP2 GDR

I have a question about the post SP2 GDR that just came out in the last day or two. My laptop only has the client tools installed, not the server components (except for the SSIS server component). Is there any need for me to install this GDR? Does it impact the Management Studio code which views maintenance plans on remote SQL Servers or anything?

How Do I Post A Job To SQL From My Web Page.

I am developing an application using Visual Web Designer (language VB) with a SQL Server 2000 back end.
Within my logic I have a point where I want to say "Run SQL procedure GEDFinish".  GEDFinish can take several minutes, and I don't need to wait for it's results - it would be fine if it ran overnight.  I can easily check whether GEDFinish has run from the database, in situation where my application logic needs to know if it has already run.
Currently I only know how to run a procedure under the direct control of my web program, but with GEDFinish this fails due to timeouts.  (This will be worse in the production site). What I really want to do is to have my web program submit "Exec GEDFinish" to the SQL agent, and then forget about it.   It would be even better if I could build a script for the SQL agent, for example "EXEC GEDFinish Parameter=7"
Help!  How do I do this?
Thanks, Robert Barnes

Need Help Except Help Regarding Sql Mail(second Post)

Sorry it is my second posting , I am trying to find answer to my problem


Hello everybody.
I have problem with mail

I have 3 servers
A) SQL2000 sp2 Standard edition 1024 MB memory
B) SQL2000 sp2 Standard edition 3072 MB memory
C) SQL2000 sp2 Enterprise edition 2048 MB memory


All servers use same mail profile and they all run under same account MYDomainsvcSql2000 for server and agent and connected to same mail server
1. server C run fine
2. servers A and B could stop mail service during the day and the only way to restart it is to open EM and retype password for Sql server account (it will force Server and agent restart)


Any idea ?

Can Someone Post Something On Indexes?

it's been too long since I answer something on indexes and it shouldn't, indexes are a important part of SQL

HTTP Post

Hi,

Is it possible to write a stored procedure which can post an XML file to a server using HTTP?

Thanks!

Post SP4 Hotfix

Can anyone help me to get the hotfix SQL Server 2000 build 8.00.2215 ?
As i do not find any download link.

How To Find Out My Post?

How to find out all my post in this forum?

I Need To Delete A Post

I need to delete a post by particular date and time, what is the syntax for that. anybody help

Articles on various categories

Where Do I Find All My Post

Hi, I am new to this forum and was wondering where i can see all my previous post? (i.e all the post i was ever involved in)

dallr

Test Post

This is a test post

From Previous Post

Ok so someone answered my last quesiton about finding what tables are in a Stored procedure. Is there an opposite of that. If I wanted to type in a table and it shows all the stored procedures that use that table.

How To Write (post) To A Url

I am at a client that uses an xml form to email from java rather thansetup a true email server. Does anyone have any suggestions as to howms sql can write to the xml or maybe even call java or xml directly.This will be done as part of the error detecting process of various sqljobs in EM.Thanks,Mike--Posted via http://dbforums.com

Where Should I Post Questions On Sql?

Was This Post Helpful

If u get any solution then plz share knowledge with me because I am new in SQL

Real Newbie Post...

I was hoping there would be a newbie section in here... But I'll post anyway (And sorry in advance if its a really dumb question)I am using VWDE and have a SQL DB which has been imported from one of my existing forums, when it shows in the database explorer its show like belowtblArcade (jdName)tblArcadePB (jdName)etc..etc...What I want to know is why this DB has (jdName) after the Table name and my other DB's shown don't?? They are just shown as tblArcade
tblArcadePB etc..etc.. My main questions are "How do I remove the brackets from the forum DB" as when I try to preview data in VWDE I get a message Invalid object name 'tblArcade'.I know its to do with this extra bit as it only happens to the tables that have this on the end... Hope that makes sense and someone can help me, if you could reply as if I'm really dumb it would be appreciated  

Post From Text Box To SQL Insert

Hello,I'm trying to update a single field of a record and i want to do it using a standard multi line text box but I'm not sure how to write the c# command to process the sql update.  I would also like the entry to be added into the database with line breaks. Thanks for your help 

Information Won't Post To My Database

I'm having a weird problem with an easy process. I have a section that allows people to enter their name and email address if they wish to be contacted. I have it set up so that when they enter that information into the text boxes, the info is then sent to my SQL database. The code looks right to me, but it never comes up. Here is the code I have for the button_click.
 
Dim NTAdatasource As New SqlDataSource()
NTAdatasource.ConnectionString = ConfigurationManager.ConnectionStrings("DatabaseConnectionString1").ToString()
NTAdatasource.InsertCommandType = SqlDataSourceCommandType.Text
NTAdatasource.InsertCommand = "INSERT into ContactUs (YourName, EmailAddress, DateTimeStamp) VALUES (@YourName, @EmailAddress, @DateTimeStamp)"
NTAdatasource.InsertParameters.Add("YourName", txtYourName.Text)
NTAdatasource.InsertParameters.Add("EmailAddress", txtEmailAddress.Text)
NTAdatasource.InsertParameters.Add("DateTimeStamp", DateTime.Now)
Dim RowsAdded As Integer = 0
Try
RowsAdded = NTAdatabase.Insert()
Catch ex As Exception
Server.Transfer("problem.aspx")
End Try
 
If RowsAdded <> 1 Then
Server.Transfer("problem.aspx")
Else
Server.Transfer("success.aspx")
End If
End Sub
 
The strange thing is that when I debug, the "rowsadded" value comes up to 1. The process runs through debugging just fine and redirects me to my "success.aspx" page. What am I doing wrong?
 
Thanks

POST BACK TO SERVER

hi all,

Pass Paramenter To DTS-HELP! (2nd Post)

HELP! I'm trying to pass parameters to a DTS Package(SELECT * FROM TABLE WHERE STATE = ?) What is the format from xp_cmdshell("exec master..xp_cmdshell 'dtsrun /Ssql /?????")? Any ideas? Thanks!