SQL Server

Page 5873




  • Topics
    Replies
    Last post
  • After restoring MASTER database, can't start SQLServer Service: Configuration block version 0 is not a valid version number
    by Ars_Maxer
    4 Replies
    Last post by Ars_Maxer
      • Now, I checked and verified that my backup version of SQL Server is the same as the version installed on the computer I'm restoring too. I have SQL Server on a production machine that I backed up and want to test a full restore on a dev machine to make sure it will work when I need it to. Now that I've run the restore command on my tape backup and go to restart the SQL server service
  • error: Could not find SP upd.sp_MSrepl_xxx_xxxxxx_1
    by Tony Fryer
    7 Replies
    Last post by Greg Y
      • Trying to set up replication as follows: SQL2000 publisher , acting as it's own distributor (v8.0.760) Transactional Replication with updateable subscriptions SQL2005 subscriber (v9.00.3042) Push subscription with immediate updating from distributor to subscriber and queued updating from subscriber to distributor The set-up went smoothly and changes in the publication db flow d
  • Plz do evaluate this SP
    by Aravindt77
    5 Replies
    Last post by Aravindt77
      • ALTER PROCEDURE JobsonUser_GetuserListValues ( @p_PortalID int , @p_UserID int, @p_SubscriptionText varchar(255)) AS BEGIN SET NOCOUNT ON --- Variable Declarations Declare @userID int Declare @portalID int Declare @DynamicQuestionID varchar(255) Declare @Question varchar(255) Declare @i int Declare @count int Declare @loop int Declare @SubscriptionList Table (PortalID int , Question Varchar(255)
  • Hide parameter if other paramter is null
    by The JD
    0 Replies
    Last post by The JD
      • What I have is a report using Reporting Services 2005 that will take in a parameter through the URL called RepID, so the parameter is hidden inside the report because it's passed through the URL. This will run the report for the specified Rep. However, I'd like to have another paramater (Or also using RepID) just as Admin which would be a boolean and when Admin='N', the RepID parameter should not
  • Stored procedure vs. query
    by Jiri Matejka
    14 Replies
    Last post by Adamus Turner
      • Hi, is it better to use stored procedures or queries in terms of performance I'm running application in ASP.NET, now the amount of data in the database is not very high, but I expect it'll grow, so I wonder about speed of queries etc. Is it better to use SELECT ... FROM ... or to prepare stored procedure for such select What about insert/update/delete thanks Jiri Matejka
  • data access to large tables in sql 2005
    by Zacky
    1 Replies
    Last post by Madhu K Nair
      • hi all, i have a large table in sql server 2005 (it has about 6 columns and 10 million records). i need to work in a linear way on all the records (i know it sounds dumb but i need to work on all records). now, obviously when trying to work on this table sql server get stuck for timeout or something like that... i've noticed that a simple function like "select top 100 * from E
  • SQL Server on Windows CE 5
    by Jaydutt Shukla
    3 Replies
    Last post by ErikEJ
      • - I read somwhere that the CAB files needed for installing SQL Server CE on a WinCE OS can be obtained with SQL Server 2005. Does Express edition have those files - I also read that same files are also distributed with VS2005. Since VS2005 is a development product, what are distribution for those CAB files when packaged with VS2005 - Additionally, there is SQL Server CE 1.7MB separate download b
  • Upgrading SQL Server 2000 Enterprise Edition to SQL Server 2005 Standard Edition
    by Buk usu
    5 Replies
    Last post by Arnie Rowland
      • Hi, I would like to find out if there is any way to upgrade SQL Server 2000 (Ent) to 2005 (STD) The Instance has many logins and jobs etc and I dont want to loose those A document or some advice on how to go about it would help Thanks
  • Should SQL 2005's BPool reservation size vary with "-g" startup parameter?
    by soonerdave
    3 Replies
    Last post by soonerdave
      • Hello, all We are trying to work out a memory problem associated with a SQLCLR procedure we have developed. This procedure will run properly on a SQLExpress box, but fails with an Insufficient Memory error (701) when run on our 32-bit enterprise edition server on W2K3 Enterprise Server. The server has 3.25 GB of RAM, and does *not* have the /3GB switch enabled; AWE is *not* enabled o
  • Trouble with Workflow DTS (SQL 2000)
    by ims.com
    4 Replies
    Last post by mayraims
      • Trouble with Workflow Hello. I have a DTS package that executes some tasks of the type "Execute Package Task". Every Task has a Condition of been executed just in case of success.  I understand that only if the precedent task ends successfully the next one would be processed. My problem is that the DTS continues even if one of the previous steps fails. Would you have any idea _________
  • Calculated Measures using AMO
    by Vijay R
    6 Replies
    Last post by furmangg
      • Hi, Stuck again...... I am creating Dimensions, Cubes, MeasureGroups, Measures, Partitions using AMO dynamically. What I need now is to create Calculated Measures using AMO, which would use some aggregation between one or two measures of the cube. I did not find any object that would enable me to work with Calculated Measures in AMO. It would be really helpful if I can get some code snipp
  • Show SQL search query in pages
    by Mr Sam
    1 Replies
    Last post by Jens K. Suessmeyer
      • How to show a SQL search query in pages for example 10 records in each page, like search engines. I'm using .NET Framework 2, SQL Server 2000 and Adobe Dreamweaver CS3. Thanx
  • Entering data into tables
    by FLABullFrog
    2 Replies
    Last post by FLABullFrog
      • How does one enter data into the tables of a new database in the first place I'm using SQL Server Management Studio Express. I can name the columns, but that seems to be as far as I get. Thanks for any Help.
  • INDEXING A VIEW in MSSQL2K5x64.de Standard w.SP1 ... ERROR 1939
    by wvg
    3 Replies
    Last post by Madhu K Nair
      • I'm experiencing a problem while trying to index a view ... I'm using a single field and everything else are default entry's. I'm getting the Error Message 1939 . The code is a follows: USE [CS_WGO] GO SET ARITHABORT ON GO SET CONCAT_NULL_YIELDS_NULL ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO SET ANSI_PADDING ON GO
  • SQL Reporting Services performance on navigation pages.
    by Ray Dodson
    12 Replies
    Last post by dribar
      • I am experimenting with SQL Reporting Services on a machine with SQL Server 2005 loaded and deploying reports to a different server. both servers are equivalent in resources. In the browser on the Reports machine when I first go to the Reports address, it takes a very long time to build and load the page. it then takes a long time for each drilled down page. Subsequent calls to the s
  • Select statement to output a date
    by AngelinaPerez
    4 Replies
    Last post by Vidhya Sagar
      • Hello Guys, Please could you help me formulate a SELECT statement to output a date in the format (Month, Date Year), eg October, 07 2007. Thanks.
  • Dumb question about compatibility level
    by msdnzoo
    4 Replies
    Last post by GlennAlanBerry
      • Hi everyone, This is my first psot so I am hoping for success.. I had been asked to web enable a sql 2000 database. We upgraded to sql 2005 and I imported the data. All went well until a tried to run a CTE ( common table ) routine and it kept on coming back with an error. On searching the web it turns out that the compatibility level must be set to 2005. When I tried to set the compatibility level
  • Updating the variable's value
    by SHIKO
    10 Replies
    Last post by SHIKO
      • Hello People, I'm using SSIS and I want to send a report to the admin about how many rows are new, updated or unchanged in a mail. Everything is working fine except that the values that are sent are always zeros. I'm using a Row Count Transformation and configuered it to update the approperiate User Variable which I priviously created. However, the initial values in these variables are always Z
  • BCP (BULK INSERT) with only <lf> as line delimiter (not <cr><lf>)...
    by .neo
    1 Replies
    Last post by KeWin
      • Hi, This might be a noob question, but is there any way to specify just <lf> as a line delimiter, and not <cr><lf> ( /n ) as line delimiter in T-SQL call for BULK INSERT (or BCP utility). How please TIA.
  • Replication using SQL server 2000 (SP4) .. urgent...
    by Rama2007
    1 Replies
    Last post by Peng Song
      • Hi, We have few branches with individual dbs are sitting in the branches itself. Periodically all the data need to be updated to a single HQ database. At the moment, all the tables's primary key are unique and each branch will have branch ID's in the transaction tables. e.g. Branch1 data need to be updated to HQ db. However, HQ db records which are related to Branch 1 data only need to be u
  • New Database
    by Leo_Frits
    2 Replies
    Last post by Leo_Frits
      • I want to design a new database. When I right-click on 'Data Connections' in the Database Explorer from VB I notice that the 'Create New SQL Server Database...' is greyed out, so I can't create a new database. What is going wrong here, please help.
  • Analysis Services Lock-ups
    by David Beavonn
    10 Replies
    Last post by Stefoon
      • I have a general comment and then a question related to Analysis Services 2005. It seems to me that AS2K (the previous version) scaled out better - because a significant amount of CPU-intensive calculation was done on the client machine. This was especially nice when user queries were: Poorly formed / unreasonable / just-plain-stupid Very intensive but we-must-have-the-data In the
  • Version for procedures
    by koosha
    3 Replies
    Last post by Arnie Rowland
      • Hi Is there any way to check a version of a procedure I mean I need to have version or comment for my procedure to indicate wicth procedure is currently is used in database
  • table column extended field properties
    by Boyd564852
    2 Replies
    Last post by Boyd
      • through MS SQL Server Management Studio I have a database defined as: dbname - Tables - dbo.xyz -Columns Field definition_a Field definition_b Field definition_c ... For each "Field definition" I can define "extended properties" So the question is, from a stored procedure in C#, how can I read through
  • Checking to see if a record exists and if so update else insert
    by Phil Brammer
    14 Replies
    Last post by bkallich
      • I've decided to post this as a sticky given the frequency this question is asked. For those of you wishing to build a package that determines if a source row exists in the destination and if so update it else insert it, this link is for you. http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx Thanks Jamie! If you