Viewing 15 posts - 1,921 through 1,935 (of 1,984 total)
Thats right.
Restore would be:
*restore full backup of saturday with norecovery
*restore differential backup of wednesday with norecovery
(this instead of applying all transactionlogs since saterday, which would take a long time)
*apply...
September 19, 2005 at 3:11 pm
1) adding an access database :
EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'MyAccessTable',
@useself = false,
@locallogin = 'loginame',
@rmtuser = 'admin', /*default access account*/
@rmtpassword = NULL /*always NULL, see the link below*/
2)...
September 19, 2005 at 3:02 pm
If adhoc queries would be permitted, your original select will most likely work.
I personally haven't any experience querying access tables through sql server.
September 19, 2005 at 2:51 pm
Vijay, mind to share the solution for future reference?
September 19, 2005 at 1:32 pm
You can find a list of connectionstrings at
September 19, 2005 at 1:26 pm
Can be a standalone server without a domain.
For windows authentication it needs a domain except if you run the application on the server itself.
See the books online (sql server help...
September 19, 2005 at 1:21 pm
Is the database being protected by access user security?
In this case you probably have to copy the mdw file to your sql server.
A Workgroup Information File (*.MDW) stores information to...
September 19, 2005 at 1:00 pm
Looks they have service pack 4 of sql server where the issue should be resolved.
If adhoc queries of your access databases isn't allowed, you can still refer to them if...
September 19, 2005 at 12:55 pm
cvsql1\administrator should be correct
My account in SQLServerAgent service got abbreviated to
.\administrator
I hope this helps.
September 18, 2005 at 11:29 am
if the number of transactions isn't too great.
SELECT StockTransactions.StockID
,ISNULL(Tran1.AvgAmount,0) AS AvgAmountforTransactionid1 ,ISNULL(Tran2.AvgAmount,0) AS AvgAmountforTransactionid2
from ( /*All distinct StockIDs to join*/
select distinct StockID
from test.dbo.StockTransactions StockTransactions
) StockTransactions
left join /*Calculate transaction 1 */
(SELECT...
September 18, 2005 at 11:21 am
Normally it is computername\administrator.
You can find a valid list of users in usermanagement in windows.
(Start->Settings->Control Panel->Users & Passwords)
September 18, 2005 at 8:56 am
Can you change the sql agent service account to the administrator account instead of NT AUTHORITY\SYSTEM? So far I know local system account has no rights on any networking stuff.
If you...
September 18, 2005 at 4:03 am
Starting the profiler and tracing for any delete / truncate table / drop table statements?
September 17, 2005 at 9:34 am
What sql server version are they running and what is their service pack?
It might be a bug that was resolved in sql server 2000 sp 3
more info:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;328569
September 17, 2005 at 6:11 am
you can use a left join / inner join
if
SELECT picks.name AS Name, Count(picks.name) AS [Days Picked], Avg(picks.gain) AS [Week 1 Avg Gain]
FROM picks
WHERE (((picks.entrydate)>=#1/3/2005#) AND ((picks.entrydate)<=#1/7/2005#))
GROUP BY picks.name
ORDER BY Avg(picks.gain)...
September 17, 2005 at 6:04 am
Viewing 15 posts - 1,921 through 1,935 (of 1,984 total)