Answer Questions

• pimpinonline SQL Server Express EULA

  Hello, I want to use SQL Server Express 2005 as the database server for a commercial web site. Web site users will have both anonymous and non-anonymous access to web pages on the site (generated from data in the SQL Server Express database). Is this kind of use within the EULA of SQL Server Express 2005 I can't comment on the legality of any specific plan for a number of reasons. Most importantly, I'm n ...Show All

• NightShade Help on replication from SQL 2005 to DB2/AS400

  I was trying to set up a replication process to move data from SQL 2005 to DB2/AS400. To get it started, I have create a simplest table (say, PERSON) on SQL 2005 server, and the same table (PERSON) on DB2/AS400. I have only one column SSN (of type int). I have journaled the table on DB2 end. I was able to have successfully configured publisher (on SQL 2005) and subscriber (i.e. a pushed subscription). I used transactional replication. And I ...Show All

• Yiru Do we still need a common share mount point in SQL2K5

  Replication in SQL2K required a common file share between publisher and subsriber. Our security policy will not allow our DB servers to communicate via net bios across the firewall. Can SQL2K5 perform replication using the normal database communication ports (1433 or 2433) As for common file share you mention, I am not sure if you mention snapshot files shared between publication and subscriptions. If it is, yes, snapshot are usual ...Show All

• Stefan Prodan How to retrieve data from query and link the data to a data number?

  i'm doing a project on SQL Server 2005, i'm stack in searching the data and can't link the data in the data number.. can someone help mi with the programming code as i can search for the words in the table but i can't link with the data number.. am i doing the correct thing this command will search for the keyword LIVER. or issit this command i doing half way through.. SELECT Omim_No FROM av WH ...Show All

• beautifoolmark Inserting non-xml data into table using bulk insert and sql schema file.

  Hi, I am using the sql bulk insert (with sql schema file) to insert xml data into sql server. I have a column in the table called DataSourceId. DataSourceId is not part of the xml data. I currently set the DataSourceId by creating a default constraint on the column. Can I put the DataSourceId in the sql schema file Maybe something like this ... This fails as the attribute 'abcdef' does not exist in the xml data. <xsd:co ...Show All

• RudyG Database moved - How to change subscription of another user.

  I want to change a subscription that has been created by another user. I'am NOT an administrator of the server, but I've given me all Reporting-Services permissions (including systemadministrator). The logfile says that I have to be a member of the sysadmin-role to change subscriptions owned by another user. Thanks Benjamin After you have moved the database to another machine, you could actually go ahead and ...Show All

• Damien Morton Connecting to hosted / remote database

  Hello, I would like to know whether is it possible to administer a database on a hosted site - i.e inserting some lines, executing a query. I normally access the files via ftp connection. And so far the only way I figured I can mess around with the database is to download it and change it on my desktop PC. Thank You. Toma Pajonk well. . .depends on your hoster. Yes it is up to him to let you vpn to the machine. So you have ...Show All

• hthan Import conversion error caused by spaces???

  I am trying to import a fixed width file where some of the numeric columns are empty. The columns in question are defined as integer columns (of varying sizes) and I am guessing that "empty" columns come across as multiple spaces on the import. Even though I have "Retain null values from source" checked off, I am still receiving the following error on these empty columns: Error: 0xC02020A1 at Input Data, Flat File Source [1] ...Show All

• AronR Encryption of SQL Queries

  Hi. I am running SQL select queries over a network from a SQL Server to a mySQL server by creating a linked server.  I need data to be encrypted (nothing heavy), but some form of encryption over the network as it exits the firewall. Any help appreciated. Karlo i'm no expert with sql server. but i am pritty good with using Windows networking. i think in this case you might wanna check out IPSec deployment. ...Show All

• grikgal function on indexed field

  Hi, I am using sql server 2000 SP1.    select * from document_display where upper(document_name) = upper(v_document_name) v_document_name is a variable. The table is over 200,000 records and presently has index on column document_name Could anyone help on how to improve the performance of above query   No, there are no function indexes in SQL Server.    Why is a ...Show All

• XavierMe SSIS on SQL Express

  Does SQL Express support SSIS packages If so, how can they be created in SQL Express Please reply to my true (not modified) e-mail address as I don't know if I will be able to look here again soon. Thank you!! ):-D P.S. Related question: Where can I find a comprehensive list of features that are supported by SQL 2005 that are *not* supported by SQL Express The answer to your first question is yes. ...Show All

• kalpna RMO: Replication between SQL Server 2005 amd SQL Server 2005 Express

  Hi! On an existing MergePullSubscription (Subscriber: SQL Express) I call the SynchronizeWithJob() method. But each time, the following exception occures: ExecutionFailureException: The specified pull subscription is not configured with a synchronization agent job. But how do I configure synchronization agent jobs in SQL Server 2005 Express SynchronizeWithJob(), I think this is equivalent to executing sp_s ...Show All

• Blainy Unable to run "Management Studio(ssmsee.exe)" for Sql Express edition

  Hi, I have downloaded Sql Express edition for Yukon. After that I installed the UI - Management Studio (SQLServer2005_SSMSEE). I checked and I was able to open and work using the Management studio. Afterwards I installed some "SQL Server 2005 Express Edition Documentation and Samples" from the following link ... http://www.microsoft.com/downloads/details.aspx FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&DisplayLang=en#filelist Now after i ...Show All

• Eric Knabe Count Query

  hi! I am new to this whole SQL language... had a question about using a count function or if i shuld even be using a count function for this... Data I have to work with I would like my result set to look like this: ID ID2 ID ID1Count ID2Count ID3Count ID4Count A 1 A 2 2 2 3 A 1 B 1 ...Show All

• pbrowntwi Problem in VB6 application with SQL Server 2005

  I have got a VB6 application where I update local SQL server table from MS Access table with code like that: ---------------------------------------------------------------------------------------------------------------- Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset rst.Open "SELECT * FROM Table1 WHERE [Fld1]=" & v1, Cn, adOpenKeyset, adLockOptimistic 'check if exist if not exist create new If rst.EOF T ...Show All