Microsoft SQL Server Forum

Hello, this is a two part question 1) Can someone recommend a way to automatically backup SQL and mysql databases? Preferably if there is an online service (free or paid). Would be nice if the software or website could handle SQL and mysql. I am currently hosting my .net MVC 3.0 application hosted on asphostportal.com. We are in the final...

I set up a Web Service Task in SSIS with the following Server URL: http://www.webservicex.net/globalweather.asmx?WSDL, Service:Global Weather, Method:GetCitiesByCountry Output File:WeatherOutput.xml. It runs fine and produces the data, but contains control characters. Instead of < and >, it shows &lt; and &gt;.

i got this question in an interview! lats say i have a below table and i want to fetch the rows only till the period is currently active (all the rows above including Active Period = 1). if Active Period = 1 that means it currently Active.Query has to be dynamic lets say if the Active Period changes later then it has to fetch the rows till...

Viewing them both on the screen yields 2 different sizes (object browser says (5), sp_help says (10))....no there have not been any recent changes so I do not need to refresh the view of the object browser. Any one know why the difference? Thanks!

I know that users can be given permission to access the database to select data from database as shown below. But doing this for each user in the user table would take ages.. is there any method i could do this for all users in the user table I want to give all of them roles to allow them to read certain tables only.. any ideas how this can be...

I am new to sql server I have web application in asp.net 4.0 with code in vb.net I am saving data for example: hr & safety When i save data in sql server 2008 R2 and retrive it in my web forms it shows hr amp safety what is it? how can i solve it? and what if i want to replace & with simple and?

Hi, I'm having problems with databases that are getting corrupted. I have a server that runs a SQL Anywhere 11 database. (the consolidated database). Beside that, we have about 15 remote databases that run on the laptops of my mobile workforces. To keep all databases in sync, I have setup a two-way server-to-laptop replication.

Hai all, I have to select the data from sql server table which is in following format. Ex table Name : sample The table sample has one column named as Text and the datatype of that column is nvarchar(20). so in that column i have a data like:

I've searched around for help on this but everything I find seems to be a discussion about the relative benefits of using, or not using, this setting. I want to specify in SQL Server that ZLSs are not acceptable in the field whether or not NULLs are allowed. If ever I have to deal with an empty-looking value I want to know it's NULL rather...

Dear all, I am currently undertaking an academic project to design & build a Web Application (using HTML5 and open standards) that will require a data storage method and a means of serving the data to the Web Application. Data will include items such as simple statistics in numeric format and information in text format. I am considering...

If i make any changes(Insert/Delete/Update)in a site then the corresponding changes will store in tables of that particular DB. How to know on which table which operation(DDl/DMl)has done. I would like to store DML activities on Database level in a table,not on perticular Table, Please help

I am trying to loop through my counter to create a dynamic sql query which should finally look like I am trying to use this approach to get the final query but doesnt seems to work declare @CurrentRow int set @CurrentRow =0; declare @RowsToProcess int declare @FinalHistoricalQuery varchar(5000) WHILE @CurrentRow<3 BEGIN

Below is a screenshot of my sql code and results where I've been trying to join 3 tables. I need to find the number and name of each customer that currently has an order on file for a Gas Range. I've included screenshots of the data as well. Any help you can give me with this most difficult problem will be appreciated. ...

hello, do you know how to determine the database version of a database on sql server management studio for some compatibility reasons because not all of the databases are created using the version of sql server i am currently running. some of them are attached using backup. Thanks.

duplicate rows occurring when using inner join,i want to join a table value to another table..

Hello All, How to split the data in a column with comma separation. I am attaching the images for my Input and my expecting Output. Input: ID Group ProjectIds 1 xxx 1234,456,8972 2 yyy 567,7890,12 3 zzz 32,165

I am struggling with some results in which I had to take values from a single column and derive separate columns. Now I have three columns and three rows that I wish to combine into a single row where the column RowNum is share. Any tips? The query and results are below. SELECT DISTINCT RowNum, chem_name, amt, measure FROM (SELECT...

Hi all, I have an SQL query that bring back data for customer contacts (name, telephone number, time of call, agent ID e.t.c) which is run manually every day. The business now requires me to extract this data every 15 mintues, and i don't want to have to do it manually as i wont have time to anything else with my day! I would like to find...

I can SELECT CONVERT(VARCHAR(8), DXACCNUM) but I cannot SELECT CONVERT(VARCHAR(8),DISTINCT(DXACCNUM)) I am merely trying to make that int column 8 char wide. Any ideas from anyone? Thanks!

Hi, SQL back end, Access front end. I have a table for entities and folks now want to be able to capture notes on an entity. Lengthy notes of text/numbers. I've seen on the web a SQL data type of nvarchar (max) but have never used it. Would that work? Any other options? I know Access has a memo data type but believe that is not an option...

This question was asked by Fredrik M?ller but can't see any replies. I have a problem with Transactional Replication over a WAN. Server A is a distributor and server B is a publisher. Sometimes the network goes down and replication fails. When the network comes up again the log reader at server A continues to fails. To get the replication going...

How to create a password column and password must be encrypted?

Hi, I wonder if anyone has any pointers to this. I have a page querying cities from my database. fields to query in database country australia uk uk

Hello! I have Contract and Rent_Payment. I want to make it mandatory one to mandatory many so that a Contract must have one or more Rent_Payments. I understand that after I create both tables, I then use How do I deal with this? I figured it out! Cant figure out how to delete though...

I have a table Rent_Payment with subclasses checks and like_value (PK is payment_ID). Each of the subclasses have a description (ex: like_value has 'Fixed a car'). Tenant pays the Rent Payment (linked by FK tenant_ID). I want to display: Tenant, and description from the subclass of how they paid. I unioned all the subclasses but I don't...