SQL Server

Page 5872




  • Topics
    Replies
    Last post
  • Conditional checks in SSIS.
    by ASOOD
    14 Replies
    Last post by Dave Sundell
      • I have two connections in a package pointing to two different databases on the same server. I have to insert records from 'DB1' table 'Gender1' to 'DB2' table 'Gender2'. Before I do that though, I have to make sure the minimum value (of all the Gender Keys that are going to be inserted) of 'DB1' 'GenderKey' (which is an identity field) is greater than the maximum value of DB2-GenderKey (which is a
  • Checkboxes in Reporting Services?
    by NeilSt
    5 Replies
    Last post by Jarret
      • Hi all Is it possible to have a checkbox as a parameter.. So a user can check a box to include a column or uncheck to hide a column Thanks Neil
  • Navigation from the header
    by indersunny
    2 Replies
    Last post by Robert Bruckner MSFT
      • Hello I have a link on the header to jump to another report. It was working fine on test server but when deployed to production, is giving the followin error. Any suggestions Thanks Inder The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)
  • Problems trying to insert data into the database using excel
    by leozidane
    1 Replies
    Last post by Bob Bojanic - MSFT
      • Hi all, I have encountered a problem. In the past i run a sql query to select all the data from the excel file and insert them into my SQL database. However recently i encountered an error when i run the query. Msg 7399, Level 16, State 1, Line 4 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "excel_ls" reported an error. The provider did not g
  • tempdb Log file - stop/start SQL Server to reset tempdb???
    by jortiz
    9 Replies
    Last post by Dhericean
      • Hello when I start executing a transact SQL process, my tempdb file is about 5Mb and It's log file is 1Mb, when the process finishes the log file never gets cleaned again... so It uses a lot of hard disk space and I can't run the process again... Pd. the process has a "begin tran" and a "commit" at the end... Could you tell me what to do
  • Code to flatten a CellSet into a datatable
    by mmman
    3 Replies
    Last post by Jeffrey Wang
      • Hi, Here's some code I've written which flattens a CellSet into a datatable. I looked for a long time to find similar code but could not find any. Can I please have some thoughts on optimisation/elegance etc... I'm a bit new to .NET so any advice would be great! Thanks. Code Snippet Public Function GetFlatData() As DataTable 'If (Me.Cells.Count = 1) Then ' Return New DataT
  • LIKE
    by Ben Amor Bassem
    1 Replies
    Last post by Jarret
      • HI,I want the synthaxe of a query with "LIKE" knowing that the fields must contain strings then a parametre then strings I tested with this synthaxe but it is not true: New_VilleExtensionBase.New_name LIKE ¡°%¡± + @param1 + ¡°%¡± How is that done
  • How to specify the MSSQL.1 DATA folder in SQL Express?
    by Graham Tree
    7 Replies
    Last post by Mike Wachal - MSFT
      • How do you determine the data folder during the SQL2005 Express install No matter what folder I start with it gets appended with MSSQL.1 or MSSQL.2 If another vendor has installed a different instance of SQL2005 how do I know whether mine is .1 or .2 Basically I need to know the full folder in order to copy our MDF/LDF files into so we can attach them. Or is there another w
  • Is Full-Text Index really that much overhead?
    by Brian Kitt
    5 Replies
    Last post by Tom Phillips
      • I am a developer, and I have a disagreement with my DBA. He has convinced management, that SQL 2005 FullText Index is so much overhead on production, that it should NEVER be used under any circumstances. We have a Cold Fusion site, and somehow he convinced management that a bunch of Cold Fusion developers can create a more efficient full text indexing method than by using SQL 2005 Full Text Index.
  • Hourly Data
    by Lawrence 007
    7 Replies
    Last post by Lawrence 007
      • Hi, I am trying to get total transactions for Cashiers on an hourly basis from my SQL Database. All the data is in the DB, but I have never ran a query that Counts transaction numbers per hour. I can get the total transactions per Cashier for the day, but not per hour. Does someone have an answer for me Thanks Lawrence
  • What happens when the 4 GB database size limit is reached?
    by psc161
    7 Replies
    Last post by Steve Herbert - MSFT
      • Does the user get an error message What error does an application get that tries to insert additional data via ODBC
  • Can I debug a SQL 2005 stored procedure with the SA account
    by Arjan Alite
    1 Replies
    Last post by Arjan Alite
      • I want to know if I can debug stored procedures remotely with the SA account. I can not have Active Directory in my system right now. Thanks
  • What permission required to DROP TABLE ?
    by Fahad349
    4 Replies
    Last post by Steven Gott - MS
      • Hi, I would execute the following query to allow a user to create table USE dbname GRANT CREATE TABLE TO username but it doesnt let me execute the following query GRANT DROP TABLE TO username I am wondering if there is a way to do this. I know db_ddladmin does that. But I dont want to assign the whole role or schema to do that. I want specific privilege According to SQL Server documentation, we n
  • Clarification on product specification
    by Gish
    1 Replies
    Last post by ErikEJ
      • http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx The above link says the pros and cons of two SQL Server 2005 editions. Document says Compact Edition is not good for ¡®When you need a multi-user database server ¡¯. What is the meaning of multi-user database Does this means the database strictly will not support two database connections at a time -Thank
  • SP to search on any number of characters
    by nbk5533
    4 Replies
    Last post by nbk5533
      • I would like to know if someone would know how to write a Stored Procedure (using Select statement) to search on a partial word, for instance, like "micro", for Microsoft Office, Microsoft Communicator, etc. or an ordered number of characters, that are unique, like "obe", and will retrieve, ad"obe" or adobe. I'm using SQL 2005 and I'm running the search against
  • Is there a way to parameterize lock type?
    by Vagif
    8 Replies
    Last post by Vishnu Chauhan
      • Hello, I have a stored procedure where I select data using a lock hint, e.g.: select * from MyTable with (UPDLOCK) Depending on arguments passed to a procedure I need to be able to turn locking on and off, otherwise I will have to create two versions of a stored procedure (or two SELECT blocks in one) with duplicate contents that differ only in lock directive. Is there any way in SQL s
  • Conflicts in Merge Replication
    by Aniket
    5 Replies
    Last post by Junhai Kan
      • Hi, I am using SQL Server 2000 Merge Replication. Sometimes when the data is replicated there are conflicts which when examined show it is due to voliation of foreign key constraint. But the data (keys) in already present in the master tables. Is there a way to give an order to the way the tables are replicated. This is so because i think the data in the details table is relpicated first in
  • cluster install 2nd node unavailable
    by acki4711
    6 Replies
    Last post by acki4711
      • Hi all, Try to install sql 2005 x64 on a Win2003r2 x64 two node cluster. All looks fine as far I get to the "cluster node configuration" dialog. My second node is always displayed as "unavailable node" reason "unknown". - I checked the logfiles but could not find any error. - Installation user & cluster user are both local admins. - Tried with sql 2005 x32 v
  • Job interview question
    by SiBown
    2 Replies
    Last post by mrdenny
      • I have been asked by a person who is going to interview me to supply this informationl; ' Come prepared to be able to talk me through how to set up an SQL driven .NET website on a server. You are given a webroot folder containing root files such as the web.config and all the files for a .NET website and a data folder which contains an .mdf and .ldf files. Talk me throu
  • Setting multi-value parameters using ReportExecutionService
    by qball0203
    3 Replies
    Last post by gg6767
      • Does anyone know how to set multi-value parameters using ReportExecutionService in C# If I have rsExec = new ReportExecutionService2005. ReportExecutionService (); . . . ReportExecutionService2005. ParameterValue [] parameters = new ReportExecutionService2005. ParameterValue [2]; parameters[0] = new ReportExecutionService2005. ParameterValue (); paramete
  • Calculated Fields in the report
    by shamen
    9 Replies
    Last post by shamen
      • I'm supposed to create a report like shown below. Credit Tier Jan-07 Feb-07 Mar-07 AA 0.00% 0.00% 0.00% A 0.00% 0.00% 0.00% B 0.00% 0.00% 0.00% C 0.00% 0.00% 0.00% Time columns go up to Dec 07. But I did not show all the columns. The values are
  • Performance is degraded drastically after migrating to SQL Express 2005 from MSDE 2000
    by SasiInfy
    8 Replies
    Last post by SasiInfy
      • Hi, Recently we have migrated our application from MSDE 2000 to SQL Server Express 2005(SP 1). This has significantly reduced the performance of our Windows.NET application which is developed using C#. For example : While logging in to the application two databases are being attached. Time taken in MSDE: 16 secs Time taken in SQL Server Express 2005 : 58 secs
  • extract information from tables
    by Gemma
    2 Replies
    Last post by Gemma
      • Hello Guys, my collegue left the job and I have been chosen to work on his assignments. He posted this question before and got the answer but I couldn't find a way to implement it in the program. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1726638&SiteID=1 I changed the database a bit as I couldn't understand his logic of putting both PayID and TransNo as this woul
  • AWE working?
    by Ning
    3 Replies
    Last post by Arnie Rowland
      • Hi all, This is a question related to AWE settings. I am on windows 2003 ent version with SQL Server 2005 std version. I have configured SQL Server to use AWE and min memery as 22G and max as 26G (I have 32G in total as physical memory). I do see the message in log as "Windows Address ... Enabled", but when I am using performance monitor to view total memory in kb for SQL Server,
  • Problem with ID 17981
    by mauricio.franzolin
    2 Replies
    Last post by mauricio.franzolin
      • Hello, I¡¯m trying to do an update through a system but this message display a problem that I didn¡¯t get to identify exactly the problem to looking for a solution. "Table error: Object ID 17981, index ID 1, page (0:871674153). Test (offset + len < PAGESIZE) failed. Slot 10, offset 0x1a8 is i Error while undoing logged operation in database " Could anyone help me ple