I made correction to my datatypes to match all columns in database.  Also, I entered all the fields on the entry form but I still unable to save it.  (Error :...

my vb code is :

If txtJobID.Text Is Nothing Then

                    JobId = -1

                Else

                    JobId = CInt(Request.QueryString("Job_ID"))

                End If

                Dim strQ As New SqlCommand("FHDJobEditing", conHDDb)

                strQ.CommandType = CommandType.StoredProcedure

                strQ.Parameters.Add("@JobId", SqlDbType.SmallInt).Value...

Update: The SS 2000 has the latest SP4 on it.

My task is to output the text from "MissingSales_Tble" which changes every 15 minutes based on how many stores didn't transfer in their sales file.

mmm.....I think I didn't make my question clear.

I have a table which changes every 15 minutes.

In DTS, I use "Microsoft OLEDB Provider for SQL Server" as the source and a...

Is it possible to write to a file from a stored procedure ? For example, I created a stored procedure by using Richard's script that will read data in a table using a...

Richard,

thank you.  it works perfectly.

Jennifer

I checked all logins in that server, there's no account works and has sa privelages.  I use sp_helplogins, it gave me error message said : cannot insert the value NULL into...

We are guessing that after a major corruption on Monday, the server appears to have forgotten the password for the account, the sql service will not start unless we can find the...

I tried and have no luck so far.  When I access the 'sa' in Logins, I still get the same SQL-DMO error message said 'dbo' was not found in the...

I found the Agent log said "Unable to access the password for the 'SQLAgentCmdExec' proxy account", so I went to the Server and reset SQLAgentCmdExec permission by clicked "Rest Proxy...

Well, I didn't count exactly how many stored procedures in the old server, but it's more than 100 SPs, and we want only 50% of them. I am thinking...

Thank you. It is different from Oracle which uses redo log files.

Another question is :

Our database is about 60 GB, mix with data warehouse stuff and mid-heavy transaction...

Yes we tried to back up to another disk drive and worked yesterday.

Today, we tried to change the recovery mode from Simple to Full and backup worked fine. When we...

Thank you. I got the statement to work now.

The output format I need is %, such as 31.24%

but now I get .3124. How to conver that?

The current output...