SQL Server

Page 5304




  • Topics
    Replies
    Last post
  • Help with a delete query
    by Wentu
    6 Replies
    Last post by Wentu
      • Hi i need help with this task i can't think how to do better. I have a table with MyField1, MyField2, Cost, SomeOtherField For each couple of MyField1, MyField2 i have several rows. I need to delete some rows so that: - for each couple of MyField1, MyField2 i have at most @MaxNumber rows remaining and - for each pair MyField1,MyField2 the Cost in the remaining rows is never more than a certain coe
  • Database constraints
    by Matrixchyah
    2 Replies
    Last post by Nitin Khurana
      • Hi i would like a suggestion from all the experts in this forum as i'am involved in design of a software package which is going to be VB6.0 as front end and SQL2005 as backend..... my question here is most of the constraints like foreign key,unique,check etc do i need to put in the sql server and increase the hardware of the server or is it better to put as a class in front end and make the client
  • isnull problem
    by Barbi
    2 Replies
    Last post by Manivannan.D.Sekaran
      • hello, I have a stored procedure that inserts or updates data depending of the value of one select that uses isnull finction. Here is the code: Declare @id1 int Select @id1= isnull(id,0) from tablename where name=@name if @id=0 begin insert..... end else begin update end the problem is that even i use isnull function the select statement does not return 0 i
  • Remote(over a network) Database Connection Issue
    by dragonsbb1616
    12 Replies
    Last post by John Gordon - MSFT
      • This has to be an easy question. WORK2 - My workstation (xp pro) WORK3 - Location of SQL Express 2005 WORK3\COMPANY sa,password WORK3 is a XPPro, both WORK2 and 3 have full admin rights to their machines and the network, I am using SQL Authentication (sa, password) I have used the SQL Server Config app to enable the 4 Protocols, then restarted service. I can connect locally to my datab
  • Relative paths
    by JAson_scoobyjw
    3 Replies
    Last post by Jamie Thomson
      • We have a growing issue where we have a relative dtsconfig file (which stores the absolute base path of the ETL packages). This way we can keep the ETL projects failry portable - only having to modify one value in the dtsconfig file. The master package that defines the dtsconfig location (which is config/Default.dtsconfig) usually interpretates this location to be relative the project. T
  • Error encountered while starting the SSIS service
    by JayaC
    2 Replies
    Last post by JayaC
      • I installed SQL Server 2005 Integration services on Windows XP machine. Then I went to the SQL Server Configuration Manager and tried to Start the SSIS service. The "Log On As" value is "NT AUTHORITY\NetworkService". But I get the follwoing error: The request failed or the service did not respond in a timely fashion. COnsult the event log or other applicable error logs for details. Event Log
  • free memory
    by ishaywei
    3 Replies
    Last post by Chris Howarth
      • i'm using BULK INSERT to insert data into table let say my function is: void foo() { char query = " BULK INSERT ABC FROM \"c:\\xxx.csv\" WITH (FIELDTERMINATOR = ','); rc = SQLAllocStmt( g_hdbc, &statement ) ; rc = SQLExecDirect( statement, ( unsigned char *)query, SQL_NTS ); rc = SQLFreeStmt(statement,SQL_CLOSE); rc = SQLFreeStmt(statement,SQL_DROP)
  • How to Reboot a Clustered SQL Server Agent
    by UnixAdmin
    2 Replies
    Last post by Jack He
      • If I am running SQL Server 2005 in a clustered environment, what is the safest way to restart the SQL server agent It is currently running but I need to restart it for maintenance purposes. Is the safeway way to restart is to login to the SQL Server Management Studio as the system administrator, select the SQL Server Agent object, right-mouse click and select "Restart "
  • Package execution stability ?
    by Steve Wang 2006
    14 Replies
    Last post by Steve Wang 2006
      • I am running into some issue that i have found any good clue on this forum... although have seen a few threads dicussions. I have a master package which invokes a dozen of child packages. 1) If I only open master package inside IDE, I am keeping getting the following error when i run the master packages inside Visual Studio 2005 IDE. The connection type "FLATFILE" specified f
  • How can I execute stored procedures with correct user rights?
    by fnuran
    3 Replies
    Last post by Mike28_DBA
      • Hi, I have a problem with sp execution.: objects of [dbo] Tables of [nuran] Grants of [nuran] [dbo].tabloA [nuran].tmptabloA Select,insert, update on [dbo].tabloA [dbo].tmptabloA Deny for [dbo].tmptabloA [dbo].sp_yordam Grant for executing [dbo].sp_yord
  • Error 3205 Restore SQLServer 2005 Express to MSDE
    by Jim in NoVA
    3 Replies
    Last post by WesleyB
      • I am trying to restore a database backed up using SQL Server 2005 Express Edition to a server using MSDE. I get an error 3205 "Too many backup devices specified...64 max..." I'm only specifying one file for the restore. Ideas
  • error column
    by arkiboys
    2 Replies
    Last post by arkiboys
      • Hi, Using SSIS, while importing (source i.e. .csv into destination i.e. sql server table), how is it possible to log the source COLUMN which causes the error in the row Thanks
  • Query to get the all the users from ADS datasource
    by Dhivya.S
    6 Replies
    Last post by MAmorim
      • Please help me to get the all the user from ADS, i searched a lot and found we can get that using linked server, i ran the following query to add the linked server, sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource' The query ran succesfully and the 'ADSI' has been added as linked server I got a query from net to get the users
  • Events log crashing SQL server 2005
    by Michael Halabi
    3 Replies
    Last post by mrdenny
      • i have my SQL server 2005 crashing when Events log is full I have a hacker attacking my DB with a brut force tool but whereas he does not have the password, event log registers his access attempts as Failure Audit. I have thousands of lines of "Failure Audit" in my event log The event logs are set to be overwritten automatically when they reach 16Mb but it's not work
  • Error Redirected to Script Component : Package Doesnt fail.
    by donMahya
    3 Replies
    Last post by Bob Bojanic - MSFT
      • I have created a data flow task. In that, in a 'data conversion', if a column fails validation then that row is redirected to a script component, which in turn writes the error to a variable. But though the error is generated and script component receives the error, package doesnt fail. Is there any way to set the package result to failure inside the script component I tried set 'Fai
  • Inline schema - XML Source
    by Sumeet
    2 Replies
    Last post by Sumeet
      • I have a serialized XML that I got from a dataset. In my 'Data Flow Task', I bind the 'XML Source' source to this XML file. Since the XML file is having the schema along with it, I check the 'Use Inline schema' option. However, when I put a dataviewer to see the rows getting sent to the destination, I see that no rows are getting transfered. As you will see from the XML file I am trying to use, I
  • Maintenance Cleanup task not functioning properly???
    by Carl Berger
    14 Replies
    Last post by crenstrom
      • Using SQL Server 2005 Management Studio and backing up databases. When I add the task Maintenance Cleanup to remove database backups older then 1 day the task fails What part of this TSQL code does SQL Server 2005 Management Studio not understand EXECUTE master.dbo.xp_delete_file 0,N'\\pdxsql03\SQL Backup\POSSQL_Server',N'.bak',N'05/15/2006 08:09:37' The database file backup extension is .bak an
  • Diffrent results in SQL2000 and SQL2005
    by Corne_kruger
    12 Replies
    Last post by Tom Phillips
      • Good day I'm having a problem where I get diffrent results between SQL2000 and 2005. I have have the following view: Code Block SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO ALTER VIEW [dbo].[vUsrMsgInfo] AS SELECT dbo.vMsgInfo.Body, dbo.vMsgInfo.FinalBody, dbo.vMsgInfo.BodyType, dbo.vMsgInfo.MsgID, dbo.vMsgInfo.Status, dbo.vMsgInfo.Creator, dbo.vMsgInf
  • Which Edition do I have?
    by korndawg
    3 Replies
    Last post by Navnit_Reddy
      • So I found out the hard way (Error 0xc00470fe ) that I need to install SSIS on my workstation client. But it's been a long time since I've installed, and don't remember which edition I installed. I'd rather not grab disk after disk to figure this out: how do I know which version I installed: express, standard, enterprise Thanks.
  • WMI HELP!
    by jnewton
    1 Replies
    Last post by Jin Feng - MSFT
      • I am trying to install microsoft sql server 2005 express. I am getting an error that I am unable to find here in the forums. I have windows xp pro sp2, just downloaded the sqlexpr.exe file from microsoft.com. I am getting: Server System Configuration Checker cannot be executed due to WMI configuration on the machine DESKTOP Error: 2147942699 (0x8007012b). I click on the info and see: Eve
  • HELP: ASP.NET won't connect to SQLexpress after deploying to IIS, try a lot of things...
    by MINGZCAN
    3 Replies
    Last post by Caddre
      • Hello, I have finish building my ASP.NET site using VS 2005 and it compile just fine. Than I try hosting it to the web via IIS v5.1 and I am getting permission error from SQL express. I have posted a detail question in experts-exchange.com and since you need a user account to even view the thread, I have taken the liberty to save the thread as .html file and host it to my ISP site. You can see the
  • SQLSCAN utility reports SQL2000 SP4 installations as vulnerable
    by Chris R
    1 Replies
    Last post by Steven Gott - MS
      • Hi- We are attempting to run the SQLScan utility from the SQL Server 2000 security tools ( http://www.microsoft.com/downloads/details.aspx familyid=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en ). I have identified 6 systems with a vulnerable installation. Each developer has updated to SP4 and when I run the scan again, I can see that the instance is now at SP4 revision but it sti
  • Using SQL Server 2005 CE embedded in desktop applications
    by IonWarp
    5 Replies
    Last post by abbarron
      • Is it ok to use SQL Server 2005 CE as an embedded DBMS inside a desktop (Windows XP / w2k3 / Vista) application The whitepaper available here: http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.doc describes this as one of the primary usages of the product. However, I've seen information elsewhere on this forum that seems to imply that SQL
  • Problem with SQL Ce Connection
    by JK789
    7 Replies
    Last post by ErikEJ
      • I have a strange problem while using sqlceconnection object. I'm using Sql Server 2005 Compact edition. While I'm trying to open the connection, an exception with blank message is raised, But if I open Query analyser on my windows ce 5.0 device and try to run the application again, it works(connection is getting opened)...Anyone faced this issue before Any help is greatly apreciated
  • Saving changes in MDX
    by AshleyS
    1 Replies
    Last post by tee_user5
      • Hi, I have written a report in Reporting Services 2005 which gets its data from a cube. I want to edit the mdx generated by the Mdx builder in RS 2005, so I click on the "design mode" button to do this. However, when i make the changes, i cannot save it. How can I do this Thanks, Ashleys.