I am assuming that each local machine has SQL server installed.

Using either VB6, VB dot net or VB2005. Use ADO. Create an ADO command object. Set...

Agree with all that has been said without exception.

Ran across this new Microsoft tool for use with an IIS server that could be of some use to you.

Microsoft has released...

Finding stored procedures and the time required for same

You may want to refer to sys.dm views and functions for example

Select * sys.dm_exec_query_stats to find those taking the longest...

You may want to refer to sys.dm views and functions for example sys.dm_exec_query_stats from BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/eb7b58b8-3508-4114-97c2-d877bcb12964.htm This reports among other items the Total elapsed time, in microseconds, for...

First step use Books On Line - click help on your SSMS menu - that produced:

Title: Considerations for the "autogrow" and "autoshrink" settings in SQL Server

URL: http://support.microsoft.com/kb/315512

Then try Google and...

I am a novice in XML, but copied your attached file to a drive and then independent of Internet Explorer open it using notepad. It appears not to be...

Assuming you have the disc space. Open SSMS, right click on the database name. In the menu that displays click on properties, another window will open. In...

Hari.Sharma

Using SSMS (SQL Express) pressed f8 to bring up object explorer. Selected a database (Northwind), then selected...

Steve lets take your baseball trip and change stadiums to manufacturing facilities, expand from the continental U.S. to the world. Now throw in the fact that our raw materials...

Be very careful making your data base available to the outside world it will open the proverbial can of worms ... look at all the posting on SQL injection...

Greg EXCELLENT answer complete with test data. Let me say again a nice job.

Now just want to point out the the statement

CREATE FUNCTION dbo.fnIncidentNotes

...

As a beginning read: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/309b9dac-0b3a-4617-85ef-c4519ce9d014.htm

Carefully note the start up options for the various SQL services.

Then: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/9d9b1cb9-f64b-405e-bdbb-a91b4abed871.htm

or you may wish to view this first:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/c82d19e5-5557-4235-9a70-37983607a1fd.htm

These hopefully will...

Do not know if this will be the answer but learned this from Jeff Moden, when I had the same problem using OPENROWSET. Jeff pointed out how to specify...

Read this for an explanation of the undocumented sp_readerrorlog

http://vyaskn.tripod.com/sp_readerrorlog_undocumented.htm

Tried it in SSMS on SQL 2005 and it appeared to work, at least it did not report any errors.

If memory servers me correctly, SQL Express will install with a default instance name of machine name\SQLEXPRESS, and yes have installed it on a box that had...