Viewing 15 posts - 2,896 through 2,910 (of 3,221 total)
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...
September 3, 2008 at 8:33 am
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...
September 3, 2008 at 8:20 am
Pardon me for asking the obvious
The workgroup information file is missing or opened exclusively by another user"
Is it missing? Opened exclusively by another user?
September 1, 2008 at 8:13 pm
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
September 1, 2008 at 7:31 pm
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: ...
September 1, 2008 at 12:29 pm
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...
September 1, 2008 at 11:19 am
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.
September 1, 2008 at 9:40 am
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
August 30, 2008 at 3:28 pm
What is your question?
August 30, 2008 at 8:03 am
Ooops wrong subject - sorry about that.
August 29, 2008 at 8:02 pm
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...
August 29, 2008 at 5:31 pm
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...
August 28, 2008 at 4:10 pm
Working as you state
I guess what I'm saying is, sometimes I work on user tables where I have to update thousands of users with potentially damaging adhoc queries
on...
August 28, 2008 at 3:34 pm
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
August 28, 2008 at 2:26 pm
morning!
This is my first time in the forum, so I'm not sure I'm doing the things in the correct way. I hope so.
Valepuffo read the article given in my signature...
August 28, 2008 at 10:42 am
Viewing 15 posts - 2,896 through 2,910 (of 3,221 total)