Viewing 15 posts - 5,866 through 5,880 (of 6,602 total)
Okay, first - you need to post in the Access forum instead of a SQL Server forum. Posting in the SQL Server forum will get you T-SQL answers which...
November 9, 2008 at 11:04 am
Cindy,
I just noticed that you are posting Access related questions in SQL Server forums. Please make sure you are posting Access questions in the appropriate forum - or, you...
November 9, 2008 at 10:49 am
cindy_sinath (11/9/2008)
SELECT Count(Lesson_CatId a) AS October_Total_Test, Count(Lesson_CatId b) AS...
November 9, 2008 at 10:46 am
This is good for a basic start. I would simplify this a little - for example, I would change the dynamic query to the following:
EXEC sp_msforeachdb 'Use ?;
INSERT INTO...
November 9, 2008 at 10:18 am
You need to lookup in Books Online the topics 'Recovery Model' and Backups. Basically, what you need is:
o Database in Full Recovery Model
o Daily Backups (2am)
o Hourly Transaction Log...
November 7, 2008 at 5:23 pm
Matt Miller (11/7/2008)
November 7, 2008 at 5:04 pm
If you are running Enterprise Edition - you can use a database snapshot. As long as the snapshot is refreshed on a regular basis, you could then read the...
November 7, 2008 at 5:01 pm
Another option (which will require a downtime) is to:
1) Perform a transaction log backup (tail log)
2) Restore your latest backup
3) Restore transaction logs to point in time...
November 7, 2008 at 4:58 pm
Those services don't have to be on that server - can be on the web server or a separate application server. If you are seeing connection attempts every few...
November 5, 2008 at 7:53 pm
Yes, that is correct - if you are restoring master then SQL Server needs to be in single user mode.
November 5, 2008 at 4:48 pm
You can try looking in the default trace for the delete event for that table.
Here is an example query:
Select *
From fn_trace_gettable(@default_trace_file,Default)
Where EventClass In (46 ,47)
...
November 5, 2008 at 4:47 pm
Check for any application services that are trying to reconnect to SQL Server. Disable those services to prevent them from trying to log in.
However, are you sure you need...
November 5, 2008 at 4:36 pm
Unfortunately, I have absolutely no clue as to why this is being done. Are you really calling a procedure in one database, that needs to access data in another...
November 4, 2008 at 2:37 pm
Sorry - still doesn't help. If the users are executing a stored procedure - then it should not matter what objects are accessed by the procedure.
The only time it...
November 4, 2008 at 1:51 pm
John, sorry - but this question does not really make any sense to me. You cannot have a stored procedure that has a USE statement in it.
Second, why would...
November 4, 2008 at 1:25 pm
Viewing 15 posts - 5,866 through 5,880 (of 6,602 total)