Eswin (6/26/2009)

---

Will using SELECT statement that assigns values to a variables and then using "while @@row_count 0" allow me to fetch one row at a time and perform queries...

Maybe if you could explain what the innards of that cursor are supposed to do, someone can help. It's rather hard...

SQL clustering is purely high availability. There's no load balancing or scale-out capabilities within it.

compass2k (6/25/2009)

---

Another sloppy MS gotcha was they turned IP connections off again so I had to use config manager and restart server to connect from

sql client or application.

Question MS -...

Do you want to see the IDs in table 1 that aren't in table2?

If so, this will work

-- same sample tables as ARUN SAS created

select a.ID,a.Name

from #TableA a LEFT OUTER...

No. The minimum version of SQL that will run on Vista is 2005 SP2

Jeffrey Williams (6/25/2009)

---

I would make sure that Backup Exec is not running a step to truncate the log or switch the recover model. If it is doing either of...

I considered that, but seeing as one of his initial examples just had...

You need a rollback in the error handling, otherwise the transaction remains open and uncommitted if either GOTO runs.. Either like this:

BEGIN TRANSACTION

SELECT FROM TABLE1

UPDATE TABLE2

IF ERROR GOTO ERRORHANDLER

SELECT FROM...

In the management studio login dialog, click on Options (bottom right). That will take you to another dialog where you can change the default database. Pick master.

jimmie.roberts (6/25/2009)

---

Thanks for the quick reply. But the problem still is I cannot login to the SQL db at all because it's in Single-user mode, so how can I...

Does com_SL have an identity column? @@Identity returns the last identity value assigned, so if the trigger inserts into a table with an identity, it'll be that identity value that...

Please note, 5 year old question.

Fresh-brewed coffee on demand, high-speed internet access and to please be left alone.

Last year at TechEd South Africa, the MVP lead ran a 'hunt the MVP contest' where there were...

And since this is a performance problem, please have a look at this article. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/