Euhm.... no. It does not produce the same result as show client stats.

Test it and you'll see it reports on object base (stats io).

You can then compare that to what...

I have the impressions it comes to your output capturing way.

Use this:

SQLCMD -E -S .\SQL2000PE -d master -i ".\Osq_Test.sql" -o ".\Osq_Test.txt" -w340 -n -h-1

my Osql_test.sql contains:

/* just produce an output...

you just don't !

Check BOL for timestamp datatype and you'll figure out it is a type that sqlserver maintains itself ! (with every modification to the row !)

So you can...

I always use

set statistics io on

set statistics time on

to get a grip rearding what SQLServer has to do for my query.

That in combination with the graphical execution plan opens...

can you post the query you're trying to execute (including the table ddl) ?

In many cases a "not exists" outperforms your in-list.

It's certainly worth the test !

select...

from bol:

-w column_width

Allows the user to set the screen width for output. The default is 80 characters. When an output line has reached its maximum screen width, it is broken...

Did you get to the MS licensing doc ?

http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

SQLServer2005Licensingv1.1.doc

It has some scenarios that may help you figure it out.

IMO it's best to monitor for a while before getting proc. licenses.

(Also...

Don't you just love the way a simple question - with some context - with the possibility of being ambiguous triggers a bunch of discussions.

"Make it fool proof and they...

I just wonder:

- how many figures behind the decimal point is their working unit :w00t:

- do they have ctrl+alt+del :hehe:

- do they run on alpha software or RC-1 😀

- finally...

Lynn Pettis (9/11/2008)

---

Unfortunately (or not), I disagree. By specifying SQL Server 2005 in the question, that should automatically eliminate SQL Server 2000 tools from the equation. In my...

Emilio.Mendoza (9/10/2008)

---

Thanks for the reply I've already use those options, probably I didn't explain myself correctly, I need to have the DBO name and the login 'NT AUTHORITY\NETWORK SERVICE' I...

... I don't think that the database should be enforcing the front-end validations, since from a performance standpoint, this would initiate extra DB communication and network traffic if, for example,...

David Paskiet (9/10/2008)

---

UNfortunately, I am trying for the quick and lazy solution. Coding another solution is not my idea of fun to rehash work alreayd done. :: sigh...

1) you could install a connectivity client (but you'll have to check if that contains OSQL)

2) as a workaround, you could "remote submit" the bat file using sysinternals psexec.