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...
Please help on the below DECLARE JOBcursor cursor for SELECT jobnos,followupjob,issuedate,compdate from joborder where contractno = @cnos and...
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...
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...
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...
We use a front-end application called<br /><br />Magic System Enterprises V8.20e which has a table in SQL database, the field in its interface is...
[?]Please help me out with the captioned<br /><br />My company have over 75 DBs initially set to 'AutoShrink=False and Recovery Model=FULL' and the...
74] Database EMSL: Index Rebuild (leaving 10%% free space)... Rebuilding indexes for table 'Budget' Rebuilding indexes for table...
Separate names with a comma.
