Answer Questions

• Dave299 Instructions for setting up a Sybase ASE Server as a SQL Server 2005 Linked Server?

  I have a Sybase Adaptive Server Enterprise server which I need to set up as a linked server in SQL Server 2005.  The Sybase server is version 12.5.2, and the Sybase ODBC driver version is 4.20.00.67.  I have already installed the Sybase client software on the server. I also created a SystemDSN on the SQL Server to connect to the Sybase server.  I tested the connection and it was able to connect. I ran the following code to c ...Show All

• dundret Variables - Changing Scope Once created

  If I have created variable and have written expression etc and then I have realised that I have created it in the wrong place. For example I have created the variable inside Package scope instead of Foreach Loop scope. Yes I know it is my mistake. Do you think it would be nice to have a feature to change the scope from Package to Foreach Loop Maybe a drop down list I am sure there is a reason behind why it was done like this. I would appreciate ...Show All

• None007 Full-text method for SQL Express

  Hi, I have enabled full-text indexing for my database in SQL Express. I have also managed to select which column I would like to perform FT searching on in the 'Modify table' section. However when I run a Freetext/Contains query nothing gets returned. I have rebooted my machine as instrcuted in previous threads! Unfortunately I am totally new to all this and have no idea what the steps are to carrying out this task. Do I need to populate my full ...Show All

• kristoffer pagels SQL 2005 - Shared Load Cluster

  Hi This is more a product featuer question which I cant seem to find the answer to If we wanted to share the loads of SQL Server requests over say 2 or 4 servers, is this possible What I mean is basically Active/Active load balancing / clustering So we have one Virtual IP and all requests are forwarded to the least busy server..... J Yes this is possible in SQL Server 2005, you need to install Std Edition to ...Show All

• Barb O RMO Equivalent for Merge Replication T-SQL Procedures

  We want to have some information about RMO (Replication Management Objects in SQL Server 2005) equivalent for the following Merge Replication T-SQL procedures. sp_changemergearticle sp_helpmergearticleconflicts sp_helpmergeconflictrows sp_helpmergedeleteconflictrows sp_deletemergeconflictrow Since I was not aware of these RMO properties, here is a response from someone who has that knowledge. Changing properties in MergeArticle object ...Show All

• Juan Vargas Case Statment - is this possible??

  the current statment reads as follows - SELECT @NonConsent as NonConsent, @NonConsentPAS as NonConsentPAS,  SUM(CASE WHEN Cast(DateDiff(Day, EP.DateofBirth, GetDate())/365 as int) <=25 THEN 1 ELSE 0 END) As Under25,  SUM(CASE WHEN Cast(DateDiff(Day, EP.DateofBirth, GetDate())/365 as int) >25 THEN 1 ELSE 0 END) as Over25 FROM......... this works fine but now ive been asked to expand upon this for the following age groups 18-25 2 ...Show All

• MojoRobbins Adding SCRIPT and LOOK UP components using C#

  Hi, Could you please tell me how to add SCRIPT and LOOK UP component to a data flow using C# Also, is there any artilces/site which gives information about the SSIS programming Regards, Gopi Gopinath M wrote: Also, is there any artilces/site which gives information about the SSIS programming from the bol: http://msdn2.microsoft.com/en-us/library/ms136025(sql.90).aspx Dou ...Show All

• Wix 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

• staticfive Deny access to a view

  I'm having trouble creating a read-only view. I've got 1 or more tables that I wish to remain updatable but I want to create a view that covers the table and/or spans all the tables. However, I want the view to be select only. I can't seem to get it to work. DENY UPDATE ON [dbo] . [MyView] TO [dbo] CASCADE All that seems to execute my dbo user can still use... Update MyView set SomeID = SomeID + 10 Plus, ideall ...Show All

• Tom Shalloe Execution ID

  Hi , For how long is the value of Execution ID valid Is it valid after the session also Can i store the value of Execution ID in some place and use it after some time/day to get the last excution done on the report Thanks   Thanks for the reply. Can you tell me which table stores the execution id The execution ID is valid for 10 minutes by default.  But ...Show All

• bangaram HELP US MICROSOFT: SYNCH BETWEEN SQL EXPRESS AND SQL MOBILE

  Hi Everyone As most of you do, I am eagerly awaiting the ability to synchronize my sql mobile database on the hand held to a local sql express database on my local machine I know users in Microsoft have pointed out to us that we are getting things for free. At the same time, Microsoft is getting our patience for free and at a cost to us developers. Its nearly April and as one article says Microsoft will release a fix for this inadequ ...Show All

• Alvarohhhhhh ERROR: table don't support this operation

  hello all, this query causes error on some servers (sql2000 sp3). on our development server is this ok. we have restore the database from customer server to the development server, this is ok too. we don't know which configuration on the server can change to solve the problem. ---------------------- select distinct V.Vereinsname as Vereinsname, V.VNr as VerNr, V.PLZ as PLZ, V.Ort as Ort, V.Strasse1 as Strase1, V.Strasse2 as Strase2, '0' as Sel , ...Show All

• simserob Passing Parameter Query from SQL Function to Access Project Report

  I can pass a parameter from an Access Query to an Access Report (MDB) by entering [Select Date] in the Query criteria and by placing an unbound control with a control source =[Select Date] on the report. I can't get this to work from a SQL Function Criteria to an unbound control on the Access Data Project Report. In the Function Criteria, I enter @SelectDate. In the Report control, I enter @SelectDate and it gives me an 'Invalide Column Name' er ...Show All

• Dinh Quang Son oracle connection manager configuration help

  Hi, I dont know if I should post this question here, or on oracle forums, but here goes ... I made a simple package that performs 2 Excecute SQL Tasks, one task does a select query on a SQL Server DB Table, the other task does a select query on an Oracle DB Table. The package runs fine in BIDS when debugging, but when I deployed the package to a file system and added it to an sql server agent Job, it all went wrong ... I tried th ...Show All

• Microtoby Copy databases

  Hi, Maybe a stupid question, but I'm trying to copy some databases from one server to another. The copy databases wizard says the job is successful and I can see that the job has been done on the remote server. But the copied databases are not there. What do I do How do you know if the databases are not there do select * from sys.databases and see if they are there. 'Execute SQL Server Agent job' ge ...Show All