SQL Server

Page 2116




  • Topics
    Replies
    Last post
  • Compatibility issues?
    by Pikker1981
    3 Replies
    Last post by Michael Hotek
      • Hi there, Correct me please if I'm wrong but one should not get any issues while restoring a database backup from a sql 2005 development edition to an enteprise edition or even from a sql express edition to whatever else I was under the impression that a sql 2005 database, no matter what edition, would work on all the other 2005 server editions/versions and hence, the backups from these databases
  • Can I mirror a sql server 2000 DB in Sql Server 2005?
    by Bharahti
    6 Replies
    Last post by Vishal Gandhi
      • Can I use Databse Mirroring to mirror a DB from 2000 in to Sql server 2005
  • When adding SSL certificate to SQL Server, C application no longer connects. With Reply from Coder
    by Anonymous564618
    7 Replies
    Last post by Xinwei Hong - MSFT
      • When adding SSL certificate to SQL Server, client applications no longer connect. Error: 17832, Severity: 20, State: 10 2007-04-03 11:42:52.82 server Connection opened but invalid login packet(s) sent. Connection closed.. SSL is not even enabled and we still have this problem. When the cert is removed, then the app works EDIT: THis seems to be happening when we use db
  • Problem starting sql express
    by mrholtsr
    4 Replies
    Last post by mrholtsr
      • I am having trouble starting sql express. When it downloaded it automatically set the start mode to network service. I am not working from a network so I changed it to local service. Then it refused to start. I tryed system service and still it would not start. So I returned it to network service and now even that will not start. Can someong tell me how I can start sql. Thanks, Ray
  • Trigger problem, comparing deleted/inserted not working :(
    by Dallastower
    9 Replies
    Last post by Dallastower
      • Hello all, I have I trigger where I want to insert all _changed_ rows from the INSERTED table into a table called tempProducts. If I put this query inside my trigger, I selects exactly the rows I want: rows changed Code Snippet SELECT * FROM INSERTED EXCEPT SELECT * FROM DELETED I the current trigger I have Code Snippet INSERT INTO dbo.TempPro
  • What version to use?
    by 00seven463280
    1 Replies
    Last post by Jens K. Suessmeyer
      • We've used SQL 7.0 for the last 6 years and now I'd like to buy a new computer and install a fresh SQL server in it. What version I can use We create web pages in the fly using Active Server Pages by querying from the sql server. Enterprise Manager is what we usually use to add/edit tables int the SQL server and Visual InterDev is the one we get connected to the SQL to view/edit data. Those who
  • sql server and vldb
    by Aleks K
    5 Replies
    Last post by ggciubuc
      • I put attention that when I open connection to large database the amount of memory which sqlserver service uses grows dramatically. What is the reason: the size of database or memory space for query How I can reduce memory expencies
  • Reading a flat file
    by Xoltrix
    1 Replies
    Last post by Phil Brammer
      • I get the following error when reading a flat file : [Credit Information 1 [1]] Error: Data conversion failed. The data conversion for column "AccountName" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". I did check all the mappings, and everything seems to be fine, the field is read in as a string. I
  • Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
    by SpecialTee
    14 Replies
    Last post by Yui_Ikari
      • This was originally posted in the SSIS Forum , but a member of the IS team suggested it be moved here.  " Most recently I got this error (Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) so does this mean that SQL Server is still trying to use named pipes even if I only have TCP/IP enabled in SQL Server Configuration Manager " I'm having the same issue, and here
  • Controlling flow in a stored procedure
    by ChrisS-AllentownPA
    3 Replies
    Last post by ChrisS-AllentownPA
      • I have a stored procedure with two UPDATE statements in it. The second UPDATE statement relies on the completion of the first UPDATE statement to run correctly. The problem I am running into is that SQL Server sometimes runs the second statement before completing the first. To get around this, I tried putting the second UPDATE statement in a different stored procedure called within the first
  • Index Creation Before Bulk Insert
    by RBCSTRC
    3 Replies
    Last post by DanR1
      • This weekend, I tried to run some large bulk insert statements followed by create index statements on the tables I inserted the data into. For some reason, it didn't finish the largest insert statement. However, the index for that table started creating. Then my log file grew to a half a terabyte. Now the cancel statement is taking forever. What am I doing wrong Here is the part of the code.
  • SQL2K client on SQL2K5 install
    by vr8ce
    5 Replies
    Last post by Euan Garden
      • I have a developer's edition of SQL2K5 installed on my laptop (on XPSP2), but I would like to also have a copy of the SQL2K client tools (Enterprise Manager and Query Analyzer) on there for occasionally talking to SQL2K machines. I know SMSS is theoretically backwards compatible, and I use it on SQL2K machines, but 10-20% of the time the theory doesn't turn into practice. We can't debug procedures
  • Question about Database Mirroring and Possibly NLB
    by Billy Strader
    12 Replies
    Last post by Michael Hotek
      • OK since my company really would not prefer to spend the money for Windows 2003 Enterprise and MS SQL 2005 Enterprise I was thinking about this idea... Server1 - W2K3 Std - SQL2005 Std - Primary Server2 - W2K3 Std - SQL2005 Std - Mirror Server3 - W2K3 Std - SQL2005 Std - Witness Server4 - W2K3 Std - SQL2005 Std - Processing OK So we have Server1 & Server2 doing the Database Mirroring. Th
  • Install Developer Edition on Windows XP Media Center Edition?
    by ddebd
    2 Replies
    Last post by ddebd
      • Can I install SQL Server 2005 Developer Edition on XP Media Center Edition Thanks.
  • ting services for reports on DW and OLAP (SQL server 2005)
    by fasttrack
    4 Replies
    Last post by fasttrack
      • Hello, I would like to know if Reporting Services 2005 is a good tool for making reporting activities on SQL Server 2005 DW and also using OLAP (Analysis Services 2005). There are any limitations or bugs to using it. This is good for trends. Thank, any help will very appreciated.
  • SQL Server Express Edition Advanced Services SP2 install problem
    by tboy
    2 Replies
    Last post by chee-kee-mon-kee
      • I recently downloaded and attempted to install this express edition. I currently have the SQL Server Standard 2005 installed on my cpu but is dedicated to the Business Manger for my Outlook 2007. Normally I suppose this is not an issue but the edition does not have the reporting feature, hence the reason for downloading this new edition. My system meets all required specs but when I get to the las
  • Flat file Import performance question
    by Pikker1981
    3 Replies
    Last post by Bob Bojanic - MSFT
      • Hi there, I have a question regarding 2 approaches importing data from a flat text file. I'm taking the approach suggested by Phil Brammer to use a checksum to see whether a row has exists, and if it does check whether it has changed. http://www.ssistalk.com/2007/03/09/ssis-using-a-checksum-to-determine-if-a-row-has-changed I would like to hear some opinions on 2 approaches: 1) Importing the dat
  • If all values of dropdown parameter are selected - show ALL in report header
    by igor_22
    2 Replies
    Last post by mahima
      • Hi, I have dropdown parameter with multi-values allowed. In my report headed I want to show all the dropdown values that were checked by the user to run the report. But since there could be a couple of hundred values I want to show ALL when all the values are selected instead of listing them one by one. How can I do that Thanks, Igor
  • performance: memory usage: any way to flush memory?
    by vivek.athalye
    4 Replies
    Last post by Chris Howarth
      • Hello, we are using SQL Server 2000 on Win2k3 machine we are having different sproc's that have a structure like: create table #tmp1 @query = 'insert into #tmp select from ......' if condition1 append where clause1 if condition2 append where clause2 exec(@query) while loop @query = 'update #tmp set col1 = (complex select stmt.....)' exec(@query) select * from #tmp drop table #tmp
  • Date dim and attribute relationships
    by Vijay R
    3 Replies
    Last post by Thomas Ivarsson
      • Hi, Just when I thought that I had understoon attribute rel and date dim, I myself have asked so many posts about this, but still I fail to understand something.... I am getting incorrect data while browsing. Scenario: I have setup the date dim with proper attrib rel. also created a natural hierarchy as given by many posts and documents. Here are the attributes and their
  • importing data to sqlserver express
    by jfmoyn
    3 Replies
    Last post by jfmoyn
      • I would like to import data to a sqlserver express database. The database I am interested in importing was created in MSDE. I tried backing it up and using the restore function in sqlserver express but with no success. I have not been able to find an import function in the Management Studio Express interface. Is it possible to import this information, or should I get busy with my data entry
  • Adding a Linked Server
    by MannuBhai
    3 Replies
    Last post by Sue Hoegemeier
      • HI, There is a requirement to transfer a table data from a oracle view to a SQL Server table. These both reside on the same box. I am trying to add the oracle instance as a linked server, like this: EXEC sp_addlinkedserver @server = @SOURCE_SERVER_NAME, @srvproduct = '', @provider = @PROVIDER_NAME, @datasrc = @DATA_SOURCE_NAME The server gets added. But When I use this string as p
  • Error 5180: Could not open FCB for invalid file id : 120
    by Anonymous1022
    2 Replies
    Last post by Sheila_bfw
      • '"Error 5180: Could not open FCB for invalid file id : 120" When we attach the mdf and ldf files we get this error, what can we do to restore the database
  • Export to Excel
    by glh8564
    9 Replies
    Last post by glh8564
      • I am having a problem exporting data to excel using t-sql. I need to create a t-sql stored procedure that exports the resultset of a dynamic query to Excel where the columns are not know beforehand. I have been able to do it using bcp, but the problem is that the bcp method just exports the data to an tab-delimited ascii file with a .xls extension. Excel is smart enough to pick it up and pa
  • SQL Query
    by U_T_A
    4 Replies
    Last post by U_T_A
      • I have a query that i created which searches all logs to see what users did on the website for the COMPUTER account. SELECT u.ID, u.LastName, u.FirstName, u.Company, ua.AccountID, wsl.SessionBegan, wsl.ServerName, wal.Activity FROM [User] u INNER JOIN UserAccount ua ON u.ID = ua.UserID INNER JOIN wwwSessionLog wsl ON u.ID = wsl.UserName INNER JOIN wwwActivityLog wal ON wsl.Sessio