Answer Questions

• mattdawg checking the database existence in sql server

  hi to everybody i'm new member to this site and i don't know where can be a good place for creating this topic pardon me for probable mistake. i need to attach and detach the database in/from sql server in vb.net with hard-code .i can do this without using stored procedure and with SQL-DMO But i can't checking The database Existence for attaching it.now, how can i check the database existense for preventing the attach operation. please help me thanks a lot       Hi, if it is a non-SQL Server database file you will have to import from the file using the DTS Import wizard or any other tools which offer a driver for the dbf files. HTH, Jens K. Suessmeyer. --- http://www. ...Show All

• FritzDeVries SELECT statement with two retrieved columns originating from the same dbase fields

  Hello, I've been busy all night searching and reading trying to figure out how I can do the following. I have a table that tracks user IDs in multiple fields. When I select records from this table I need a way to resolve those ID fields back into user names by referencing the users table. SQL statement thus far... SELECT A.Username as NameA, B.Username As NameB, FROM theTable, Users As A, Users As B WHERE theTable.UserIDA How do I resolve theTable.UserIDA and theTable.UserIDB back to Users.Username so that the records returned fill the fields NameA and NameB Your help is greatly appreciated. Thanks, -Mike Also, please don't use the column_expression AS 'column_al ...Show All

• Martin Rajotte SSIS Inner Join Problem

  I have a Merge Join transofrmation that takes as input Table1 and Table2, which are each OLEDB Sources. Both tables have IsSorted set to true and the join key set to position 1. Table1 contains 242 rows. Table2 contains 61 rows. I connect Table1 and Table2 to my Merge Join Transformation, and slect the join key. For some reason, during transformation, the join is messed up because it spits out 69 records. If I write an equivelent statement is T-SQL, the results are correct: Select Table1.Col1, Table1.Col2, Table2.Col1 FROM Table1 INNER JOIN Table2 ON Table2.JoinKey = Table1.JoinKey The results are 242 because every instance of JoinKey exists in both tables. Having double cheked sorting and data types, I am ...Show All

• Garyngl New SQL Express User - No Server Connection

  Hello, I am a new to SQL server express, although i have been using SQL server 2003 for development purpose. I just recently installed express and would like to connect to it but can't. I've downloaded and installed SQL Server 2005, SQL Server Management Studio Express, SQL Server Native Client, MSXML 6.0 Parser and .Net Framework 2.0. When i setup my ODBC driver and test the connection i get the "test failed" message: Attempting connection [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error I also get the following message from the SQL Server Management Studio Express. Any help on slving this problem will be highly appreciated. Thank you. =================================== A connection was su ...Show All

• mikej409 SQL Server 2005 (Dev Ed) Install gone WRONG!

  Hi, I cant get SQL Server Management Studio installed. The install completes but Management Studio is unavailable in my program files list. I've uninstalled and reinstalled and even been through "How to uninstall an instance of SQL Server 2005 manually" http://support.microsoft.com/kb/909967 . But no matter how many times I run ARPWrapper.exe 5 items are still present: <img scr=" http://EventAnalyser.Appointmentsbook.com/SQLWontUninstall.jpg "> I'm tempted to use MSIZAP but it doesn't apply to sqlserver. How can I get rid of SQL Server and start again without rebuilding my pc Cheers, Jeremy Hi Madhu, Thanks for the feedback. During install I selected everything including Workstation C ...Show All

• MaHMouD 2006 How to improve the efficience of Sql query ?

  now i want to get results from server tables, but i found it is very slow, for example : select Coalesce(T1.Name, T2.Name, T3.Name), T1.M1, T2.M2, T3.M3 from T1 full outer join T2 on Coalesce(T1.Name, NULL) = T2.Name full outer join T3 on Coalesce(T1.Name, T2.Name) = T3.Name in Tables i have builded index for name, but when every table have 20000 records, the sql above is very slow, is there other method to improve the query speed Thks You're trying to full outer join three tables and on the join condition is based on computed columns... well that's a query not build for performance... If you want to improve performance you need to rewrite the query in a way that doesn't uses ...Show All

• kconcept send user

  Hi everyone!! I have a system that will be accessed on internet/extranet. And they will grant the access to this system from an AD. I thought I could grant the users by its login in the AD. But I noticed that the reporting services grants to the user that logon on the pc. A way to resolve my problem would be sending as parameter a default user that have access to these reports. Anyone have an idea of how I could do it Or another solution to my problem. Best regards! Pedro Hi Jordi! thanks for reply. They won’t be windows users because the AD will check the login and password to grant access to this extranet system. And the users will access it from internet. I thoug ...Show All

• supersonic1976 Copying variables from another package

  HI, we have something like 120 packages that need to be "upgraded" to a newer version of a template. Basically, we need to add a bunch of variables of various types (12-15 variables). Is there a way to open the package in a script task and add those variables programmatically Or is there another way to do it (e.g. modify the dtsx file) Thank you, Ccote HI Jamie, I have been able to achieve something interesting by using a script component with the test code below: Public Sub Main() Dim application As Microsoft.SqlServer.Dts.Runtime.Application = New Application() Dim packagename As Object = Dts.Connections( "ChildPackage" ).AcquireConnection( Nothing ) ...Show All

• upgraders sqlcmd with trusted connection and IP address or fully qualified hostname

  The command sqlcmd seems to fail when using trusted connection and an IP address or a fully qualified hostname. For example: sqlcmd -E -S nnn.nnn.nnn.nnn where nnn.nnn.nnn.nnn is the real IP address of the machine, or sqlcmd -E -S hostname.domain.com where hostname.domain.com is the fully qualified hostname of the machine, gives the error: Msg 18452, Level 14, State 1, Server 380GX280B05, Line 1 Login failed for user ''. The user is not associated with a trusted SQL Server c onnection. On the other hand, sqlcmd -E -S 127.0.0.1 works, and so does sqlcmd -E -S hostname, or sqlcmd -E -S tcp:hostname,1433. This is on a clean machine, with SQL Server 2005 freshly installed as Administrator with mixed authentication, and t ...Show All

• kcchesnut Column Header for Matrix Report

  I have a matrix report, which looks like the following: Header C Header D Column A Column B Column C Column D Column A and B are Row Group columns in the matrix. Column C and D are the details columns. How can I add column header to column A and B. Seems I cannot do it in Reporting Services 2005. Fan Try also using a table inside a rectangle on the matrix corner only with the header row. Adjust the header row to have the size ,number and style of the columns of the matrix. Nik Perfect - Thanks! Yes, you can not able to achieve this with Matrices currently and we are hoping to make it possible in ...Show All

• barkingdog Rebuild Index grew database .mdf files

  Hello, Overnight, I had a Rebuild Index job run and it grew the size of the database.mdf file approximately 4 times. 300MB to 1.2GB. It also changed the initial size of the database to 1.2GB. Is there any way to recover this space or to shrink the database I tried to shrink it with DBCC SHRINKDATABASE to no avail (only recovered 40MB). Do I have any options to reclaim the space Any ideas Thanks. It turns out that the cause of the increase in size of database files was due to the fact that I had the Rebuild Index job set with a fill factor of 10%. I tested a bit and found that if I set it to reorganize pages with the default amount of free space that it didn't triple/quadruple/etc the size of the files ...Show All

• Guwapo Cannot start SQL Server Browser

  Hello, I use SQL Server 2005 for multi-user access. In the Surface Area Configuration, I changed the protocol from TCP/IP to Named Pipes and restarted the service. Then I went to SQL Server Browser, stopped it and clicked on Start to restart. I am getting a message "An error occurred while performing this operation". I am not able to get the Browser started. Any help would be greatly appreciated. Matt, That worked. I am amazed that it did... but it did. How would an invalid setup have affected this I have just run a fresh install and service packed to SP2, but this problem persisted. I'm going to need that DLL though, this server is supposed to run analysis services and OLAP. W ...Show All

• Joe Simmonds Problem deploying reports

  Hi, I have an application that involves 3 components one of which is Reports. My system's configuration: SQL 2000 - Default instance SQL 2005 - Named instance (Instance1). I provide the user with an option of selecting the SQL Server instance. If the user chooses Instance1, then I need to deply the reports in SQL 2005. The exceptions encountered during installation are logged in the Event log. When I do the installation for the in a machine, I always get the following error in the event log: Could not connect to the Report Server Database http://<MachineName>/ReportingServices.asmx . I tried giving the rs.exe options from commandline. I got an error like: Error in DetermineReportUrlSecurity(). I don't have the exact error ...Show All

• Suganya Mahadevan problem with foreach loop container and excel files

  well i am trying to follow the example of msdn help on how to loop through excel files and it doesn't work. the variables have the project scope. what can i do well i have a number of excel files and i want to use them in a loop so as to do calculations and load a table. when i use one file the process is ok, but when i use the steps described in that link http://msdn2.microsoft.com/en-us/library/ms345182.aspx i get errors. thank u in advance no an i get the following message TITLE: Microsoft Visual Studio ------------------------------ Error at Package3 [Connection manager "SourceConnectionExcel"]: An OLE DB error has occurred. Error code: ...Show All

• TruePsion changing compatability level from80(2000) to 90(2005)

  Hi I am planning to migrate my database from sql 2000 to sql 2005 I need to know when i change the compatibility from 80 to 90 1) What are the things which i need to look out for. If i have changed every thing as per upgrade advisor will i have to make or anticipate further changes. 2) Please tell me whether if i dont use 90 compatability level will i miss out anything What am i missing out Will it be possible to do online index re-build with compatability level set to 80. Is there a list of new benefits/changes i will be getting when i move to sql 2005 compatability set to 90. Please do reply .Awaiting your answers,.... Thanks in advance. Thank you for your reply ...Show All