SQL Server

Page 2697




  • Topics
    Replies
    Last post
  • Conversion error
    by Chris Holt
    2 Replies
    Last post by Chris Holt
      • I am getting the error message Error converting data type varchar to float when running the following query: Code Snippet select top 175816 AV.intItemID, AV.intAttrID, -- AV.vchValue, CAST(AV.vchValue AS float) AS Test, 0 from tblAttrVals AV join tblAttributes AA on AA.intAttributeID = AV.intAttrID and AA.intDataTypeID in (2, 3) and (1 = isnumeric (AV.
  • Distributed Partitioned View with RPC (or DTC) problem
    by azwandi
    7 Replies
    Last post by azwandi
      • I am setting up 3 Linked Servers (SERVER_A, SERVER_B and SERVER_C) in an isolated local network. They are all running SQL Server 2005 Developer Edition, all on XP SP2. On each server, I have a distributed partitioned view named WAREHOUSE_ALL that basically is the UNION of all WAREHOUSE tables. I am having trouble in running write (INSERT, UPDATE or DELETE) queries on the distributed partitioned vi
  • For Loop Container with Dates
    by Newish To SSIS
    6 Replies
    Last post by Phil Brammer
      • I'm trying to set up a For Loop Container that steps through the loop based on date logic. Here's an example of what I'd like to do: InitExpression | @SomeDate = 1 / 1 / 2007 EvalExpression | @SomeDate < GETDATE () AssignExpression | @SomeDate = DATEADD ( DAY , 1 , @SomeDate ) The above syntax does not work, and I can't find an example that uses date logic
  • Moving RS 2005 Reports to new server
    by Silaphet
    2 Replies
    Last post by Jens K. Suessmeyer
      • Hi Guru, Currently, we are running our RS 2005 reports on our old hardware and wanted to move them to better server where IĄŻll be building it tomorrow. On the existing server, we installed both database and reporting services running on the same box but IĄŻm ONLY planning to install reporting service on the new server. What are the options to move RDL, shared data sources, shared sc
  • Pre-requisiste install error 87 "invalid parameter" from SQL 2005 Dev Ed on Server 2008 RC0
    by bderemer
    5 Replies
    Last post by bderemer
      • The subject pretty much sums the problem up. I am trying to get a database installed on Server 2008 RC0. The public information says SQL 2005 SP2 should work, but I cannot get the base SQL 2005 installed in order to apply the service pack. When I run the installation, I immediately get an error when trying to install the pre-requisites. Specifically, the .NET 2.0 Framework errors with code 87, &qu
  • dynamic query
    by Jay Jose
    5 Replies
    Last post by Jay Jose
      • Good Day to all, I just started using SQL Server 2005 and didn't have any experience with other DB... Is it possible to make a dynamic query I would like to make a stored procedure where the table name from where it will select/insert/update data is user inputed... if it's possible, can someone please guide me.. thanks in advance... example: @TableName VARCHAR(20), SELECT * FROM @TableName is it p
  • MDX Query Help...Please
    by Prash1
    4 Replies
    Last post by Prash1
      • Hi, I have a fact table containing the following columns: CustomerID RegionID CategoryID ItemID Price Relationships: A customer belongs to only one particular region and category Each customer can buy the same item at different prices The measures are LowPrice and AveragePrice Query For a particular customer, what was the customer price, average price a
  • Sizing a Pagefile on Servers with Large Amounts of Memory
    by DBADave
    7 Replies
    Last post by DBADave
      • I know the standard Microsoft recommendation is to make the pagefile at least 1.5 to 3 times larger then the amount of physical memory. However, if you're talking about a server with lots of memory such as 16GB or 32GB, would following this rule be unnecessary. With SQL 2000 running on Windows 2000 Server or Windows Server 2003 I typically see pagefile usage no more then 12% for a 2GB pagefile. An
  • how to order by non-key fields in related union tables (For XML EXPLICIT)?
    by perrier000
    6 Replies
    Last post by saurabhdotnet
      • I'm using union to build related xml structure with FOR XML EXPLICIT. To do so, i user 'ORDER BY key field' to relate multiple tables in multiple union statements. That's just to link related children data to the parent data. However, I also need to sort the entire xml by non-key fields. For example, I use id to relate data but I need to sort by name. In my code below, I'm relating data by [Listin
  • How to Transfer database from mssql2005 to mssql2000 by using generate script.
    by elvin
    4 Replies
    Last post by Jens K. Suessmeyer
      • Currently i need to transfer database (complete with primary key, foreign key ,constraint) from mssql2005 to mssql2000 by using generate script. After getting the script, i execute the script in the sql analyzer 2000, i get a lots of syntax error. Following are some of the error : Server: Msg 208, Level 16, State 1, Line 1 Invalid object name 'sys.objects'. Server: Msg 170, Level 15, State
  • SSAS: User can't create new Database
    by thomas.neemann
    2 Replies
    Last post by thomas.neemann
      • Hello, I've got a User who cannot create a Database for SSAS. But he has got serveradmin rights. The following error occurs: =================================== Der Benutzer 'DOMAIN\USER' besitzt keine Berechtigung zum Erstellen eines neuen Objekts in 'SERVER', oder das Objekt ist nicht vorhanden. (Microsoft.AnalysisServices) ------------------------------ Program Locati
  • Cannot create new or change existing subscriptions
    by three twos
    14 Replies
    Last post by Report Developer
      • We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says Only members of sysadmin role are allowed to update or delete jobs owned by a different login When trying to create a new subscription the r
  • 2-Tier architecture - how to manage lots of users
    by sktmmm
    4 Replies
    Last post by Raul Garcia - MS
      • We have a 2-tier architecture with thick client (.NET 2.0) applications directly accessing the SQL Server database. We are struggling to manage lots of users while maintaining security. Granting lots of users directly to the database seems to be tough to manage. In fact, we would like to let supervisors without DBA previlege to add and remove users of our applications. Using SQL Authentication (a
  • Access 2005 databases from 2000
    by sureshv
    2 Replies
    Last post by Arnie Rowland
      • I have upgraded 2000 databases to sql server 2005.If the users use just query analyzer & enterprise manager in 2000 to access 2005 databases. will there be any issues let me know
  • Conditional split error message
    by sadie519590
    8 Replies
    Last post by Bob Bojanic - MSFT
      • Getting the below error msg on my conditional split. I changed the error output to ignore errors and that keeps the error msg from appearing (and everything seems to work normally), but why would it evaluate to NULL Thanks [Conditional Split - Find rows with balances [3412]] Error: The expression "FINDSTRING(Column0,"OPENING",1) > 0 || FINDSTRING(Column0,"CLOSI
  • SqlCe ntext data types and VS2005
    by NeilL
    5 Replies
    Last post by NeilL
      • I have an application where I'm trying to store xml data in a db field defined as ntext. I have a dataset and table adapter setup in VSNet 2005 and SqlCe 3.1. When I look at the table adapter in the VS designer it shows the field with a type of String and a size of 2147483647 which appears to be correct. Also, if I look at the code generated by the MSDataSetGenerator tool it shows the parameter de
  • Analysis Server 2005 Clustering
    by Sunil Gidwani
    9 Replies
    Last post by Sunil Gidwani
      • Hi I want know for Analysis server 2005 on Clustering environment which type of Cluster (Server Custer/ NLB) is recommended by Microsoft & what is reason behind the recommendation. Appreciated if you could provide me the URL for Analysis Server 2005 Clustering Best practice. Thanks Sunil
  • Data mapping
    by agenda9533
    1 Replies
    Last post by lkh
      • We have 2 databases - Prod and Dev. They are not syncronized and has a slightly different stored proc-s and table structure (column added/ or removed). So  Prod and Dev are not in sync, they are not mirrors. Production db has production data. How I can transition/move/map data from Prod to Dev For example, both databases have table Users :(f_name, l_name, field1, field2). And I ne
  • principal db in "principal, synchronizing" state, the mirror in "restoring" state
    by hotsauce
    1 Replies
    Last post by GlennAlanBerry
      • We have mirroring setup for 5 dbs, 4 of which are synchronized and 1 which is in "synchronizing" state on the principal and "restoring" state on the mirror. Mirroring for all dbs has been working fine for the past several months and we have a witness that has allowed automatic failover in the past without problems. This database has several bulk inserts performed through
  • Unable to install SQl Server 2005 SP2 - Unexpected error
    by AshishGupta
    14 Replies
    Last post by Peter Saddow MSFT
      • I am trying to install SQl Server 2005 SP2 but it was throwing an unexpected error when trying to install "setup support files". O/s: Windows Server 2003 SP1 Product: SQL Server 2005 Standard Edition Log file shows: +++++++++++++++++++ === Verbose logging started: 2/20/2007 16:05:42 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: F:\SQL2005sp2\hotfix.exe === MSI (c) (74:68)
  • Using CASE within a SELECT Query
    by Craig G
    10 Replies
    Last post by hunchback
      • i have a stored proc query that returns certain data dependant on the current user role & userID. is possible to do something along these lines using a case statment withing the select here is my query DECLARE @Role nvarchar(15) DECLARE @ContactID int SELECT @Role = Role, @ContactID = ContactID FROM Contact WHERE UserName = USER SELECT CL.ClaimID, CL.ProjectID, P.ProjectName, C
  • BUG? or intended that in order to move or rename reports....
    by Jeff Agent
    1 Replies
    Last post by Jeff Agent
      • ...anywhere in the folder structure a person must be set up as a Content Manager at the Reporting Services ROOT (and at every level of the folder hierarchy down to the level that they are moving/renaming) Sure, you can remove them from the role in other folders where they should not be moving or renaming objects, but it seems you still have to have them at the root (and down the cha
  • Can I apply a database function or assembly call in an Expression for Filter Data?
    by Toni552737
    3 Replies
    Last post by Toni
      • I need to translate a userĄŻs regional setting into one of our own language codes before I send it through as a filter to the model query. If our language codes were the same, the filter would look like this in the report filter - Language Code = GetUserCulture() Which translates to this in the database query (for us english) - table.language_code = 'EN-us' And
  • help with a querie
    by luisdanielurea
    2 Replies
    Last post by Kent Waldrop 2007 Mar
      • i need to finish to define this function create function okJetsHelpFunc (@idevent INT) Returns Table AS return select j.* from jet as j where j.eventid = @idevent and abs(dbo.eta(j.id))>4.5 and dbo.pt(j.id)>20.0 GO right now is working perfectly, but i need to put a condition that return all the jets information if they are 3 jets that fullfil the where statement, and return a null
  • SQL Express Database table data insert into another database
    by transtar
    6 Replies
    Last post by SpaceShot
      • Hi, I have two SQL Express database and I want to do two things. One is to transfer a table over to the other database. Two, move the files from one table in one database to another. Please let me know when you get a chance. Thanks, Kyle