Answer Questions

• Matthew Watson How connect SQL server 2000 with c#.net .....?

  Hello masters, help me yaar i am using dotnet 2003 and SqL SERVER 2000. BUT UNABLE TO CONNECT DATABASE using dataAdaptor(design time ) or sqlconnection any can help me gs hi i am using this code it dose not show any error as well as no output... please check it... string conn = ("Data Source=localhost;"+ "Initial Catalog=gstest;"+ "User ID=sa;"+ "Password=logic;"); SqlCo ...Show All

• erikj INSERT fails - problem with SQL command or SQL server?

  I've posted this on http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=85&SiteID=1 , but it might be better here, so I've re-posted. I'm looking after a batch system which posts files to a asp site. This de-constructs the files, builds a SQL INSERT/UPDATE/DELETE statement and executes the SQL. If this fails, I assume that there is a problem with the SQL, invalid column names, duplicate records, etc. It is critical that the applic ...Show All

• daisy1225 Problems running SQL Agent Jobs & SSIS Packages

  I'm having some difficulties with the SQL Agent and running my SSIS packages. At present, I have several packages that import data from Oracle, a few that use a JODBC connection and several more that transfer data from other SQL servers (2000) I originally had the SQL Agent log in as a System Account, and although the pacages run fine if I manually right click and execute them, if I add them to a Job they fail with a login error. I then changed ...Show All

• DLafferty What are the implications for changing the remote distributor SQL server service details

  Hi, I am replicating a couple of SQL2K databases via transactional rep and remote 2K distributor to 1 SQL2K5 database. I want the distributor to email me when/if any of the agents fail etc. In order to set this up, I think that I need the SQL Server service to use a domain account (from error messages that I have been getting). It is currently using a local system account (it was a test box in a previous life). I have tried this briefly ...Show All

• NTx Beta Report Builder button

  We've installed SQLServer 2005 and are trying to use Report Builder.  But we only see the Report Builder button if we're currently logged onto the machine that's running RS. My understanding is that anybody with a role of Content Manager should be able to see this, but nothing we do with the role assignments seems to help. We've installed on XP and Win2003 machines and this behavior is consistent. Any ideas TIA, Jim ...Show All

• Michael Boehm Problem dropping replication support

  I am working on establishing a merge replication process between SQL Server 2005 and SQL Mobile 2005. I started with a new SQL Server 2005 instance and went through the Sample for SQL Mobile merge replication. So far so good. Today, I tried to drop all support for replication on my current SQL 2005 test instance, so that I can start from a fresh instance and do another. I used Management Studio to drop all publisher and distribution settings ...Show All

• Gareth_teh_Geek DTEXEC ReturnCode

  Hi, The DTEXEC Utility has the capability of returning ReturnCodes which have specific meanings e.g. ReturnCode=3 means: The package was canceled by the user. Is it possible to set my own ReturnCode values For example, my Package contains a Script Task which contains code to search a folder for a file. If the file cannot be found then I make the Script Task fail and hence the Package fails. But, when the Package is invoked by the D ...Show All

• Ozan Cetin SQL Server 2005 Reporting Serivces: XML Datasource problem

  Hi, I'm just starting to use SQL Server 2005 Reporting services, and need to use an XMLdocument as the datasource. I will get the xml data from a webservice and then need to bind it to the report. Here is what I am doing: 1. I created a webservice at the following location: http://localhost/myWebDirectory/myService.asmx . this webservice has a method called " GetXMLDocument" that has 1 parameter (sql). This method uses the sql st ...Show All

• Mark Raimondi Return the data from a table ordered by its hierarchy

  How can I create a function that returns hierarchical data from a table with this structure: - CategoryID - CategoryName - CategoryFather I want to bring the result set like this... CategoryID | CategoryName | CategoryFather | HierarchicalLevel 1 | Video | 0 | 0 2 | DivX | 1 | 1 3 | WMV | 1 | 1 4 | Programming | 0 | 0 5 | Web | 4 | 1 6 | ASP.Net | 5 | 2 7 | ColdFusion | 5 | 2 How can I do this Does anybody has a sample code I need th ...Show All

• Patrick Berny SQLAgent is not allowed to run

  Hi Keep getting this message in the Application Event Viewer . Hi I am also geting this problem but running on a SQL2005 instance running share point services. Is it the same fix as in the artical regarding SQL2000 delete the GUID key in the reg ta Jon After feeling like taking a bit of a risk i tried deleting the GUID on the 2005 instance and so far (touch wood) it seems to have worked the SQL Agent is runn ...Show All

• JamesVSTS Exception Has been thrown by the target of an invocation

  Getting this error "Exception Has been thrown by the target of an invocation" when trying to create Integration Services Project. Any ideas what can be wrong Thanks. In our case the problem was related to the installation image we used to setup our computers (every PC that used that image had the problem). I am receiving the same issue... were you able to solve t ...Show All

• Jeffrey Palermo Troubles returning values with SQL Statement -

  Hi, I just want to know the following. Is it posible to write a SQL statement that searches all values in a table where the e.g: "Jobid = 1" and sort the result set according to the "CategoryID" then if you want to display the values, you can populate them according to the "CategoryID" and then also write the result set to a "text file", and catagorize everything according to the "c ...Show All

• RichieRichieRich connect to MSSQL2005 via ODBC

  Installed SQL2005, connect via (the new) SQL Nativ Client ODBC Vers. 2005.90.1399.00 works, just as (the old) SQL Server ODBC-Driver 2000.85.1117.00. Works fine. But from an other machine -there is no client installed - using driver 2000.85.1117.00 I get the message "Server dosn't exist or access denied" How I can connect It is due to the fact of .NET FRAMEWORK 2 Thanks! Have you verified using the Surface Area Configuration tool that rem ...Show All

• Mata1979 Creating xsd schema file for a xml file ...

  Hi ... I need to bulk insert the xml data below.  I am working on some issues related to the Itentity column (you may have read the other question).  The xml below uses elements with attributes.   Is the schema file formated correctly to extract the attributes from the SITE element and then also extract the attributes from the ATMOSPHERIC element ...   Not sure about the schema file Thanks, Chris /////////// ...Show All

• Charmy Frustrated: Error Output in Source and Destination Editor.

  Hi Is there anyway I can multi select rows when I'm changing the value for either Error or Truncation    I'm finding it frustrating having to change 2 values for each row in the output.  for example redirect row, when I have 10,20,30 columns. It would have been nice to have a global drop down at the top of each column so that I could then selectively change rows back. Any hints and tips on making this easier would be gratefully ap ...Show All