In SQL 2000 BOL

Many of your administrative activities in Microsoft® SQL Server™ 2000 are performed through a special kind of procedure known as a system stored procedure. System stored procedures...

DISREGARD THIS RANTING

I too selected a single answer not multiple answers

KevRiley -...

DISREGARD THIS RANTING

I too selected a single answer not multiple answers

KevRiley -...

DISREGARD THIS RANTING

I too selected a single answer not multiple answers

KevRiley -...

It was said once by Jack

Check out these links on how to get faster and more accurate answers:

Forum Etiquette: How to post data/code on a forum to get...

You say SQL Server.... which revision SQL 2000 or 2005 or 2008?

Do you have a copy of the database which is not on a production server, do you have either...

Looks like you are missing a semi-colon after MSDASQL

Try this

insert into openrowset ('MSDASQL;', .........

and another point to check has the OLE DB...

Just a thought to kindle your creativity. In your code

Right trim the VARCHAR data returned

append a CHAR(10) -for a line feed

and a CHAR(13) - for a carriage return

Had a 6 month assignment that required me to leave my home at 5:30 AM to travel (driving) 21 miles to Newark NJ airport - time 30 minutes. Board...

I have got to agree with rbarryyoung:

Well, personally I wouldn't want to do it both because I would not want to profit from a lie and because lying is intrinsically...

Refer to BOL and read and understand what is in sys.comments.

You could use

SELECT id,colid, text FROM syscomments WHERE text LIKE '%word or phrase you are search for%' ORDER BY id,...

R. Van Laake

A characteristic of Excel:

When you save...

Please follow the link in the signature box and follow the instructions so as to present a question such that it will assist people who are more than willing to...

Might this be the source of confusion:

From the definition of: sys.dm_db_index_operational_stats

Cumulative count of leaf-level rows that are marked as deleted, but not yet removed. These rows are removed by a...

sql_er this may explain your problem

When you save a workbook, Microsoft Office Excel stores only the part of each worksheet that contains data or formatting. Empty cells may contain formatting...