Answer Questions

• Fenghus Attach MySql database via internet

  Hie ! Please, how to manage (attach,connect to) MySql database located on host server http://www.avanti.si from my home PC with Microsoft SQL Server Management Studio Express This " http://www.avanti.si:8080\MySqlDatabaseName,3306 " fail ! Thenks! Actually, you can't connect directly to MySQL database, Management Studio is designed for use with SQL Server. You can create a linked server to any database that offers an OLEDB provider, which I believe MySQL has. The linked server will allow you to query your data from MySQL, but not manage the database. Regards, Mike hi, you should ask you provider about connection info.. assuming the "server" is named and available as " www.avant ...Show All

• anf600 Replication Error 28559

  We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication). We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. When it occurs the device needs a soft reset to recover from the error / close the application and start again. Problem happens more frequently on XDA Exec (http://shop.o2.co.uk/shop/handset/O2/XDAExec:3G) running WM5 compared to devices running Windows Mobile 2003 2nd Edition for Pocket PC phone edition. I had a chat with one of the Micro ...Show All

• Jose76 Problems with Rights in MS SQL Server Management Studio Express

  Hi all!   I'm a beginner in SQL server admin and have just set up SQL Server 2005 in a Vista environment. So far so good! What I've got a problem with now is to get rights set up properly in the MS SQL Server Management Studio Express sw. If I try to add another database or add a new login and such, the results is all the time insufficent priviledges. CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) for instance. SQL is SP2, all else is up to date too Really would appreciate som help on this Olof Hi again! I found the tabs u mentioned, came in where the explicit rights where and set create db on my user. Effectiv rights lists all the rights. Still I can't create a ...Show All

• naiad No connection could be made because the target machine actively refused it

  Hi, I have successfully created a project (using VS.Net 2003 and SQL Server Analysis Services 2000) which is dynamically retrieving dimensions, levels, and members, and i generating and executing a query as per user needs and requirements. However when I tried to deploy the project on another machine, even though the apps is running fine, and the query getting generated, when its trying to show the data in the report-display page using ADOMD.Net, the following error was shown. No connection could be made because the target machine actively refused it Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it origina ...Show All

• Bryce Covert Getting data time in expression

  I would like to get this date+3days and show it on a text-box. Can i do it on the Text-box expression what should i write or i have to use custom code =DateAdd("m", 3, DateTime.Now()) Should be "d" not m =DateAdd("m", 3, DateTime.Now()) Well spotted. Just testing you ...Show All

• Tyrael117 Rights Management in Reporting Service- Organisation wide

  Hello Experts, We are using Reporting service as our reporting solution. as of now we manually add user and give them browser rights. Is there a way by which i dont have to add users to the security section of the report for users to view it. As we have a very big organization who would be using some reports. adding each user will be a night mare. Any idea to get rid of this. /Soni Hello Soni, If your company network is a Windows network, you can use Windows Authentication. You can make a group or use existing groups to authenticate users or groups of users to use reports. This is quite a big topic so you could best check BOL on this. Regards, Jeroen ...Show All

• OmegaMan Distributor cannot connect to subscriber

  I am setting up my 2005 Replication system... publisher = 2005 sp1 Subscriber = 2005 sp1 I created a publication for a single table. Then I created the subscription to another 2005 server. Had to add it as a subscriber in the wizard. Told it to do the snapshot right away. Everything seems fine right up to the point where it tries to connect to the subscriber... I get a cannot connect error. I have tried all kinds of security context and accounts for the sql agent to run under but nothing seems to work. I cannot even get a linked server to work. I have the subscriber setup to accept remote connections. I am not sure where to look at next... I never had this issue in 2000. I double checked ...Show All

• liberty2k Hardware Specifications

  Is there any documented hardware specification for Analysis Services 2005/2000 This is one question asked frequently to me by people implementing AS 2005. I could not find any documents on this. It would be great if any recommendations are available on this. Thanks, S Suresh Such information is often provided by hardware vendors. For instance; http://h18004.www1.hp.com/products/servers/software/microsoft/sqlserver2005.html jumpid=reg_R1002_USEN www.dell.com/sql You can also take a look at the existing case studies like Project REAL http://www.microsoft.com/sql/solutions/bi/projectreal.mspx see what are the data sizes and what hardware used. Edward. -- This posting is provided "AS I ...Show All

• Dominik Chrzanowski Quorum & MSDTC Cluster Questions

  We are trying to setup a Windows Server 2003 Cluster with 2 systems and a DAV. We intend to install SQL 2005 on this Cluster. We purchased a DAV with 3 physical disk arrays as follows. 73GB RAID 1 (our plan is to use this to store sql transaction logs) 146GB RAID 1 (sql backups, temp database & other temp files) 420GB RAID 10 (sql databases) Now as we are setting all this up we find out we need a shared physical drive on the DAV to store the Quorom. It is my understanding we cannot partition the physical drives and use one of the partitions to store the Quorum because when you create the resource for the Quorum the resource is the phsyical disk not the partition. So my question is, is it in our best interest to buy a seperate ...Show All

• Suresh S Unable to set Identity_Insert Off?

  Hi i am unable to set Identity_insert off in sql server compact Can you please tell me if sqlce supports or not If it does not support what is the work around that can be done Please tell the workaround in detail i mean altering table for identity key e.g. Because i have seen some posts that talk about alter table but i am unable to understand how that can done Thanks To copy data from one table (or other data source) to another table with an IDENTITY column, use this algorithm: 1 - Determine the current value of the IDENTITY column of the target table (use the INFORMATION_SCHEMA) 2 - For each row to copy: 2.1 - Get the source IDENTITY value 2.2 - Use an ALTER TABLE ... ALTER COLUMN ... IDENT ...Show All

• qrli Bulk Insert performance

  I have a situation where I need to do multiple inserts into the sql mobile db at one time. I am wondering what would be the most efficient method to do this. Right now I am just doing many inserts, but the performance is lacking. I tried to wrap all the inserts into 1 sql command and process it like that, but it does not seem to want to execute. Any help would be appreciated. Form a loop to write the columns (tab seperated) in the order exactly as in the table in database using SteamWriter object's WriteLine() method. Code Block using System.Data.SQLClient; cnMessage=new SQLConnection("Your Connectionstring") string PathToFile="\\\\DBServer\\Messages\\File.txt" cmdMess ...Show All

• PPR How to log print jobs?

  Hello kind friend. i have this script from the repository, strComputer = "." Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colPrintJobs = objWMIService.ExecQuery _ ("Select * from Win32_PrintJob") Wscript.Echo "Print Queue, Job ID, Owner, Total Pages" For Each objPrintJob in colPrintJobs strPrinter = Split(objPrintJob.Name,",",-1,1) Wscript.Echo strPrinter(0) & ", " & _ objPrintJob.JobID & ", " & objPrintJob.Owner & ", " _ & objPrintJob.TotalPages Next it reads the queue well if I run it when I can see the print jobs in the ...Show All

• Ranier Template Explorer - Changing file location / Removing Defaults

  I have been unable to remove the default list of SQL Server Templates from management studio. I don't really care about the ones already in there, but have hundreds of my own that i would rather be displayed. I don't like searching through the 25 different folders that microsoft already has out there cluttering up my own folder structure, and would like to see them disapear, however after deleting them, they just come back next time i open up management studio. Does anyone know how I can remove the default templates, or change the template location to point somewhere else so i don't see them in the explorer list anymore Thanks in advance, Chris I have to say so far I'm really disappointed in SSMS I was hoping that it woul ...Show All

• Kennon2005 Whole number to decimal format

  I have a report that returns an amount. The problem is that the amount shows on the report as a whole dollar amount example: 498, 99, 397 and so forth. I would like to be able to format the numbers to 4.98, 0.99 and 3.97 but I can not figure out how to format the decimal place two spaces to the left instead of the right of the whole number. If someone out there could help me out on this I would be extremely greatful. Thanks, Jen Duh!... I think I have officially earned idiot of the day and it is time for me to go home. I told everyone that my pregnancy was affecting my thinking skills. At least I have the temporary excuse that pregnancy shrinks a womans brain. Thank you so much for he ...Show All

• graab A Word about Meta-data, pass through columns and Derived columns

  Here's another one of my bitchfest about stuff which annoy the *** out of me in SSIS (and no such problems in DTS): Do you ever wonder how easy it was to set up text file to db transform in DTS - I had no problems at all. In SSIS - 1 spent half a day trying to figure out how to get proper column data types for text file - OF Course MS was brilliant enough to add "Suggest Types" feature to text file connection manager - BUT guess what - it sample ONLY 1000 rows - so I tried to change that number to 50000 and clicked ok - BUT ms changed it to 1000 without me noticing it - SO NO WONDER later on some of datatypes did not match. And boy what a fun it is to change the source columns after you have created a few transforms. This s**hit ...Show All