Viewing 15 posts - 3,001 through 3,015 (of 3,221 total)
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...
July 16, 2008 at 6:04 pm
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...
July 16, 2008 at 11:36 am
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...
July 16, 2008 at 11:25 am
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...
July 15, 2008 at 5:23 pm
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...
July 15, 2008 at 4:54 pm
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...
July 15, 2008 at 2:59 pm
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...
July 15, 2008 at 2:35 pm
Hari.Sharma
Just select a table name and press Alt+F1 and see the result...
Using SSMS (SQL Express) pressed f8 to bring up object explorer. Selected a database (Northwind), then selected...
July 15, 2008 at 9:55 am
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...
July 15, 2008 at 9:32 am
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...
July 15, 2008 at 7:00 am
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
...
July 14, 2008 at 3:01 pm
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...
July 14, 2008 at 11:13 am
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...
July 13, 2008 at 7:38 pm
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.
July 13, 2008 at 1:59 pm
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...
July 13, 2008 at 1:10 pm
Viewing 15 posts - 3,001 through 3,015 (of 3,221 total)