Answer Questions

• iamme SQL Server 2005 Install Hangs - Does MS Plan to fix?

  I am experiencing extremely slow behavior (no activity for > 30 mins) during a SS 2005 Dev Edition install on XP SP2 on various steps during the SQL Server Database Services step - e.g. during "Setting File Security". This is very annoying. I've found many postings on this issue indicating that OS calls in this part of the install (e.g. LookupAccountName()) are network speed dependent. Does Microsoft have any plans to rework this part of the install to rid the need of these calls I really wish the install would be possible without these calls - it's driving me crazy monitoring this for hours. We've got to roll SS2005 out to a couple hundred developers eventually and this isn't going to cut it. Thanks for your tim ...Show All

• Will Merydith Web Synchronisation Using RMO

  hi every body please help me out on this issue , since i am at final stage in finishing up the module. Previously i had done web synchronisation using RMO it is working fine at my office where i have an 2003 server which is an domain controller , publisher i have configured on the 2003 server , and i had subscribers on xp Machines where it was well working fine, clients were not on the domain , it is an independent Machine. we had an security error which was resolve by this same forum, ie the client windows login id should exists on the server too. only then synchronisation is happening at our office, Now the problem is i have an same setup , but the server 2003 is hosted at a remote place , which is not an domain controller, n ...Show All

• vishuonline Importing Data from Access 2002 in SQL Express

  Hi All, At the moment i have a piece of software that uses Access to store the data into a number of tables. I am developing a new piece of software that has been built around SQL express and need to upgrade users that are using access. I have managed to write the installation to install etc and also the start of a script to insert all of the tables. I cant work out how to get the data into SQL express using a script. Basically the access db (CentralDb) will be stored a a given location C:\Program Files\CentralDB.mdb The tables within the SQL version are indentical to access but i need a way of pulling out the information stored and putting it into SQL, and as there is no DTS i am becoming stuck on how to automate the process. ...Show All

• donkaiser SQL Server 2000 Server: Msg 18456, Level 14, State 1, Line 1 Login failed for user 'sa'.

  As an 'SA' I thought that you have permission to do anything on the server. Running an update command from Query Analyzer is throwing this error: SQL Server 2000 SP3 Server: Msg 18456, Level 14, State 1, Line 1 Login failed for user 'sa'. The table is in the dbo schema. Has anyone seen this error before Windows 2003 R2 SQL Server 8.0.2039 I am having the same problem described above: I am trying to update a stored proc on one of our boxes. I have logged in as SA. I have logged in as Myself (windows, sysadmin). I have logged in as a newly created ID with Sysadmin rights. I have logged in with a newly created ID mapped to the database in question. Ev ...Show All

• GrkEngineer Converting date from string to datetime in data transfer task

  The source is a flat file with a column where dates are stored as: 07/12/2006 11:35am. In some cases the column is blank. I need to import this into a table with a datetime column. In the data flow task, I get the error that conversion b/w String and DB_Timestamp is not allowed. First question is why does SSIS think its a DB_Timestamp column Shouldnt it be DB_Date or DB_Time. Anyway, when I add a Data Conversion Task in the Data Flow, and cast to the source column to either DB_TimeStamp, DB_Date or DB_Time I get an error. Please help. What am I doing wrong. Asim. Right on. Thanks! Asim Ahmed wrote: No, different system. Also, when I use a conv ...Show All

• Yannis Angelis To sum a field which already contains an aggregate function

  Hi, I am using a "Previous" an aggregate function in Table Detail Section, i want to total that field at the end i.e in Table Footer. when i use "SUM" function, its says aggregate functions cannot be nested inside an aggregate function thanks in advance Could you paste your "detail field" and "total field" code ...Show All

• DQM Integrate more than one SSIS packages into one package

  Hi I'm new to SSIS field. I'm importing data from flat files to sql server 2005 through SSIS packages. I have around 30 packages which transfers data from flat files to corresponding database tables. I want a single package that will run all the 30 packages by running that single package. Like in a single stored procedure we can run multiple stored procedure, I want the same solutions for my packages. Is there any method which can solve the above issue Please kindly guide me . Its urgent. please reply soon. Thanks in advance. Hi priyanka, You could use the Execute Package Task to call your other packages on one "mother" package. You can find it in your Too ...Show All

• keithy02 Database Engine Tuning Advisor gives non existent errors in SQL 2005

  Hello, I am sure you have heard of Community server - if not you are just using it ;) I decided to try to optimise the performance of my site, run a trace and then DETA. And I am getting errors like these: SanjayAgrawal wrote: Can you please use the -d option (dta.exe) or "Database for Workload Analysis" option in UI to set the database context to the database that contains the stored procedures. Thanks Sanjay I'm having a similar issue, and I have set the database context to the correct database the contains the stored procedures and tables. Any clues Hi! The database name is CommunityServer - the sprocs res ...Show All

• SouLDragooN Passing object properties to variables

  Hi. I was wondering if it's possible to pass object properties to variables For example, if I have a ConnectionString property for a SQL Server connection, would it be possible to pass this value to a User-scoped variable Any ideas would be appreciated. Thanks! Yes, this is exactly what I meant. Thanks! One way you could accomplish this is by using a Script task. You can access the properties of all the connections in your Connection Manager through the Dts ScriptObjectModel . For example, the following code grabs the ConnectionString of my " currentFolder " connection object, and stores it in the " myConnectionString " variable. Public Sub Main() Dim value As String value = Dts ...Show All

• fettoter 2000 active x doesn't work in 2005

  I have an active x script written in vb that just counts the records in a table and fails the step if there are not enough records. It is simple and effective. But when I transfered this task to my SSIS package I get a function not found error. I am not familiar with active x or vb script so I have no idea what is wrong. I can do without while I build the package but I need it in the end to prevent possible problems.... Here is the script... '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() dim myConn dim myRecordset dim iRowCount ' instantiate the ADO objects set myC ...Show All

• progames25 SSAS Security in an enterprise network scenario

  Our company operates a public, internet-facing website. To support this, our network is divided into three domains: Production <- this is where our live website operates DataWarehouse <- This is where our datawarehouse is located, and takes data feeds from the Production domain. Our analysis services instances live here as well. Local <- This is where all all our development, etc takes place, and is the domain all users have access to. For security reasons and to ensure the safety of private information the Local domain can only access the DMZ domain, and the number of ports open between the two domains are limited. Currently, the AS port (1444, I believe) is not open between the two domains, and we are facing an issue because lo ...Show All

• Krista how to build a Organogram report

  hi i want to develop a report to show organogram, anyone can help me.... thanks, Imran. Check out www.dundas.com - there are some org chart controls there. cheers, Andrew ...Show All

• Aleksandr Tokarev OPENQUERY and unicode from MySQL

  Hi, all. Using SQL 2005. When I execute this query against a MySQL database set up as a linked server, cyrillic text stored in unicode in MySQL shows up as question marks ( ). SELECT * FROM OPENQUERY ( LINKEDSERVER , 'SELECT * FROM documents ) Clearly, some kind of unicode issue. I've spent a few hours reading in BOL and searching online. Must be something simple, but I'm not finding a solution. If anyone has suggestions, I'd be very grateful. Stephen Just to follow up, my testing this morning suggests that this is an issue with the MySQL OBDC driver, used to create the connection to the linked server in SQL Server. So if anyone has solved this issue before, of course I'd be ...Show All

• srividyaramesha Reporting Services SP2 CTP "Select All" back in preview but not on web

  Hi I've installed SQL Server Express 2005 SP2 CTP specifically because I require the "Select All" checkbox to reappear in multi-value parameters. This was successful in Business Intelligence Studio and when i preview the report the MV params have Select All options. However, when I deploy to the web the MV params do not have Select All options. Why would this be Regards Adam Whitehead You and me both, MS Will just not give out a rlease date for SP2, purely because it is dependant on the CTP, so far most things i have looked at are good, so im hopeful of a quick delivery from CTP to SP2 release. Before Xmas...... I think prob not, Early - Mid Jan Maybe but Def in by Feb next year. All jus ...Show All

• Joshizzle Desprate..Please Help

  I wrote an application using Visual Studio 2005. This app requires a login that get that accesses SQL Express Data. I have an XP Pro box set up as a server using DSL Modem and connected to that is a Wireless hub. I used Network Wizard to set up a Home/Small Business Network on all the computers. My laptop has XP Pro and has Visual Studio and that's where I wrote the application. It's connect to the wirless hub with a cat 5 cable. The other laptop has XP Home Edition and is in another room is connected with wirless only. I set up a user called user1 in SQLExpress with a password. I set it up using MIXED MODE. (SQL server and Windows authentication mode) Connection String: myCn.ConnectionString = "Provider=SQLOLEDB;Data Sou ...Show All