Viewing 15 posts - 36,691 through 36,705 (of 39,818 total)
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
January 14, 2003 at 10:38 am
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...
January 14, 2003 at 10:28 am
Have you checked that the SQLAgent account has rights to delete? Check the log files for the maintenance plan for errors.
Steve Jones
January 14, 2003 at 10:25 am
This is a holdover from SQL v6.5 which takes a query and then builds an HTML page from the results. It isn't documented in v7 or 2000, but was left...
January 13, 2003 at 10:34 am
Are you appending to one file or making a new one each time?
Steve Jones
January 13, 2003 at 10:21 am
Sounds like you have some bug set. Perhaps SQL is setup for dynamic ports? Check the network setup. I restart SQL and have no issues on a number of servers.
Steve...
January 13, 2003 at 10:16 am
Intersting, have to check on this. Will try to ping some MS contacts to see if we can get an explanation of the coding.
Steve Jones
January 10, 2003 at 8:45 pm
Personally I'd stick with a simple solution if I could.
backup/restore.
Script the deletion of all data.
Steve Jones
January 10, 2003 at 2:38 pm
Haven't used a NAS, though we have some on a SAN. Similar concept, slightly different architecture. The idea behind this is that the storage is consolidated and rarely, if ever,...
January 10, 2003 at 10:59 am
NO RAID 0. Not worth it on a production server. If one drive goes, your server is down. The tempdb should be on RAID 1 or 5 or 10, same...
January 10, 2003 at 10:46 am
January 10, 2003 at 10:36 am
I favor the filesystem, but that's me. Andy has good arguments in another thread (http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4169&FORUM_ID=9&CAT_ID=1&Topic_Title=Images:%20Store%20in%20SQL2000%20or%20on%20File%20Directory?&Forum_Title=General) on this.
Steve Jones
January 10, 2003 at 10:35 am
use a left outer join
select *
from affiliate a
left outer join template t
on a.affiliateid = t.affiliateid
Steve Jones
January 9, 2003 at 2:48 pm
Are these employees? Authenticated (to NT) users? If they are, you need to buy 1 SQL Server License and 15 CALs. Middle Tiers don't count.
If they are Internet or unauthenticated...
January 9, 2003 at 1:02 pm
I'm not sure I agree with all the choices made either, but it was nicely written and it appears that it works well for you to solve the problem.
I worked...
January 9, 2003 at 1:00 pm
Viewing 15 posts - 36,691 through 36,705 (of 39,818 total)