Or, run VBScript (either from batch file, or instead of batch file.  Then, either:

1. Create ADO connection object and run the Execute method.  See "ADO Samples" in BOL.
2. Create SQLDMO object and...

Sorry, missing the extra space character at the end.  This should work:

whereString = "and tbEmpleado.noTarjeta = '" & noTarjeta & "' "

In the sproc, all those "char(39)" are to delimit...

I don't think you can do that without code.  You have to convert the file contents to a some sort of binary stream, depending on your application code.  How you...

You are mixing up your quotes.  You want to use double quotes for the VB syntax strings, and single quotes for the SQL quote delimters.

whereString = "and tbEmpleado.noTarjeta = '"...

In your situation, I would agree with Yelena, and use WMI queries.  You can use those to check service status on remote servers from vbscript, then email your desired response/report. ...

Mel;

I think somewhere along the line, memory tables became pinned tables (DBCC PINTABLE).

(Sort of) Related, one of the early features of Windows 2000 Advanced Server was In-Memory DataBases (IMDBs).  These...

Other suggestion from the simple side...

How about Show Execution Plan?

Or Set ShowPlan_Text = ON?

You installed SQL Server 2000 Enterprise Manager on a workstation with SQL Server 2005 Management Studio already installed. 

You cannot run them side-by-side.  Best case is to follow these instructions:

http://blogs.msdn.com/mab/archive/2006/03/18/554466.aspx

Hope...

Since these are Windows services, you would need to query Windows to determine if these services are running.

From command line:

sc query mssqlserver

sc query mssqlagent

sc query msdtc

If you are looking...

You may not accurately be able to tell from the database. 

If your applications were designed to be scalable, they will take advantage of OLEDB/ODBC connection pooling.  Multiple users will be...

You could change the drive letter of the CD drive on the dev server. Then use subst to map D: to a directory.

Hope this helps.

I cannot say definitively that this will work, as I have not specifically done this .  But I know you can setup Outlook to use Notes (I have done that,...

Yes, I use SourceSafe to manage all DDL for my databases.  I usually just use the Generate Script command, set to 1 file per object, script all indexes and keys,...

This is a rather obscure problem that pops up here frequently.  Check my comment under the discussion of the QOD on March 15, 2006. < http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=120&messageid=265749 >.

As I mentioned in the...

As a consultant/contractor, and primarily a developer but also DBA on some contracts and projects, I have some projects where I work primarily at home, and some where I work...