Answer Questions

• Neil_Trainer1 xp_sendmail issue

  I'm using Server 2000....I have pointed the master database to the sqlmap70.dll so now QueryAnalyzer understands the xp_sendmail syntax; EXEC master..xp_sendmail 'Callan' , @query = 'qmtest' ....however, I now receive the following error; xp_sendmail: Procedure expects parameter @user, which was not supplied. ....yet, when I add the parameter @user = 'guest' It tells me; xp_sendmail: Invalid parameter '@user' Any help would be GREATLY ap ...Show All

• Goodguy Looping through rows in flat file

  I'd appreciate some guidance on how to solve a problem. I have a flat file of the format Header1 Header2 Header3 Data Record Data Record ... etc. ... Data Record Trailer1 Trailer2 I want to loop through each data record. I want to take a column value (string) from each row, and call a stored procedure passing in that value. The s/p will return another string which I want to use to update the original column value from the flat file. If I can't u ...Show All

• WilliamDGJones UPDATE statement via stored procedure

  Hi, I have a question regarding updating a record with SQL 2000 or SQL 2005. Imagine the following scenario: - A database table "Customer" with the following fields: id, firstname, lastname - A stored procedure : ..... @Id uniqueidentifier, @LastName varchar(20), @FirstName varchar(20) UPDATE Customer SET ID=@Id , firstname=@FirstName , lastname=@LastName WHERE ID=@Id .... Imagine that in the paramet ...Show All

• rain_flow Remove "top of report" when published via ASP call

  Sorry the subject is a little vague! I am issuing reports via ASP pages. I inherited this setup from my predecessor, who has a cycling "Sales Board" that calls reporting services pages from a script. All other pages do not have the light colored band across the top in which you can add parameters, click the "View Report" button etc. I have now created a new report and this band is there - can anyone please tell me how I ca ...Show All

• robosport Can you use Rank to get rows 51 to 60 of a query?

  I have not installed SQL Server 2005 yet (hopefully this weekend), so I have not been able to experiment yet. One of the things I had hoped would be added to T-SQL is a way to get a range of rows out the middle of a query to populate a table, e.g. when you are showing the user page 6 of many.  I had been hoping for a variation of SELECT TOP something like: SELECT ROWS 51 TO 60 * FROM MyTable WHERE State = 'CA' ORDER BY CustomerNum ...Show All

• Mayur K Business Scorecard Integration with SQL server 2000/2005

  I was trying to install Business Scorecard Manager Server , for that i have installed SQL server 2000, Analysis services and Service Pack 4 and also have taken mixed mode of authentication . Then i have installed sharepoint portal server 2003 and extended a site . Now when i install BSM server at the end of installation it gives me error that user administrator does not exist in Scorecard server database( Database which is created during insta ...Show All

• Pascal Bourque Replication between SQL CE 2.0 and SQL Server 2005 not working

  Hi, I've been trying to get my merge replication to work with a sql ce 2.0 on sql server 2005, but it keeps generating shapshot scripts my pocket pc can't execute. Example of my table.sch file in my snapshot folder: drop Table [dbo].[Application] go SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Application]( [AppID] [nvarchar](20) NOT NULL, [AddOnInfo] [nvarchar](50) NULL, [MaxClients] [int] NULL, ...Show All

• LeonM Problem with Union ALl

  I want to combine 4 columns and map those 4 to respective fileds in the target database.For this..when i used "Union All " its going for cross join and filling the columns with Null vlaues.. Like If each column has 5 rows ,iam getting (4* 5 =20) 20 rows Is there any solution to avoid for this and to get the 5 rows Thanks Kumar I need only 5 rows with out any null values (making sure that there is no ...Show All

• Delusion7 Various data access issues with June CTP

  Hi, June CTP is much better than April CTP, I can get a little farther than before with data access however there are still problems. - Converting 2000 database with the wizard. now creates the database and move some data however the process times-out even with a little database - migrating DTS2000 packages, half of them now gets migrated but half of the migrated packages are unusable. it would be nice if the wizard would automati ...Show All

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

• Gordigor SQL 2005 Mirroring... Remote Broker ID does not match the ID on the principal

  Hi, I'm trying to get database mirror working with SQL 2005... but I'm not having much luck. Any pointers would be appreciated. I've got 3 separate machines in a work group configuration. There isn't a primary dns suffix so I'm just using the simple machine names. I've configured the certificates, logins/users, and end points. On the mirror I do the ALTER DATABASE SET PARTNER and that works. On the primary I do the ALTER DATABASE SET PARTNER and ...Show All

• Kalpana Rajan No TRIM function in 2005 - are you serious!?

  I cannot believe that there is yet another version of SQL Server without a TRIM function.  So for SQL 2005 (like I've done in 7.0 and 2000) my T-SQL will look like dog poo because I will have to write LTRIM(RTRIM(MyValue)) anytime I want to remove whitespace from both ends of character values instead of just writing TRIM(MyValue). Microsoft - how can you write LTRIM and RTRIM and not write TRIM in the same breath an ...Show All

• Phanindra Problem creating diagrams

  I just upgraded an existing sql server 2000 installation with the RTM sql server 2005 (developer). I went to work on a database that I've been working on for a couple of weeks before the upgrade, and wanted to create a database diagram. However, when I click on the "Database Diagrams" tree node, I get this message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed ...Show All

• DaveCat DeleteSubscription leaves job in SQL Server

  Has anyone else noticed that if you create a timed subscription using the web service and then delete it using the DeleteSubscription method, there is a job (id'ed by a guid) left in SQL Server Jobs Consequently we now have hundres of "orphaned" jobs in our database :-( A bit more investigation appears to reveal this: I use data driven subscriptions and create them using CreateDataDrivenSub ...Show All

• hmemcpy Instert found records into DB

  here, this query produces 21 days for @TotalPostingDays  ...the days left after pulling out weekend days (sat and sun) and holidays. What I want to do is instead of pulling the total amount for @TotalPostingDays I want to insert the actual dates that are contained within the @TotalPostingDays into a table DECLARE @TotalDaysInMonth int ,             @today datetime , ...Show All