Answer Questions

• Leo Kent SP2 shipped!

  SQL Server 2005 SP2 has now been Released To Web and is available for download: http://www.microsoft.com/sql/sp2.mspx February Books Online update is not included in SP2, get it separately: http://www.microsoft.com/downloads/details.aspx familyid=BE6A2C5D-00DF-4220-B133-29C1E0B6585F   Anybody know if this SP2 solves the problem with Foxpro OLE datasources that SP1 created I dunno if anyone else remembers but when SP1 came out and people installed it they suddenly found that they could no longer use SSIS with the FoxPro OLE connections... So we all had to go and reinstall SQL Server 2005 to get our packages running again... Thanks ...Show All

• alsc Connection failed: 18456 error

  When one of my users creates an ODBC connection to a SQL database using Windows authentication, he gets this error: Connection failed: SQLState: '28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Domain\username' The thing is, the 'Domain\username' is not his username and I have no idea where or why it is trying to use that username. Ideas I don't have any problems using the ODBC DSN Administrator and integrated auth. Did you make sure that "With Integrated Windows Authentication" was selected on the "How should SQL Server verify the authenticity of the login ID" prompt Il-Sung. Hi Mike, If I read your post c ...Show All

• sathyank error in sql server 2005 setup on win2k sp4

  error msg in summary.txt Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows 2000 Server Service Pack 4 (Build 2195) Time : Wed Feb 14 03:31:27 2007 LDINTSQL1 : There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt. Time : Wed Feb 14 03:39:30 2007 List of log files: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_LDINTSQL1_Core.log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup00 ...Show All

• Brandon Patram Has anyone seen a Licensing screen during the install process?

  Hi again. I have been deploying the first few test SQL 2005 machines recently, from what I was told is the full-feature edition DVD received from the https://licensing.microsoft.com  website. We have purchased a mixture of per-processor and per-user licenses to use for this software. However, I am never asked what licensing mode to use during the install. Can anyone confirm or deny that a setup screen appears asking what licensing version you want to use (per-user or per-processor) I cannot confirm what was downloaded from the licensing-website because I don't have access through the company. I have the same symptoms as seen on this postings: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=360181& ...Show All

• AvalonNewbie Setting collection element value using expression fails

  I'm trying to set the value of the SelectedDatabases collection property of an Update Statistics Task using an expression for the task, basing it on a user variable. Ultimately, I'll set that variable's value from a configuration file at run time and thereby specify the database whose statistics I want to update. When I set this up in the designer, I get an error at the time I try to save the package: TITLE: Microsoft Visual Studio ------------------------------ Nonfatal errors occurred while saving the package: Error at Update Statistics Task: The result of the expression "@[User::SelectedDatabase]" on property "SelectedDatabases" cannot be written to the property. The expression was evaluated, but cannot be s ...Show All

• Kristian Jörgensen Help with finding the time diff

  I am looking for some guidance on what would be the easiest way to obtain the difference between two times and add the result to a another column within a table. For example: Column1 Column2 Column3 11-29-2006 23:32:35 11-29-2006 23:37:21 00:04:46 As you can see from the example above I am wanting to obtain the time difference between the values in column1 and column2 while adding the result to column3. I have read that this can be done and have been told this can be done. But I have yet to figure out a way to make it happen. Any suggestions would be appreciated. Thanks! One more version may select RIGHT ( CONVERT ( VARCHAR ( 20 ), ET ...Show All

• Danny Jr Total a result of a subreport

  I need to total the result of a subreport for a filtered dataset. Anybody have any ideas I have this set up with subreports because there are two different queries that I am running for my results with tables that cannot be linked in one query. The problem is that the subreport with the totals is totaling everything because it doesn't know what values I have filtered out in my main report. I tried keeping track with custom code in an ArrayList, but I can't pass that to my subreport. BJ Hi- How are you filtering the parent data set Are you doing this via a report parameter Could you create 2 datasets in the main report and filter both of them accordingly You don't need to create a subreport just ...Show All

• Hiral SQL Server Express - how to deploy App_Data to web?

  VWD Express 2005 -- My application is working fine on local computer. I used FTP to transfer pages to ISP - done. Now I need to store SQL App_Data on their separate server. I have a tutorial from the ISP that shows a step by step procedure for SQL 2000 starting with Enterprise Manager. Is Enterprise Manager available for SQL Server Express If not, how do you deploy the SQL App_Data to the web thx Your answer helped me - for others in future, here is an article that may also be worthwhile: http://www.c-sharpcorner.com/uploadfile/dsdaf/104012006083052am/1.aspx # I sure appreciate your help, CARMCK Thanks for the link carmck, that's a pretty good article. There is one part of the arti ...Show All

• Edentheguy SQL Server is waiting for an internal operation to complete

  When saving a database diagram, SQL Server 2005 frequently "hangs" for an indeteminate amount of time and displays the message "Microsoft SQL Server Management Studio is waiting for an internal operation to complete. If you regularly encounter this delay during normal usage, pelase report this problem to Microsoft." For one thing, this is an extremely lame and unhelpful message, as it gives no clue as to specifically *who* to report the problem to (Microsoft is pretty big, after all), and an "internal operation" is sufficiently ambiguous to mean anything. I cannot find any references to this problem, and it happens frequently enough that I'm finding it very difficult to use Management Studio for editing ...Show All

• Ridge SQL Everywhere - Utter Dissapointment!

  On the surface, SQL Everywhere seems like a great way to reuse code from an enterprise app using SQL Server in a SMB or home office app needing a more But in experimenting, I have been utterly dissapointed in SQL Everywhere. Key reasons for my dissapointment are the inability to write Database Independent codeusing System.Data.Common . There are instructions for doing this in the MSDN. But do they only apply to non Microsoft Databases I have the following grievances. Are these things that Microsoft plans to fix, or do they plan to leave SQL Everywhere as an inferior product 1. Limitations of query language are not well documented nor understood. SQL Everywhere uses a "subset of Transact-SQL syntax". I have not seen it do ...Show All

• RobDever SIMPLE QUESTION !!

  This might be a very dumb question but "is there an easy way to obtain only the name of the fields from a table" I am sure there is but as you might have guess I am just a starter who cannot figure it out. Any code is appreciated for the same. Thanks! NEVILLE GEORGE Neville: The sp_help procedure will return this information -- along with a lot of additional information. If you are wanting ONLY the field names this will not work. Nonetheless, you can see if this meets your purposes: sp_help tableName Another option is to query the 'name' column of the 'syscolumns' table (depending on your version of SQL server); something like: declare @targetObject sysname set @target ...Show All

• Singersinger report builder

  I login in my server do report with report builder , when i run report , the error is: The permissions granted to user 'ADSYSTEC-CZW\users11' are insufficient for performing this operation. thanks for helps! Make sure that the user is in the appropiate permission group to view the report builder models (Minimum is the default "Report Builder" group) which can be found under the "Site Administration" setting in the Report Server. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Sorry I have something make up. 1. The server and my machine are not  the same computer,My machine name is adsystec-czw. 2. The reports web site's Aut ...Show All

• Cereal123 Problem with SQLServer 2000

  i installed the Visual Studio 2004+ Framework.NET 2 and SQLserver 2005 after those i installed SQLserver 2000 and i got this : http://img240.imageshack.us/img240/7392/sql2fk.jpg thank you From the screenshot http://img240.imageshack.us/img240/7392/sql2fk.jpg - it looks like you are trying to access SQL Server 2005 Express Edition from SQL Server Enterprise Manager. Try accessing SQL Server 2005 express edition from SQL Server Management Studio (which is equivalent of SQL Server 2000 Enterprise manager for SQL Server 2005.) Thanks, Loonysan what should i change here http://img86.imageshack.us/img86/746/remote6np.jpg thank you ...Show All

• JasW How to remove a Primary Key you don't know?

  Hello Guys, I need some help with a question I've been struggling to solve all day. I'm new to Transact-SQL and thus tried to solve my little problem by reading the language reference, but I didn't find what I was looking for. Here's the scenario: I want to remove a table's primary key and replace it with a new one. Removing the pk is usually done with: 1) ALTER TABLE tablename DROP CONSTRAINT constraint_name; GO Unfortunatley, I don't know constraint_name and the simple MySQL command ALTER TABLE tablename DROP PRIMARY KEY doesn't seem to work. To get constraint_name I made a query: 2) SELECT name from sys.key_constraints where parent_object_id = (select object_id from sys.tables where name = 'tablename') Now, here' ...Show All

• Dany V Partner works from mirror to principal, but not vice versa.

  We were having problems setting up the mirroring, so I did it via command lines. I found out the "alter...set partnership" command works on the mirror server going to the principal, but gets a 1418 error when going from the principal to the mirror. So if A is the principal and B is the mirror, A to B fails but B to A works. If I reverse it so that B is the principal and A is the mirror, B to A fails and A to B works. Any suggestions Here’s an update on our problem. We are now doing it thru Management Studio. We set up the mirroring, but answer “no” when it asks to start mirroring and go back to the mirroring screen. One of the default names contains the domain but the other does not. ...Show All