Answer Questions

• SteveCook I need a second opinion on SQL 2005 syntax

  I am not that experienced in SQL 2005 and I'm trying to debug a stored proc (written by a far more experienced programmer which is why I'm appending here.) At the top of the proc is the statement ' DECLARE @BillActualRoom bit'. If I understand correctly this is a local variable. Later in the code we have the statement 'SELECT @BillActualRoom = 0 FROM BillingOptions WHERE CenterID = @CenterID' where @CenterID is an input ...Show All

• yourself_20052006 How to do Running Total on a field

  I am creating a Summary report and on one of the fields "Resume Exists" has values of Yes or No. I am trying to do a summary by BU on this field to say how many resumes don't exist. So I would like it to total how many No's are in the Resume Exists field. I was thinking of having the field on the detail row, but hide it, then do a summary on the footer. I have not been very successful and was wondering if anyone has done this a ...Show All

• dmcrews4202 T-Sql Problem

  Hi there, can someone please help me on how will I transfer a record from a table in one database server to another database server with a different table name Thanks in advance... add the server as a linked server, then . . . insert into ThisServer.ThisDB.ThisOwner.ThisTable select * from ThatServer.ThatDB.ThatOwner.ThatTable ...Show All

• ZeroZero navigation question

  hi all, i need to add a BACK button to some reports. I have a report that has a hyperlink to another report. When I click it, I go to that other report, but because I cannot open it into a new page, I got to be able to return somehow to the initial page. In this second report I added a row, I have embedded the picture of a button that reads GOBACK, but for the Navigation property I do not know how to specify navigation to the previous page. ...Show All

• RickyLin SQL Server 2005 fails while installing on a cluster.

  I'm building an SQL Server 2005 cluster on a Windows 2003 cluster. Windows 2003 cluster and MSDTC service are all up and running properly. No problems there, but when I try to install SQL Server 2005 as a cluster service, it fails. The installation goes past the stage where it validates both the nodes and doesn't find any issue there, but when it tries to install fiels it fails. It fails on node 2. When I checked the scduled installer job it cre ...Show All

• Girija The value could not be converted because of a potential loss of data in SSIS package

  With my SSIS package, I want to import data from a flat file (TXT- delimited with ) to a table in my database in sql server 2005. The problem is that I have a column of type datetime in my table. But as you know, the data in txt is string. First I created my package through importing data and using import/export wizard in management studio to my database and selecting flat file connection. There, I selected my txt file and column delimiter as ...Show All

• Steven Wilmot Cannot deploy assembly from VS.NET into SQL server 2005

  Hi, when deploying assembly from VS into SQL Server 2005, deployment fails with these error messages: Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command.  The results, if any, should be discarded. Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command.  The results, if any, should be discarded. I'm deploying assembly with UNSAFE permission setting. What's wrong, please Than ...Show All

• mwharton An instance of the SQL Server Reconciler error object cannot be created

  I've got the following server configuration. Database Server - Windows 2003 Standard - MSSQL 2000 sp4   Web Server - Windows 2003 Standard - SQL 2000 sp4 replication components - SQL Mobile 2005 Server tools   The database server published out the snapshot to a share on the web server. This bit is working file, I can see the snapshot contents etc. When I connect from my own pc using SQL Management Studio a ...Show All

• pwoods Can I use VB.NET 2003 with SQL Everywhere?

  Hi, Can I use VB.NET 2003 with SQL Everywhere on desktop Is it possible to create and populate data into .sdf with VB.NET 2003 Please advice, thank you very much. Best Regards, Gabriel I would like to know also... I am having problem with reference System.Data.SqlServerCe.dll Not valid assembly or COM component. VS 2003 C# Thanks No, SQL Mobile and SQL Everywhere ...Show All

• llong Restored Database/Diagrams Support/SQL-Server 2005

  Hello, I have restored a database from SQL-server 2000 into SQL-server 2005 and when I try to install diagram support, I receive this error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the da ...Show All

• TGrattidge SQLDumper

  Hi I have been reading KB 917825 about SQLDumper and have the following questions: The article explains that we can automatically produce a dump in a clustered environement and explains how to set it up. It doesn't mention however how to set it up in a standalone environment . However it mentions the trace flags 2540 to 2559, is this what we need to set as they are also not documented Also there are various parameters in Analysis Servic ...Show All

• jamescarpino SSIS

  Iam copying the data from a excel file to a database using SSIS.The excel file has a accounting  column to store money (ie $ 789.2344667) etc. In database it has a currency column for the same. But when we copy the data running the ssis the value is rounded off to the 4th decimal place and the rest gets truncated. ie a value of 789.2344667 goes to 789.2345. Can any body suggest me a way by which we can get the accurate value in the dat ...Show All

• Matthew Martin Global Temp tables

  Hi group, I want to create several global temp tables. I've created a script: if not object_id('tempdb..##tbl_ProductTypes') is null begin drop table ##tbl_ProductTypes end select * into ##tbl_ProductTypes from dbo.tbl_ProductTypes This script creates a global temp table. When I run it in QA the table is created. When I close QA the table is dropped. This is correct since I found the following in BoL: [Global temporary tables are automatically ...Show All

• ss23 SSIS - trouble moving data from SQL Server 2005 to MS Access 2003

  I'm having some trouble moving data from SQL Server 2005 to MS Access 2003.  I used the SSIS Import and Export Wizard to create a package to move data from a view in SQL Server to a table in Access.  The wizard successfully creates the package with a data flow task that has a source, conversion and destination, but when I run it (using the debugger), it fails.  The conversion is just converting some Unicode strings.  Any help ...Show All

• Jos Wilson How can I have SQL 9.0 instance in management studio

  I've installed SQL Server 2005 and SQL Server 2000 side by side. Now when I open SQL Server Management Studio it runs the SQL version 8 that belongs to SQL Server 2000. How can I start with SQL Server 2005 (SQL 9.0) to create new database under the new features thank you. Thanks Chad, I have two Instances of SQL Server. one is ServerName which is based on SQL 8.0 (2000) and another one is ServerName/SQLEX ...Show All