Viewing 15 posts - 36,991 through 37,005 (of 39,769 total)
We have a Compaq SAN for some other items, but not the dbs. I have spoken recently to MS on another issue, a server with fiber channel disks, and they...
October 18, 2002 at 9:24 am
Slightly confusing, so let me state this simply and let me know if this is correct.
MAchine1 - SQL Server 7 server, has dts pacakge.
Machine2 - Remote Windows server machine containing...
October 16, 2002 at 9:48 am
No replication. Not sure why the values are creeping up, but pinged McAfee on the issue.
I suggested BIGINT, but since it's a 3rd party db and software, hestitant to do...
October 16, 2002 at 9:35 am
The "restore earlier log" means you are restoring out of order. Logs MUST be restored in the order they were taken.
If you are missing one, you can only restore to...
October 15, 2002 at 3:32 pm
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
Viewing 15 posts - 36,991 through 37,005 (of 39,769 total)