Answer Questions

• simon.bruynsteen Deadlock Issues

  You need to post detail about your queries.  Show DDL, sample data, and the two queries that are deadlocking, and we can help you re-write them so that they don't deadlock.   See the following if you need help providing DDL and sample data:  http:// www.aspfaq.com/etiquette.asp id=5006 -- Adam Machanic SQL Server MVP http://www.datamanipulation.net --     < clubberx@di ...Show All

• AndyB90 Just the time...

  Hi, I'm new to SQLServer and I would like to know how I store times without dates! I simply want to store a duration which has no concept of a date, but I cannot seem to find a data type that does the job. Am I missing something obvious Cheers, Roy Datetime is the only "temporal" format in SQL Server (that you can then use with Datediff, Datepart, etc). What you may want to consider, since you're storing a dur ...Show All

• ooodi Problem trying to compare calculation

  SELECT l.CAgency,         l.Product,         l.OfficerCode,         l.AgencyName,         l.AgencyID,         l.TranCode,         l.UserID,         l.ReceivedDate,         l.PostingDate,    &nbs ...Show All

• J Griffin Views or not?

  I am supposing that SQL Mobile 2005 does not support views in its database It is odd that all development tools show the tab of Views, but I cannot seem to find how someone would create one there. Is there a reference someone can point me to, or just reply to the forum to set me straight. Thanks. Correct, views and stored procedures are not supported by SQL Mobile. I would guess development tolls are c ...Show All

• Don Hiatt ReportViewer's checked dropdown list control?

  I would like to create my own parameter area for my reports which are displayed in an ASP.NET web page with the ASP.NET 2005 ReportViewer control (i.e. I have the ShowParameterPrompts property on my Report Viewer control set to False). I would like to use the Checked Dropdown List control that allows you to check off each item individually or to check the (Select All) option for my multi-valued parameters. Is there a way I can create an instanc ...Show All

• Davidrd Active Directory/ADSI connection problems...help!

  I am having weird problems using ADSI and SQL Server. Our local intranet is ASP with a SQL database on Windows 2003 Server. It uses Active Directory (via ADSI linked server) to get authenicate users, etc. Every now and then (about once a month) the SQL connection to AD will "crash". The following error is what I see when it has crashed: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL ...Show All

• Clark Snowden Table created in SQL Query Analiser won't work

  Hi all, We're facing a rather strange problem here: Oe of my colleagues is trying to create a table using Sql Query Analiser. the "create table" command returns no errors. But when we try to access the table, it says it's an invalid object name. I've checked sysobjects, and the objetc is there. Can someone give me any clues Thanks Can you include the 'create table' command that was ...Show All

• Asim A backup on remote computer

  Hi How can i make backup on the other computer. 1. SQL computer is express edition, and computers are in workgroup 2. SQL computer is express edition and is not on domain, and backup computer is on domain. thanks alex Hi, you can simply make a backup by connecting to the server and issue a backup command LIEK BACKUP DATABASE (...) the exact syntax can be found in the BOL. if you want to stor ...Show All

• Khamul Can't connect to SSIS

  Hi,   I'm evaluating SQL server 2005 for planning a upgrade of our datawarehouse from SQL 2000 to 2005. We use a lot of DTS pacakages so that's my primary focus right now. I get this strange error when trying to connect to SSIS -> Stored Pacakges -> MSDB: TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For hel ...Show All

• rayBristol SQL Server 2000 sign-on to 2005

  Good morning, I'm wondering if it's possible to connect to SQL Server 2005 from 2000 I'm having no trouble going from 2005 to 2000 but I can't seem to connect the other way. Any help would be apprciated. Thanks, Hi Bill,   Good -- consistency means it will be easier to track down the problem :)   Can you connect to the 2005 server locally   (ass ...Show All

• cstackable Combine Data and Split into separate txt files for each header/detail row groupings

  I’ve created with the help of some great people an SSIS 2005 package which does the follow so far:   1)        Takes an incoming txt file.   Example txt file: http://www.webfound.net/split.txt       The txt file going from top to bottom is sort of grouped like this      Header Row (designated by ‘HD’)       & ...Show All

• tgallagher Can't get a Subreport to start on the correct page or table header to repeat on multiple pages

  I am staring to lose my mind on all this "work-around" BS in trying to create a dynamic header. I have a report with contains a table, whose first two lines are a header line in which I want to repeat on each page. Then I have about 20 detail rows of information related to the header. The 21st detail row is a merged cell that contains a subreport relating to the header item. When printing to PDF, the detail rows consume about hal ...Show All

• LSanders No TRIM function in 2005 - are you serious!?

  I cannot believe that there is yet another version of SQL Server without a TRIM function.  So for SQL 2005 (like I've done in 7.0 and 2000) my T-SQL will look like dog poo because I will have to write LTRIM(RTRIM(MyValue)) anytime I want to remove whitespace from both ends of character values instead of just writing TRIM(MyValue). Microsoft - how can you write LTRIM and RTRIM and not write TRIM in the same breath an ...Show All

• Mial Changing SSIS package - new user question

  I saved a simple export/import package from the import/export wizard to a .dtsx file/package. Now I want to change the package to delete/truncate all of the tables before adding data. (since this has 80 tables it would have been a pain to edit each of them individually) How can I easily go about doing this with the SSIS package. I can't find out where this would actually be executed. Also, how can I actually view the code behind the SSIS p ...Show All

• KNPaing cannot install express edition

  I am using the SQL Server June 2005 Community Technology Preview and installing express edition from it. I did unisntall the old version of sql and .net framework. Then followed the instructions on page http://www.microsoft.com/downloads/details.aspx FamilyId=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en but I am getting an error "sql server 2005 CTP setup has detected incompatible beta components from visual studio or ...Show All