SQL Server

Page 2418




  • Topics
    Replies
    Last post
  • How to move Full Text Catalog SQL 2005???
    by Hikmer
    6 Replies
    Last post by Sudarshan N
      • I have Googled the terms 'move path change full-text index catalog' and have come up with nothing that pertains to SQL 2005...only 2000 and 7.0.... So my question remains, how the heck do you change the location of the full-text catalog in SQL 2005 Must I delete and re-create If so is there a good article on this process I don't want to loose data or screw anything up....I can't imagine
  • How to programmatically set column mappings of a simple data flow task?
    by Donny Ma
    6 Replies
    Last post by jwelch
      • Has anyone done this I can't find anything in the documentation that describes this. The closest I get is to the InnerObject property of the TaskHost class. There is an example of programming a bulk insert task. But I can't find anything on programmatically setting the column mappings (source to dest) of a simple data flow task. Any help is appreciated!
  • suggestions
    by sureshv
    10 Replies
    Last post by sureshv
      • I want to transform textfiles to sql server set based and not row based.what would be the best way to transfer. let me know.
  • Cannot get SSCE 3.5 beta 2 to work
    by JonM
    10 Replies
    Last post by Shimi Weitzhandler
      • I'm running VS2008 beta2. I've succefully added a SDF database file to my project and created a couple of tables in it from VS. I added a reference to the System.Data.SqlCeConnection. When I try to create a new instance of the SqlCeConnection class I get a nasty error that states I'm missing the 'sqlceme35.dll' file. I copy all of the files .dll into by bin folder. Now I'm getting a BadImageFormat
  • Database Mail Command Not Supported - Again
    by dknapp
    4 Replies
    Last post by dknapp
      • I have three SQL 2005 servers. Only one will send mail successfully using database mail. The only difference I can see in the way they are set up is that, in the database mail log, the server that works shows a last_mod_by of the domain account that runs SQL Server. The ones that do not work show "sa" as the last_mod_by in the database mail log. It seems that something seems to be trying
  • Generate a cube in Standard Edition
    by user__2006
    5 Replies
    Last post by sprdave
      • I would like to know if there are some example of how to generate a cube by c#. I am using MS SQL Standard Edition. The AMOAdventureWorks example, just run in Enterprise edition, because of Semi-Additive measures. Tks!!
  • SQL Server 2000 - Generating new field containing the sum of other rows
    by ajliaks
    3 Replies
    Last post by lkh
      • Hi guys, This one seems to be a difficult one: I have a table called "myTable" with a field called "myField" (which contains only numbers). I need to generate a new field where each row is the sum of the row in field "myField" plus all the values in the rows before it. something like this: myField NewField 100 100 = 100+0 200 300 =
  • Checking Job Status using T-SQL
    by kangalert
    11 Replies
    Last post by kangkang
      • Hi. How can i check the job status using SQL Query
  • Whats does this mean ??? --- SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds
    by rk07
    2 Replies
    Last post by rk07
      • Hello, I see the following error on the sql server log of one of our sql servers running sql 2000 with sp4. SQL Server has encountered 1964 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [h:\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x00000534. The offset of the latest long IO is: 0x0000002b09e000 Any idea as to what might be cau
  • Repeat Report Title On EveryPage
    by Joseph Ollero
    5 Replies
    Last post by GrahamM
      • Dear Anyone,   All reports have report titles especially in RS. These are usually big textboxes that can be found in the beginning of the report. When a report is executed, normally, these report titles, dissapear once we opted to go to another page of the report. Is there a way to make the report titles repeat on each page Thanks, Joseph Ollero
  • Cascading Date for Filter
    by cherriesh
    5 Replies
    Last post by Matt Tolhurst
      • Hi, I have a Date Dimension with these attributes: Datekey FullDate (eg. 1/1/2007, 1/1/2008) Year, Month (eg. Feb 2006, March 2006, April 2006) If i put the Year on the filter and select 2005, I want the Month filter to show only months with 2005 as the year. Is it possible cherriesh
  • Function with Dynamic Column Name without Execute statement
    by Vishnu Chauhan
    5 Replies
    Last post by Louis Davidson
      • Hi, There is a table named status keeping status of a policy at the end of every month. The schema of the table is as below. sym pol mod stat_198612 stat_198701 stat_198702 stat_198703 AAB 1409502 00 f f f f AAB 1409502 01 f f f f AAB 1409503 00 f f f f AAB 1409503 01 f f f f AAB 1409504 00 f f f f AAB 1409505 00 f f f f AAB 1409506 00 f f f f AAB 1409507 00 f f f f AAB 1409508 00 f f f f
  • Digest Authorization on HTTP Endpoint
    by Darrell Bennington
    5 Replies
    Last post by Darrell Bennington
      • I need to enable digest authorization on an HTTP endpoint, because the integration tools for some java code that needs to connect to it does not support NTLM or kerberos - only digest and basic. I setup a test endpoint in order to test only digest authorization (as opposed to the final endpoint which needs both digest and integrated), but I can't even get that to work - when I point my browser to
  • Query with CASE and NULL values
    by Codigo47
    5 Replies
    Last post by Codigo47
      • Hi, please, take a look to this query: declare @IDCliente int declare @Cliente varchar(50) declare @IDUsuario int declare @IDUsuarioAlta int set @IDcliente = 0 set @Cliente = '' set @IDUsuario = 0 set @IDUsuarioAlta = 0 select * from cliente where (IDUsuario = CASE @IDUsuario WHEN 0 THEN IDUsuario ELSE @IDUsuario END or idusuario is null) AND (IDUsuarioAlta = CASE @IDUsuarioAlta WHEN 0 THEN ID
  • SQLServer Error: 15404 with Active Directory
    by Syndrake
    14 Replies
    Last post by Raul Garcia - MS
      • Hello, I'm having trouble running jobs with my active directory (ADS) account. I've setup my SQL services to run under an ADS account, but jobs cannot seem to query ADS for user information. We're running Windows Server 2003 and SQL Server 2005 SP2. Here is the error message: == The job failed. Unable to determine if the owner (ADS\me) of job eFASRtest has server access (reason: Could
  • Sql server 2000 - xp_sendmail stored procedure
    by Anushka K Rajasingha
    3 Replies
    Last post by Anushka K Rajasingha
      • I have no idea about how can I use xp_sendmail when I try to use it this error displayed on the screen. There is no default mail client or the current mail client cannot fulfill the messaging request . Please run Microsoft Outlook and set it as the default mail ...
  • Error 500 Takes it's toll
    by CodedFreak
    4 Replies
    Last post by CodedFreak
      • The Error: An attempt to attach an auto-named database for file C:\Users\CodeFreak\Documents\Visual Studio 2005\WebSites\PersonalSite\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. --------------------------------------------------------------------------------------------------------------- I've tri
  • SQL Server 2005 SP2 (X64 version) Performance issues
    by Jitendra579618
    2 Replies
    Last post by Vishal Gandhi
      • Hi, We have our SQL databases clustered using MSCS on X64 servers and are planning to apply SP2. During initial tests, we find that around 20-25% queries perform slow after applying SP2 compared to SP1. Just wanted to know if anyone else has found the same behavior and if there are any known patterns / issues with respect to performance for Sp2
  • Help: How to improve the speed of Sync.
    by YoungC
    5 Replies
    Last post by ErikEJ
      • I have a table which has around 132000 rows with 24 columns. I use rda.pull download the data to PDA. For query these data, I must create a index on 5 character columns. The data download time is good enough, around 4 mins. But it takes 12mins to create the index. Please help to give me any idea on how to improve the whole synchroniztion speed. Thanks!
  • TSQL for dependency hierarchy
    by Stubey
    6 Replies
    Last post by NorthwindDBA
      • Hi i have a stored proc that searches through stored proc etc text and returns the name if some text is found in it. I would like to extend this so whne the stored procedure name is retrieved it checks to see if that stored proc is used in another stored proc. Thus building up a tree of dependencies (i dont want to use the sysdepend function). im sure there must be TSQL around that does
  • Struggling with dts from .NET
    by enric vives
    1 Replies
    Last post by enric vives
      • Hi everyone, We've got running an vb .net service which throws on-demand .DTSX. Now a new feature has been added: it must be able to launch dts 2000/7.0 too. No problem with that. It works fine using the same thread. Issue comes when we were accostumed to cancel any DTSX execution for sake IDTSEvents interface and OnQueryCancel event. We want to the same but for the old ETL. My wonder i
  • Error when deleting report in Report Manager and SQL Management Studio
    by LFP
    4 Replies
    Last post by LFP
      • I am getting a rsInternalError when I try to delete a report in Report Manager and SQL Management Studio. I am able to deploy, move (as long as the report doesn't exist at the destination) and upload but not delete. This is the error dump: <Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.3050.00</Product> <Locale>en-US</Locale> &
  • MSSQLSERVER service error when starting (timely fashion problem) :((
    by Felix Adhitya
    2 Replies
    Last post by Felix Adhitya
      • Hi All, I would need your help please :((. When i tried to start the SQL Server service theres an error sayin like this "The MSSQLSERVER service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion. " Do you have any web link for solution or you have any solutions, please kindly help :((. Thanks a l
  • date conversion - derived column
    by CSharpCoder
    14 Replies
    Last post by Phil Brammer
      • I'm reading a .csv file that has a column such as 17June2007:00:00:00, how can I convert this column in my Derived Column routine so its inserted into my DateTime column in my database so far I've tried DT_DateTimeStamp DT_Date DT_DBDate DT_DbTime and its kicking back errors on this column. What do I have to do to convert 17June2007:00:00:00 into a readable datetime fo
  • Built-in data types in SQL Express: best practices?
    by CnoEvil
    22 Replies
    Last post by CnoEvil
      • Greetings, I think these should be rather simple questions, yet I spent a number of hours last night digging through the forums here and msdn and couldn't find any satisfactory answers. Basically, there tend to be types of information that are commonly saved in most databases, like names, addresses, phone numbers, email addresses, etc...and there are a variety of built in data types in SQL