SQL Server

Page 1978




  • Topics
    Replies
    Last post
  • How to shutdown SQL 2005 Express Properly
    by JohnFeeney
    3 Replies
    Last post by Ekrem Önsoy
      • While working on my Visual C# 2005 Express programs, I will sometimes open SQL 2005 Express to look at the database. Then I will disconnect the database and exit the SQL Server Management Studio Express. Then when I run my Visual C# 2005 program the next time, I will always get this error message. "Cannot open user default database. Login failed...." Here is a copy of my
  • Bar Chart Scale
    by JohnSLG
    2 Replies
    Last post by JohnSLG
      • Can you have different scales on a bar chart. I want to chart sales and quantity. Oracle lets you label the top of the bar chart as money and the bottom as quantity. I am dividing my sales by one million and quantity by one thousand to make them similar in size on the same chart. I am using the sum of the sales/1000000 as a point label. Is there any way to limit the number of decimal places
  • ntwdblib and sql2005 port specification
    by WIvey
    2 Replies
    Last post by WIvey
      • We are in the process of upgrading to sql 2005. For us its a big jump but right now I need to know how to specify the port I want to connect on the server. We use ntwdblib, dblogin, dbopen...where and how do I specify the port, since we now have multiply instances on the single server and the default port is not what I need to connect too. Thanks
  • SQL Server 2005 rendered unable to start post SP2 install. Help!
    by jasonz
    6 Replies
    Last post by oj
      • Hi can someone help me please I browsed through the SP2 install feedback below, but it doesn't quite seem to fit what happened to my install. My .MDF and .LDF files for the system databases are in C:\Program Files\Microsoft SQL Server\MSQL.1\MSQL\Data (I presume this is the correct location.) I am the local administrator on this box. I uploaded the .CAB file with all the logs onto www.sendspace.
  • Lookup Component Error: Statement(s) could not be prepared.
    by chip_levis
    14 Replies
    Last post by chip_levis
      • Hi all, I recieve an error when I use the Lookup component in SSIS that reads: Statement(s) could not be prepared. I'm using a SQL 2005 DB as the source which runs into a lookup table and is use to compare records with an SQL 2000 Database. I've created connection managers successfully to both these databases. When trying to use the results of an SQL Query for the lookup to th
  • Saving SSIS package connection passwords
    by master20
    4 Replies
    Last post by SQL-PRO
      • Hello All, I'm new to SQL 2005. I am setting up some SSIS packages which will connect to an Oracle database and copy some tables from it. These packages will then be scheduled to run on a daily basis. Because they will run automatically, it is required that passwords be saved along with the connection string. However, even though the password is saved (and encrypted, I checked the .dtsx in
  • Moving System databases SQL 2005
    by BPH
    4 Replies
    Last post by BPH
      • I am in the process of moving my system databases to another volume. I have accommplished the first section pertaining to master database. I have reached step 3 in the Resource database move section down below. It states to change the FILENAME path to match the new location of the master database. Do not change the name of the database or the file names. ALTER DATABASE mssqlsy
  • Management Studio - Object Explorer
    by Max Noyeke
    3 Replies
    Last post by WWWebb
      • Can anyone tell me how to get Object Explorer to 'remember' and re-establish my Connected Servers when I open SS Management Studio I am working with several Database Servers and Several Report Servers and each time I close SQL Server Management Studio I have to manually re-establish my Connected Objects in Object Explorer. Is there a way to automate re-establishing those connections that I am mis
  • creating documentation
    by johajones
    1 Replies
    Last post by Buck Woody - MSFT
      • Hi: When I used SQL 2000 (long time ago) I remember that in the Tools menu, it has an option to create a Full Documentation of all the tables, views, etc used in the database. Know I'm doing a project in SQL 2005 and I want to print that information, but I don't know how. Anyone that can help me Thanks, Johajones
  • EMail Subscription Error
    by James Tow
    3 Replies
    Last post by Igor Taranov -- MSFT
      • All of a sudden, the e-mail subscriptions for a report quit being sent. Running Sql 2000 Microsoft SQL Server Reporting Services Version 8.00.743.00 Here is the log error: aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ; Info: Microsoft.Reporting
  • Hierarchies & Members/Children
    by Andrew of Oz
    3 Replies
    Last post by Darren Gosbell
      • Hi, I've started learning MDX but have found one issue which I can't seem to find a way around. Basically I have an Organisation hierarchy, that iterates down a number of levels. Within each branch of the organisation, there can be 0 or more Employees. At present I'm crossjoining them as such: crossjoin( [Organisation].[Hierarchy].[Level0].&[Sales].child
  • SQL Server Express SP2 CTP
    by LogoTron8000
    2 Replies
    Last post by Ajay Manchepalli
      • I'm a fairly new employee at a software development company.  If SQL Server Express SP2 is released by June, I'll need to allocate time for it to be added to our standalone product.  When can we expect the full release of SQL Express SP2   Thank You.   How long does a CTP phase usually last
  • .sql attachments will not open
    by Frank The Tank Carty
    1 Replies
    Last post by Manivannan.D.Sekaran
      • Hi, I have developed a web app where documents may be uploaded onto a server, and then opened of downloaded from the server by the users. Every type of file can be opened and downloaded apart from .sql. The main types of files that are uploaded are .txt, .dox, .pdf, .xls and .psd (photoshop), they all work apart from .sql just wondering does somthing different have to be done for .sql files the u
  • Compare two tables query result
    by ronlahav
    5 Replies
    Last post by Jens K. Suessmeyer
      • dear all i need to write SQL Query that compares 2 tables as folows: lets say i have: table A with A.A, A.B, A.C columns (Table A with Columns A,B,C) table B with B.A, B.B, B.C columns (Table B with Columns A,B,C) i need to compare and to mark (get in result Query) each row lets say in table B that was changed from table A For Example Table A A B C
  • Spatial and location datatypes not found
    by Akash C
    1 Replies
    Last post by MVP User
      • Unable to find spatial and location datatypes in the June CTP for Katmai. Can figure it out why and if its not available in June CTP will it be there in the upcoming next CTP of Katmai. Thanks -Akash
  • Report Builder and optional parameters
    by Wapper
    14 Replies
    Last post by elibet
      • Hi, Is it possible to create optional parameters in Report Builder An *ordinary* parameter is created by marking a filter expression as "prompted". At run-time, the user will be asked to provide a value for this parameter (or accept a default value if it is available). This works fine. What I want is to let the user choose whether to provide a value, or leave the parameter empty. I
  • Object reference not set to an instance of an object.
    by km6589
    6 Replies
    Last post by XTheSimpleton
      • Folks I had to take the report server offline temporarily-- I have brought it back online and stopped and restarted ssrs not I get the dreaded Object reference not set to an instance of an object.Error. I can log into the report server via a browser just fine. Its when I try and access any report I get error message and the report is all jarbled up--attributes of the report are not where they s
  • How to get the parameter type in VB.net?
    by Forscius
    8 Replies
    Last post by Forscius
      • I am currently using the following embedded code to get the selected values from a Parameter and display in a textbox. I however have a number of reports and I don't want to include this in all of them. I have created a dll with some other functions but when i try to include the following function it throws an error on the Parameter type. What am I doing wrong, I am not all that familiar with do
  • no key
    by KRISTER
    0 Replies
    Last post by KRISTER
      • Hello I got a error like this. "no key matching the described characteristics cold be found within the current range" What does this exactly means before this error i got this error. Error messages: An error occurred while reading the .bcp data file for the 'MSmerge_rowtrack' article. If the .bcp file is corrupt, you must regenerate the snapshot before init
  • three queries of one table as one stored procedure?
    by mtm81
    3 Replies
    Last post by Kent Waldrop No07
      • Hi, I currently have three queries running seperately which I'd like to join up.. However I'm sure it can be done.. Here goes: I have one table which lists payments made (it stores a PaymentID from another table, a payment amount and an invoiceID) Therefore there can be several records with the same PaymentID referenceing different invoices (i.e a user paying off sev
  • How to start with historization of dimensions!?
    by SPeters
    4 Replies
    Last post by SPeters
      • Hi there, I've got a question regarding the historization of dimension tables. How do I approach it at best Let's say I've got 4 dimensions I want to apply historization to (article, customer, agent, forwarding). What is the starting point in Analysis Services Things that aren't clear to me: 1. If I use snapshot for historization I think all of the tables need to have 3 additional columns added
  • change @@SERVERNAME 2005 - Urgent please help !!!
    by Dietz
    2 Replies
    Last post by Dietz
      • Hi There I have changed the servername of a sql server 2005 instance. Using sp_dropserver and sp_addserver as per BOL. However, after changing the servername i still see that : EWX-JDGSQLSRV1\SQLServer2005SQLAgentUser$EWX-JDGSQLSRV1$MSSQLSERVER EWX-JDGSQLSRV1\SQLServer2005MSSQLUser$EWX-JDGSQLSRV1$MSSQLSERVER EWX-JDGSQLSRV1\SQLServer2005MSFTEUser$EWX-JDGSQLSRV1$MSSQLSERVER built i
  • Problem Installing SQL Server 2005 Enterprise Edition On Windows Server 2003 Box
    by swilliam
    1 Replies
    Last post by Deepak Rangarajan
      • While attempting to install SQL Server 2005 Enterprise Edition on a Windows Server 2003 box, it is failing as follows... Microsoft SQL Server 2005 Setup beginning at Thu Sep 20 11:11:35 2007 Process ID : 5440 E:\setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/8/20 11:11:35 Complete: LoadResourcesAction at: 2007/8/20 11:11:35, returned true Running: ParseBootstrapOp
  • XML Columns to Rows
    by dwloeb77
    2 Replies
    Last post by jwelch
      • I have a large amount of data in an XML file. The file is very simple. Off of the root node are category nodes and each category node has many detail nodes. The detail node consist of the node name and the node value. Rather than map the detail to matching named fields in a single record, I would like to send the detail node data to individual data records where the category code, node name and no
  • Exact SQL for running process
    by Anna Mallikarjunan
    5 Replies
    Last post by WesleyB
      • For a long running stored procedure, how can I determine the SQL statement within the stored procedure that is currently running The Activity Monitor only shows the name of the stored procedure and whether it is a SELECT/INSERT/UPDATE, never the complete statement. Thank you.