SQL Server

Page 3652




  • Topics
    Replies
    Last post
  • Problem with the SQL Insert with .CommandText() and .ExecuteNonQuery()
    by Ionix
    3 Replies
    Last post by Ionix
      • Hi I have done a SQL statement INSERT for my coding. The program compiled and run the insertion with no error occurred. But after the compilation I found out that my database is not populated at all. I tried the data insertion using the manual query, and I work perfectly. So the problem now is that I do not know why my codes did not insert the data into my database. Will like to get some advise. T
  • Select Statement In Table (Valid Expressions Error).
    by DB_Newbie
    3 Replies
    Last post by rh4m1ll3
      • We are currently implimenting row level security by putting part of the Customer's account information in a DB Table. I have been able to do this on a case by case (individual customer) basis, but I tried to script inserting a whole bunch of customers at once using a script. When I run the script just using print commands, everything looks fine. When I run it to actually process the data, things b
  • Why does using the "in" clause cause an error in my "Having" condition in 2000, but not 2005?
    by Abslom Rob
    9 Replies
    Last post by Abslom Rob
      • I'm using the following SQL, which works against 2005 but fails against 2000: select "table1"."LevelKey" AS "level0key", case when "table1"."UnitCode" in ('012201', '09C202', '10C010') then 'A' else 'B' end AS "levelkey", sum("table2"."Total") AS "Total" from "t_mlcdm_d_business
  • Dose anybody knows how to use MergeJoin component programitcally?
    by Avi Gershon
    0 Replies
    Last post by Avi Gershon
      • I'm building a package programitcally and I can't find any document which shows how to work with MergeJoin component in code. Please help, Thanks
  • SQL Server 2005 SP2 cannot be installed because the Database Engine setup remains in suspended installation mode
    by C-J Berg
    1 Replies
    Last post by C-J Berg
      • SP2 refuses to install for the Database Engine because ¡°the previous upgrade did not complete¡±, i.e. it detects a suspended installation. The same thing happened to me when I installed SP1. I then remember opening the maintenance dialog and completing the setup, after which SP1 installed just fine. When I try to do the same thing this time, I¡¯m presented with the ¡±complete the suspended instal
  • patindex with nvarchar
    by HarshalChoksi
    14 Replies
    Last post by Manivannan.D.Sekaran
      • Hi Microsoft, My Name is Harshal Choksi. i am working in microsoft technolgy in .NET and SQL Server 2000. we are storing some unicode data in database in table which has a nvarchar data types. i have written one function in SQL which contains some T-Transact function like SubString, Len & PatIndex. in which i m not getting any value with PatIndex, it shows me always column with 0 value.
  • MDX Ranking Question
    by Michael Schreuder
    5 Replies
    Last post by Michael Schreuder
      • Hi We are trying to create a Ranking of a dimension based on multiple different measures. An example would be to rank the Sales Consultant by Num Sales, Total Sales and Num Customers. In SQL, I would create three different temp tables, with the Sales Consultant, Measure and Ranking for each different measure. Then you could join these results together and generate the final ranking b
  • BCP loading failing on timeout error
    by Paul Jacob
    10 Replies
    Last post by cognoid
      • Hi, I am trying to load data to SQL server 2005 table using BCP from Cognos data warehouse tool. This works most of the cases but adhocly fails or delays BCP loading considerably. Failure is every time with timeout error as below [INTERNAL - 18:56:57] Mem(M): 0.0 [Peak=0.0] (Ref=0.0 Domain=0.0 Pool=0.0) [DETAIL - 18:56:57] Data Stream row limits: sample rate 1, max rows 0 [DETAI
  • allows blank value for integer Parameter
    by marina B.
    2 Replies
    Last post by marina B.
      • Hi have a problem to solve and I hope that this is not a SSRS Bug. I created a Reports(using SQL Server Project) which has several parameters which values are passed to a SP. One of these parameter is an Integer and it is an optional value, so if the user fill it is used by the SP, otherwise the SP uses NULL and run anyway. I starts to define tha parameter: Datatype = integ
  • No one can help me on this prolem??????
    by JoneLee
    5 Replies
    Last post by JoneLee
      • or it may be too simple to care about My scenario is: I want to pass a multi-value parameter, Employee, with value set string[]{n1,n2,..,nk} to the report1. {n1,n2,..,nk} is a subset of whole employee name set {n1,n2,...,nk,...,nm}(k<=m), and it value is based on the user's access. when user open the report1, he/she can select one or more user name from the Employee dropdown value list
  • SSIS deployment - redefined
    by Sara4
    9 Replies
    Last post by Sara4
      • 1) Every package has to have its own configuration file There's no configuration on a project level 2) is there anything in particular I have to do with a configuration file before running a build When I run deployed package it seems like it ignores my configuration file and takes the connection string of conn. manager i use in development.
  • Merge Replication (Push) over Internet
    by PNM
    2 Replies
    Last post by PNM
      • Hi all, I was wondering if someone could suggest a solution to my problem: I have an in-house production database. I wanted to use Merge replication (push) to mirror parts of this data to our Internet server on the web which has a Public IP. Steps I followed 1. Created an entry in ¡°C:\WINNT\system32\drivers\etc\hosts¡± file with IP address of the Subscriber and just the ¡°Serv
  • Secure SQL Server remote access from ISV application
    by -&amp;#61;B3N&amp;#61;
    4 Replies
    Last post by Guennadii Vanine
      • Hi guys I'm writing a C# application which connects to a local SQL database for data access. The application connects to SQL Server through windows authentication, but opens up the port and sqlbrowser to others on the network wanting to access the database through SQL Server authentication, and also allows remote users to connect to this server remotely if they have the login and password (
  • SQL server 2000 move
    by JasonMM
    6 Replies
    Last post by Madhu K Nair
      • Hello, I'm in the process of moving a SQL Server 2000 to a new server. I have installed the new server added the latest sp. When I try to restore the system databases (Master, msdb) I get the following error "the database xxxx.bak Cannot be restored because it was created by a different version of the server restore database is terminating abnormally" I have looked at everyth
  • Using CTE in data paging
    by Mark Shvarts
    5 Replies
    Last post by Umachandar Jayachandran - MS
      • I explore a possibility of using Common Table Expression (CTE) instead of temporary table in data paging. But the problem is that it looks like I can reference CTE only once in my script. I need to return data for a current page as well as the row count for entire selection. Here is my script: with names(row_num, first_name, last_name) as ( select row_num = row_number() over(order by last_na
  • Aggregating records and displaying
    by LalitBoliya
    8 Replies
    Last post by LalitBoliya
      • Hi, I have 2 tables: Class - ClassID(int), ClassName(varchar) Student - StudentID(int), ClassID, Age(smallint), Sex(nchar(1)), DateOfJoining(datetime) I want to write a query that gives me the Top 10 Class which have maximum no. of student joining during the past 6 months. The query should include the following : ClassName, Count(StudentID), Avg(Age), Avg(Sex) Fro
  • Cannot connect to SQL Server with PHP
    by JamesBrady
    14 Replies
    Last post by HarrylT
      • I installed Windows Server Service Pack 2 on my Windows 2003 server last night, and now my PHP application can longer connect to SQL Server running on this machine. Specifically, the PHP command mssql_connect("servername", "username", "password") returns the following error: Warning : mssql_connect() [ function.mssql-connect ]: Unable to connect to ser
  • Changing the default database files path fails
    by Waleed Yaseen
    5 Replies
    Last post by Waleed Yaseen
      • i have the following code segment which works fine as is: try { ServerConnection connection = new ServerConnection ( "localhost" ); Server server = new Server (connection); if (!server.Databases.Contains( "SMO_TEST" )) { Database database = new Database (server, "SMO_TEST" ); //FileGroup fileGroup = new FileGroup(da
  • Will FTP and File System Tasks run in Workgroup Edition?
    by Erik Sampsell
    6 Replies
    Last post by Erik Sampsell
      • I have a package that does an FTP and some File System Tasks. It runs perfectly fine in BIDS but doesn't want to run via SQL Agent. Is the SQL Server Edition the problem
  • Store Membership information using Access .mdb database
    by Realaxed
    5 Replies
    Last post by Caddre
      • Hello, I'm trying to create a web page that is protected by a user login. I want the user data to be stored in an access database file and not an SQL Server express database. I was following this guide on msdn: http://msdn2.microsoft.com/en-us/library/879kf95c(VS.80).aspx However, I was doing everything locally using a file system and not IIS. (Which seemed to work fine)
  • SQL 2005 Server DDL Trigger Errors
    by Brian Laws
    12 Replies
    Last post by tvu4251
      • Greetings! I've been working on a SQL 2005 project, and have really been excited about the new DDL triggers. I managed to implement some database-level DDL triggers successfully. However, I keep getting an error when I try to create a server-level DDL trigger. For several of the event groups, I keep getting the following error: Msg 1082, Level 15, State 1, Procedure tr_Server_Audit_Security, Li
  • Merge Join - Output of Lookup as sorted field?
    by Lindsay
    12 Replies
    Last post by Lindsay
      • I'm doing a data conversion with one of my fields (SUMDWK) from one of the tables that will be used in a merge join. With the new, converted field, I do a look up. From this look up, I want to take a new field FiscalWeekOfYear, and replace the original field, SUMDWK. This is necessary because SUMDWK is one of the sorted fields. In the look up, it is not possible to change the Output Alias. Does an
  • Failing Execute SQL Task
    by Lindsay
    9 Replies
    Last post by Lindsay
      • Inside of an SQL Task (below), I have a call to a stored procedure with 7 parms. [Audit].[spBatchPackage_OnExtract] , , , , , , User:: ParentExecution_Idx Long User:: Batch_Idx Long System:: PackageName Nvarchar System:: PackageID GUID User:: TargetTable Nvarchar System:: ContainerStartTime DBTimestamp User:: DataFilePa
  • Null Values
    by Davids Learning
    12 Replies
    Last post by Davids Learning
      • I set up a new SQL database file, in that file I allowed nulls, When I went through code to save the record, the exception is saying it doesnt allow nulls. Before I get to involved with SQL, is it a bad practice to use nulls If it is what do you enter in place of the null value, which will lead to more code, right Davids Learning SQL
  • Management Studio Express "Save Results As..." CSV Encoding
    by KSpeed
    4 Replies
    Last post by KSpeed
      • Hi, I want to save the results in the grid of a query i have run in Management Studio Express to CSV format and open it up in excel without all fields being grouped in the left column. Currently what happens is that when i open the CSV file in Excel it shows all the fields in the first column. The resulting "Save Results As..." saves the file in Unicode format, but when i manually change