Forum Replies Created
Viewing 15 posts - 36,631 through 36,645 (of 39,771 total)
-
RE: Server Name Change
sp_dropserver (old name)
go
sp_addserver (new name), local
Steve Jones
-
RE: Another Disaster (Almost)
We are looking at testing SQL-UP at SQL Server Central. We met with the vendor and do like the program. There are some limitations and issues (we need another box...
-
RE: Who Needs Change Management?
Nice high level article and something that I completely agree with. You need a process for managing changes.
Steve Jones
-
RE: Processor Upgrade for sql server 2000
As long as you have not set any affinity, you should get the use of all 4 CPUs. If you set an affinity, you'd still see all 4 CPUs, but...
-
RE: Instant Messaging groups
Interesting idea and something we've considered. We'll kick it around.
Steve Jones
-
RE: Error with Transaction Log Auto Grow
I agree with above. Likely the log grew and filled the disk. When the transaction rolled back, the log shrank back. Do you have autoshrink on?
I'd move the table in...
-
RE: Version Control - Dealing with Code
Not sure what you mean as far as labeling. When I branch the project, there is only a single version of each file, so we can tell if anyone has...
-
RE: New Hardware - Suggestions wanted
What we do:
RAID 1 for OS
RAID 1 for db logs
RAID 5 for data on some servers, RAID 10 for data files on others
RAID 5 for backup files (if we can...
-
RE: Obfuscating a column
Sure. Not that secure, but easy to do. Want something simple? Roll the letters, replace A with F, B with G, etc.
Or add some # to the ASCII() value of...
-
RE: Number of DBs Supported
Is your dba a network engineer? Be careful here. Someone needs to sniff the network and provide evidence of being "too much work"
Also, what does that mean? Things are slow?
Doesn't...
-
RE: Another Disaster (Almost)
Glad I'm not Andy or the last guy
I've been pretty lucky with very few disasters, and hopefully that will continue.
Steve Jones
-
RE: New Hardware - Suggestions wanted
$50K is pretty good. How is this system used? Lots of transactions? More reads?
I'd go with RAID 10, try to separate out tempdb (if used) from other db and...
-
RE: SQL2K CLIENT
ODBC drivers will work. Get the latest MDAC from MS will work. You can also install the client tools from the SQL Server CD on W98.
Steve Jones
-
RE: Copy Database
There isn't an easy way to avoid the autoiuncrement fields. You'd need to script something for these.
To copy the database, a backup and restore is the easiest way.
Steve Jones
-
RE: Can't Shrink tempdb
Restart the server should bring it back down.
I assume you've right clicked in EM and done shrink. If not, do that.
Any errors in the logs? Might also try this shrink...
Viewing 15 posts - 36,631 through 36,645 (of 39,771 total)