Viewing 15 posts - 601 through 615 (of 920 total)
Without more information, we'd just be guessing, so ...
What error message are you getting, if any?
Has the account that runs the procedure changed? (new permissions, new password,...)
Can you drop and...
July 10, 2008 at 9:59 am
How many rows in the table before the delete?
Are these rows useful? Do they need to be in the table for a while and then get deleted or could...
July 7, 2008 at 5:04 pm
Check the sql server error log, and the event log on the windows box for more meaningful error messages.
Also, if this is running as a part of a scheduled job,...
June 27, 2008 at 11:03 am
What error message are you getting when the backup fails? If the backup is running from a scheduled job, does the account under which the sql server agent is...
June 26, 2008 at 6:08 pm
If you copied the ldf after the damage was done and the production database was in 'simple' recovery mode, the data is gone and can't be recovered. The backup...
June 23, 2008 at 4:45 pm
Now I'm a little confused. The 4338 message seems to indicate that the stop point you want to get to isn't in the log anymore. Does the table...
June 23, 2008 at 2:32 pm
What recovery model was the database in before you backed it up. I'm guessing it was in 'simple' mode, which means the logs were truncating every few minutes (clearing...
June 23, 2008 at 1:24 pm
It might also help to post the connection string that the Access front end is using.
June 23, 2008 at 10:50 am
... and you're sure you're not calling the proc twice? Is there a trigger on the table?
June 23, 2008 at 10:28 am
When you set up SQL Server express, did you enable the protcol you're using to connect (TCP, Named Pipes, etc) using the surface configuration tool?
June 23, 2008 at 10:12 am
Check to make sure that the user has access to whatever his default database is, or make sure the database you want him to access is his default. That's...
June 20, 2008 at 4:42 pm
Can you just use Access to link to the SQL Server tables you need and run the compare in Access? It would probably be a pretty slow operation, but...
June 17, 2008 at 1:41 pm
You need to really understand what Kent said. In a relational database, the order in which rows are returned can't be guaranteed unless they are explicitly ordered using an...
April 14, 2008 at 4:42 pm
Check the account under which SQL Server is running. That's the account that needs to have permissions to the files.
April 9, 2008 at 2:10 pm
I don't know where that last once came from either, but I think it might have been my last performance appraisal...
My hat's off to anyone who can remember that long...
February 25, 2008 at 2:39 pm
Viewing 15 posts - 601 through 615 (of 920 total)