I dont see the advantage of running "DBCC...".  Can you please elaborate more.

Can you run SQL Server Profiler and capture all those queries that gets fired against the entire server, may be that shall provide you some insight, saying which all SQL could...

In Books On Line,look for sp_oacreate and all other method starting with "sp_oa"

Hope that helps.

Could somebody please let me know where can I get this driver?

Krystian Jedrzejczak, could you please send me the screen shot on how the screen looks like (sqlemail@yahoo.com)

Thanks in...

How do we "alias" the SQL Server.  Can you please let us now, this is something  have never heard of.

See if this will work, you might have to twaek some code (BW, thisis not my code :-))

-------------------------------------------------------------------

-- ValidateURL.sql

-- http://sqljunkies.com/WebLog/amachanic/articles/ValidateURL.aspx

-------------------------------------------------------------------

-- Select ObjectProperty(Object_id('ValidateURL'),'IsScalarFunction')

If (Select ObjectProperty(Object_id('ValidateURL'),'IsScalarFunction')) = 1

   Begin

       Drop FUNCTION...

Here are my comments

=================

1. People usually look for sample codes, for most common type of requirement.  SQLDts.com has some good sample codes, does your site or discussion group plan to...

I believe this feature is not available in SQL 2000.

Try re-installing MDAC, hope that will fix this issue.

How about these steps

1. Read this excel file (the one you have shown as example above) and store all its rows in a WORK TABLE
2. Now your WORK table will have the schema for the...

If the file is 200 MB we had issues with loading it in one shot, eventually we ended up splitting the file in to 8 files for approx 25 MB...

Hi Julian

Where do I find these options

• Reorganise data and index pages
• Remove unused space from database files

SP_Depends should list all dependent SP's

Using TEXT column of SysComments table you can re-create the SP I Guess for these dependent SP's

I know this will involve some coding, unfortunaltely I...

Exec sp_mstablespace <tablename>

paul

Hi

I have question to Steve Jones, Alamir, mespadoto. Each of you said the following

Steve Jones - hyperthreaded

Alamir - default cluster size (4K) .....