Answer Questions

• Blast Installing SQL SERVER 2005 Enterprise Edition On Windows XP??????

  Hi, I brought the MCTS Sql Server 2005 Implementation and Maintenance,Self paced training kit recently but i cant get my hands on the required OS for SQL Server 2005 Enterprise Edition which comes with the book. (Too Expensive!!!!!!) Is it OK to intall it on Windows XP Will I encounter any problems Many thanks Uma Hi, How do you login in to SQL Server 2005 When I load Microsoft SQL Server Management Studio I get a dialog box with the following entries: Server type: Database Engine Server name: I enter localhost Authentication: Windows Authentication When I click connect, I consistently get an error message. Can you tell me what I'm doing wrong Thanks much, Johnnie ...Show All

• Tim Dallmann Send in table name to stored procedure

  Is it possible to send a table name into a stored procedure to use as the "From" What I mean is i have a stored procedure that will do exactly the same to 3 different tables so I want to send the table name in so I don't have to create 3 different stored procedures, this is a simplified eg of what I mean; CREATE PROCEDURE DoSomething (@tablename ) AS SELECT * FROM @table I have seen a few other posts similar to this but I didn't really understand what they meant. The actual SP i want to use this for is this; CREATE Procedure ListsImport ( @campaigncode varchar ( 100 ), @tablename varchar(100) ) AS INSERT INTO Lists ( title , firstname , lastname , emailaddress , homephone , businessphone , state , ...Show All

• Shaantu Sql 2005 Express + Replication

  Hi, does any know of any plans to support publications in Sql 2005 Express I want to start moving away from MSDE but we use replication (one MSDE database is the publisher and several client PC's use MSDE as the subscribers.). Maybe it is on SP2 Thanks for any info you have on this. Graham There are no current plans to support Publication in SQL Express in 2005. Our recomendation is to use SQL Workgroup Edtion as the Publisher. I'm interested in the scale of your application. How many client PC's connect to the Publisher How is this application used (i.e. Is this something you sell, something that was developed as an internal application for your company ) Why do you use replication If ...Show All

• ZoomyX Problems backing up SQL Express Database...

  Hello, I found some code below that works fine when I run it in my vb.net code in Design mode. When I publish the application, run the app and then execute the sub MyDbBackup() I get the following error:  Cannot open backup device 'C:\dbBackup'. Operating system error 5(Access is denied). BACKUP DATABASE is terminating abnormally.   Here is the code that runs:  Public Sub MyDbBackup()         Dim sqlconn As New SqlClient.SqlConnection(MyConnectionStringdb)         sqlconn.Open()         Dim Backupcommand As SqlClient.SqlCommand = New SqlClient.SqlCommand("BACKUP DATABASE [" & sqlconn.Database.ToString ...Show All

• Herbert Lehner System Stored Procedures

  I'm trying to use the system stored procedure sp_addumpdevice to create a database backup. When I put the following code in a button click event handler, USE master EXEC sp_addumpdevice 'disk', 'FIRM_Backup', 'C:\MSSQL\BACKUP\FIRM.Bak' (FIRM is the name of the database) I get an error that "USE" and "EXEC" are not declared. Obviously, I'm new to using stored procedures and I'm not really sure what the issue is. I've tried adding the sp_addumpdevice to my project under stored procedures in the Server Explorer, but I can't find a way to add a system stored procedure. Can anybody assist with the process of how to call a system stored procedure from within a Windows form app Any assistance would be greatly app ...Show All

• Chris4578 Error when connecting to server via SQL 2005 Management Studio in Object Explorer but not Query Window

  Hi, I'm getting the error below when I attempt to connect to a remote Sql 2005 server using Management Studio and the Object Explorer. The same error does not occur if I go through "New > Database Engine Query" and fill out the same connection dialog with the exact same information. FYI, I am connecting to the IP of an external SQL 2005 server via SQL Server Authentication, and there is some level of connection going on as connecting with the wrong authentication information gives me a standard authentication error even while using the Object Explorer dialog. I am able to do all operations I need in the database engine query window without problem. I think there is some problem with the object explorer dlls. I got th ...Show All

• mitchwardrop Collations in SSAS. How should it work?

  Hi SSAS gurus, Could you tell me, please, what collation gets a new dimension (cube), that collation isn't specified in create script, from Server collation or from data base collation In the MSDN there isn't clear information related to it. If I create a new database from script, where only the collation of the database specified, all dimension and cubes get collation from server, but not from database. But in the SQL Server DB Engine all the objects inherit collation from database not from server. How can I specify the collation of the data base object in the SSAS project Is there in UI any place to set collation of database in the project Hi Edward, I have following problem (probabl ...Show All

• Mario Almeida SQL Server 2005 Enterprise Cluster Installation Fail (Error 29503 & 17058)

  When the setup program tries to start the database service (the last step of installation), it indicates an error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (17058) Any help would be appreciated. Solved after several tries. Seems that the problem is the user running the setup program cannot be the cluster service account. ...Show All

• Dan Ribar automatic caching of subreports

  Hi, I have a report which has several drill through reports associated with it. This report is used very very frequently by our users at various time. The report has been set to cache for 30 minutes to offset performance issues. I have found that due to this caching that the detail drill through reports are going out of sync with the main report. is there any way i can set the drill through reports to fire at the same time as the main report for all users the report is set out as below: main report drill one drill two drill three As not every user drills as far as drill three, the stats shown in the report for people who do drill this far are different to stats the inital main report. each drill report is based on ...Show All

• ramana reddy Dynamic column in the query using SQL 2005

  Hi All,  I am using Micosoft Visual Studio Report Desinger. with MS SQL 2005. I have a table transac table fields are likely, location,date,amount values, USA,01/07/2006,3000 SG,01/07/2006,2500 USA,02/07/2006,6000 SG,02/07/2006,3500 USA,03/07/2006,1000 SG,03/07/2006,6700 USA,04/07/2006,500 SG,04/07/2006,200 Am writing query for date = 04/07/2006 select location,date,amount from transac where date = 04/07/2006 I wanted to add two more column in the query which is a.two days before what is the amount b. From 01/07/2006 to 04/07/2006 what is the amount   The result I want to be Location,date,amount,2daysbefore,uptodate USA,04/07/2006,500,6000,10500 SG,04/07/2006,200 ...Show All

• Zulbaric MICR Font Issue When Exporting to PDF

  Hi, I'm using Reporting Service to print checks. Everything seems ok when I design and deploy and view the reports. But when I try to export to pdf, the MICR font I'm using does not work. I've tried a couple of different MICR fonts from the web and they either get replaced by a standard font or disappear altogether. I would love to know why that is. Thanks in advance, Tom Make sure the MICR font is on the same mechine that you open the pdf and leva space fot the height and the width and try woth Size 12 max this worked by me We don't embed fonts in the PDF. This means the font needs to be installed on the machine you are opening the pdf on. ...Show All

• mitchwardrop XML source not reading any records

  The problem started off as: I have a webservice written in VB.NET that simply returns a System.Data.Dataset. I want to use the dataset in SSIS. So i decided to do this: Save the returned dataset returned by the WS to an XML file. so it is sitting there, and looks like a fully valid XML file < xml version="1.0" encoding="utf-16" > <DataSet> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" max ...Show All

• Noorul Ahmed cannot P/Invoke SQLCEME30.DLL when debugging Pocket PC 2003 SE Emulator

  I'm trying to debug an assembly with System.Data.SqlServerCe - and when I deploy to a IPAQ 2210 - I get no errors! Alas, when I try to debug using the Pocket PC 2003 SE Emulator - I get the "cannot P/Invoke SQLCEME30.DLL" exception. Can anyone offer directions best regards, Walther OK, Walther, judging by what Ilya as stated, you need to install the SQL CAB's onto the Emulator. To do this, in VS 2005 go to 'Tools'->'Device Emulator Manager', then in the available Emulators select the Emulator you need then go to 'Actions'->'Connect' (wait for Green tick next to Emulator). Then in the Emulator Window go to 'File'->'Configure', then under the 'General' tab in the 'Shared Folder', click ...Show All

• Flintman SQL Server 2005 Evaluation and SQL Express side-by-side?

  I have SQL Express installed on my desktop and want to install SQL Server Evaluation. Will these 2 clash or can they sit happily side-by-side Hi, I'm having the same problems! Have you rectified it I already have Express installed and in use. I'm wanting to trial the full evaluation version as a side-by-side installation. I'm running Win2000 sp4, is the Evaluation version compatible with this OS Thanks in advance, Dom I am also encountering this problem. I have attempted to uninstall the whole package and I could not even install after that. How do I get rid of SQLExpress As long as they are both the final relea ...Show All

• cpurick Combinations

  Hi, I have the table: exexposureRoute: with columns caseId, exRouteID 200 70 300 71 200 72 200 73 .. .. Route table: exRoteID name 70 a 71 b 72 c 73 d .. .. In my result set i want like this: Route CaseCount a 78 b 89 c 90 d 345 a/b 9 a/c 8 a/d 9 a/b/c 2 Otherroute comb 98 in the above a/b means i want the casecount for which cases both a and b exists. For one case there mey be possibilty of more than one route. How to write the query to get those routes combinations case counts. Thnaks in advance Hi Kent, I have one question in the above requirement.In the query what you gave whether we can specify conditions for the some route combinations only like I need Routes Outcome1 Outcome2 Outcome3 ...Show All