What table?

hmbtx (6/20/2012)

---

Jared:

Thank you for your response to my question.

Am I correct that in order to access the remote SQL Server 2000 databases I would perform the following steps:

In SSMS Object...

Yes you can, and I am not "aware" of any problems.

sqlfriends (6/20/2012)

---

Thanks all, I did some research and made two steps, one is notify SQL server agent restart, the other is to notify SQL server restart.

By the way, anyone knows...

isuckatsql (6/20/2012)

---

I dont know what they do, other than make the query faster!

I have had a few DBA's and Microsoft Enterprise support work with me on this query, and was...

We scan the log every hour and send an email with the information we want to be notified about. Server restarts are one of the things we like to know...

What does this mean? Not getting the correct results or giving an error? My first guess is that your subquery is returning more...

The problem is that this:

select USO_StrikeNo

from UsersStrikeOuts

where ID_Users = 47505 and CourseID = 4058

returns more than 1 value.

My "guess" without knowing your table structures and their relationships is that it...

I tend to use the Maintenance Plan Wizard for this if it is simple. Otherwise, there are plenty of scipts out there you can find with a google search....

Luis Cazares (6/19/2012)

---

peacesells (6/16/2012)

---

balasach82 (6/16/2012)

---

is it possible to give an SELECT statement ...ORDER BY but the field in ORDER BY clause would not be in SELECT list.

Like ...

SELECT F1,...

Hmm... Not really sure. That sounds like an MS issue.

Hmm... Not being an expert in this... Would simply using a TRY CATCH block suffice? Simply attempt to insert and if it fails rollback and signal to the application...

Please try wrapping your code in the IFcode shortcut to decrease the amount of space it takes. Use the [ code="sql"] [/code] without the space in the first one to...

Ok, so the application does not care if a row gets inserted or not? It just attempts and either succeeds or fails?

The only thing that comes to mind is to make sure you have all of the .NET updates installed.