Difficult to answer your question with the information you have initially supplied.

Suggest reading the article whose link is in my signature block. That said have you thought of placing...

maryjane

Are you using SQL Express? If you are the access to the Export Wizard is not available.

If you are using another version then

1. Right Click on...

Pardon me for asking the obvious

Is it missing? Opened exclusively by another user?

Hope these can be of assistance:

http://msdn.microsoft.com/en-us/library/ms190312(SQL.90).aspx

http://www.mssqltips.com/tip.asp?tip=1202

http://www.mssqltips.com/tip.asp?tip=1055

http://www.mssqltips.com/tip.asp?tip=1202

Microsoft's recommended method to get around the problem:

http://support.microsoft.com/kb/194124/EN-US/

You can add the option IMEX=1; to the Excel connect string in the OpenDatabase method. For example: ...

Oh well here is a quick and dirty solution

INSERT INTO Dbo.Weekly(ProductNumer, WeeksCost)

SELECT ProductNumber,SUM(Cost) FROM Daily GROUP BY ProductNumber

Now go to Books On Line (BOL) are read the following:

Group By

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/40075914-6385-4692-b4a5-62fe44ae6cb6.htm

Aggregate...

Rather obscure question ... need more information in order to assist you

Suggest you read the article in my signature block and supply requested information so that some one may help.

Hopefully you have read about the compatability level in BOL and are taking this into consideration ...

In the 2005 BOL read

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/4760732b-aa3c-4f07-96ec-ba920476dd69.htm

What is your question?

Ooops wrong subject - sorry about that.

This might give you a start, it was posted here on SCC but by whom my memory fails me.

DECLARE @string VARCHAR(50)--must be sized large enough for given string

DECLARE @Find AS...

For a quick - well not so quick - use SSMS object explorer

1. Select the database and expand it

2. In the resulting tree view expand security

3. The...

Working as you state

on...

venkatesulu

Like J thanks for that link - wondered how to debug SQL 2005 and that link leading to other was just what the doctor ordered

Valepuffo read the article given in my signature...