Viewing 15 posts - 36,946 through 36,960 (of 39,720 total)
I'd recommend calling MS, but they might tell you this.
detach the db. Create a new db and retry your restores.
Can't hurt.
Steve Jones
October 15, 2002 at 2:53 pm
You could build a query to generate a script for a table. Check the script library here (Resource | Scripts).
There isn't a way to be informed of all changes. You...
October 15, 2002 at 10:18 am
October 15, 2002 at 10:16 am
1) Search is on the top menu bar. It is hokey, but we haven't spent time fixing it as we have other priorities.
2) No. The only workaround is to build...
October 15, 2002 at 10:13 am
Timestamps (datatype) are not related to hours and dates, rather, they are incremental trackers for the transaction logs.
The datetime fields you have may indeed get duplicates when the times change....
October 15, 2002 at 10:07 am
Interesting topics, however getting a little off topic.
acudlip,
Can you repost your question in a new thread?
Steve Jones
October 15, 2002 at 10:05 am
It may be for you, but it threw me briefly, especially when the table involved was for a relatively new server.
What is simple for one person may not be for...
October 15, 2002 at 10:02 am
Not sure. We are still researching this with McAfee.
Steve Jones
October 14, 2002 at 2:47 pm
Not sure. It might using the TOP. I avoid the exists because select count(*) tends to go after a single row in sysindexes if there is a clustered index rather...
October 14, 2002 at 2:47 pm
Keep in mind, crdate doesn't change unless there is a create involved. If an alter table is used, then no crdate change is made.
Steve Jones
October 14, 2002 at 10:51 am
I think it can be a reason not to use the identity. What if you were importing 3B rows a day? Or a week, it might be a reason to...
October 14, 2002 at 10:13 am
Probably worth an article to discuss these, and I'd welcome feedback on what people think, but here's our issue.
We backup nearly 1TB a day of changed information. So our backups...
October 13, 2002 at 9:09 pm
That is what I thought. I was reviewing a setup for a client on SQL 7 and wanted to be sure.
My recomendation is to use scripts I've developed, but I...
October 11, 2002 at 10:32 am
Mine will delete everything less than tomorrow, which includes today's records.
I did misread. You'd want to delete everything less than today, so you can take
cast( month(getdate()) + '/' day(getdate())...
October 11, 2002 at 10:30 am
You'd need to develop a script that will write out the necessary parameters and build the mail from scratch. Or use an ActiveX type object. Persits software has a free...
October 11, 2002 at 9:57 am
Viewing 15 posts - 36,946 through 36,960 (of 39,720 total)