It output SQL_Latin1_General_CP1_CI_AS Please explain further... Thanks in advance
Thanks, Adriaan<br /><br />But its not working[<img src='/community/emoticons/emotion-6.gif' alt=':(' />]. I tried to set the...
Our company purchased a font-end application with SQL back-end and we can input/view/modify the Chinese character in a field but it display garbat...
1. I try to pass 3 parameter to the sp 2. I want to retrieve all the record from the sp how can I obtain the result set and I can loop thr. the...
I have two tables Staff_ID datejoin 1 30-6-2004 2 30-6-2004 3 29-6-2004 Staff_ID dateLeft 1 30-6-2004 I want to...
DECLARE @jobnos varchar(10) DECLARE @JMonth varchar(20) DECLARE @Jnature varchar(20) DECLARE @Jissuedate datetime DECLARE @Jcompdate datetime DECLARE...
Please help on the below DECLARE JOBcursor cursor for SELECT jobnos,followupjob,issuedate,compdate from joborder where contractno = @cnos and...
[<img src='/community/emoticons/emotion-1.gif' alt=':)' />][<img src='/community/emoticons/emotion-1.gif' alt=':)' />]Is there any work around if the...
Satya SKJ, can you highlight some steps that I need to be complete in order to have a full replications as I cannot manage to setup one[V][V]<br...
I would like to have a full backup from one server to another server<br />I have a production server with 75DBs and would like to replicate to...
[<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img...
Sorry, when I try to run<br />exec sp_dbbackup 'tvdb' ,'d:ackup'<br /><br />it display the below error<br /><br />Server: Msg 156, Level 15, State...
Many thanks, the command ran successfully<br /><br />Use master<br />go<br />Create procedure SP_DBbackup @dbname varchar(12<img...
[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]Thanks Satya SKJ[<img src='/community/emoticons/emotion-1.gif' alt=':)' />] but when I...
Many thanks both of u and I grant/learn a lot from this site COOL !!! Thanks again
We have a front-end application which MUST hardcode the user name and password in order to manipulate the SQL data and it using 'sa'[:0][:0][:0][<img...
Sorry, should be my COMPANY rather than my computer installed serveral SQL servers...
Dear all<br /><br />My computer equipped serveral SQL server but one is installed the 5 client's MSDE Sql2000 server (FREE). I found the different as...
Dear all<br /><br />Finally did it.<br /><br />1. as the date is start from 01-01-1900 and it convert to int is 693596<br />2. select...
[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]It indeed can works if not leap year where the year should minus 1900. If leap year, the...
Separate names with a comma.
