Another point to remember, Microsoft does not support VMWare. You must consider Hyper-V. Again, when your job counts on it, not for production.

Joe

Running a Production SQL Server that is highly transactional is an extreme issue. We have had customers with tempdb problems, poor or no response, and database corruption (CHECKDB errors)....

Yes, it is very odd. What I was doing was to start a new trace, then select the custom template I made, and check the events within the template,...

Yes the edit 200 rows then click on the Diagram then right click in the table area does work in SQL08. Interesting. But like the man said, who...

Yeah, but that Query designer feature (by right clicking on a table) does not work in SQL 08.

Thanks, but the FMTONLY ON really does the trick.

Doc

I have it working fine now. This is an application being ported from an Oracle Forms application into .Net and SQL Server. My job is to port...

So what I figured out is that if I replace the @ variables with the number 1, no matter what the column's datatype, the statement parses correctly. The "SET...

fmtonly does all but one thing: handle @variables. It checks the table names, column names, keyword spelling, everything but if there is an @ anywhere in the statement it...

SQL returns msg 137 must declare scalar variable. So the final and real issue is how do you get the parser to parse a statement and ignore the scalar...

Lowell,

How would you check the return code after you exec the statement?

Doc

No, the company seeks code reuse. XML parsers can deal with: select * from t where tid= ?tid

Oracle's dbms_sql.parse: select * from t where tid = :tid

The question is...

The problem is that our application needs to evaluate strings before they are submitted for processing. and these strings may contain variables, e.g.,

" select *from t where id <...

Never mind, I fixed it.

Doc

🙂