Viewing 15 posts - 3,646 through 3,660 (of 6,216 total)
Sounds like you've either got you bak files confused or the names for them. I think you'll get this error trying to apply a log backup from db A to...
July 29, 2002 at 10:01 am
How are you generating the differential? If you dont supply a unique filename it will either append or overwrite the existing file, depending on options set.
Andy
July 29, 2002 at 9:37 am
July 29, 2002 at 9:36 am
See a ton of posts about it on Google. Might want to weed through them. Try groups.google.com, search for "Could not resolve recipient" and xp_sendmail.
Andy
July 29, 2002 at 6:55 am
No problem. Hope you'll post a follow up with the results of your testing and your final solution.
Andy
July 29, 2002 at 6:34 am
The smaller the width of your table the better it will work. I'd recommend using smalldatetime, tinyint instead of int, etc...if possible. How will you be querying? I'd guess a...
July 29, 2002 at 4:44 am
You'll have to qualify it in the select with the table name. It's ambiguous because it exists in both tables.
Andy
July 29, 2002 at 4:38 am
If DBCC won't fix it there isn't a lot you can do. Tried an earlier back up maybe? If you cant fix it you'll have to drop the table, then...
July 29, 2002 at 4:37 am
You cannot turn it off. You can set the recovery mode to simple (truncate on checkpoint in SQL7). It will still log everything but completed transactions are not saved. You...
July 29, 2002 at 4:33 am
One way is to just make the logic intrinsic to your app - basically any place you query include the " and userid='xyz'".
Andy
July 28, 2002 at 3:42 pm
SQL Server is a server database that uses a client server model. This means that a client - your typical end user - submits a query, the server processes the...
July 28, 2002 at 3:11 pm
Not sure I agree either. Can you show me a real world problem that this solves more cleanly than a standard RDBMS solution?
Andy
July 28, 2002 at 3:06 pm
Not easily. You can send over a delimited string as one param then parse it out and push into a temp table used by the proc. Or multiple params to...
July 28, 2002 at 3:02 pm
I have not. There's no reason for it to happen that I can think of since you're moving the entire db as a file, not moving objects.
Andy
July 28, 2002 at 2:22 pm
How do you determine which records they can see? A value in a column? Can users view overlapping sets of data?
Andy
July 28, 2002 at 2:07 pm
Viewing 15 posts - 3,646 through 3,660 (of 6,216 total)