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