Viewing 15 posts - 37,561 through 37,575 (of 39,757 total)
June 26, 2002 at 10:08 am
Better off using DBCC, it's supported. A service pack (unlikely) or server upgrade (likely) will break what you build.
Steve Jones
June 26, 2002 at 10:06 am
I agree with Andy, though if you can get another RAID 1 set, I'd separate logs out.
RAID 1 - OS, SQL, tempdb, etc.
RAID 5 - Data mdf/ndf
RAID 1 - SQL...
June 26, 2002 at 10:01 am
June 26, 2002 at 9:56 am
June 26, 2002 at 9:54 am
June 26, 2002 at 9:46 am
Why not just build the table? It wouldn't be that hard to read information_schema.columns for the table and create the new table based on this. Of course, permissions are an...
June 26, 2002 at 9:40 am
No way to do this natively. You could do some kind of funky thing that secures access to the MMC plugin, like maybe encrypting it with a password, but not...
June 26, 2002 at 9:38 am
You would need some type of third party tool or run Profiler. I do not believe that you can set an alert for this.
Of course, you should have VERY few...
June 26, 2002 at 9:35 am
Are you backing up the database? What recovery model are you set to (database/properties)?
Normally a database backup truncates the log, allowing space to be reused.
Steve Jones
June 26, 2002 at 9:24 am
It could be. The instances will be competing for the memory on the server. Can you set both servers to use the same amount of memory and see what happens?
Steve...
June 26, 2002 at 9:22 am
I agree. you should have some primary key. You can make it non-clustered (recommended).
Steve Jones
June 25, 2002 at 5:42 pm
no cursors needed.
Use an UPDATE to update data.
update realtable
set cola = b.cola
, colb = b.colb
...
from temptable b
where...
June 25, 2002 at 5:36 pm
Curious, why does it help with Vendors? I can understand separateing the security environments, and it might be useful for applications like Great Plains which have hardcoded database names.
Steve Jones
June 25, 2002 at 5:28 pm
Viewing 15 posts - 37,561 through 37,575 (of 39,757 total)