SQL Server

Page 4101




  • Topics
    Replies
    Last post
  • schemas and permessions
    by Rama..
    2 Replies
    Last post by Rama..
      • I have schema called [sitex] for some tables . I have to perform insert or update operations in to these tables through views only and these views were created with [site] schema All stored procedures are written in the point of view only ( all DML operations into the tables are through views).and these stored procedures has schema same as views. Now come to the permissions and authorization.
  • Precedence Constraint in SSIS didn't work
    by Hery Susanto WR
    11 Replies
    Last post by jwelch
      • Dear all, I've been searching the article for error handling in SSIS but seems no article have same problem exactly as mine. In my package there's container, it contains Data Flow task and some of Script tasks. I put an error precedence from Data Flow task into Script task that contains script for log an error that might be occured. The Data Flow task imports data from flat file into SQL Serv
  • Cube Navigation
    by Stefan Ghose
    2 Replies
    Last post by Stefan Ghose
      • Hi, I have a small problem which I hope that someone can help me with. I have got a fact table looking at website usage and this fact table is related to multiple dimensions. What I want to do Is to look for a particular page that a user has accessed and go 2 steps backwards using the time dimension to see what page was accesed at that time. I do not want to expand the whole page dim
  • using Variables
    by soanfu
    4 Replies
    Last post by Dylan72
      • Is there a way to manipulate the value of a variable with out using a skripttask I just want to var1 = var2.Substring(5)
  • Solve Cross tab query
    by Vidhura
    3 Replies
    Last post by Vidhura
      • The table contains Table Old Year Month Serial# Batch# 2007 Jan 101 MW 2007 Jan 101 TR Problem: Take the given table and show how you would generate the following resulting table. Table New Year Month Serial# Batch01# Batch02# Batch03# 2007 Jan 101 MW TR null
  • What do I need to do to import Ebcdic file with comp3 packed data fields from mf into SQL Server
    by agentf1
    14 Replies
    Last post by agentf1
      • What do I need to do to import Ebcdic file with comp3 packed data fields from mf into SQL Server Is this possible Do I need to go into advanced properties and change the data type Or do I need to use data conversion task for the packed fields. Any advice or if somebody could point me to a sample script would be greatly appreciated.
  • too many connections since my win app
    by Jocker23
    4 Replies
    Last post by Jocker23
      • I have a c# winapp and use SqlHelper to CRUD operation wint an sql server 2005 database, every time mi data access layer opens an connections, I do Close() and Dispose() after the transaction, and I execute SP_WHO and the database server shows me that my winapp has generated a lot of connections, I dont understand why since i clean every connection, Also, I m not using pooling since my connection
  • connot connect to the repository with Analysis Service
    by benjamin b
    1 Replies
    Last post by Mosha Pasumansky
      • I have a problem with Analysis Services. When I open Analysis Manager and try to connect to the SQL server with Analysis Service, the following error message is displayed: "connot connect to the repository. Error:Could not use ''; file already in use." the server and my local machine all both using SQL server 2000 with SP4 any help will be appreciate, thanks in advance.
  • Installing SQL Server 05 on same machine as SQL Server 2K ?
    by gshut
    1 Replies
    Last post by Samuel Lester - MSFT
      • Can this be done safely If so is there any speacil tricks i should know about Thanks ! Gene
  • File System Error after Restore
    by Ashok Ojha
    8 Replies
    Last post by Troy Sherrill
      • Hi Guys, I have issues in restoring our Analysis Services database. Any help will be great. I took backups of our production olap database and Unfortunately, I had to restore next day and it didn't worked out very well. Restore process was successful but when I tried to Query database I was getting error - "File system error: The following error occurred while the
  • OLE DB & SQL
    by Mazmo
    7 Replies
    Last post by torkal
      • Does anyone know why SQL doesn't work properly in my OLE DB component Underlying DB: DB2 Provider: IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider If I insert some SQL I get get a preview of the data but it errors when I run it. [OLE DB Source [1]] Error: An OLE DB error has occurred. Error code: 0x80040E00. [DTS.Pipeline] Error: The PrimeOutput method on component "OLE DB Sou
  • SQL 2005 Configuration Manager permissions
    by tunes2468
    5 Replies
    Last post by Michael Hotek
      • I can't seem to find the documentation on how to delegate control for SQL server configuration Manger 2005. I have DBA that need access to the tool from a remote machine without admin access on the boxes. Does anyone know how to delegated control and what permissions are needed to set up remote access for my DBA to user the 2005 configuration manager The only article that I was able to find is
  • msmdsrv.exe taking substantial memory
    by Dz0001
    5 Replies
    Last post by Dz0001
      • Wondering if you have this problem or not, it seems SQL 2005 AS msmdsrv.exe taking lots of memory, I looked at 64 bit server, and 32 bit server, compare with other SQL server services, msmdsrv.exe runs about 500,000 - 600,000 K on 64 bit server, vs. 87,000 k for sqlserver.exe, and 67,000 k for reportserver.exe, and connect to AS through Management Studio also takes long time. I have default settin
  • selecting first 10 cities in a state
    by ralanjackson
    2 Replies
    Last post by ralanjackson
      • Greetings: I read with great interest a post on getting hte top 75 per cent by month, but still get through this problem. I have a table containing addresses, city names and state names, Each row has a unique address. I want to get the first ten addresses for each city in each state. I've tried something like the following which didn't work. Suggestions on how to solve the (simple) problem
  • Triggers per row not per statement
    by vdhant
    12 Replies
    Last post by oj
      • Hi guys I am wondering if there is any way of setting the trigger to execute once per individual row that is updated as appose to once per statement. Thus a statement like this would trigger twice not just once: Update Order Set Name = 'test' Where OrderId In (1,2) If this is not possible do the Deleted and Inserted tables have the records for all the items that were
  • Hiding a table row depending on page number?
    by Palmie
    14 Replies
    Last post by Lisa Nicholls
      • Hi, Everyone. i am wondering if there is some way to hide a table row depending on the page number. I have tried to find a way to access the global page number to use it in an expression for the visibility property on the table row, but i havent found anything useful.
  • how to use group by (group tasks based on projects)
    by Rajeshwar
    3 Replies
    Last post by aNiall8
      • Hi folks, I have a Projects , each project have many tasks now i want to display tasks replated to each project: for example: Project1-------------------->task1 task2 task3 task4 Project2----------------------->task4 task5
  • Can I put a common table inside a common table?
    by dvang
    2 Replies
    Last post by Umachandar Jayachandran - MS
      • I have query A that uses 2 common tables, and I would like to put query A into query B as a common table along with the other common tables already in query B. So basically I would be creating another common table in query B that consists of query A in its entirety. Can this be done and if so, what's the correct syntax Query A (keep in mind i just use generic coding to simpifly the ide
  • Could not create Maintenance Plan
    by Markus Fritz
    14 Replies
    Last post by Daveko
      • Hello, if I try to create a Maintenance Plan from my local workstation I get the following Error Message: TITLE: Microsoft SQL Server Management Studio ------------------------------ The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install SQL Server 2
  • Local SQL Server instances not showing up on Local Servers tab of Management Studio logon screen
    by Craig Beier
    2 Replies
    Last post by Arnie Rowland
      • We have a 64-bit VM server running SQL Server 2005. The SQL Server on this particular VM server has 6 local instances installed. On the Management Studio logon screen I can type the full name of the local instance and connect to it, however if I press the drop down in the Server name field, choose Browse and select the Local Servers tab there is nothing listed under Database Engines. Any idea why
  • Formating
    by AuliyaIkhsan
    2 Replies
    Last post by Kent Waldrop My07
      • how to format an integer in sql 2005 for ex: 1.09876 i want to format to 1.1 in access i can use : format(field,'0.0') as field1 thanks
  • What is the fastest way to add new named instances to SQL 2005?
    by JohDas
    2 Replies
    Last post by JohDas
      • Hello SQL colleagues, I need to add 5 new named instances on a SQL Server 2005 Enterpise Edition. Is there a fast way to do it Best Regards, John
  • New Vista Install => Cannot connect to SQL Server
    by Webps
    3 Replies
    Last post by John Gordon - MSFT
      • Hi, I've installed Windows Vista 64 bit on my pc (I had XP Pro). Also I've installed the management studio of SQL Server 2005 developer edition which I've uses also on my XP machine. I've a online server at "myserver.myprovider.com". With C:\Windows\System32\cliconfg.exe a made a TCP/IP alias to with the name "MySql". In XP I then can connect in Sql management studio to
  • SSRS 2005 Exporting a report to .xls containing a subreport
    by bubberz
    6 Replies
    Last post by PostaCoder
      • Does SSRS 2005 have the issue fixed as to when the user exports a report to .xls format and the report contains a subreport In SSRS 2000, if there was a subreport in the main report, and the user exported the report to .xls, then it would just display an error message. Thanks!
  • making use of the ScriptTask
    by LalitBoliya
    1 Replies
    Last post by Phil Brammer
      • Hi, I have the following flow in which i am looping through a folder containing textfiles Foreach loop [ ScriptTask -> DataFlowTask -> Execute SQL ] In my ScriptTask, i am checking the file validity. Now if the file is found incorrect, I do not want the DataFlowTask and other to execute. Instead i want the file to be moved to Error and the loop to proceed with t