Answer Questions

• Toon Nijland Suitable Administrators Guide

  Hello Our company will be rolling out a new business system in the near future. This will run on SQL Server 2005. I have prior experience of SQL 2000 and I'm looking to purchase some suitable literature to get me up to speed with 2005. I need something that will quickly show me best practices for implementation, backup and high availability etc. Can anyone suggest a suitable administrators companion I've had a quick look an Amazon and there seem to be plenty, but before I buy I'd like some advice from those in the field if possible. Many thanks in advance of your help and advice. Kind regards Danny I used SQL Server Book Online. I think it's a good place to start. Cheers Buck, much appr ...Show All

• drdexter33 DTExec via xp_cmdshell

  In my previous post here: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1044739&SiteID=1 Michael Entin provides a number of responses to my questions regarding programatic execution of remote SSIS packages. Having experienced some significant reliability problems with the Microsoft.SqlServer.Dts.Runtime components from an ASP.NET process (the page either times out, or inevitably just stops responding), I have been prototyping the DTExec command option which Michael suggests as being a better approach to remote programability. So, off I've been prototyping this all day today... I have a stored procedure that wraps a call to xp_cmdshell which takes the DTS (DTEXEC) params as a big long argument. This scenario would h ...Show All

• Hello_Yo OBDC connection problem to MS SQL 2005

  Still fumbling with this I will try to be as descriptive as I can. I have placed the following code in my asp data access page: <% set cnn = server.createobject("ADODB.Connection") cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=data.EDITED.com;UID=EDITED;PWD=EDITED;DATABASE=EDITED" %> Finding the server fine, creating the error on the SQL 2005 server is: 2006-11-16 09:22:22.92 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 208.38.82.114] 2006-11-16 09:22:22.92 Logon Error: 18452, Severity: 14, State: 1. 2006-11-16 09:22:22.92 Logon Login failed for user ''. The user is n ...Show All

• BigAl_NZ SQL Server time zone?

  I don't know what is going on, here's the error message, could someone please answer thanks Server Error in '/' Application. been there done that, no one knows what that is over there, only told that I was shut out of the SQL database and no suggestions since. I know I'm not shut out of the database since I can upload other things besides new users to it, but if it is searching for something in the ASP.net program no one knows what it is. Thanks well obviously... but how to fix it is a little less obvious. Paul Randal - MSFT wrote: Did you try changing the code to pass that parameter Perhaps I'm misunderstanding what you are talking about ...Show All

• Wee Bubba Query datetime and its performance

  Hi all, I know I miss something very obvious here, but I can see it at the moment - I am very appreciated if someone could help. Why am I have a table scan when I run the query below - note created_date is indexed. DECLARE @LastDate datetime SET @lastDate = (SELECT DATEADD(hh,-1,getdate()) SELECT * FROM Report WHERE Created_Date >@lastDate However, I don't have table scan when I do the following query SELECT * FROM Report WHERE Created_Date > (Getdate()-1) Thanks in advance Thanks for replying Ronald but nope, tried that - I still have table scan. :-( BTW I am using SQL 2000 In this case, the table scan is probably the most effienct way to get the data, according to the query optim ...Show All

• R.Tutus OS backup

  Hello. New MSSQL guy coming from Oracle.  I've read and understand that you can create backup files for a database using the server management studio. However, I'm wondering if that is really necessary.  Suppose I do not care about the loss of transaction logs, is copying the .mdf database files via OS command a viable backup strategy If so do I need to bring down the database engine before starting the file copy Thanks a lot Thank you Kevin. Our production operations run on Oracle systems. We have to run 1 small MSSQL instance since some MSFT application only use that. So, I'm not really concerned about that DB's size, around-the-clock availibility, or point-in-time recovery. Given the above ...Show All

• edukulla rsAccessDenied

  Hello, I am new to Reporting Services 2005, so please bare with me. I have set up a new report that runs fine when I run it, but I am the administrator on the server. When I have a user go to the same web page and attempt to run the report, they receive an error that says something along the lines of "User account 'DomainName\UserName' does not have sufficient access to ReportServer... rsAccessDenied." I have seen several threads on the web that point to IIS, and some that point to the "Reporting Services Configuration Manager" under "Windows Service Identity". In my Windows Services Identity, I have the server set up as "Built-in Account = 'Local System'". Everything seems to be running perfect ...Show All

• lockdon9w1 Single Select Parameter Width Problem in Reporting Services

  Hi I have a report which has 2 parameters 1.Type(Single select)- (Values- Customer,Country) 2.Code(single Selecte)- (If Customer is selected in Type above i display Customer Name/If Country is selected i display Country Name). The problem which i am facing is i have a customer Name which is 199 characters. When i run the report i can see that the Code dropdown expands horizontally to accomodate the text below and it screws up the report screen.The customer Name is - 1234567891123456789112345678911234567891123456789112345678911234567891123456789112345678911234567891ABCDEFGHIJKLMNOPQRSTUVWXYZ ! @#$ABCDEFGHIJKLMNOPQRSTUVWXYZ ! @#$ABCDEFGHIJKLMNOPQRSTUVWXYZ ! @#$123456789 Is there any way to fix this Any help will be apprecia ...Show All

• Meltdown61 Records not updating in Script Component

  I am seeing a strange behavior in a script component that I can't figure out. Basically, there is a field in my script that checks to see if a string field is length of 1. If it is, it updates the field with some value. The strange behavior is that it picks up some of the rows but not others. If Row.FieldValue.Length = 1 Then Row.FieldValue= "Some Value" End If I've tried variations such as: If left(Row.FieldValue.,1) = "-" Then Row.FieldValue= "Some Value" End If But I get the same results. Any Ideas Thanks, that did it. I am relatively new to SSIS, never really delved into the debug information before. tha ...Show All

• Evan Mulawski Differing results on identical systems.

  I have a staging environment and a developement environment set up on the same machine. Both environments consist of two databases, a staging area and a data warehouse. On the staging system when I run a query of the form: select count(*) from [StagingArea].[dbo].[saTable] join [DataWarehouse].[dbo].[dwView] on saTable.col = dwView.col join [DataWarehouse].[dbo].[dwTable1] on dwTable1.col = dwView.col join [DataWarehouse].[dbo].[dwTable2] on (dwTable1.col = dwTable2.col AND dwTable2.col = saTable.col) I get an answer returned in 2 seconds. When I run the same query on the developement system it never comes back with an answer (after 3+ hours). The data in both systems is identical. But it would appear that the query optimizer i ...Show All

• Jith Sensitive data

  Hi all, How can we protect sensitive data (custom properties) in a custom connection manager or a custom data flow component The SSIS Books Online indicates in the " Security Considerations for Integration Services" page that "If you write custom tasks, connection managers, or data flow components, you can specify which properties should be treated as sensitive by Integration Services". But how to do it programmatically Are there any attributes that can be applied on custom properties Thanks. Pascal To get more control about saving properties, you need to implement IDTSComponentPersist. You then override the two methods, LoadFromXml and SaveToXml. You are now in charge of ...Show All

• johnvarney How to check out our cluster remotely?

  Hi everyone, Primary platform on client is XP Pro sp2 and on server Win2003 Ad.Server 64-bit We're looking for any snippet or link related with Clustering instantiating. We need to call our remote cluster from an ASP 3.0 page and check out if one of our Active Resource is up (in this case is a .net service) . We suppose that it should be done for each node. It's an Active-Passive cluster. Thanks for your time, Just connect to the virtual host name that is part of the SQL Resource Group, and make a query. Coding technique should be no different for a cluster than any other remote connection - just use the name of the virtual host instead of the physical one, and the connection gets automati ...Show All

• winprock SQL Server 2005 Express Edition Won't Install

  I've read through every thread I can find, but can't find an answer for this. The installation gets all the way to the end, and then stops. I receive the following error message: "Microsoft SQL Server 2005 Setup has encountered a problem and will end..." I've tried all the troubleshooting tips. I never had any of the beta or prior versions installed, so I'm not sure what the hangup is. Can anyone please help me with this Charlie Great!!! But how do I put it work if I'm getting the WMI problem: Error 2147749896 (0x80041008) I have done everything I'm able to and I can't put it to work. It is downloaded and saved in my PC, but I can't get it down !!!! Please help; I don't know ...Show All

• Paul_Rus Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

  I am receiving the following message when connecting via query analzyer to SQL server using windows authentication.(error 18452). I have a login created with the sys admin server role on the server. When I connect using SQL authentication it works. I added myself to the local admin group on the server, this allows it to work. The same situation is seen with another user. I am using windows 2000 sp4 server and SQL 2000 SP3, connecting from NT4. I get the same issue if I use TCP or named pipes. We have been using SQL security but are moving to windows authentication - but this issue is stopping us. I have checked and upgraded my version of MDAC to match the server version 2.7 (sp1) Any help would be much appreciated. Thanks ...Show All

• C. Hunter I'm Looking For : ReportViewer tutorial With C# && .NET

  Hi All , If you will send to me a link I'll be very grateful . Thanks In Advance Boaz Shalev. That link redirects to this: http://msdn.microsoft.com/vstudio/default.aspx Take a look at the Web Analyzer starter kit at http://lab.msdn.microsoft.com/vs2005/downloads/starterkits/default.aspx . ...Show All